APPS.JAI_FA_ASSETS_PKG dependencies on RCV_TRANSACTIONS

Line 86: cursor c_rcv_transactions(p_transaction_id number) is

82: and invoice_line_number = p_invoice_line_number
83: and distribution_line_number = p_distribution_line_number;
84:
85:
86: cursor c_rcv_transactions(p_transaction_id number) is
87: select shipment_line_id,
88: vendor_id
89: from rcv_transactions
90: where transaction_id = p_transaction_id;

Line 89: from rcv_transactions

85:
86: cursor c_rcv_transactions(p_transaction_id number) is
87: select shipment_line_id,
88: vendor_id
89: from rcv_transactions
90: where transaction_id = p_transaction_id;
91:
92: /* Added by LGOPALSA. Bug 4210102.
93: * Added CVD and Customs Education Cess */

Line 123: r_rcv_transactions c_rcv_transactions%rowtype;

119: select fa_mass_additions_s.nextval
120: from dual;
121:
122: r_ap_invoice_lines_all c_ap_invoice_lines_all%rowtype;
123: r_rcv_transactions c_rcv_transactions%rowtype;
124: r_ja_in_receipt_tax_lines c_ja_in_receipt_tax_lines%rowtype;
125: r_ja_in_tax_codes c_ja_in_tax_codes%rowtype;
126: ln_no_of_tax_for_inv_line number;
127: lv_phase varchar2(100);

Line 225: open c_rcv_transactions(r_ap_invoice_lines_all.rcv_transaction_id);

221: fetch c_ap_invoice_lines_all into r_ap_invoice_lines_all;
222: close c_ap_invoice_lines_all;
223:
224:
225: open c_rcv_transactions(r_ap_invoice_lines_all.rcv_transaction_id);
226: fetch c_rcv_transactions into r_rcv_transactions;
227: close c_rcv_transactions;
228:
229: /* Appotion factor between receipt and invoice */

Line 226: fetch c_rcv_transactions into r_rcv_transactions;

222: close c_ap_invoice_lines_all;
223:
224:
225: open c_rcv_transactions(r_ap_invoice_lines_all.rcv_transaction_id);
226: fetch c_rcv_transactions into r_rcv_transactions;
227: close c_rcv_transactions;
228:
229: /* Appotion factor between receipt and invoice */
230: ln_apportion_factor :=

Line 227: close c_rcv_transactions;

223:
224:
225: open c_rcv_transactions(r_ap_invoice_lines_all.rcv_transaction_id);
226: fetch c_rcv_transactions into r_rcv_transactions;
227: close c_rcv_transactions;
228:
229: /* Appotion factor between receipt and invoice */
230: ln_apportion_factor :=
231: jai_ap_utils_pkg.get_apportion_factor(cur_rec_invoice_line.invoice_id, cur_rec_invoice_line.invoice_line_number); /*rchandan for bug#4454657*/

Line 243: c_ja_in_receipt_tax_lines(r_rcv_transactions.shipment_line_id, r_rcv_transactions.vendor_id)

239:
240: ln_no_of_tax_for_inv_line := 0;
241:
242: for cur_rec_taxes in
243: c_ja_in_receipt_tax_lines(r_rcv_transactions.shipment_line_id, r_rcv_transactions.vendor_id)
244: loop
245:
246: open c_ja_in_tax_codes(cur_rec_taxes.tax_id);
247: fetch c_ja_in_tax_codes into r_ja_in_tax_codes;

Line 467: FROM PO_HEADERS_ALL A, RCV_TRANSACTIONS B, RCV_SHIPMENT_HEADERS C

463: --This is for Fetching the PO Number for the Receipt Number...............
464: FOR C_FETCH_PO_NUMBER_RECEIPT IN
465: (
466: SELECT SEGMENT1
467: FROM PO_HEADERS_ALL A, RCV_TRANSACTIONS B, RCV_SHIPMENT_HEADERS C
468: WHERE A.PO_HEADER_ID = B.PO_HEADER_ID
469: AND B.SHIPMENT_HEADER_ID = C.SHIPMENT_HEADER_ID
470: AND B.TRANSACTION_TYPE =lv_transaction_type--rchandan for bug#4428980
471: AND A.VENDOR_ID = B.VENDOR_ID