eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RCV_RCV_RTV_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 371: cursor c_rcv_shipment_headers(cp_shipment_header_id number) is

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,
373: receipt_num
374: from rcv_shipment_headers
375: where shipment_header_id = cp_shipment_header_id;

Line 374: from rcv_shipment_headers

370:
371: cursor c_rcv_shipment_headers(cp_shipment_header_id number) is
372: select upper(receipt_source_code) receipt_source_code,
373: receipt_num
374: from rcv_shipment_headers
375: where shipment_header_id = cp_shipment_header_id;
376:
377:
378: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;

Line 381: r_rcv_shipment_headers c_rcv_shipment_headers%rowtype;

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;
385: ln_excise_expense_account number;

Line 476: open c_rcv_shipment_headers(r_rcv_transactions.shipment_header_id);

472: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
473: close c_ja_in_rcv_transactions;
474:
475: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
476: open c_rcv_shipment_headers(r_rcv_transactions.shipment_header_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 */

Line 477: fetch c_rcv_shipment_headers into r_rcv_shipment_headers;

473: close c_ja_in_rcv_transactions;
474:
475: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
476: open c_rcv_shipment_headers(r_rcv_transactions.shipment_header_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);

Line 478: close c_rcv_shipment_headers;

474:
475: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
476: open c_rcv_shipment_headers(r_rcv_transactions.shipment_header_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;

Line 542: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,

538: get_accounts
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,

Line 641: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,

637: (
638: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
639: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
640: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
641: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
642: p_boe_account_id => ln_boe_account_id,
643: p_rtv_expense_account_id => ln_rtv_expense_account_id,
644: p_excise_expense_account => ln_excise_expense_account,
645: p_excise_rcvble_account => ln_excise_rcvble_account,

Line 737: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,

733: p_transaction_id => p_transaction_id,
734: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
735: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
736: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
737: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
738: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
739: p_receipt_num => r_rcv_shipment_headers.receipt_num,
740: p_receiving_account_id => ln_receiving_account_id,
741: p_ap_accrual_account => ln_ap_accrual_account,

Line 739: p_receipt_num => r_rcv_shipment_headers.receipt_num,

735: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
736: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
737: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
738: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
739: p_receipt_num => r_rcv_shipment_headers.receipt_num,
740: p_receiving_account_id => ln_receiving_account_id,
741: p_ap_accrual_account => ln_ap_accrual_account,
742: p_boe_account_id => ln_boe_account_id,
743: p_rtv_expense_account_id => ln_rtv_expense_account_id,

Line 799: and r_rcv_shipment_headers.receipt_source_code <> 'CUSTOMER'

795:
796: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
797: /*Bug 5632406 Start*/
798: if (lb_account_service_interim and nvl(ln_service_recoverable, 0) <> 0 )
799: and r_rcv_shipment_headers.receipt_source_code <> 'CUSTOMER'
800: /* bug#5632406 - bduvarag used the p_receipt_source_code
801: instead of nvl(r_rcv_transactions.attribute_category, 'XX') <> 'INDIA RMA RECEIPT'*/
802: then
803: /*Bug 5632406 End*/

Line 816: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,

812: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
813: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
814: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
815: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
816: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
817: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
818: p_receipt_num => r_rcv_shipment_headers.receipt_num,
819: p_regime_code => jai_constants.service_regime,
820: ptr_jv => tr_jv,/*Bug 5632406*/

Line 818: p_receipt_num => r_rcv_shipment_headers.receipt_num,

814: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
815: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
816: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
817: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
818: p_receipt_num => r_rcv_shipment_headers.receipt_num,
819: p_regime_code => jai_constants.service_regime,
820: ptr_jv => tr_jv,/*Bug 5632406*/
821: p_simulation => p_simulation,
822: p_process_flag => p_process_flag,

Line 837: and r_rcv_shipment_headers.receipt_source_code <> 'CUSTOMER' then/Bug 5527885/

833: end if;
834:
835: /* following call added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
836: if (nvl(ln_vat_recoverable, 0) <> 0 OR nvl(ln_inclu_vat_recoverable,0) <> 0) /*Bug 16598602 VAT interim accounting required as inclusive vat tax exists*/
837: and r_rcv_shipment_headers.receipt_source_code <> 'CUSTOMER' then/*Bug 5527885*/
838: p_codepath := jai_general_pkg.plot_codepath(10.2, p_codepath); /* 10.2 */ /*Bug 5527885*/
839: /* VAT interim accounting required as recoverable vat tax exists */
840: regime_tax_accounting_interim
841: (

Line 850: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,

846: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
847: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
848: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
849: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
850: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
851: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
852: p_receipt_num => r_rcv_shipment_headers.receipt_num,
853: p_regime_code => jai_constants.vat_regime,
854: ptr_jv => tr_jv,/*Bug 5632406*/

Line 852: p_receipt_num => r_rcv_shipment_headers.receipt_num,

848: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
849: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
850: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
851: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
852: p_receipt_num => r_rcv_shipment_headers.receipt_num,
853: p_regime_code => jai_constants.vat_regime,
854: ptr_jv => tr_jv,/*Bug 5632406*/
855: p_simulation => p_simulation,
856: p_process_flag => p_process_flag,