APPS.EGO_IMPORT_BATCH_PURGE_PKG dependencies on BOM_REF_DESGS_INTERFACE

Line 688: --delete records from bom_ref_desgs_interface

684: l_sub_comp_entity_count := l_sub_comp_entity_count + SQL%BULK_ROWCOUNT(i);
685: END LOOP;
686:
687:
688: --delete records from bom_ref_desgs_interface
689: stm_num := 3;
690:
691: FORALL comp IN l_structure_table.first .. l_structure_table.last
692:

Line 693: DELETE FROM bom_ref_desgs_interface brdi

689: stm_num := 3;
690:
691: FORALL comp IN l_structure_table.first .. l_structure_table.last
692:
693: DELETE FROM bom_ref_desgs_interface brdi
694: WHERE brdi.batch_id = TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).batch_id
695: AND brdi.organization_id = TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).organization_id
696: AND Nvl(brdi.request_id,0) = Nvl(TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).request_id,0)
697: AND ( brdi.bill_sequence_id = bill_sequence_id

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

1096:
1097:
1098: stm_num :=10;
1099:
1100: DELETE bom_ref_desgs_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1101:
1102: fnd_file.put_line(fnd_file.Log,'No.of ref-designators deleted are '||SQL%ROWCOUNT);
1103:
1104: