APPS.JAI_RCV_RCV_RTV_PKG dependencies on RCV_SHIPMENT_LINES

Line 289: cursor c_rcv_shipment_lines(cp_shipment_line_id number) is

285: -- jai_rcv_trx_processing_pkg.india_receipt) attribute_category
286: from rcv_transactions
287: where transaction_id = cp_transaction_id;
288:
289: cursor c_rcv_shipment_lines(cp_shipment_line_id number) is
290: select from_organization_id,
291: to_organization_id
292: from rcv_shipment_lines
293: where shipment_line_id = cp_shipment_line_id;

Line 292: from rcv_shipment_lines

288:
289: cursor c_rcv_shipment_lines(cp_shipment_line_id number) is
290: select from_organization_id,
291: to_organization_id
292: from rcv_shipment_lines
293: where shipment_line_id = cp_shipment_line_id;
294:
295: cursor c_rcv_shipment_headers(cp_shipment_header_id number) is
296: select upper(receipt_source_code) receipt_source_code,

Line 304: r_rcv_shipment_lines c_rcv_shipment_lines%rowtype;

300:
301:
302: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;
303: r_rcv_transactions c_rcv_transactions%rowtype;
304: r_rcv_shipment_lines c_rcv_shipment_lines%rowtype;
305: r_rcv_shipment_headers c_rcv_shipment_headers%rowtype;
306:
307: ln_boe_account_id number;
308: ln_rtv_expense_account_id number;

Line 392: open c_rcv_shipment_lines(r_rcv_transactions.shipment_line_id);

388: fetch c_rcv_shipment_headers into r_rcv_shipment_headers;
389: close c_rcv_shipment_headers;
390:
391: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
392: open c_rcv_shipment_lines(r_rcv_transactions.shipment_line_id);
393: fetch c_rcv_shipment_lines into r_rcv_shipment_lines;
394: close c_rcv_shipment_lines;
395:
396: if p_debug = 'Y' then

Line 393: fetch c_rcv_shipment_lines into r_rcv_shipment_lines;

389: close c_rcv_shipment_headers;
390:
391: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
392: open c_rcv_shipment_lines(r_rcv_transactions.shipment_line_id);
393: fetch c_rcv_shipment_lines into r_rcv_shipment_lines;
394: close c_rcv_shipment_lines;
395:
396: if p_debug = 'Y' then
397: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> get_accounts');

Line 394: close c_rcv_shipment_lines;

390:
391: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
392: open c_rcv_shipment_lines(r_rcv_transactions.shipment_line_id);
393: fetch c_rcv_shipment_lines into r_rcv_shipment_lines;
394: close c_rcv_shipment_lines;
395:
396: if p_debug = 'Y' then
397: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> get_accounts');
398: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/

Line 454: p_from_organization_id => r_rcv_shipment_lines.from_organization_id,

450: (
451: p_organization_id => r_ja_in_rcv_transactions.organization_id,
452: p_location_id => r_ja_in_rcv_transactions.location_id,
453: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
454: p_from_organization_id => r_rcv_shipment_lines.from_organization_id,
455: p_to_organization_id => r_rcv_shipment_lines.to_organization_id ,
456: p_po_distribution_id => r_rcv_transactions.po_distribution_id,
457: p_po_line_location_id => r_rcv_transactions.po_line_location_id,
458: /** OUT parameters **/

Line 455: p_to_organization_id => r_rcv_shipment_lines.to_organization_id ,

451: p_organization_id => r_ja_in_rcv_transactions.organization_id,
452: p_location_id => r_ja_in_rcv_transactions.location_id,
453: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
454: p_from_organization_id => r_rcv_shipment_lines.from_organization_id,
455: p_to_organization_id => r_rcv_shipment_lines.to_organization_id ,
456: p_po_distribution_id => r_rcv_transactions.po_distribution_id,
457: p_po_line_location_id => r_rcv_transactions.po_line_location_id,
458: /** OUT parameters **/
459: p_boe_account_id => ln_boe_account_id,