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

Line 517: lv_tax_type := jai_constants.tax_type_exc_edu_cess ;

513: ln_cess_amount := 0;
514:
515: IF tax = 1 THEN
516:
517: lv_tax_type := jai_constants.tax_type_exc_edu_cess ;
518: ln_prev_cess_cl_bal := nvl(r_prev_cess_period_bal.exc_edu_cess_cl_bal,0);
519: ln_cess_cl_bal := nvl(r_cess_period_bal.exc_edu_cess_cl_bal,0);
520:
521: ELSIF tax = 2 THEN

Line 523: lv_tax_type := jai_constants.tax_type_cvd_edu_cess ;

519: ln_cess_cl_bal := nvl(r_cess_period_bal.exc_edu_cess_cl_bal,0);
520:
521: ELSIF tax = 2 THEN
522:
523: lv_tax_type := jai_constants.tax_type_cvd_edu_cess ;
524: ln_prev_cess_cl_bal := nvl(r_prev_cess_period_bal.cvd_edu_cess_cl_bal,0);
525: ln_cess_cl_bal := nvl(r_cess_period_bal.cvd_edu_cess_cl_bal,0);
526:
527: ELSIF tax = 3 THEN

Line 529: lv_tax_type := jai_constants.tax_type_sh_exc_edu_cess;

525: ln_cess_cl_bal := nvl(r_cess_period_bal.cvd_edu_cess_cl_bal,0);
526:
527: ELSIF tax = 3 THEN
528:
529: lv_tax_type := jai_constants.tax_type_sh_exc_edu_cess;
530: ln_prev_cess_cl_bal := nvl(r_prev_cess_period_bal.sh_exc_edu_cess_cl_bal,0);
531: ln_cess_cl_bal := nvl(r_cess_period_bal.sh_exc_edu_cess_cl_bal,0);
532:
533: ELSIF tax = 4 THEN

Line 535: lv_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;

531: ln_cess_cl_bal := nvl(r_cess_period_bal.sh_exc_edu_cess_cl_bal,0);
532:
533: ELSIF tax = 4 THEN
534:
535: lv_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;
536: ln_prev_cess_cl_bal := nvl(r_prev_cess_period_bal.sh_cvd_edu_cess_cl_bal,0);
537: ln_cess_cl_bal := nvl(r_cess_period_bal.sh_cvd_edu_cess_cl_bal,0);
538:
539: END IF;

Line 1010: lv_tax_type := jai_constants.tax_type_exc_edu_cess ;

1006: CLOSE cur_get_fin_year;
1007:
1008: IF tax = 1 THEN
1009:
1010: lv_tax_type := jai_constants.tax_type_exc_edu_cess ;
1011:
1012: ELSIF tax = 2 THEN
1013:
1014: lv_tax_type := jai_constants.tax_type_cvd_edu_cess ;

Line 1014: lv_tax_type := jai_constants.tax_type_cvd_edu_cess ;

1010: lv_tax_type := jai_constants.tax_type_exc_edu_cess ;
1011:
1012: ELSIF tax = 2 THEN
1013:
1014: lv_tax_type := jai_constants.tax_type_cvd_edu_cess ;
1015:
1016: ELSIF tax = 3 THEN
1017:
1018: lv_tax_type := jai_constants.tax_type_sh_exc_edu_cess;

Line 1018: lv_tax_type := jai_constants.tax_type_sh_exc_edu_cess;

1014: lv_tax_type := jai_constants.tax_type_cvd_edu_cess ;
1015:
1016: ELSIF tax = 3 THEN
1017:
1018: lv_tax_type := jai_constants.tax_type_sh_exc_edu_cess;
1019:
1020: ELSIF tax = 4 THEN
1021:
1022: lv_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;

Line 1022: lv_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;

1018: lv_tax_type := jai_constants.tax_type_sh_exc_edu_cess;
1019:
1020: ELSIF tax = 4 THEN
1021:
1022: lv_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;
1023:
1024: END IF;
1025:
1026: ld_date := p_date;

Line 3046: OPEN cur_get_rg23_cess_slno(rg23_log_rec.organization_id,rg23_log_rec.location_id,ln_fin_year,jai_constants.tax_type_sh_exc_edu_cess,pv_date);

3042: CLOSE cur_get_rg23_cess_trans;
3043:
3044:
3045: ln_rg23_cess_slno := NULL;
3046: OPEN cur_get_rg23_cess_slno(rg23_log_rec.organization_id,rg23_log_rec.location_id,ln_fin_year,jai_constants.tax_type_sh_exc_edu_cess,pv_date);
3047: FETCH cur_get_rg23_cess_slno INTO ln_rg23_cess_slno;
3048: CLOSE cur_get_rg23_cess_slno;
3049:
3050: IF ln_rg23_cess_slno IS NULL THEN

Line 3052: OPEN cur_get_rg23_cess_slno(rg23_log_rec.organization_id,rg23_log_rec.location_id,ln_fin_year-1,jai_constants.tax_type_sh_exc_edu_cess,pv_date);

3048: CLOSE cur_get_rg23_cess_slno;
3049:
3050: IF ln_rg23_cess_slno IS NULL THEN
3051:
3052: OPEN cur_get_rg23_cess_slno(rg23_log_rec.organization_id,rg23_log_rec.location_id,ln_fin_year-1,jai_constants.tax_type_sh_exc_edu_cess,pv_date);
3053: FETCH cur_get_rg23_cess_slno INTO ln_rg23_cess_slno;
3054: CLOSE cur_get_rg23_cess_slno;
3055:
3056: IF ln_rg23_cess_slno IS NULL THEN

Line 3062: OPEN get_rg23_cess_closing_bal(ln_fin_year-1,ln_rg23_cess_slno,jai_constants.tax_type_sh_exc_edu_cess) ;

3058: ln_sh_exc_cess_rg23 := 0;
3059:
3060: ELSE
3061:
3062: OPEN get_rg23_cess_closing_bal(ln_fin_year-1,ln_rg23_cess_slno,jai_constants.tax_type_sh_exc_edu_cess) ;
3063: FETCH get_rg23_cess_closing_bal INTO ln_sh_exc_cess_rg23;
3064: CLOSE get_rg23_cess_closing_bal;
3065:
3066: END IF;

Line 3070: OPEN get_rg23_cess_closing_bal(ln_fin_year,ln_rg23_cess_slno,jai_constants.tax_type_sh_exc_edu_cess) ;

3066: END IF;
3067:
3068: ELSE
3069:
3070: OPEN get_rg23_cess_closing_bal(ln_fin_year,ln_rg23_cess_slno,jai_constants.tax_type_sh_exc_edu_cess) ;
3071: FETCH get_rg23_cess_closing_bal INTO ln_sh_exc_cess_rg23;
3072: CLOSE get_rg23_cess_closing_bal;
3073:
3074: END IF;

Line 3079: jai_constants.tax_type_sh_exc_edu_cess);

3075:
3076: OPEN cur_get_rg23_cess_trans(rg23_log_rec.organization_id,
3077: rg23_log_rec.location_id ,
3078: pv_date ,
3079: jai_constants.tax_type_sh_exc_edu_cess);
3080: FETCH cur_get_rg23_cess_trans INTO ln_sh_exc_cess_rg23_cr,ln_sh_exc_cess_rg23_dr;
3081: CLOSE cur_get_rg23_cess_trans;
3082:
3083: ln_rg23_cess_slno := NULL;

Line 3084: OPEN cur_get_rg23_cess_slno(rg23_log_rec.organization_id,rg23_log_rec.location_id,ln_fin_year,jai_constants.tax_type_sh_cvd_edu_cess,pv_date);

3080: FETCH cur_get_rg23_cess_trans INTO ln_sh_exc_cess_rg23_cr,ln_sh_exc_cess_rg23_dr;
3081: CLOSE cur_get_rg23_cess_trans;
3082:
3083: ln_rg23_cess_slno := NULL;
3084: OPEN cur_get_rg23_cess_slno(rg23_log_rec.organization_id,rg23_log_rec.location_id,ln_fin_year,jai_constants.tax_type_sh_cvd_edu_cess,pv_date);
3085: FETCH cur_get_rg23_cess_slno INTO ln_rg23_cess_slno;
3086: CLOSE cur_get_rg23_cess_slno;
3087:
3088: IF ln_rg23_cess_slno IS NULL THEN

Line 3090: OPEN cur_get_rg23_cess_slno(rg23_log_rec.organization_id,rg23_log_rec.location_id,ln_fin_year-1,jai_constants.tax_type_sh_cvd_edu_cess,pv_date);

3086: CLOSE cur_get_rg23_cess_slno;
3087:
3088: IF ln_rg23_cess_slno IS NULL THEN
3089:
3090: OPEN cur_get_rg23_cess_slno(rg23_log_rec.organization_id,rg23_log_rec.location_id,ln_fin_year-1,jai_constants.tax_type_sh_cvd_edu_cess,pv_date);
3091: FETCH cur_get_rg23_cess_slno INTO ln_rg23_cess_slno;
3092: CLOSE cur_get_rg23_cess_slno;
3093:
3094: IF ln_rg23_cess_slno IS NULL THEN

Line 3100: OPEN get_rg23_cess_closing_bal(ln_fin_year-1,ln_rg23_cess_slno,jai_constants.tax_type_sh_cvd_edu_cess) ;

3096: ln_exc_cess_rg23 := 0;
3097:
3098: ELSE
3099:
3100: OPEN get_rg23_cess_closing_bal(ln_fin_year-1,ln_rg23_cess_slno,jai_constants.tax_type_sh_cvd_edu_cess) ;
3101: FETCH get_rg23_cess_closing_bal INTO ln_sh_cvd_cess_rg23;
3102: CLOSE get_rg23_cess_closing_bal;
3103:
3104: END IF;

Line 3108: OPEN get_rg23_cess_closing_bal(ln_fin_year,ln_rg23_cess_slno,jai_constants.tax_type_sh_cvd_edu_cess) ;

3104: END IF;
3105:
3106: ELSE
3107:
3108: OPEN get_rg23_cess_closing_bal(ln_fin_year,ln_rg23_cess_slno,jai_constants.tax_type_sh_cvd_edu_cess) ;
3109: FETCH get_rg23_cess_closing_bal INTO ln_sh_cvd_cess_rg23;
3110: CLOSE get_rg23_cess_closing_bal;
3111:
3112: END IF;

Line 3117: jai_constants.tax_type_sh_cvd_edu_cess);

3113:
3114: OPEN cur_get_rg23_cess_trans(rg23_log_rec.organization_id,
3115: rg23_log_rec.location_id ,
3116: pv_date ,
3117: jai_constants.tax_type_sh_cvd_edu_cess);
3118: FETCH cur_get_rg23_cess_trans INTO ln_sh_cvd_cess_rg23_cr,ln_sh_cvd_cess_rg23_dr;
3119: CLOSE cur_get_rg23_cess_trans;
3120:
3121:

Line 3145: OPEN cur_get_final_cess_bal(rg23_log_rec.organization_id,rg23_log_rec.location_id,jai_constants.tax_type_sh_exc_edu_cess);

3141: FETCH cur_get_final_cess_bal INTO ln_cvd_cess_rg23_final;
3142: CLOSE cur_get_final_cess_bal;
3143:
3144:
3145: OPEN cur_get_final_cess_bal(rg23_log_rec.organization_id,rg23_log_rec.location_id,jai_constants.tax_type_sh_exc_edu_cess);
3146: FETCH cur_get_final_cess_bal INTO ln_sh_exc_cess_rg23_final;
3147: CLOSE cur_get_final_cess_bal;
3148:
3149: OPEN cur_get_final_cess_bal(rg23_log_rec.organization_id,rg23_log_rec.location_id,jai_constants.tax_type_sh_cvd_edu_cess);

Line 3149: OPEN cur_get_final_cess_bal(rg23_log_rec.organization_id,rg23_log_rec.location_id,jai_constants.tax_type_sh_cvd_edu_cess);

3145: OPEN cur_get_final_cess_bal(rg23_log_rec.organization_id,rg23_log_rec.location_id,jai_constants.tax_type_sh_exc_edu_cess);
3146: FETCH cur_get_final_cess_bal INTO ln_sh_exc_cess_rg23_final;
3147: CLOSE cur_get_final_cess_bal;
3148:
3149: OPEN cur_get_final_cess_bal(rg23_log_rec.organization_id,rg23_log_rec.location_id,jai_constants.tax_type_sh_cvd_edu_cess);
3150: FETCH cur_get_final_cess_bal INTO ln_sh_cvd_cess_rg23_final;
3151: CLOSE cur_get_final_cess_bal;
3152:
3153:

Line 3189: open c_cess_err_exists(rg23_log_rec.organization_id,rg23_log_rec.location_id, rg23_log_rec.register_type,jai_constants.tax_type_sh_exc_edu_cess) ;

3185: end if ;
3186:
3187: ln_err_exists := NULL;
3188:
3189: open c_cess_err_exists(rg23_log_rec.organization_id,rg23_log_rec.location_id, rg23_log_rec.register_type,jai_constants.tax_type_sh_exc_edu_cess) ;
3190: fetch c_cess_err_exists into ln_err_exists ;
3191: close c_cess_err_exists ;
3192:
3193: if nvl(ln_err_exists,0) = 0 then

Line 3200: open c_cess_err_exists(rg23_log_rec.organization_id,rg23_log_rec.location_id, rg23_log_rec.register_type,jai_constants.tax_type_sh_cvd_edu_cess) ;

3196: lv_sh_exc_cess_status := 'INCONSISTENT' ;
3197: end if ;
3198: ln_err_exists := NULL;
3199:
3200: open c_cess_err_exists(rg23_log_rec.organization_id,rg23_log_rec.location_id, rg23_log_rec.register_type,jai_constants.tax_type_sh_cvd_edu_cess) ;
3201: fetch c_cess_err_exists into ln_err_exists ;
3202: close c_cess_err_exists ;
3203:
3204: if nvl(ln_err_exists,0) = 0 then

Line 3369: OPEN cur_get_pla_cess_slno(pla_log_rec.organization_id,pla_log_rec.location_id,ln_fin_year,jai_constants.tax_type_sh_exc_edu_cess,pv_date);

3365:
3366:
3367:
3368: ln_pla_cess_slno := NULL;
3369: OPEN cur_get_pla_cess_slno(pla_log_rec.organization_id,pla_log_rec.location_id,ln_fin_year,jai_constants.tax_type_sh_exc_edu_cess,pv_date);
3370: FETCH cur_get_pla_cess_slno INTO ln_pla_cess_slno;
3371: CLOSE cur_get_pla_cess_slno;
3372:
3373: IF ln_pla_cess_slno IS NULL THEN

Line 3375: OPEN cur_get_pla_cess_slno(pla_log_rec.organization_id,pla_log_rec.location_id,ln_fin_year-1,jai_constants.tax_type_sh_exc_edu_cess,pv_date);

3371: CLOSE cur_get_pla_cess_slno;
3372:
3373: IF ln_pla_cess_slno IS NULL THEN
3374:
3375: OPEN cur_get_pla_cess_slno(pla_log_rec.organization_id,pla_log_rec.location_id,ln_fin_year-1,jai_constants.tax_type_sh_exc_edu_cess,pv_date);
3376: FETCH cur_get_pla_cess_slno INTO ln_pla_cess_slno;
3377: CLOSE cur_get_pla_cess_slno;
3378:
3379: IF ln_pla_cess_slno IS NULL THEN

Line 3385: OPEN get_pla_cess_closing_bal(ln_fin_year-1,ln_pla_cess_slno,jai_constants.tax_type_sh_exc_edu_cess) ;

3381: ln_sh_exc_cess_pla := 0;
3382:
3383: ELSE
3384:
3385: OPEN get_pla_cess_closing_bal(ln_fin_year-1,ln_pla_cess_slno,jai_constants.tax_type_sh_exc_edu_cess) ;
3386: FETCH get_pla_cess_closing_bal INTO ln_sh_exc_cess_pla;
3387: CLOSE get_pla_cess_closing_bal;
3388:
3389: END IF;

Line 3393: OPEN get_pla_cess_closing_bal(ln_fin_year,ln_pla_cess_slno,jai_constants.tax_type_sh_exc_edu_cess) ;

3389: END IF;
3390:
3391: ELSE
3392:
3393: OPEN get_pla_cess_closing_bal(ln_fin_year,ln_pla_cess_slno,jai_constants.tax_type_sh_exc_edu_cess) ;
3394: FETCH get_pla_cess_closing_bal INTO ln_sh_exc_cess_pla;
3395: CLOSE get_pla_cess_closing_bal;
3396:
3397: END IF;

Line 3402: jai_constants.tax_type_sh_exc_edu_cess);

3398:
3399: OPEN cur_get_pla_cess_trans(pla_log_rec.organization_id,
3400: pla_log_rec.location_id ,
3401: pv_date ,
3402: jai_constants.tax_type_sh_exc_edu_cess);
3403: FETCH cur_get_pla_cess_trans INTO ln_sh_exc_cess_pla_cr,ln_sh_exc_cess_pla_dr;
3404: CLOSE cur_get_pla_cess_trans;
3405:
3406: ln_pla_cess_slno := NULL;

Line 3407: OPEN cur_get_pla_cess_slno(pla_log_rec.organization_id,pla_log_rec.location_id,ln_fin_year,jai_constants.tax_type_sh_cvd_edu_cess,pv_date);

3403: FETCH cur_get_pla_cess_trans INTO ln_sh_exc_cess_pla_cr,ln_sh_exc_cess_pla_dr;
3404: CLOSE cur_get_pla_cess_trans;
3405:
3406: ln_pla_cess_slno := NULL;
3407: OPEN cur_get_pla_cess_slno(pla_log_rec.organization_id,pla_log_rec.location_id,ln_fin_year,jai_constants.tax_type_sh_cvd_edu_cess,pv_date);
3408: FETCH cur_get_pla_cess_slno INTO ln_pla_cess_slno;
3409: CLOSE cur_get_pla_cess_slno;
3410:
3411: IF ln_pla_cess_slno IS NULL THEN

Line 3413: OPEN cur_get_pla_cess_slno(pla_log_rec.organization_id,pla_log_rec.location_id,ln_fin_year-1,jai_constants.tax_type_sh_cvd_edu_cess,pv_date);

3409: CLOSE cur_get_pla_cess_slno;
3410:
3411: IF ln_pla_cess_slno IS NULL THEN
3412:
3413: OPEN cur_get_pla_cess_slno(pla_log_rec.organization_id,pla_log_rec.location_id,ln_fin_year-1,jai_constants.tax_type_sh_cvd_edu_cess,pv_date);
3414: FETCH cur_get_pla_cess_slno INTO ln_pla_cess_slno;
3415: CLOSE cur_get_pla_cess_slno;
3416:
3417: IF ln_pla_cess_slno IS NULL THEN

Line 3423: OPEN get_pla_cess_closing_bal(ln_fin_year-1,ln_pla_cess_slno,jai_constants.tax_type_sh_cvd_edu_cess) ;

3419: ln_sh_cvd_cess_pla := 0;
3420:
3421: ELSE
3422:
3423: OPEN get_pla_cess_closing_bal(ln_fin_year-1,ln_pla_cess_slno,jai_constants.tax_type_sh_cvd_edu_cess) ;
3424: FETCH get_pla_cess_closing_bal INTO ln_sh_cvd_cess_pla;
3425: CLOSE get_pla_cess_closing_bal;
3426:
3427: END IF;

Line 3431: OPEN get_pla_cess_closing_bal(ln_fin_year,ln_pla_cess_slno,jai_constants.tax_type_sh_cvd_edu_cess) ;

3427: END IF;
3428:
3429: ELSE
3430:
3431: OPEN get_pla_cess_closing_bal(ln_fin_year,ln_pla_cess_slno,jai_constants.tax_type_sh_cvd_edu_cess) ;
3432: FETCH get_pla_cess_closing_bal INTO ln_sh_cvd_cess_pla;
3433: CLOSE get_pla_cess_closing_bal;
3434:
3435: END IF;

Line 3440: jai_constants.tax_type_sh_cvd_edu_cess);

3436:
3437: OPEN cur_get_pla_cess_trans(pla_log_rec.organization_id,
3438: pla_log_rec.location_id ,
3439: pv_date ,
3440: jai_constants.tax_type_sh_cvd_edu_cess);
3441: FETCH cur_get_pla_cess_trans INTO ln_sh_cvd_cess_pla_cr,ln_sh_cvd_cess_pla_dr;
3442: CLOSE cur_get_pla_cess_trans;
3443:
3444:

Line 3469: OPEN cur_get_final_cess_bal(pla_log_rec.organization_id,pla_log_rec.location_id,jai_constants.tax_type_sh_exc_edu_cess);

3465: CLOSE cur_get_final_cess_bal;
3466:
3467:
3468:
3469: OPEN cur_get_final_cess_bal(pla_log_rec.organization_id,pla_log_rec.location_id,jai_constants.tax_type_sh_exc_edu_cess);
3470: FETCH cur_get_final_cess_bal INTO ln_sh_exc_cess_pla_final;
3471: CLOSE cur_get_final_cess_bal;
3472:
3473: OPEN cur_get_final_cess_bal(pla_log_rec.organization_id,pla_log_rec.location_id,jai_constants.tax_type_sh_cvd_edu_cess);

Line 3473: OPEN cur_get_final_cess_bal(pla_log_rec.organization_id,pla_log_rec.location_id,jai_constants.tax_type_sh_cvd_edu_cess);

3469: OPEN cur_get_final_cess_bal(pla_log_rec.organization_id,pla_log_rec.location_id,jai_constants.tax_type_sh_exc_edu_cess);
3470: FETCH cur_get_final_cess_bal INTO ln_sh_exc_cess_pla_final;
3471: CLOSE cur_get_final_cess_bal;
3472:
3473: OPEN cur_get_final_cess_bal(pla_log_rec.organization_id,pla_log_rec.location_id,jai_constants.tax_type_sh_cvd_edu_cess);
3474: FETCH cur_get_final_cess_bal INTO ln_sh_cvd_cess_pla_final;
3475: CLOSE cur_get_final_cess_bal;
3476:
3477:

Line 3515: open c_cess_err_exists(pla_log_rec.organization_id,pla_log_rec.location_id, 'PLA',jai_constants.tax_type_sh_exc_edu_cess) ;

3511:
3512:
3513: ln_err_exists := NULL;
3514:
3515: open c_cess_err_exists(pla_log_rec.organization_id,pla_log_rec.location_id, 'PLA',jai_constants.tax_type_sh_exc_edu_cess) ;
3516: fetch c_cess_err_exists into ln_err_exists ;
3517: close c_cess_err_exists ;
3518:
3519: if nvl(ln_err_exists,0) = 0 then

Line 3526: open c_cess_err_exists(pla_log_rec.organization_id,pla_log_rec.location_id, 'PLA',jai_constants.tax_type_sh_cvd_edu_cess) ;

3522: lv_sh_exc_cess_status := 'INCONSISTENT' ;
3523: end if ;
3524: ln_err_exists := NULL;
3525:
3526: open c_cess_err_exists(pla_log_rec.organization_id,pla_log_rec.location_id, 'PLA',jai_constants.tax_type_sh_cvd_edu_cess) ;
3527: fetch c_cess_err_exists into ln_err_exists ;
3528: close c_cess_err_exists ;
3529:
3530: if nvl(ln_err_exists,0) = 0 then