APPS.AHL_OSP_RCV_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

Line 788: FROM RCV_TRANSACTIONS_INTERFACE

784:
785: -- Cursor to check whether a pending receipt transaction exists for a given PO line id.
786: CURSOR chk_pending_transaction (c_po_line_id NUMBER) IS
787: SELECT 'X'
788: FROM RCV_TRANSACTIONS_INTERFACE
789: WHERE po_line_id = c_po_line_id
790: AND processing_status_code = 'PENDING';
791:
792: -- Cursor to get the 'ship to org id' for a given PO line id.

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

1055:
1056: -- Get the difference between the PO line quantity and the total received quantity.
1057: l_po_diff_qty := l_po_line_qty - l_po_line_tot_qty;
1058:
1059: -- Insert a record in RCV_TRANSACTIONS_INTERFACE table corresponsing to this PO line.
1060: INSERT INTO RCV_TRANSACTIONS_INTERFACE(
1061: INTERFACE_TRANSACTION_ID,
1062: HEADER_INTERFACE_ID,
1063: GROUP_ID,

Line 1060: INSERT INTO RCV_TRANSACTIONS_INTERFACE(

1056: -- Get the difference between the PO line quantity and the total received quantity.
1057: l_po_diff_qty := l_po_line_qty - l_po_line_tot_qty;
1058:
1059: -- Insert a record in RCV_TRANSACTIONS_INTERFACE table corresponsing to this PO line.
1060: INSERT INTO RCV_TRANSACTIONS_INTERFACE(
1061: INTERFACE_TRANSACTION_ID,
1062: HEADER_INTERFACE_ID,
1063: GROUP_ID,
1064: LAST_UPDATE_DATE,

Line 1083: PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,

1079: PO_HEADER_ID,
1080: PO_LINE_ID,
1081: SHIP_TO_LOCATION_ID
1082: ) VALUES (
1083: PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
1084: PO.RCV_HEADERS_INTERFACE_S.CURRVAL,
1085: PO.RCV_INTERFACE_GROUPS_S.CURRVAL,
1086: SYSDATE,
1087: FND_GLOBAL.USER_ID,

Line 1325: FROM RCV_TRANSACTIONS_INTERFACE

1321:
1322: -- Cursor to check whether a pending receipt transaction exists for a given order line id.
1323: CURSOR chk_pending_transaction (c_oe_line_id NUMBER) IS
1324: SELECT 'X'
1325: FROM RCV_TRANSACTIONS_INTERFACE
1326: WHERE oe_order_line_id = c_oe_line_id
1327: AND processing_status_code = 'PENDING';
1328:
1329: CURSOR get_err_tranansaction_dtls(c_oe_line_id NUMBER) IS

Line 1331: FROM RCV_TRANSACTIONS_INTERFACE

1327: AND processing_status_code = 'PENDING';
1328:
1329: CURSOR get_err_tranansaction_dtls(c_oe_line_id NUMBER) IS
1330: SELECT interface_transaction_id, header_interface_id
1331: FROM RCV_TRANSACTIONS_INTERFACE
1332: WHERE oe_order_line_id = c_oe_line_id
1333: AND processing_status_code = 'ERROR';
1334:
1335: CURSOR get_same_phyitem_order_lines(c_osp_order_line_id IN NUMBER) IS

Line 1903: DELETE FROM RCV_TRANSACTIONS_INTERFACE

1899:
1900: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE
1901: WHERE PRODUCT_TRANSACTION_ID = l_err_intf_trans_id;
1902:
1903: DELETE FROM RCV_TRANSACTIONS_INTERFACE
1904: WHERE INTERFACE_TRANSACTION_ID = l_err_intf_trans_id;
1905:
1906: DELETE FROM RCV_HEADERS_INTERFACE
1907: WHERE HEADER_INTERFACE_ID = l_err_intf_hdr_id;

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

1913:
1914: --Initialize the sequences that are to be used.
1915: SELECT PO.RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;
1916: SELECT PO.RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM sys.dual;
1917: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;
1918: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;
1919:
1920: --select the user related ids
1921: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;

Line 1968: INSERT INTO RCV_TRANSACTIONS_INTERFACE

1964: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'l_intf_hdr_id:'||l_intf_hdr_id);
1965: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'l_group_id:'||l_group_id);
1966: END IF;
1967:
1968: INSERT INTO RCV_TRANSACTIONS_INTERFACE
1969: (
1970: INTERFACE_TRANSACTION_ID,
1971: HEADER_INTERFACE_ID,
1972: GROUP_ID,