APPS.JAI_FA_MA_TRIGGER_PKG dependencies on RCV_TRANSACTIONS

Line 49: cursor c_rcv_transactions(p_transaction_id number) is

45: select currency_code
46: from gl_sets_of_books
47: where set_of_books_id = p_set_of_books_id;
48:
49: cursor c_rcv_transactions(p_transaction_id number) is
50: select shipment_line_id,
51: vendor_id
52: from rcv_transactions
53: where transaction_id = p_transaction_id;

Line 52: from rcv_transactions

48:
49: cursor c_rcv_transactions(p_transaction_id number) is
50: select shipment_line_id,
51: vendor_id
52: from rcv_transactions
53: where transaction_id = p_transaction_id;
54:
55: /* Added by LGOPALSA. Bug 4210102.
56: * Added CVD and Customs Education Cess */

Line 90: r_rcv_transactions c_rcv_transactions%rowtype;

86: and process_flag <> 'Y';
87:
88:
89: r_ap_invoice_lines_all c_ap_invoice_lines_all%rowtype; /*rchandan for bug#4454657*/
90: r_rcv_transactions c_rcv_transactions%rowtype;
91: r_ja_in_receipt_tax_lines c_ja_in_receipt_tax_lines%rowtype;
92: r_gl_sets_of_books c_gl_sets_of_books%rowtype;
93: ln_boe_3p_count number:=0;
94: lb_result boolean;

Line 202: open c_rcv_transactions(r_ap_invoice_lines_all.rcv_transaction_id);

198: /* PO and/or Receipt references does not exist, no need to process */
199: return;
200: end if;
201:
202: open c_rcv_transactions(r_ap_invoice_lines_all.rcv_transaction_id);
203: fetch c_rcv_transactions into r_rcv_transactions;
204: close c_rcv_transactions;
205:
206: /* All validations are over at this point, now check if BOE or third party tax exists */

Line 203: fetch c_rcv_transactions into r_rcv_transactions;

199: return;
200: end if;
201:
202: open c_rcv_transactions(r_ap_invoice_lines_all.rcv_transaction_id);
203: fetch c_rcv_transactions into r_rcv_transactions;
204: close c_rcv_transactions;
205:
206: /* All validations are over at this point, now check if BOE or third party tax exists */
207: open c_ja_in_receipt_tax_lines(r_rcv_transactions.shipment_line_id, r_rcv_transactions.vendor_id);

Line 204: close c_rcv_transactions;

200: end if;
201:
202: open c_rcv_transactions(r_ap_invoice_lines_all.rcv_transaction_id);
203: fetch c_rcv_transactions into r_rcv_transactions;
204: close c_rcv_transactions;
205:
206: /* All validations are over at this point, now check if BOE or third party tax exists */
207: open c_ja_in_receipt_tax_lines(r_rcv_transactions.shipment_line_id, r_rcv_transactions.vendor_id);
208: fetch c_ja_in_receipt_tax_lines into ln_boe_3p_count;

Line 207: open c_ja_in_receipt_tax_lines(r_rcv_transactions.shipment_line_id, r_rcv_transactions.vendor_id);

203: fetch c_rcv_transactions into r_rcv_transactions;
204: close c_rcv_transactions;
205:
206: /* All validations are over at this point, now check if BOE or third party tax exists */
207: open c_ja_in_receipt_tax_lines(r_rcv_transactions.shipment_line_id, r_rcv_transactions.vendor_id);
208: fetch c_ja_in_receipt_tax_lines into ln_boe_3p_count;
209: close c_ja_in_receipt_tax_lines;
210:
211: if ln_boe_3p_count <= 0 then

Line 336: FROM rcv_transactions

332:
333: CURSOR c_get_ship_head_id(p_rcv_transaction_id NUMBER) is
334: SELECT shipment_header_id,
335: shipment_line_id
336: FROM rcv_transactions
337: WHERE transaction_id = p_rcv_transaction_id;
338:
339:
340: CURSOR item_mod_cur(c_shipment_line_id number) IS