[Home] [Help]
763:
764: COMMIT;
765:
766:
767: /* Now start inserting rows into CST_RESOURCE_OVERHEADS table */
768:
769: /* now check for the run option and delete or error out rows accordingly */
770: If i_run_option = 2 then
771: delete from CST_RESOURCE_OVERHEADS cro
767: /* Now start inserting rows into CST_RESOURCE_OVERHEADS table */
768:
769: /* now check for the run option and delete or error out rows accordingly */
770: If i_run_option = 2 then
771: delete from CST_RESOURCE_OVERHEADS cro
772: where exists (select 1 from CST_RES_OVERHEADS_INTERFACE croi
773: where croi.cost_type_id = cro.cost_type_id
774: AND croi.resource_id = cro.resource_id
775: AND croi.overhead_id = cro.overhead_id
784: croi.error_code = 'CST_CANT_INSERT',
785: croi.error_explanation = substrb(fnd_message.get_string('BOM','CST_CANT_INSERT'),1,240)
786: where croi.error_flag is null
787: AND croi.group_id = SEQ_NEXTVAL
788: AND EXISTS (select 1 from CST_RESOURCE_OVERHEADS cro
789: where croi.organization_id = cro.organization_id
790: AND croi.cost_type_id = cro.cost_type_id
791: AND croi.overhead_id = cro.overhead_id
792: AND croi.resource_id = cro.resource_id
798: fnd_file.put_line(fnd_file.log,'done deleting or erroring out rows as per run option');
799:
800: l_stmt_no := 175;
801:
802: INSERT INTO CST_RESOURCE_OVERHEADS(cost_type_id,
803: resource_id,
804: overhead_id,
805: last_update_date,
806: last_updated_by,
857: attribute15
858: FROM CST_RES_OVERHEADS_INTERFACE croi
859: where croi.error_flag is null
860: AND group_id = SEQ_NEXTVAL;
861: fnd_file.put_line(fnd_file.log,'done inserting ' || to_char(SQL%ROWCOUNT) || ' rows into CST_RESOURCE_OVERHEADS');
862:
863: l_stmt_no := 180;
864:
865: Update CST_RES_OVERHEADS_INTERFACE croi