APPS.AHL_OSP_RCV_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

Line 1018: FROM RCV_TRANSACTIONS_INTERFACE

1014:
1015: -- Cursor to check whether a pending receipt transaction exists for a given PO line id.
1016: CURSOR chk_pending_transaction (c_po_line_id NUMBER) IS
1017: SELECT 'X'
1018: FROM RCV_TRANSACTIONS_INTERFACE
1019: WHERE po_line_id = c_po_line_id
1020: AND processing_status_code = 'PENDING';
1021:
1022: -- Cursor to get the 'ship to org id' for a given PO line id.

Line 1289: -- Insert a record in RCV_TRANSACTIONS_INTERFACE table corresponsing to this PO line.

1285:
1286: -- Get the difference between the PO line quantity and the total received quantity.
1287: l_po_diff_qty := l_po_line_qty - l_po_line_tot_qty;
1288:
1289: -- Insert a record in RCV_TRANSACTIONS_INTERFACE table corresponsing to this PO line.
1290: INSERT INTO RCV_TRANSACTIONS_INTERFACE(
1291: INTERFACE_TRANSACTION_ID,
1292: HEADER_INTERFACE_ID,
1293: GROUP_ID,

Line 1290: INSERT INTO RCV_TRANSACTIONS_INTERFACE(

1286: -- Get the difference between the PO line quantity and the total received quantity.
1287: l_po_diff_qty := l_po_line_qty - l_po_line_tot_qty;
1288:
1289: -- Insert a record in RCV_TRANSACTIONS_INTERFACE table corresponsing to this PO line.
1290: INSERT INTO RCV_TRANSACTIONS_INTERFACE(
1291: INTERFACE_TRANSACTION_ID,
1292: HEADER_INTERFACE_ID,
1293: GROUP_ID,
1294: LAST_UPDATE_DATE,

Line 1313: PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,

1309: PO_HEADER_ID,
1310: PO_LINE_ID,
1311: SHIP_TO_LOCATION_ID
1312: ) VALUES (
1313: PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
1314: PO.RCV_HEADERS_INTERFACE_S.CURRVAL,
1315: PO.RCV_INTERFACE_GROUPS_S.CURRVAL,
1316: SYSDATE,
1317: FND_GLOBAL.USER_ID,

Line 1555: FROM RCV_TRANSACTIONS_INTERFACE

1551:
1552: -- Cursor to check whether a pending receipt transaction exists for a given order line id.
1553: CURSOR chk_pending_transaction (c_oe_line_id NUMBER) IS
1554: SELECT 'X'
1555: FROM RCV_TRANSACTIONS_INTERFACE
1556: WHERE oe_order_line_id = c_oe_line_id
1557: AND processing_status_code = 'PENDING';
1558:
1559: CURSOR get_err_tranansaction_dtls(c_oe_line_id NUMBER) IS

Line 1561: FROM RCV_TRANSACTIONS_INTERFACE

1557: AND processing_status_code = 'PENDING';
1558:
1559: CURSOR get_err_tranansaction_dtls(c_oe_line_id NUMBER) IS
1560: SELECT interface_transaction_id, header_interface_id
1561: FROM RCV_TRANSACTIONS_INTERFACE
1562: WHERE oe_order_line_id = c_oe_line_id
1563: AND processing_status_code = 'ERROR';
1564:
1565: CURSOR get_same_phyitem_order_lines(c_osp_order_line_id IN NUMBER) IS

Line 2180: DELETE FROM RCV_TRANSACTIONS_INTERFACE

2176:
2177: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE
2178: WHERE PRODUCT_TRANSACTION_ID = l_err_intf_trans_id;
2179:
2180: DELETE FROM RCV_TRANSACTIONS_INTERFACE
2181: WHERE INTERFACE_TRANSACTION_ID = l_err_intf_trans_id;
2182:
2183: DELETE FROM RCV_HEADERS_INTERFACE
2184: WHERE HEADER_INTERFACE_ID = l_err_intf_hdr_id;

Line 2194: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;

2190:
2191: --Initialize the sequences that are to be used.
2192: SELECT PO.RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;
2193: SELECT PO.RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM sys.dual;
2194: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;
2195: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;
2196:
2197: --select the user related ids
2198: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;

Line 2245: INSERT INTO RCV_TRANSACTIONS_INTERFACE

2241: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'l_intf_hdr_id:'||l_intf_hdr_id);
2242: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'l_group_id:'||l_group_id);
2243: END IF;
2244:
2245: INSERT INTO RCV_TRANSACTIONS_INTERFACE
2246: (
2247: INTERFACE_TRANSACTION_ID,
2248: HEADER_INTERFACE_ID,
2249: GROUP_ID,