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 226: open c_rcv_transactions(r_ap_invoice_lines_all.rcv_transaction_id);

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

Line 227: fetch c_rcv_transactions into r_rcv_transactions;

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

Line 228: close c_rcv_transactions;

224:
225:
226: open c_rcv_transactions(r_ap_invoice_lines_all.rcv_transaction_id);
227: fetch c_rcv_transactions into r_rcv_transactions;
228: close c_rcv_transactions;
229:
230: /* Appotion factor between receipt and invoice */
231: ln_apportion_factor :=
232: 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 249: c_ja_in_receipt_tax_lines(r_rcv_transactions.shipment_line_id, r_rcv_transactions.vendor_id)

245: end if;
246: ln_no_of_tax_for_inv_line := 0;
247:
248: for cur_rec_taxes in
249: c_ja_in_receipt_tax_lines(r_rcv_transactions.shipment_line_id, r_rcv_transactions.vendor_id)
250: loop
251:
252: open c_ja_in_tax_codes(cur_rec_taxes.tax_id);
253: fetch c_ja_in_tax_codes into r_ja_in_tax_codes;

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

469: --This is for Fetching the PO Number for the Receipt Number...............
470: FOR C_FETCH_PO_NUMBER_RECEIPT IN
471: (
472: SELECT SEGMENT1
473: FROM PO_HEADERS_ALL A, RCV_TRANSACTIONS B, RCV_SHIPMENT_HEADERS C
474: WHERE A.PO_HEADER_ID = B.PO_HEADER_ID
475: AND B.SHIPMENT_HEADER_ID = C.SHIPMENT_HEADER_ID
476: AND B.TRANSACTION_TYPE =lv_transaction_type--rchandan for bug#4428980
477: AND A.VENDOR_ID = B.VENDOR_ID