2985: i :=l_ent_contracts.next(i);
2986: j:=j+1;
2987: END LOOP;
2988: --delete records in the table
2989: delete OKS_INSTANCE_CONTRACTS_TEMP;
2990: --insert into table
2991: FORALL j in 1..l_ent_contracts.count
2992: INSERT INTO OKS_INSTANCE_CONTRACTS_TEMP
2993: (CONTRACT_NUMBER ,
2988: --delete records in the table
2989: delete OKS_INSTANCE_CONTRACTS_TEMP;
2990: --insert into table
2991: FORALL j in 1..l_ent_contracts.count
2992: INSERT INTO OKS_INSTANCE_CONTRACTS_TEMP
2993: (CONTRACT_NUMBER ,
2994: CONTRACT_NUMBER_MODIFIER ,
2995: CHR_ID ,
2996: LINE_NUMBER ,