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

Line 323: ld_start_date, ld_end_date, JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS);/Bug 5989740 bduvarag/

319: CLOSE c_get_fin_year;
320: end if;
321:
322: OPEN c_total_cess_amount(org.organization_id, org.location_id, p_register_type,
323: ld_start_date, ld_end_date, JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS);/*Bug 5989740 bduvarag*/
324: FETCH c_total_cess_amount INTO ln_total_exc_edu_cess;
325: CLOSE c_total_cess_amount;
326: ln_exc_edu_cess_cl_bal := ln_prev_exc_edu_cess_cl_bal + nvl(ln_total_exc_edu_cess, 0);
327:

Line 329: ld_start_date, ld_end_date, JAI_CONSTANTS.TAX_TYPE_CVD_EDU_CESS);/Bug 5989740 bduvarag/

325: CLOSE c_total_cess_amount;
326: ln_exc_edu_cess_cl_bal := ln_prev_exc_edu_cess_cl_bal + nvl(ln_total_exc_edu_cess, 0);
327:
328: OPEN c_total_cess_amount(org.organization_id, org.location_id, p_register_type,
329: ld_start_date, ld_end_date, JAI_CONSTANTS.TAX_TYPE_CVD_EDU_CESS);/*Bug 5989740 bduvarag*/
330: FETCH c_total_cess_amount INTO ln_total_cvd_edu_cess;
331: CLOSE c_total_cess_amount;
332: ln_cvd_edu_cess_cl_bal := ln_prev_cvd_edu_cess_cl_bal + nvl(ln_total_cvd_edu_cess, 0);
333: /* end, bgowrava for forward porting bug#5674376 */

Line 336: ld_start_date, ld_end_date, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS);

332: ln_cvd_edu_cess_cl_bal := ln_prev_cvd_edu_cess_cl_bal + nvl(ln_total_cvd_edu_cess, 0);
333: /* end, bgowrava for forward porting bug#5674376 */
334: /*Bug 5989740 bduvarag start*/
335: OPEN c_total_cess_amount(org.organization_id, org.location_id, p_register_type,
336: ld_start_date, ld_end_date, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS);
337: FETCH c_total_cess_amount INTO ln_total_sh_exc_edu_cess;
338: CLOSE c_total_cess_amount;
339: ln_sh_exc_edu_cess_cl_bal := ln_prev_sh_exc_edu_cess_cl_bal + nvl(ln_total_sh_exc_edu_cess, 0);
340:

Line 342: ld_start_date, ld_end_date, JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS);

338: CLOSE c_total_cess_amount;
339: ln_sh_exc_edu_cess_cl_bal := ln_prev_sh_exc_edu_cess_cl_bal + nvl(ln_total_sh_exc_edu_cess, 0);
340:
341: OPEN c_total_cess_amount(org.organization_id, org.location_id, p_register_type,
342: ld_start_date, ld_end_date, JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS);
343: FETCH c_total_cess_amount INTO ln_total_sh_cvd_edu_cess;
344: CLOSE c_total_cess_amount;
345: ln_sh_cvd_edu_cess_cl_bal := ln_prev_sh_cvd_edu_cess_cl_bal + nvl(ln_total_sh_cvd_edu_cess, 0);
346: /*Bug 5989740 bduvarag end*/

Line 579: open c_get_cess_rnd_amount(p_register_id_rounding,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS);/Bug 5989740 bduvarag/

575:
576: /* Start bgowrava for forward porting bug#5674376 */
577: ln_round_amount := nvl(ln_round_amount,0);
578:
579: open c_get_cess_rnd_amount(p_register_id_rounding,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS);/*Bug 5989740 bduvarag*/
580: fetch c_get_cess_rnd_amount into ln_exc_edu_cess_adj;
581: close c_get_cess_rnd_amount;
582:
583: open c_get_cess_rnd_amount(p_register_id_rounding, JAI_CONSTANTS.TAX_TYPE_CVD_EDU_CESS);/*Bug 5989740 bduvarag*/

Line 583: open c_get_cess_rnd_amount(p_register_id_rounding, JAI_CONSTANTS.TAX_TYPE_CVD_EDU_CESS);/Bug 5989740 bduvarag/

579: open c_get_cess_rnd_amount(p_register_id_rounding,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS);/*Bug 5989740 bduvarag*/
580: fetch c_get_cess_rnd_amount into ln_exc_edu_cess_adj;
581: close c_get_cess_rnd_amount;
582:
583: open c_get_cess_rnd_amount(p_register_id_rounding, JAI_CONSTANTS.TAX_TYPE_CVD_EDU_CESS);/*Bug 5989740 bduvarag*/
584: fetch c_get_cess_rnd_amount into ln_cvd_edu_cess_adj;
585: close c_get_cess_rnd_amount;
586:
587: ln_exc_edu_cess_adj := nvl(ln_exc_edu_cess_adj,0);

Line 591: open c_get_cess_rnd_amount(p_register_id_rounding, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS);

587: ln_exc_edu_cess_adj := nvl(ln_exc_edu_cess_adj,0);
588: ln_cvd_edu_cess_adj := nvl(ln_cvd_edu_cess_adj,0);
589: /* End bgowrava for forward porting bug#5674376 */
590: /*Bug 5989740 bduvarag start*/
591: open c_get_cess_rnd_amount(p_register_id_rounding, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS);
592: fetch c_get_cess_rnd_amount into ln_sh_exc_edu_cess_adj;
593: close c_get_cess_rnd_amount;
594:
595: open c_get_cess_rnd_amount(p_register_id_rounding, JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS);

Line 595: open c_get_cess_rnd_amount(p_register_id_rounding, JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS);

591: open c_get_cess_rnd_amount(p_register_id_rounding, JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS);
592: fetch c_get_cess_rnd_amount into ln_sh_exc_edu_cess_adj;
593: close c_get_cess_rnd_amount;
594:
595: open c_get_cess_rnd_amount(p_register_id_rounding, JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS);
596: fetch c_get_cess_rnd_amount into ln_sh_cvd_edu_cess_adj;
597: close c_get_cess_rnd_amount;
598:
599: ln_sh_exc_edu_cess_adj := nvl(ln_sh_exc_edu_cess_adj,0);

Line 700: elsif cp_tax_type = JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS then

696: ln_cess_op_bal := r_period_bal_rec.exc_edu_cess_cl_bal;
697: elsif cp_tax_type = 'CVD_EDUCATION_CESS' then
698: ln_cess_op_bal := r_period_bal_rec.cvd_edu_cess_cl_bal;
699: /*Bug 5989740 bduvarag start*/
700: elsif cp_tax_type = JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS then
701: ln_cess_op_bal := r_period_bal_rec.sh_exc_edu_cess_cl_bal;
702: elsif cp_tax_type = JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS then
703: ln_cess_op_bal := r_period_bal_rec.sh_cvd_edu_cess_cl_bal;
704: /*Bug 5989740 bduvarag end*/

Line 702: elsif cp_tax_type = JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS then

698: ln_cess_op_bal := r_period_bal_rec.cvd_edu_cess_cl_bal;
699: /*Bug 5989740 bduvarag start*/
700: elsif cp_tax_type = JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS then
701: ln_cess_op_bal := r_period_bal_rec.sh_exc_edu_cess_cl_bal;
702: elsif cp_tax_type = JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS then
703: ln_cess_op_bal := r_period_bal_rec.sh_cvd_edu_cess_cl_bal;
704: /*Bug 5989740 bduvarag end*/
705: else
706: ln_cess_op_bal := 0;