damy PK for ID and EntityCode:
create procedure ba_dealerreportinitialdata is
ecnum number; yyy number; uniqueIDVar VARCHAR2(16);
BEGIN
select identifier into ecnum from private_entity_identifier where name='SIBDealerReportType'; yyy := 1;
uniqueIDVar := 'UniqueId' yyy;
insert into DealerReportType (sibID, sibEntityCode, reportTypeName) values (uniqueIDVar, ecnum, 'CSI Results');
yyy := yyy + 1;
uniqueIDVar := 'UniqueId' yyy;
insert into DealerReportType (sibID, sibEntityCode, reportTypeName) values (uniqueIDVar, ecnum, 'KPI Reports');
yyy := yyy + 1;
uniqueIDVar := 'UniqueId' yyy;
insert into DealerReportType (sibID, sibEntityCode, reportTypeName) values (uniqueIDVar, ecnum, 'TCR Reports');
yyy := yyy + 1;
uniqueIDVar := 'UniqueId' yyy;
insert into DealerReportType (sibID, sibEntityCode, reportTypeName) values (uniqueIDVar, ecnum, 'Benchmark Reports');
END;
begin ba_dealerreportinitialdata;
end;
drop procedure ba_dealerreportinitialdata;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment