APPS.JAI_PO_HOOK_PKG dependencies on RCV_TRANSACTIONS

Line 66: FROM RCV_TRANSACTIONS

62: WHERE requisition_header_id = p_header_id;
63:
64: CURSOR rcpt_cur IS
65: SELECT *
66: FROM RCV_TRANSACTIONS
67: WHERE shipment_header_id = p_header_id
68: AND shipment_line_id = p_line_id
69: AND transaction_type = 'RECEIVE';
70:

Line 104: RCV_TRANSACTIONS_INTERFACE rtxns,

100: -- rtxns.CURRENCY_CONVERSION_RATE, /*rchandan for 5961325*/
101: -- rtxns.CURRENCY_CONVERSION_DATE, /*rchandan for 5961325*/
102: poll.org_id /*rchandan for 5961325*/
103: FROM JAI_CMN_LINES lines,
104: RCV_TRANSACTIONS_INTERFACE rtxns,
105: po_line_locations_all poll
106: WHERE lines.interface_transaction_id =
107: rtxns.interface_transaction_id
108: AND lines.HEADER_INTERFACE_ID = rtxns.HEADER_INTERFACE_ID

Line 590: UPDATE rcv_transactions

586: END calc_taxes;
587:
588: PROCEDURE update_rcv_trxs(P_transaction_id IN NUMBER) IS
589: BEGIN
590: UPDATE rcv_transactions
591: SET attribute4 = 'Y', attribute_category = 'India Return to Vendor'
592: WHERE transaction_id = P_transaction_id;
593:
594: END update_rcv_trxs;

Line 633: UPDATE JAI_RCV_TRANSACTIONS

629: ELSIF p_process_Action = 'N' THEN
630: lv_process_flag := 'P';
631: END IF;
632:
633: UPDATE JAI_RCV_TRANSACTIONS
634: SET process_status = lv_process_flag,
635: cenvat_rg_status = lv_process_flag,
636: cenvat_rg_message = NULL,
637: process_vat_status = lv_process_flag

Line 865: from rcv_transactions_interface

861: retcode OUT NOCOPY VARCHAR2
862: ) IS
863: CURSOR c_txns_interface(cp_hdr_intf_id IN NUMBER) IS
864: /*select *
865: from rcv_transactions_interface
866: where HEADER_INTERFACE_ID = cp_hdr_intf_id;*/
867: SELECT rtxn.*,
868: (SELECT currency_code
869: FROM po_headers_all

Line 874: FROM rcv_transactions_interface rtxn

870: WHERE po_header_id = rtxn.po_header_id) CUR_CODE,
871: (SELECT quantity
872: FROM po_line_locations_all
873: WHERE LINE_LOCATION_ID = rtxn.PO_LINE_LOCATION_ID) TOT_QUANTITY
874: FROM rcv_transactions_interface rtxn
875: WHERE rtxn.HEADER_INTERFACE_ID = cp_hdr_intf_id;
876:
877: CURSOR c_hdr_interface(cp_hdr_intf_id IN NUMBER) IS
878: SELECT shipment_num

Line 1039: UPDATE RCV_TRANSACTIONS_INTERFACE

1035: retcode OUT NOCOPY VARCHAR2
1036: ) IS
1037: lv_attr_categ VARCHAR2(30) := 'India Receipt';
1038: BEGIN
1039: UPDATE RCV_TRANSACTIONS_INTERFACE
1040: SET ATTRIBUTE_CATEGORY = lv_attr_categ,
1041: ATTRIBUTE1 = p_invoice_num,
1042: ATTRIBUTE2 = P_invoice_date
1043: WHERE INTERFACE_TRANSACTION_ID = P_transaction_id;

Line 1086: FROM rcv_transactions

1082: WHERE requisition_line_id = cp_reqn_line_id;
1083: /* Get the conversion rate for the currency code for the receipt shipment line */
1084: CURSOR c_conv_rate_rcpt(cp_shipment_line_id IN NUMBER) IS
1085: SELECT currency_conversion_rate, currency_code
1086: FROM rcv_transactions
1087: WHERE shipment_line_id = cp_shipment_line_id
1088: AND transaction_type = 'RECEIVE';
1089: /* Get the RFQ / PO / BPA tax amount for each line location currency code wise*/
1090: CURSOR c_po_rfq IS

Line 1603: UPDATE RCV_TRANSACTIONS_INTERFACE

1599: SET PROCESSING_STATUS_CODE = 'IL_PENDING'
1600: WHERE header_interface_id = lv_header_id
1601: AND PROCESSING_STATUS_CODE = 'PENDING';
1602:
1603: UPDATE RCV_TRANSACTIONS_INTERFACE
1604: SET PROCESSING_STATUS_CODE = 'IL_PENDING'
1605: WHERE header_interface_id = lv_header_id
1606: AND PROCESSING_STATUS_CODE = 'PENDING';
1607:

Line 1615: UPDATE RCV_TRANSACTIONS_INTERFACE

1611: SET PROCESSING_STATUS_CODE = 'PENDING'
1612: WHERE header_interface_id = lv_header_id
1613: AND PROCESSING_STATUS_CODE = 'IL_PENDING';
1614:
1615: UPDATE RCV_TRANSACTIONS_INTERFACE
1616: SET PROCESSING_STATUS_CODE = 'PENDING'
1617: WHERE header_interface_id = lv_header_id
1618: AND PROCESSING_STATUS_CODE = 'IL_PENDING';
1619:

Line 2162: FROM rcv_transactions

2158: CURSOR conv_rate_rcpt_csr(pn_shipment_line_id IN NUMBER) IS
2159: SELECT
2160: currency_conversion_rate
2161: , currency_code
2162: FROM rcv_transactions
2163: WHERE shipment_line_id = pn_shipment_line_id
2164: AND transaction_type = 'RECEIVE';
2165:
2166: --Get the RFQ / PO / BPA tax amount for each line location currency code