696:
697: insert into bom_inventory_comps_interface(component_item_id,bill_sequence_id, batch_id,
698: effectivity_date,disable_date)
699: select component_item_id, bill_sequence_id,
700: cto_msutil_pub.bom_batch_id,effectivity_date,disable_date
701: from bom_inventory_components
702: where bill_sequence_id = lComItmBillId; -- 3543547 lItmBillId;
703:
704: IF PG_DEBUG <> 0 THEN
728:
729: insert into bom_inventory_comps_interface(component_item_id,bill_sequence_id, batch_id,
730: effectivity_date,disable_date)
731: select distinct a.base_model_id, b.bill_sequence_id,
732: cto_msutil_pub.bom_batch_id,effectivity_date,disable_date
733: from bom_ato_configurations a,bom_inventory_components b
734: where a.config_item_id = b.component_item_id
735: and b.bill_sequence_id = lComItmBillId; -- 3543547 lItmBillId
736:
1452:
1453: -- 3543547 Replace lItmBillId with lComItmBillId
1454: delete from bom_inventory_comps_interface
1455: where bill_sequence_id = lComItmBillId
1456: and batch_id = cto_msutil_pub.bom_batch_id;
1457:
1458:
1459: EXCEPTION /* exception for stmt 112 , 115 and 116 */
1460: