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 1812: FROM mtl_transaction_lots_interface

1808: l_msni_count NUMBER := 0;
1809:
1810: CURSOR l_curs_rcpt_lots_detail IS -- 13972742
1811: SELECT lot_number, transaction_quantity
1812: FROM mtl_transaction_lots_interface
1813: WHERE product_transaction_id = p_transaction_temp_id ;
1814: end_loop NUMBER := 0;
1815: l_rcpt_lots l_curs_rcpt_lots_detail%ROWTYPE;
1816: l_transaction_quantity NUMBER;

Line 1894: FROM mtl_transaction_lots_interface

1890: END IF;
1891:
1892: SELECT lot_number
1893: INTO l_lot_number
1894: FROM mtl_transaction_lots_interface
1895: WHERE product_transaction_id = p_transaction_temp_id ;
1896:
1897: EXCEPTION
1898: WHEN No_Data_Found THEN

Line 2321: UPDATE mtl_transaction_lots_interface

2317: WHERE product_transaction_id = p_transaction_temp_id
2318: AND product_code = 'RCV';
2319: END IF;
2320: IF (l_msni_count = 0) THEN
2321: UPDATE mtl_transaction_lots_interface
2322: SET serial_transaction_temp_id = NULL
2323: WHERE product_transaction_id = p_transaction_temp_id
2324: AND product_code = 'RCV';
2325: END IF;

Line 3952: UPDATE mtl_transaction_lots_interface

3948: AND product_code = 'RCV';
3949: END IF;
3950:
3951: IF l_msni_count = 0 THEN
3952: UPDATE mtl_transaction_lots_interface
3953: SET serial_transaction_temp_id = NULL
3954: WHERE product_transaction_id = p_transaction_temp_id
3955: AND product_code = 'RCV';
3956: END IF;