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_EXCISE_PROCESSING_PKG dependencies on JAI_CMN_RG_PLA_TRXS

Line 453: lv_remarks JAI_CMN_RG_PLA_TRXS.REMARKS%TYPE;

449: ln_other_tax_credit NUMBER ;
450: ln_transaction_id NUMBER(10);
451: lv_transaction_type VARCHAR2(50);
452: ln_register_id NUMBER ;
453: lv_remarks JAI_CMN_RG_PLA_TRXS.REMARKS%TYPE;
454: lv_statement_id VARCHAR2(5);
455: lv_process_status VARCHAR2(2);
456: lv_process_message VARCHAR2(2000);
457: lv_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;

Line 490: jai_cmn_rg_pla_trxs_pkg.get_trxn_type_and_id(lv_transaction_type,

486: END IF;
487: lv_statement_id := '2';
488: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath);
489: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
490: jai_cmn_rg_pla_trxs_pkg.get_trxn_type_and_id(lv_transaction_type,
491: pr_base_trx.source_document_code,
492: ln_transaction_id);
493: lv_statement_id := '3';
494: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath);

Line 506: FROM jai_cmn_rg_pla_trxs

502: dr_other_ed,
503: other_tax_credit,
504: other_tax_debit,
505: remarks
506: FROM jai_cmn_rg_pla_trxs
507: WHERE organization_id = pr_tax.organization_id
508: AND location_id = pr_tax.location_id
509: AND inventory_item_id = pr_tax.inventory_item_id
510: AND ref_document_id = pr_tax.transaction_id

Line 610: JAI_CMN_RG_PLA_TRXS_PKG.update_row(

606: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath);
607: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
608:
609: /* Update PLA with the latest difference amount to the existing amount */
610: JAI_CMN_RG_PLA_TRXS_PKG.update_row(
611: P_REGISTER_ID => ln_register_id,
612: P_CR_BASIC_ED => ln_cr_basic,
613: P_CR_ADDITIONAL_ED => ln_cr_addl,
614: P_CR_OTHER_ED => ln_cr_other,

Line 3277: ln_register_id JAI_CMN_RG_PLA_TRXS.register_id%TYPE;

3273: r_trx c_trx%ROWTYPE;
3274: r_base_trx c_base_trx%ROWTYPE;
3275: r_orgn_info c_orgn_info%ROWTYPE;
3276:
3277: ln_register_id JAI_CMN_RG_PLA_TRXS.register_id%TYPE;
3278: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
3279: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
3280: lv_excise_invoice_no JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE;
3281: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;

Line 3280: lv_excise_invoice_no JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE;

3276:
3277: ln_register_id JAI_CMN_RG_PLA_TRXS.register_id%TYPE;
3278: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
3279: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
3280: lv_excise_invoice_no JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE;
3281: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;
3282: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
3283:
3284: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;

Line 3281: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;

3277: ln_register_id JAI_CMN_RG_PLA_TRXS.register_id%TYPE;
3278: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
3279: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
3280: lv_excise_invoice_no JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE;
3281: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;
3282: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
3283:
3284: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;
3285: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;

Line 3284: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;

3280: lv_excise_invoice_no JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE;
3281: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;
3282: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
3283:
3284: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;
3285: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;
3286: ln_cr_other JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE;
3287: ln_dr_basic JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE;
3288: ln_dr_addl JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE;

Line 3285: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;

3281: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;
3282: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
3283:
3284: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;
3285: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;
3286: ln_cr_other JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE;
3287: ln_dr_basic JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE;
3288: ln_dr_addl JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE;
3289: ln_dr_other JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE;

Line 3286: ln_cr_other JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE;

3282: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
3283:
3284: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;
3285: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;
3286: ln_cr_other JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE;
3287: ln_dr_basic JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE;
3288: ln_dr_addl JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE;
3289: ln_dr_other JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE;
3290:

Line 3287: ln_dr_basic JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE;

3283:
3284: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;
3285: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;
3286: ln_cr_other JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE;
3287: ln_dr_basic JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE;
3288: ln_dr_addl JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE;
3289: ln_dr_other JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE;
3290:
3291: lv_statement_id VARCHAR2(5);

Line 3288: ln_dr_addl JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE;

3284: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;
3285: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;
3286: ln_cr_other JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE;
3287: ln_dr_basic JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE;
3288: ln_dr_addl JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE;
3289: ln_dr_other JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE;
3290:
3291: lv_statement_id VARCHAR2(5);
3292: ln_other_tax_credit NUMBER;

Line 3289: ln_dr_other JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE;

3285: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;
3286: ln_cr_other JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE;
3287: ln_dr_basic JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE;
3288: ln_dr_addl JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE;
3289: ln_dr_other JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE;
3290:
3291: lv_statement_id VARCHAR2(5);
3292: ln_other_tax_credit NUMBER;
3293: ln_other_tax_debit NUMBER;

Line 3392: FND_FILE.put_line(FND_FILE.log,'Calling jai_cmn_rg_pla_trxs_pkg.insert_row');

3388: ln_other_tax_credit := pr_tax.excise_edu_cess + pr_tax.cvd_edu_cess+nvl(pr_tax.sh_exc_edu_cess,0)+ nvl(pr_tax.sh_cvd_edu_cess,0);/*added pr_tax.sh_exc_edu_cess + pr_tax.sh_cvd_edu_cess by vkaranam for budget 07 impact - bug#5989740*/
3389: END IF;
3390:
3391: if lb_rg_debug then
3392: FND_FILE.put_line(FND_FILE.log,'Calling jai_cmn_rg_pla_trxs_pkg.insert_row');
3393: end if;
3394:
3395: lv_statement_id := '5';
3396: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */

Line 3397: jai_cmn_rg_pla_trxs_pkg.insert_row(

3393: end if;
3394:
3395: lv_statement_id := '5';
3396: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
3397: jai_cmn_rg_pla_trxs_pkg.insert_row(
3398: p_register_id => p_register_id,
3399: p_tr6_challan_no => NULL,
3400: p_tr6_challan_date => NULL,
3401: p_cr_basic_ed => ln_cr_basic,

Line 4863: jai_cmn_rg_pla_trxs_pkg.update_payment_details(

4859:
4860: ELSIF p_payment_register = 'PLA' THEN
4861: lv_statement_id := '6';
4862: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
4863: jai_cmn_rg_pla_trxs_pkg.update_payment_details(
4864: p_register_id => p_payment_register_id,
4865: p_charge_account_id => p_charge_account_id
4866: );
4867:

Line 6426: lv_reference_name := 'JAI_CMN_RG_PLA_TRXS';

6422: lv_statement_id := '8';
6423: IF pv_process_status IN ('E', 'X') THEN
6424: GOTO end_of_procedure;
6425: END IF;
6426: lv_reference_name := 'JAI_CMN_RG_PLA_TRXS';
6427: ln_reference_id := ln_part_ii_register_id;
6428: else
6429: lv_statement_id := '9';
6430: pv_codepath := jai_general_pkg.plot_codepath(17.2, pv_codepath);