APPS.CSD_RECEIVE_PVT dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 774: INSERT INTO mtl_transaction_lots_interface

770: || ']'
771: );
772: END IF;
773:
774: INSERT INTO mtl_transaction_lots_interface
775: (transaction_interface_id, source_code,
776: source_line_id, last_update_date, last_updated_by,
777: creation_date, created_by, last_update_login,
778: lot_number, lot_expiration_date,

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

790: --
791: -- Dynamic sql is being used to ensure that the code is not dependent on
792: -- the 11.5.0 PO code. This will be only run time dependent.(functional dependence)
793: sql_str :=
794: 'UPDATE mtl_transaction_lots_interface SET product_code=''RCV'' ';
795: sql_str :=
796: sql_str
797: || ',product_transaction_id='
798: || 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 1541: DELETE FROM mtl_transaction_lots_interface

1537: ----------------------------------------------Delete from the MTL lots/MTL serial numbers
1538: --------------------------------------------- interface table.
1539: FOR l_txn_rec in cur_transactions(p_request_group_id) LOOP
1540: BEGIN
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