343: and batch_id = p_batch_id
344: and process_flag = 1;
345:
346: update
347: BOM_SUB_COMPS_INTERFACE
348: set
349: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
350: where
351: transaction_id is null
4760:
4761: stmt_num := 4;
4762: Write_Debug('Deleting the Sub Comps Rows');
4763:
4764: DELETE bom_sub_comps_interface
4765: WHERE batch_id = p_batch_id;
4766:
4767: stmt_num := 5;
4768: Write_Debug('Deleting the component attr rows');
5397: SET process_flag = 5
5398: WHERE batch_id = p_batch_id
5399: AND process_flag = 1;
5400:
5401: UPDATE bom_sub_comps_interface
5402: SET process_flag = 5
5403: WHERE batch_id = p_batch_id
5404: AND process_flag = 1;
5405:
5475: AND nvl(alternate_bom_designator,'Primary') = nvl(l_header_table(i).alternate_bom_designator,'Primary')
5476: )
5477: );
5478:
5479: UPDATE bom_sub_comps_interface
5480: SET process_flag = 5
5481: WHERE batch_id = p_batch_id
5482: AND process_flag = 1
5483: AND ( bill_sequence_id = l_header_table(i).bill_sequence_id