APPS.CSD_RECEIVE_PVT dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 842: INSERT INTO mtl_serial_numbers_interface

838: || ']'
839: );
840: END IF;
841:
842: INSERT INTO mtl_serial_numbers_interface
843: (transaction_interface_id, source_code,
844: source_line_id, last_update_date, last_updated_by,
845: creation_date, created_by, last_update_login,
846: fm_serial_number,

Line 861: 'UPDATE mtl_serial_numbers_interface SET product_code=''RCV'' ';

857: --
858: -- Dynamic sql is being used to ensure that the code is not dependent on
859: -- the 11.5.0 PO code. This will be only run time dependent.(functional dependence)
860: sql_str :=
861: 'UPDATE mtl_serial_numbers_interface SET product_code=''RCV'' ';
862: sql_str :=
863: sql_str
864: || ',product_transaction_id='
865: || l_intf_txn_id

Line 1461: /* MTL_TRANSACTION_LOTS_INTERFACE_TBL, MTL_SERIAL_NUMBERS_INTERFACE_TBL tables. */

1457:
1458: /*-----------------------------------------------------------------------------------------------------------*/
1459: /* procedure name: DELETE_INTF_TBLS */
1460: /* description : Deletes records in RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE., PO_INTERFACE_ERRORS*/
1461: /* MTL_TRANSACTION_LOTS_INTERFACE_TBL, MTL_SERIAL_NUMBERS_INTERFACE_TBL tables. */
1462: /* Called from : receive_item api */
1463: /* Input Parm : */
1464: /* p_request_group_id NUMBER Required */
1465: /* p_interface_transaction_Id NUMBER Required */

Line 1545: DELETE FROM mtl_serial_numbers_interface

1541: DELETE FROM mtl_transaction_lots_interface
1542: WHERE TRANSACTION_INTERFACE_ID = l_txn_rec.interface_transaction_Id
1543: RETURNING SERIAL_TRANSACTION_TEMP_ID into l_txn_temp_id;
1544:
1545: DELETE FROM mtl_serial_numbers_interface
1546: WHERE (TRANSACTION_INTERFACE_ID = l_txn_rec.interface_transaction_Id
1547: OR TRANSACTION_INTERFACE_ID = l_txn_temp_id);
1548: EXCEPTION
1549: WHEN NO_DATA_FOUND