APPS.CSD_RECEIVE_PVT dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 718: INSERT INTO mtl_transaction_lots_interface

714: || ']'
715: );
716: END IF;
717:
718: INSERT INTO mtl_transaction_lots_interface
719: (transaction_interface_id, source_code,
720: source_line_id, last_update_date, last_updated_by,
721: creation_date, created_by, last_update_login,
722: lot_number, lot_expiration_date,

Line 737: 'UPDATE mtl_transaction_lots_interface SET product_code=''RCV'' ';

733: --
734: -- Dynamic sql is being used to ensure that the code is not dependent on
735: -- the 11.5.0 PO code. This will be only run time dependent.(functional dependence)
736: sql_str :=
737: 'UPDATE mtl_transaction_lots_interface SET product_code=''RCV'' ';
738: sql_str :=
739: sql_str
740: || ',product_transaction_id='
741: || 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 1454: DELETE FROM mtl_transaction_lots_interface

1450: ----------------------------------------------Delete from the MTL lots/MTL serial numbers
1451: --------------------------------------------- interface table.
1452: FOR l_txn_rec in cur_transactions(p_request_group_id) LOOP
1453: BEGIN
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