APPS.EGO_IMPORT_BATCH_PURGE_PKG dependencies on BOM_CMP_USR_ATTR_INTERFACE

Line 712: --delete records from bom_cmp_usr_attr_interface

708: END LOOP;
709:
710:
711:
712: --delete records from bom_cmp_usr_attr_interface
713: stm_num := 4;
714:
715: FORALL comp IN l_structure_table.first .. l_structure_table.last
716:

Line 717: DELETE FROM bom_cmp_usr_attr_interface bcuai

713: stm_num := 4;
714:
715: FORALL comp IN l_structure_table.first .. l_structure_table.last
716:
717: DELETE FROM bom_cmp_usr_attr_interface bcuai
718: WHERE ( bcuai.batch_id = TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).batch_id OR bcuai.data_set_id = TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).batch_id)
719: AND bcuai.organization_id = TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).organization_id
720: AND Nvl(bcuai.request_id,0) = Nvl(TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).request_id,0)
721: AND bcuai.bill_sequence_id = bill_sequence_id;

Line 1114: DELETE bom_cmp_usr_attr_interface WHERE (batch_id = p_batch_id or data_set_id = p_batch_id) AND PROCESS_STATUS IN (3,6,7);

1110:
1111:
1112: stm_num :=12;
1113:
1114: DELETE bom_cmp_usr_attr_interface WHERE (batch_id = p_batch_id or data_set_id = p_batch_id) AND PROCESS_STATUS IN (3,6,7);
1115:
1116:
1117: stm_num :=13;
1118: