76: ,p_pk1_num_value => r_mtl_mat_transactions.TRANSACTION_ID
77: );
78:
79: /*** Also insert Lot numebers and serial numbers into their respective acc tables ***/
80: CSL_MTL_TRANS_LOT_NUM_ACC_PKG.Insert_MTL_trans_lot_num(
81: p_resource_id => p_resource_id,
82: p_transaction_id => r_mtl_mat_transactions.TRANSACTION_ID,
83: p_inventory_item_id => r_mtl_mat_transactions.inventory_item_id,
84: p_organization_id => p_organization_id
192: );
193: END IF;
194:
195: /*** Also Update Lot numebers and serial numbers into their respective acc tables ***/
196: CSL_MTL_TRANS_LOT_NUM_ACC_PKG.Update_MTL_trans_lot_num(
197: p_resource_id => p_resource_id,
198: p_transaction_id => r_mtl_mat_transactions.TRANSACTION_ID,
199: p_inventory_item_id => r_mtl_mat_transactions.inventory_item_id,
200: p_organization_id => p_organization_id
292: ,p_pk1_num_value => r_mtl_mat_transactions.TRANSACTION_ID
293: );
294:
295: /*** Also insert Lot numebers and serial numbers into their respective acc tables ***/
296: CSL_MTL_TRANS_LOT_NUM_ACC_PKG.Delete_MTL_trans_lot_num(
297: p_resource_id => p_resource_id,
298: p_transaction_id => r_mtl_mat_transactions.TRANSACTION_ID,
299: p_inventory_item_id => r_mtl_mat_transactions.inventory_item_id,
300: p_organization_id => p_organization_id