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 295: cursor c_rcv_shipment_headers(cp_shipment_header_id number) is

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,
297: receipt_num
298: from rcv_shipment_headers
299: where shipment_header_id = cp_shipment_header_id;

Line 298: from rcv_shipment_headers

294:
295: cursor c_rcv_shipment_headers(cp_shipment_header_id number) is
296: select upper(receipt_source_code) receipt_source_code,
297: receipt_num
298: from rcv_shipment_headers
299: where shipment_header_id = cp_shipment_header_id;
300:
301:
302: r_ja_in_rcv_transactions c_ja_in_rcv_transactions%rowtype;

Line 305: r_rcv_shipment_headers c_rcv_shipment_headers%rowtype;

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

Line 387: open c_rcv_shipment_headers(r_rcv_transactions.shipment_header_id);

383: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
384: close c_ja_in_rcv_transactions;
385:
386: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
387: open c_rcv_shipment_headers(r_rcv_transactions.shipment_header_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 */

Line 388: fetch c_rcv_shipment_headers into r_rcv_shipment_headers;

384: close c_ja_in_rcv_transactions;
385:
386: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
387: open c_rcv_shipment_headers(r_rcv_transactions.shipment_header_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);

Line 389: close c_rcv_shipment_headers;

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

Line 453: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,

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

Line 538: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,

534: (
535: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
536: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
537: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
538: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
539: p_boe_account_id => ln_boe_account_id,
540: p_rtv_expense_account_id => ln_rtv_expense_account_id,
541: p_excise_expense_account => ln_excise_expense_account,
542: p_excise_rcvble_account => ln_excise_rcvble_account,

Line 623: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,

619: p_transaction_id => p_transaction_id,
620: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
621: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
622: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
623: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
624: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
625: p_receipt_num => r_rcv_shipment_headers.receipt_num,
626: p_receiving_account_id => ln_receiving_account_id,
627: p_ap_accrual_account => ln_ap_accrual_account,

Line 625: p_receipt_num => r_rcv_shipment_headers.receipt_num,

621: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
622: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
623: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
624: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
625: p_receipt_num => r_rcv_shipment_headers.receipt_num,
626: p_receiving_account_id => ln_receiving_account_id,
627: p_ap_accrual_account => ln_ap_accrual_account,
628: p_boe_account_id => ln_boe_account_id,
629: p_rtv_expense_account_id => ln_rtv_expense_account_id,

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

666:
667: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
668: /*Bug 5632406 Start*/
669: if (lb_account_service_interim and nvl(ln_service_recoverable, 0) <> 0 )
670: and r_rcv_shipment_headers.receipt_source_code <> 'CUSTOMER'
671: /* bug#5632406 - bduvarag used the p_receipt_source_code
672: instead of nvl(r_rcv_transactions.attribute_category, 'XX') <> 'INDIA RMA RECEIPT'*/
673: then
674: /*Bug 5632406 End*/

Line 687: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,

683: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
684: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
685: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
686: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
687: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
688: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
689: p_receipt_num => r_rcv_shipment_headers.receipt_num,
690: p_regime_code => jai_constants.service_regime,
691: ptr_jv => tr_jv,/*Bug 5632406*/

Line 689: p_receipt_num => r_rcv_shipment_headers.receipt_num,

685: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
686: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
687: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
688: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
689: p_receipt_num => r_rcv_shipment_headers.receipt_num,
690: p_regime_code => jai_constants.service_regime,
691: ptr_jv => tr_jv,/*Bug 5632406*/
692: p_simulation => p_simulation,
693: p_process_flag => p_process_flag,

Line 707: if nvl(ln_vat_recoverable, 0) <> 0 and r_rcv_shipment_headers.receipt_source_code <> 'CUSTOMER' then/Bug 5527885/

703:
704: end if;
705:
706: /* following call added by Vijay Shankar for Bug#4250236(4245089). VAT Impl. */
707: if nvl(ln_vat_recoverable, 0) <> 0 and r_rcv_shipment_headers.receipt_source_code <> 'CUSTOMER' then/*Bug 5527885*/
708: p_codepath := jai_general_pkg.plot_codepath(10.2, p_codepath); /* 10.2 */ /*Bug 5527885*/
709: /* VAT interim accounting required as recoverable vat tax exists */
710: regime_tax_accounting_interim
711: (

Line 720: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,

716: p_transaction_type => r_ja_in_rcv_transactions.transaction_type,
717: p_currency_conversion_rate => r_ja_in_rcv_transactions.currency_conversion_rate,
718: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
719: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
720: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
721: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
722: p_receipt_num => r_rcv_shipment_headers.receipt_num,
723: p_regime_code => jai_constants.vat_regime,
724: ptr_jv => tr_jv,/*Bug 5632406*/

Line 722: p_receipt_num => r_rcv_shipment_headers.receipt_num,

718: p_parent_transaction_type => r_ja_in_rcv_transactions.parent_transaction_type,
719: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. p_attribute_category => r_rcv_transactions.attribute_category,
720: p_receipt_source_code => r_rcv_shipment_headers.receipt_source_code,
721: p_transaction_date => r_ja_in_rcv_transactions.transaction_date,
722: p_receipt_num => r_rcv_shipment_headers.receipt_num,
723: p_regime_code => jai_constants.vat_regime,
724: ptr_jv => tr_jv,/*Bug 5632406*/
725: p_simulation => p_simulation,
726: p_process_flag => p_process_flag,