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_CMN_RCV_MATCHING_PKG dependencies on JAI_CONSTANTS

Line 543: v_exempt_flag := jai_constants.no; --Ramananda for File.Sql.35

539:
540:
541: BEGIN
542:
543: v_exempt_flag := jai_constants.no; --Ramananda for File.Sql.35
544:
545: IF p_ref_line_id IS NULL THEN
546: RAISE_APPLICATION_ERROR( -20120, 'Ref Line Id cannot be NULL' );
547: END IF;

Line 1361: lv_sh_excise_cess_code VARCHAR2(25) := JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS;/Bug 5989740 bduvarag/

1357: ---------------------------------------------------
1358:
1359: -- added by Vijay Shankar for Bug# 3781299
1360: lv_excise_cess_code VARCHAR2(25); -- := 'EXCISE_EDUCATION_CESS'; --Ramananda for File.Sql.35
1361: lv_sh_excise_cess_code VARCHAR2(25) := JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS;/*Bug 5989740 bduvarag*/
1362: lv_cvd_cess_code VARCHAR2(25); -- := 'CVD_EDUCATION_CESS'; --Ramananda for File.Sql.35
1363: lv_sh_cvd_cess_code VARCHAR2(25) := JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS;/*Bug 5989740 bduvarag*/
1364: ln_cess_check NUMBER := -1;
1365: ln_sh_cess_check NUMBER := -1;/*Bug 5989740 bduvarag*/

Line 1363: lv_sh_cvd_cess_code VARCHAR2(25) := JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS;/Bug 5989740 bduvarag/

1359: -- added by Vijay Shankar for Bug# 3781299
1360: lv_excise_cess_code VARCHAR2(25); -- := 'EXCISE_EDUCATION_CESS'; --Ramananda for File.Sql.35
1361: lv_sh_excise_cess_code VARCHAR2(25) := JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS;/*Bug 5989740 bduvarag*/
1362: lv_cvd_cess_code VARCHAR2(25); -- := 'CVD_EDUCATION_CESS'; --Ramananda for File.Sql.35
1363: lv_sh_cvd_cess_code VARCHAR2(25) := JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS;/*Bug 5989740 bduvarag*/
1364: ln_cess_check NUMBER := -1;
1365: ln_sh_cess_check NUMBER := -1;/*Bug 5989740 bduvarag*/
1366: ln_transaction_id NUMBER(15);
1367:

Line 1500: AND jrttv.regime_code = jai_constants.vat_regime), 5,

1496: lv_sh_cvd_cess_code,4, --added by sacsethi for budget07 enhancement
1497: (SELECT jrttv.tax_type
1498: FROM jai_regime_tax_types_v jrttv
1499: WHERE jrttv.tax_type = upper(b.tax_type)
1500: AND jrttv.regime_code = jai_constants.vat_regime), 5,
1501: 'VAT REVERSAL', 6, 0) tax_type_val,
1502: b.mod_cr_Percentage ,
1503: b.vendor_id ,
1504: b.tax_type ,

Line 1863: v_exempt_flag := jai_constants.no; --Ramananda for File.Sql.35

1859: --------------------------------------------------------------------------------------------*/
1860:
1861: lv_excise_cess_code := 'EXCISE_EDUCATION_CESS'; --Ramananda for File.Sql.35
1862: lv_cvd_cess_code := 'CVD_EDUCATION_CESS'; --Ramananda for File.Sql.35
1863: v_exempt_flag := jai_constants.no; --Ramananda for File.Sql.35
1864:
1865: IF p_ref_line_id IS NULL THEN
1866: RAISE_APPLICATION_ERROR( -20120, 'Ref Line Id cannot be NULL' );
1867: END IF;

Line 1878: if rec.tax_type in( jai_constants.tax_type_exc_edu_cess,

1874:
1875: for rec in cur_cess_Duty_Rate_Cur
1876: loop /*bduvarag for the bug#6038720 start*/
1877:
1878: if rec.tax_type in( jai_constants.tax_type_exc_edu_cess,
1879: jai_constants.tax_type_cvd_edu_cess)
1880: then
1881: ln_cess_duty_amount := NVL(ln_cess_duty_amount,0) + rec.credit ;
1882: elsif rec.tax_type in( jai_constants.tax_type_sh_exc_edu_cess,

Line 1879: jai_constants.tax_type_cvd_edu_cess)

1875: for rec in cur_cess_Duty_Rate_Cur
1876: loop /*bduvarag for the bug#6038720 start*/
1877:
1878: if rec.tax_type in( jai_constants.tax_type_exc_edu_cess,
1879: jai_constants.tax_type_cvd_edu_cess)
1880: then
1881: ln_cess_duty_amount := NVL(ln_cess_duty_amount,0) + rec.credit ;
1882: elsif rec.tax_type in( jai_constants.tax_type_sh_exc_edu_cess,
1883: jai_constants.tax_type_sh_cvd_edu_cess)

Line 1882: elsif rec.tax_type in( jai_constants.tax_type_sh_exc_edu_cess,

1878: if rec.tax_type in( jai_constants.tax_type_exc_edu_cess,
1879: jai_constants.tax_type_cvd_edu_cess)
1880: then
1881: ln_cess_duty_amount := NVL(ln_cess_duty_amount,0) + rec.credit ;
1882: elsif rec.tax_type in( jai_constants.tax_type_sh_exc_edu_cess,
1883: jai_constants.tax_type_sh_cvd_edu_cess)
1884: then
1885: ln_sh_cess_duty_amount := NVL(ln_sh_cess_duty_amount,0) + rec.credit ;
1886:

Line 1883: jai_constants.tax_type_sh_cvd_edu_cess)

1879: jai_constants.tax_type_cvd_edu_cess)
1880: then
1881: ln_cess_duty_amount := NVL(ln_cess_duty_amount,0) + rec.credit ;
1882: elsif rec.tax_type in( jai_constants.tax_type_sh_exc_edu_cess,
1883: jai_constants.tax_type_sh_cvd_edu_cess)
1884: then
1885: ln_sh_cess_duty_amount := NVL(ln_sh_cess_duty_amount,0) + rec.credit ;
1886:
1887: /*bduvarag for the bug#6038720 end*/