APPS.EGO_IMPORT_BATCH_PURGE_PKG dependencies on BOM_COMPONENT_OPS_INTERFACE

Line 725: --delete records from bom_component_ops_interface

721: AND bcuai.bill_sequence_id = bill_sequence_id;
722:
723:
724:
725: --delete records from bom_component_ops_interface
726: stm_num := 5;
727:
728: FORALL comp IN l_structure_table.first .. l_structure_table.last
729:

Line 730: DELETE FROM bom_component_ops_interface bcoi

726: stm_num := 5;
727:
728: FORALL comp IN l_structure_table.first .. l_structure_table.last
729:
730: DELETE FROM bom_component_ops_interface bcoi
731: WHERE bcoi.batch_id = TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).batch_id
732: AND bcoi.organization_id = TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).organization_id
733: AND Nvl(bcoi.request_id,0) = Nvl(TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).request_id,0)
734: AND ( bcoi.bill_sequence_id = bill_sequence_id

Line 1119: DELETE bom_component_ops_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);

1115:
1116:
1117: stm_num :=13;
1118:
1119: DELETE bom_component_ops_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1120:
1121: fnd_file.put_line(fnd_file.Log,'No.of Component Operations deleted are '||SQL%ROWCOUNT);
1122:
1123: