APPS.JAI_PO_HOOK_PKG dependencies on RCV_TRANSACTIONS_INTERFACE

Line 144: RCV_TRANSACTIONS_INTERFACE rtxns,

140: -- rtxns.CURRENCY_CONVERSION_RATE, /*rchandan for 5961325*/
141: -- rtxns.CURRENCY_CONVERSION_DATE, /*rchandan for 5961325*/
142: poll.org_id /*rchandan for 5961325*/
143: FROM JAI_CMN_LINES lines,
144: RCV_TRANSACTIONS_INTERFACE rtxns,
145: po_line_locations_all poll
146: WHERE lines.interface_transaction_id =
147: rtxns.interface_transaction_id
148: AND lines.HEADER_INTERFACE_ID = rtxns.HEADER_INTERFACE_ID

Line 957: from rcv_transactions_interface

953: retcode OUT NOCOPY VARCHAR2
954: ) IS
955: CURSOR c_txns_interface(cp_hdr_intf_id IN NUMBER) IS
956: /*select *
957: from rcv_transactions_interface
958: where HEADER_INTERFACE_ID = cp_hdr_intf_id;*/
959: SELECT rtxn.*,
960: (SELECT currency_code
961: FROM po_headers_all

Line 966: FROM rcv_transactions_interface rtxn

962: WHERE po_header_id = rtxn.po_header_id) CUR_CODE,
963: (SELECT quantity
964: FROM po_line_locations_all
965: WHERE LINE_LOCATION_ID = rtxn.PO_LINE_LOCATION_ID) TOT_QUANTITY
966: FROM rcv_transactions_interface rtxn
967: WHERE rtxn.HEADER_INTERFACE_ID = cp_hdr_intf_id;
968:
969: CURSOR c_hdr_interface(cp_hdr_intf_id IN NUMBER) IS
970: SELECT shipment_num

Line 1154: UPDATE RCV_TRANSACTIONS_INTERFACE

1150: retcode OUT NOCOPY VARCHAR2
1151: ) IS
1152: lv_attr_categ VARCHAR2(30) := 'India Receipt';
1153: BEGIN
1154: UPDATE RCV_TRANSACTIONS_INTERFACE
1155: SET ATTRIBUTE_CATEGORY = lv_attr_categ,
1156: ATTRIBUTE1 = p_invoice_num,
1157: ATTRIBUTE2 = P_invoice_date
1158: WHERE INTERFACE_TRANSACTION_ID = P_transaction_id;

Line 1740: UPDATE RCV_TRANSACTIONS_INTERFACE

1736: SET PROCESSING_STATUS_CODE = 'IL_PENDING'
1737: WHERE header_interface_id = lv_header_id
1738: AND PROCESSING_STATUS_CODE = 'PENDING';
1739:
1740: UPDATE RCV_TRANSACTIONS_INTERFACE
1741: SET PROCESSING_STATUS_CODE = 'IL_PENDING'
1742: WHERE header_interface_id = lv_header_id
1743: AND PROCESSING_STATUS_CODE = 'PENDING';
1744:

Line 1752: UPDATE RCV_TRANSACTIONS_INTERFACE

1748: SET PROCESSING_STATUS_CODE = 'PENDING'
1749: WHERE header_interface_id = lv_header_id
1750: AND PROCESSING_STATUS_CODE = 'IL_PENDING';
1751:
1752: UPDATE RCV_TRANSACTIONS_INTERFACE
1753: SET PROCESSING_STATUS_CODE = 'PENDING'
1754: WHERE header_interface_id = lv_header_id
1755: AND PROCESSING_STATUS_CODE = 'IL_PENDING';
1756: