APPS.CSD_RECEIVE_PVT dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 785: INSERT INTO mtl_serial_numbers_interface

781: || ']'
782: );
783: END IF;
784:
785: INSERT INTO mtl_serial_numbers_interface
786: (transaction_interface_id, source_code,
787: source_line_id, last_update_date, last_updated_by,
788: creation_date, created_by, last_update_login,
789: fm_serial_number,

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

800: --
801: -- Dynamic sql is being used to ensure that the code is not dependent on
802: -- the 11.5.0 PO code. This will be only run time dependent.(functional dependence)
803: sql_str :=
804: 'UPDATE mtl_serial_numbers_interface SET product_code=''RCV'' ';
805: sql_str :=
806: sql_str
807: || ',product_transaction_id='
808: || l_intf_txn_id

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

1370:
1371: /*-----------------------------------------------------------------------------------------------------------*/
1372: /* procedure name: DELETE_INTF_TBLS */
1373: /* description : Deletes records in RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE., PO_INTERFACE_ERRORS*/
1374: /* MTL_TRANSACTION_LOTS_INTERFACE_TBL, MTL_SERIAL_NUMBERS_INTERFACE_TBL tables. */
1375: /* Called from : receive_item api */
1376: /* Input Parm : */
1377: /* p_request_group_id NUMBER Required */
1378: /* p_interface_transaction_Id NUMBER Required */

Line 1458: DELETE FROM mtl_serial_numbers_interface

1454: DELETE FROM mtl_transaction_lots_interface
1455: WHERE TRANSACTION_INTERFACE_ID = l_txn_rec.interface_transaction_Id
1456: RETURNING SERIAL_TRANSACTION_TEMP_ID into l_txn_temp_id;
1457:
1458: DELETE FROM mtl_serial_numbers_interface
1459: WHERE (TRANSACTION_INTERFACE_ID = l_txn_rec.interface_transaction_Id
1460: OR TRANSACTION_INTERFACE_ID = l_txn_temp_id);
1461: EXCEPTION
1462: WHEN NO_DATA_FOUND