APPS.BOM_IMPORT_PUB dependencies on BOM_SUB_COMPS_INTERFACE

Line 354: BOM_SUB_COMPS_INTERFACE

350: and batch_id = p_batch_id
351: and process_flag = 1;
352:
353: update
354: BOM_SUB_COMPS_INTERFACE
355: set
356: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
357: where
358: transaction_id is null

Line 5156: DELETE bom_sub_comps_interface

5152:
5153: stmt_num := 4;
5154: Write_Debug('Deleting the Sub Comps Rows');
5155:
5156: DELETE bom_sub_comps_interface
5157: WHERE batch_id = p_batch_id;
5158:
5159: stmt_num := 5;
5160: Write_Debug('Deleting the component attr rows');

Line 5793: UPDATE bom_sub_comps_interface

5789: SET process_flag = 5
5790: WHERE batch_id = p_batch_id
5791: AND process_flag = 1;
5792:
5793: UPDATE bom_sub_comps_interface
5794: SET process_flag = 5
5795: WHERE batch_id = p_batch_id
5796: AND process_flag = 1;
5797:

Line 5871: UPDATE bom_sub_comps_interface

5867: AND nvl(alternate_bom_designator,'Primary') = nvl(l_header_table(i).alternate_bom_designator,'Primary')
5868: )
5869: );
5870:
5871: UPDATE bom_sub_comps_interface
5872: SET process_flag = 5
5873: WHERE batch_id = p_batch_id
5874: AND process_flag = 1
5875: AND ( bill_sequence_id = l_header_table(i).bill_sequence_id