APPS.JAI_RCV_RCV_RTV_PKG dependencies on RCV_SHIPMENT_LINES

Line 365: cursor c_rcv_shipment_lines(cp_shipment_line_id number) is

361: -- jai_rcv_trx_processing_pkg.india_receipt) attribute_category
362: from rcv_transactions
363: where transaction_id = cp_transaction_id;
364:
365: cursor c_rcv_shipment_lines(cp_shipment_line_id number) is
366: select from_organization_id,
367: to_organization_id
368: from rcv_shipment_lines
369: where shipment_line_id = cp_shipment_line_id;

Line 368: from rcv_shipment_lines

364:
365: cursor c_rcv_shipment_lines(cp_shipment_line_id number) is
366: select from_organization_id,
367: to_organization_id
368: from rcv_shipment_lines
369: where shipment_line_id = cp_shipment_line_id;
370:
371: cursor c_rcv_shipment_headers(cp_shipment_header_id number) is
372: select upper(receipt_source_code) receipt_source_code,

Line 380: r_rcv_shipment_lines c_rcv_shipment_lines%rowtype;

376:
377:
378: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;
379: r_rcv_transactions c_rcv_transactions%rowtype;
380: r_rcv_shipment_lines c_rcv_shipment_lines%rowtype;
381: r_rcv_shipment_headers c_rcv_shipment_headers%rowtype;
382:
383: ln_boe_account_id number;
384: ln_rtv_expense_account_id number;

Line 481: open c_rcv_shipment_lines(r_rcv_transactions.shipment_line_id);

477: fetch c_rcv_shipment_headers into r_rcv_shipment_headers;
478: close c_rcv_shipment_headers;
479:
480: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
481: open c_rcv_shipment_lines(r_rcv_transactions.shipment_line_id);
482: fetch c_rcv_shipment_lines into r_rcv_shipment_lines;
483: close c_rcv_shipment_lines;
484:
485: if p_debug = 'Y' then

Line 482: fetch c_rcv_shipment_lines into r_rcv_shipment_lines;

478: close c_rcv_shipment_headers;
479:
480: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
481: open c_rcv_shipment_lines(r_rcv_transactions.shipment_line_id);
482: fetch c_rcv_shipment_lines into r_rcv_shipment_lines;
483: close c_rcv_shipment_lines;
484:
485: if p_debug = 'Y' then
486: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> get_accounts');

Line 483: close c_rcv_shipment_lines;

479:
480: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
481: open c_rcv_shipment_lines(r_rcv_transactions.shipment_line_id);
482: fetch c_rcv_shipment_lines into r_rcv_shipment_lines;
483: close c_rcv_shipment_lines;
484:
485: if p_debug = 'Y' then
486: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> get_accounts');
487: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/

Line 543: p_from_organization_id => r_rcv_shipment_lines.from_organization_id,

539: (
540: p_organization_id => r_ja_in_rcv_transactions.organization_id,
541: p_location_id => r_ja_in_rcv_transactions.location_id,
542: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
543: p_from_organization_id => r_rcv_shipment_lines.from_organization_id,
544: p_to_organization_id => r_rcv_shipment_lines.to_organization_id ,
545: p_po_distribution_id => r_rcv_transactions.po_distribution_id,
546: p_po_line_location_id => r_rcv_transactions.po_line_location_id,
547: /** OUT parameters **/

Line 544: p_to_organization_id => r_rcv_shipment_lines.to_organization_id ,

540: p_organization_id => r_ja_in_rcv_transactions.organization_id,
541: p_location_id => r_ja_in_rcv_transactions.location_id,
542: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
543: p_from_organization_id => r_rcv_shipment_lines.from_organization_id,
544: p_to_organization_id => r_rcv_shipment_lines.to_organization_id ,
545: p_po_distribution_id => r_rcv_transactions.po_distribution_id,
546: p_po_line_location_id => r_rcv_transactions.po_line_location_id,
547: /** OUT parameters **/
548: p_boe_account_id => ln_boe_account_id,