APPS.INV_RCV_DIR_RCPT_APIS dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 703: UPDATE mtl_transaction_lots_interface

699: print_debug('create_osp_drct_dlvr_rti_rec 8.6:
700: serial_control_code IS '||l_rcv_rcpt_rec.serial_number_control_code || ' , need TO NULL OUT mtli', 4);
701: END IF;
702: BEGIN
703: UPDATE mtl_transaction_lots_interface
704: SET serial_transaction_temp_id = NULL
705: WHERE product_transaction_id = p_transaction_temp_id
706: AND product_code = 'RCV';
707: EXCEPTION

Line 1456: UPDATE mtl_transaction_lots_interface

1452: IF (l_debug = 1) THEN
1453: print_debug('create_po_drct_dlvr_rti_rec 9.6: serial_control_code IS 6, need TO NULL OUT mtli', 4);
1454: END IF;
1455: BEGIN
1456: UPDATE mtl_transaction_lots_interface
1457: SET serial_transaction_temp_id = NULL
1458: WHERE product_transaction_id = p_transaction_temp_id
1459: AND product_code = 'RCV';
1460: EXCEPTION

Line 2237: UPDATE mtl_transaction_lots_interface

2233: WHERE product_transaction_id = p_transaction_temp_id
2234: AND product_code = 'RCV';
2235: END IF;
2236: IF (l_msni_count = 0) THEN
2237: UPDATE mtl_transaction_lots_interface
2238: SET serial_transaction_temp_id = NULL
2239: WHERE product_transaction_id = p_transaction_temp_id
2240: AND product_code = 'RCV';
2241: END IF;

Line 3812: UPDATE mtl_transaction_lots_interface

3808: AND product_code = 'RCV';
3809: END IF;
3810:
3811: IF l_msni_count = 0 THEN
3812: UPDATE mtl_transaction_lots_interface
3813: SET serial_transaction_temp_id = NULL
3814: WHERE product_transaction_id = p_transaction_temp_id
3815: AND product_code = 'RCV';
3816: END IF;