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_INVENTORY_ORGS

Line 2301: lv_cr_rvrsl_flag jai_cmn_inventory_orgs.CENVAT_CR_REVRSL_FLAG%TYPE; --added for bug#9854329

2297: ln_additional_ed NUMBER;
2298: ln_additional_cvd NUMBER; -- Date 30/10/2006 Bug 5228046 added by sacsethi
2299: ln_other_ed NUMBER;
2300: ln_quantity NUMBER;
2301: lv_cr_rvrsl_flag jai_cmn_inventory_orgs.CENVAT_CR_REVRSL_FLAG%TYPE; --added for bug#9854329
2302:
2303: --start additions for bug#9854329
2304: cursor get_rev_flag(cp_organization_id in number,cp_location_id in number)
2305: is

Line 2306: SELECT CENVAT_CR_REVRSL_FLAG FROM jai_cmn_inventory_orgs

2302:
2303: --start additions for bug#9854329
2304: cursor get_rev_flag(cp_organization_id in number,cp_location_id in number)
2305: is
2306: SELECT CENVAT_CR_REVRSL_FLAG FROM jai_cmn_inventory_orgs
2307: WHERE organization_id = cp_organization_id
2308: AND location_id =cp_location_id;
2309:
2310: lv_statement_id VARCHAR2(5);

Line 2952: lv_cr_rvrsl_flag jai_cmn_inventory_orgs.CENVAT_CR_REVRSL_FLAG%TYPE;

2948: lv_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;
2949: lv_source_register JAI_CMN_RG_OTHERS.source_register%TYPE;
2950:
2951: --start additions for bug#9854329
2952: lv_cr_rvrsl_flag jai_cmn_inventory_orgs.CENVAT_CR_REVRSL_FLAG%TYPE;
2953: cursor get_rev_flag(cp_organization_id in number,cp_location_id in number)
2954: is
2955: SELECT CENVAT_CR_REVRSL_FLAG FROM jai_cmn_inventory_orgs
2956: WHERE organization_id = cp_organization_id

Line 2955: SELECT CENVAT_CR_REVRSL_FLAG FROM jai_cmn_inventory_orgs

2951: --start additions for bug#9854329
2952: lv_cr_rvrsl_flag jai_cmn_inventory_orgs.CENVAT_CR_REVRSL_FLAG%TYPE;
2953: cursor get_rev_flag(cp_organization_id in number,cp_location_id in number)
2954: is
2955: SELECT CENVAT_CR_REVRSL_FLAG FROM jai_cmn_inventory_orgs
2956: WHERE organization_id = cp_organization_id
2957: AND location_id =cp_location_id;
2958:
2959: --end bug#9854329

Line 3294: lv_cr_rvrsl_flag jai_cmn_inventory_orgs.CENVAT_CR_REVRSL_FLAG%TYPE; --added for bug#9854329

3290:
3291: lv_statement_id VARCHAR2(5);
3292: ln_other_tax_credit NUMBER;
3293: ln_other_tax_debit NUMBER;
3294: lv_cr_rvrsl_flag jai_cmn_inventory_orgs.CENVAT_CR_REVRSL_FLAG%TYPE; --added for bug#9854329
3295: cursor get_rev_flag(cp_organization_id in number,cp_location_id in number)
3296: is
3297: SELECT CENVAT_CR_REVRSL_FLAG FROM jai_cmn_inventory_orgs
3298: WHERE organization_id = cp_organization_id

Line 3297: SELECT CENVAT_CR_REVRSL_FLAG FROM jai_cmn_inventory_orgs

3293: ln_other_tax_debit NUMBER;
3294: lv_cr_rvrsl_flag jai_cmn_inventory_orgs.CENVAT_CR_REVRSL_FLAG%TYPE; --added for bug#9854329
3295: cursor get_rev_flag(cp_organization_id in number,cp_location_id in number)
3296: is
3297: SELECT CENVAT_CR_REVRSL_FLAG FROM jai_cmn_inventory_orgs
3298: WHERE organization_id = cp_organization_id
3299: AND location_id =cp_location_id;
3300:
3301: BEGIN

Line 3608: lv_cr_rvrsl_flag jai_cmn_inventory_orgs.CENVAT_CR_REVRSL_FLAG%TYPE; --added for bug#9854329

3604: ln_sh_edu_cess_balancin_debit NUMBER;
3605: ln_sh_edu_cess_balancin_credit NUMBER;
3606: ln_sh_bal_edu_cess_debit NUMBER;
3607: ln_sh_bal_edu_cess_credit NUMBER;
3608: lv_cr_rvrsl_flag jai_cmn_inventory_orgs.CENVAT_CR_REVRSL_FLAG%TYPE; --added for bug#9854329
3609: cursor get_rev_flag(cp_organization_id in number,cp_location_id in number)
3610: is
3611: SELECT CENVAT_CR_REVRSL_FLAG FROM jai_cmn_inventory_orgs
3612: WHERE organization_id = cp_organization_id

Line 3611: SELECT CENVAT_CR_REVRSL_FLAG FROM jai_cmn_inventory_orgs

3607: ln_sh_bal_edu_cess_credit NUMBER;
3608: lv_cr_rvrsl_flag jai_cmn_inventory_orgs.CENVAT_CR_REVRSL_FLAG%TYPE; --added for bug#9854329
3609: cursor get_rev_flag(cp_organization_id in number,cp_location_id in number)
3610: is
3611: SELECT CENVAT_CR_REVRSL_FLAG FROM jai_cmn_inventory_orgs
3612: WHERE organization_id = cp_organization_id
3613: AND location_id =cp_location_id;
3614:
3615: