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.

[Home] [Help]

APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on JAI_CMN_RG_PLA_TRXS

Line 322: lv_remarks JAI_CMN_RG_PLA_TRXS.REMARKS%TYPE;

318: ln_other_tax_credit NUMBER ;
319: ln_transaction_id NUMBER(10);
320: lv_transaction_type VARCHAR2(50);
321: ln_register_id NUMBER ;
322: lv_remarks JAI_CMN_RG_PLA_TRXS.REMARKS%TYPE;
323: lv_statement_id VARCHAR2(5);
324: lv_process_status VARCHAR2(2);
325: lv_process_message VARCHAR2(2000);
326: lv_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;

Line 359: jai_cmn_rg_pla_trxs_pkg.get_trxn_type_and_id(lv_transaction_type,

355: END IF;
356: lv_statement_id := '2';
357: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath);
358: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
359: jai_cmn_rg_pla_trxs_pkg.get_trxn_type_and_id(lv_transaction_type,
360: pr_base_trx.source_document_code,
361: ln_transaction_id);
362: lv_statement_id := '3';
363: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath);

Line 375: FROM jai_cmn_rg_pla_trxs

371: dr_other_ed,
372: other_tax_credit,
373: other_tax_debit,
374: remarks
375: FROM jai_cmn_rg_pla_trxs
376: WHERE organization_id = pr_tax.organization_id
377: AND location_id = pr_tax.location_id
378: AND inventory_item_id = pr_tax.inventory_item_id
379: AND ref_document_id = pr_tax.transaction_id

Line 479: JAI_CMN_RG_PLA_TRXS_PKG.update_row(

475: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath);
476: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
477:
478: /* Update PLA with the latest difference amount to the existing amount */
479: JAI_CMN_RG_PLA_TRXS_PKG.update_row(
480: P_REGISTER_ID => ln_register_id,
481: P_CR_BASIC_ED => ln_cr_basic,
482: P_CR_ADDITIONAL_ED => ln_cr_addl,
483: P_CR_OTHER_ED => ln_cr_other,

Line 2969: ln_register_id JAI_CMN_RG_PLA_TRXS.register_id%TYPE;

2965: r_trx c_trx%ROWTYPE;
2966: r_base_trx c_base_trx%ROWTYPE;
2967: r_orgn_info c_orgn_info%ROWTYPE;
2968:
2969: ln_register_id JAI_CMN_RG_PLA_TRXS.register_id%TYPE;
2970: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2971: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2972: lv_excise_invoice_no JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE;
2973: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;

Line 2972: lv_excise_invoice_no JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE;

2968:
2969: ln_register_id JAI_CMN_RG_PLA_TRXS.register_id%TYPE;
2970: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2971: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2972: lv_excise_invoice_no JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE;
2973: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;
2974: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2975:
2976: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;

Line 2973: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;

2969: ln_register_id JAI_CMN_RG_PLA_TRXS.register_id%TYPE;
2970: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2971: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2972: lv_excise_invoice_no JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE;
2973: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;
2974: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2975:
2976: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;
2977: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;

Line 2976: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;

2972: lv_excise_invoice_no JAI_CMN_RG_PLA_TRXS.DR_INVOICE_NO%TYPE;
2973: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;
2974: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2975:
2976: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;
2977: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;
2978: ln_cr_other JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE;
2979: ln_dr_basic JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE;
2980: ln_dr_addl JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE;

Line 2977: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;

2973: ld_excise_invoice_date JAI_CMN_RG_PLA_TRXS.dr_invoice_date%TYPE;
2974: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2975:
2976: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;
2977: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;
2978: ln_cr_other JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE;
2979: ln_dr_basic JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE;
2980: ln_dr_addl JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE;
2981: ln_dr_other JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE;

Line 2978: ln_cr_other JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE;

2974: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2975:
2976: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;
2977: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;
2978: ln_cr_other JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE;
2979: ln_dr_basic JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE;
2980: ln_dr_addl JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE;
2981: ln_dr_other JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE;
2982:

Line 2979: ln_dr_basic JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE;

2975:
2976: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;
2977: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;
2978: ln_cr_other JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE;
2979: ln_dr_basic JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE;
2980: ln_dr_addl JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE;
2981: ln_dr_other JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE;
2982:
2983: lv_statement_id VARCHAR2(5);

Line 2980: ln_dr_addl JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE;

2976: ln_cr_basic JAI_CMN_RG_PLA_TRXS.cr_basic_ed%TYPE;
2977: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;
2978: ln_cr_other JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE;
2979: ln_dr_basic JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE;
2980: ln_dr_addl JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE;
2981: ln_dr_other JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE;
2982:
2983: lv_statement_id VARCHAR2(5);
2984: ln_other_tax_credit NUMBER;

Line 2981: ln_dr_other JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE;

2977: ln_cr_addl JAI_CMN_RG_PLA_TRXS.cr_additional_ed%TYPE;
2978: ln_cr_other JAI_CMN_RG_PLA_TRXS.cr_other_ed%TYPE;
2979: ln_dr_basic JAI_CMN_RG_PLA_TRXS.dr_basic_ed%TYPE;
2980: ln_dr_addl JAI_CMN_RG_PLA_TRXS.dr_additional_ed%TYPE;
2981: ln_dr_other JAI_CMN_RG_PLA_TRXS.dr_other_ed%TYPE;
2982:
2983: lv_statement_id VARCHAR2(5);
2984: ln_other_tax_credit NUMBER;
2985: ln_other_tax_debit NUMBER;

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

3060: 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*/
3061: END IF;
3062:
3063: if lb_rg_debug then
3064: FND_FILE.put_line(FND_FILE.log,'Calling jai_cmn_rg_pla_trxs_pkg.insert_row');
3065: end if;
3066:
3067: lv_statement_id := '5';
3068: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */

Line 3069: jai_cmn_rg_pla_trxs_pkg.insert_row(

3065: end if;
3066:
3067: lv_statement_id := '5';
3068: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
3069: jai_cmn_rg_pla_trxs_pkg.insert_row(
3070: p_register_id => p_register_id,
3071: p_tr6_challan_no => NULL,
3072: p_tr6_challan_date => NULL,
3073: p_cr_basic_ed => ln_cr_basic,

Line 4495: jai_cmn_rg_pla_trxs_pkg.update_payment_details(

4491:
4492: ELSIF p_payment_register = 'PLA' THEN
4493: lv_statement_id := '6';
4494: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
4495: jai_cmn_rg_pla_trxs_pkg.update_payment_details(
4496: p_register_id => p_payment_register_id,
4497: p_charge_account_id => p_charge_account_id
4498: );
4499:

Line 5839: lv_reference_name := 'JAI_CMN_RG_PLA_TRXS';

5835: lv_statement_id := '8';
5836: IF pv_process_status IN ('E', 'X') THEN
5837: GOTO end_of_procedure;
5838: END IF;
5839: lv_reference_name := 'JAI_CMN_RG_PLA_TRXS';
5840: ln_reference_id := ln_part_ii_register_id;
5841: else
5842: lv_statement_id := '9';
5843: pv_codepath := jai_general_pkg.plot_codepath(17.2, pv_codepath);