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

Line 423: AND tax_type IN ( JAI_CONSTANTS.tax_type_excise

419: , tax_id
420: FROM
421: jai_retro_tax_changes
422: WHERE line_change_id = pn_line_change_id
423: AND tax_type IN ( JAI_CONSTANTS.tax_type_excise
424: , JAI_CONSTANTS.tax_type_exc_additional
425: , JAI_CONSTANTS.tax_type_exc_other
426: , JAI_CONSTANTS.tax_type_exc_edu_cess
427: , JAI_CONSTANTS.tax_type_sh_exc_edu_cess

Line 424: , JAI_CONSTANTS.tax_type_exc_additional

420: FROM
421: jai_retro_tax_changes
422: WHERE line_change_id = pn_line_change_id
423: AND tax_type IN ( JAI_CONSTANTS.tax_type_excise
424: , JAI_CONSTANTS.tax_type_exc_additional
425: , JAI_CONSTANTS.tax_type_exc_other
426: , JAI_CONSTANTS.tax_type_exc_edu_cess
427: , JAI_CONSTANTS.tax_type_sh_exc_edu_cess
428: )

Line 425: , JAI_CONSTANTS.tax_type_exc_other

421: jai_retro_tax_changes
422: WHERE line_change_id = pn_line_change_id
423: AND tax_type IN ( JAI_CONSTANTS.tax_type_excise
424: , JAI_CONSTANTS.tax_type_exc_additional
425: , JAI_CONSTANTS.tax_type_exc_other
426: , JAI_CONSTANTS.tax_type_exc_edu_cess
427: , JAI_CONSTANTS.tax_type_sh_exc_edu_cess
428: )
429: AND recoverable_flag ='Y';

Line 426: , JAI_CONSTANTS.tax_type_exc_edu_cess

422: WHERE line_change_id = pn_line_change_id
423: AND tax_type IN ( JAI_CONSTANTS.tax_type_excise
424: , JAI_CONSTANTS.tax_type_exc_additional
425: , JAI_CONSTANTS.tax_type_exc_other
426: , JAI_CONSTANTS.tax_type_exc_edu_cess
427: , JAI_CONSTANTS.tax_type_sh_exc_edu_cess
428: )
429: AND recoverable_flag ='Y';
430:

Line 427: , JAI_CONSTANTS.tax_type_sh_exc_edu_cess

423: AND tax_type IN ( JAI_CONSTANTS.tax_type_excise
424: , JAI_CONSTANTS.tax_type_exc_additional
425: , JAI_CONSTANTS.tax_type_exc_other
426: , JAI_CONSTANTS.tax_type_exc_edu_cess
427: , JAI_CONSTANTS.tax_type_sh_exc_edu_cess
428: )
429: AND recoverable_flag ='Y';
430:
431: CURSOR get_vat_tax_info_cur

Line 445: AND jr.regime_code = jai_constants.vat_regime

441: FROM
442: JAI_RGM_DEFINITIONS jr
443: , JAI_RGM_REGISTRATIONS jrr
444: WHERE jr.regime_id = jrr.regime_id
445: AND jr.regime_code = jai_constants.vat_regime
446: AND jrr.registration_type = jai_constants.regn_type_tax_types
447: AND jrtc.tax_type = jrr.attribute_code
448: )
449: AND recoverable_flag ='Y'

Line 446: AND jrr.registration_type = jai_constants.regn_type_tax_types

442: JAI_RGM_DEFINITIONS jr
443: , JAI_RGM_REGISTRATIONS jrr
444: WHERE jr.regime_id = jrr.regime_id
445: AND jr.regime_code = jai_constants.vat_regime
446: AND jrr.registration_type = jai_constants.regn_type_tax_types
447: AND jrtc.tax_type = jrr.attribute_code
448: )
449: AND recoverable_flag ='Y'
450: AND line_change_id = pn_line_change_id;

Line 589: IF upper(tax_rec.tax_type) = JAI_CONSTANTS.excise_regime

585: END IF;
586:
587: IF pv_breakup_type = 'RG23D'
588: THEN -- trading case
589: IF upper(tax_rec.tax_type) = JAI_CONSTANTS.excise_regime
590: THEN
591: pr_tax.basic_excise := pr_tax.basic_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
592: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_additional
593: THEN

Line 592: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_additional

588: THEN -- trading case
589: IF upper(tax_rec.tax_type) = JAI_CONSTANTS.excise_regime
590: THEN
591: pr_tax.basic_excise := pr_tax.basic_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
592: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_additional
593: THEN
594: pr_tax.addl_excise := pr_tax.addl_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
595: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_other
596: THEN

Line 595: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_other

591: pr_tax.basic_excise := pr_tax.basic_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
592: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_additional
593: THEN
594: pr_tax.addl_excise := pr_tax.addl_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
595: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_other
596: THEN
597: pr_tax.other_excise := pr_tax.other_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
598: ELSIF tax_rec.tax_type = JAI_CONSTANTS.tax_type_cvd
599: THEN

Line 598: ELSIF tax_rec.tax_type = JAI_CONSTANTS.tax_type_cvd

594: pr_tax.addl_excise := pr_tax.addl_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
595: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_other
596: THEN
597: pr_tax.other_excise := pr_tax.other_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
598: ELSIF tax_rec.tax_type = JAI_CONSTANTS.tax_type_cvd
599: THEN
600: pr_tax.cvd := pr_tax.cvd + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
601: ELSIF tax_rec.tax_type = jai_constants.tax_type_exc_edu_cess
602: THEN

Line 601: ELSIF tax_rec.tax_type = jai_constants.tax_type_exc_edu_cess

597: pr_tax.other_excise := pr_tax.other_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
598: ELSIF tax_rec.tax_type = JAI_CONSTANTS.tax_type_cvd
599: THEN
600: pr_tax.cvd := pr_tax.cvd + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
601: ELSIF tax_rec.tax_type = jai_constants.tax_type_exc_edu_cess
602: THEN
603: pr_tax.excise_edu_cess := pr_tax.excise_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
604: ELSIF tax_rec.tax_type = jai_constants.tax_type_cvd_edu_cess
605: THEN

Line 604: ELSIF tax_rec.tax_type = jai_constants.tax_type_cvd_edu_cess

600: pr_tax.cvd := pr_tax.cvd + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
601: ELSIF tax_rec.tax_type = jai_constants.tax_type_exc_edu_cess
602: THEN
603: pr_tax.excise_edu_cess := pr_tax.excise_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
604: ELSIF tax_rec.tax_type = jai_constants.tax_type_cvd_edu_cess
605: THEN
606: pr_tax.cvd_edu_cess := pr_tax.cvd_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
607: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess
608: THEN

Line 607: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess

603: pr_tax.excise_edu_cess := pr_tax.excise_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
604: ELSIF tax_rec.tax_type = jai_constants.tax_type_cvd_edu_cess
605: THEN
606: pr_tax.cvd_edu_cess := pr_tax.cvd_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
607: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess
608: THEN
609: pr_tax.sh_cvd_edu_cess := nvl(pr_tax.sh_cvd_edu_cess,0) + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
610: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess
611: THEN

Line 610: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess

606: pr_tax.cvd_edu_cess := pr_tax.cvd_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
607: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess
608: THEN
609: pr_tax.sh_cvd_edu_cess := nvl(pr_tax.sh_cvd_edu_cess,0) + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
610: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess
611: THEN
612: pr_tax.sh_exc_edu_cess := nvl(pr_tax.sh_exc_edu_cess,0) + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
613: ELSIF tax_rec.tax_type = jai_constants.tax_type_add_cvd
614: THEN

Line 613: ELSIF tax_rec.tax_type = jai_constants.tax_type_add_cvd

609: pr_tax.sh_cvd_edu_cess := nvl(pr_tax.sh_cvd_edu_cess,0) + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
610: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess
611: THEN
612: pr_tax.sh_exc_edu_cess := nvl(pr_tax.sh_exc_edu_cess,0) + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
613: ELSIF tax_rec.tax_type = jai_constants.tax_type_add_cvd
614: THEN
615: pr_tax.addl_cvd := pr_tax.addl_cvd + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
616: ELSE
617: pr_tax.non_cenvat := pr_tax.non_cenvat + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);

Line 621: upper(tax_rec.tax_type) IN (JAI_CONSTANTS.excise_regime, JAI_CONSTANTS.tax_type_exc_additional,

617: pr_tax.non_cenvat := pr_tax.non_cenvat + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
618: END IF;
619: ELSE -- manufacturing case
620: IF tax_rec.modvat_flag = 'Y' AND
621: upper(tax_rec.tax_type) IN (JAI_CONSTANTS.excise_regime, JAI_CONSTANTS.tax_type_exc_additional,
622: JAI_CONSTANTS.tax_type_exc_other, JAI_CONSTANTS.tax_type_cvd,
623: JAI_CONSTANTS.tax_type_add_cvd,
624: jai_constants.tax_type_exc_edu_cess,
625: jai_constants.tax_type_cvd_edu_cess,

Line 622: JAI_CONSTANTS.tax_type_exc_other, JAI_CONSTANTS.tax_type_cvd,

618: END IF;
619: ELSE -- manufacturing case
620: IF tax_rec.modvat_flag = 'Y' AND
621: upper(tax_rec.tax_type) IN (JAI_CONSTANTS.excise_regime, JAI_CONSTANTS.tax_type_exc_additional,
622: JAI_CONSTANTS.tax_type_exc_other, JAI_CONSTANTS.tax_type_cvd,
623: JAI_CONSTANTS.tax_type_add_cvd,
624: jai_constants.tax_type_exc_edu_cess,
625: jai_constants.tax_type_cvd_edu_cess,
626: jai_constants.tax_type_sh_cvd_edu_cess,

Line 623: JAI_CONSTANTS.tax_type_add_cvd,

619: ELSE -- manufacturing case
620: IF tax_rec.modvat_flag = 'Y' AND
621: upper(tax_rec.tax_type) IN (JAI_CONSTANTS.excise_regime, JAI_CONSTANTS.tax_type_exc_additional,
622: JAI_CONSTANTS.tax_type_exc_other, JAI_CONSTANTS.tax_type_cvd,
623: JAI_CONSTANTS.tax_type_add_cvd,
624: jai_constants.tax_type_exc_edu_cess,
625: jai_constants.tax_type_cvd_edu_cess,
626: jai_constants.tax_type_sh_cvd_edu_cess,
627: jai_constants.tax_type_sh_exc_edu_cess)

Line 624: jai_constants.tax_type_exc_edu_cess,

620: IF tax_rec.modvat_flag = 'Y' AND
621: upper(tax_rec.tax_type) IN (JAI_CONSTANTS.excise_regime, JAI_CONSTANTS.tax_type_exc_additional,
622: JAI_CONSTANTS.tax_type_exc_other, JAI_CONSTANTS.tax_type_cvd,
623: JAI_CONSTANTS.tax_type_add_cvd,
624: jai_constants.tax_type_exc_edu_cess,
625: jai_constants.tax_type_cvd_edu_cess,
626: jai_constants.tax_type_sh_cvd_edu_cess,
627: jai_constants.tax_type_sh_exc_edu_cess)
628: THEN

Line 625: jai_constants.tax_type_cvd_edu_cess,

621: upper(tax_rec.tax_type) IN (JAI_CONSTANTS.excise_regime, JAI_CONSTANTS.tax_type_exc_additional,
622: JAI_CONSTANTS.tax_type_exc_other, JAI_CONSTANTS.tax_type_cvd,
623: JAI_CONSTANTS.tax_type_add_cvd,
624: jai_constants.tax_type_exc_edu_cess,
625: jai_constants.tax_type_cvd_edu_cess,
626: jai_constants.tax_type_sh_cvd_edu_cess,
627: jai_constants.tax_type_sh_exc_edu_cess)
628: THEN
629: IF upper(tax_rec.tax_type) = JAI_CONSTANTS.excise_regime

Line 626: jai_constants.tax_type_sh_cvd_edu_cess,

622: JAI_CONSTANTS.tax_type_exc_other, JAI_CONSTANTS.tax_type_cvd,
623: JAI_CONSTANTS.tax_type_add_cvd,
624: jai_constants.tax_type_exc_edu_cess,
625: jai_constants.tax_type_cvd_edu_cess,
626: jai_constants.tax_type_sh_cvd_edu_cess,
627: jai_constants.tax_type_sh_exc_edu_cess)
628: THEN
629: IF upper(tax_rec.tax_type) = JAI_CONSTANTS.excise_regime
630: THEN

Line 627: jai_constants.tax_type_sh_exc_edu_cess)

623: JAI_CONSTANTS.tax_type_add_cvd,
624: jai_constants.tax_type_exc_edu_cess,
625: jai_constants.tax_type_cvd_edu_cess,
626: jai_constants.tax_type_sh_cvd_edu_cess,
627: jai_constants.tax_type_sh_exc_edu_cess)
628: THEN
629: IF upper(tax_rec.tax_type) = JAI_CONSTANTS.excise_regime
630: THEN
631: pr_tax.basic_excise := pr_tax.basic_excise

Line 629: IF upper(tax_rec.tax_type) = JAI_CONSTANTS.excise_regime

625: jai_constants.tax_type_cvd_edu_cess,
626: jai_constants.tax_type_sh_cvd_edu_cess,
627: jai_constants.tax_type_sh_exc_edu_cess)
628: THEN
629: IF upper(tax_rec.tax_type) = JAI_CONSTANTS.excise_regime
630: THEN
631: pr_tax.basic_excise := pr_tax.basic_excise
632: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
633: pr_tax.non_cenvat := pr_tax.non_cenvat

Line 635: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_additional

631: pr_tax.basic_excise := pr_tax.basic_excise
632: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
633: pr_tax.non_cenvat := pr_tax.non_cenvat
634: + round(tax_rec.tax_amount * (1 - tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
635: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_additional
636: THEN
637: pr_tax.addl_excise := pr_tax.addl_excise
638: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
639: pr_tax.non_cenvat := pr_tax.non_cenvat

Line 641: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_other

637: pr_tax.addl_excise := pr_tax.addl_excise
638: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
639: pr_tax.non_cenvat := pr_tax.non_cenvat
640: + round(tax_rec.tax_amount * (1 - tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
641: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_other
642: THEN
643: pr_tax.other_excise := pr_tax.other_excise
644: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
645: pr_tax.non_cenvat := pr_tax.non_cenvat

Line 647: ELSIF tax_rec.tax_type IN (JAI_CONSTANTS.tax_type_cvd)

643: pr_tax.other_excise := pr_tax.other_excise
644: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
645: pr_tax.non_cenvat := pr_tax.non_cenvat
646: + round(tax_rec.tax_amount * (1 - tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
647: ELSIF tax_rec.tax_type IN (JAI_CONSTANTS.tax_type_cvd)
648: THEN
649: pr_tax.cvd := pr_tax.cvd
650: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
651: pr_tax.non_cenvat := pr_tax.non_cenvat

Line 653: ELSIF tax_rec.tax_type IN ( jai_constants.tax_type_add_cvd)

649: pr_tax.cvd := pr_tax.cvd
650: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
651: pr_tax.non_cenvat := pr_tax.non_cenvat
652: + round(tax_rec.tax_amount * (1 - tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
653: ELSIF tax_rec.tax_type IN ( jai_constants.tax_type_add_cvd)
654: THEN
655: pr_tax.addl_cvd := pr_tax.addl_cvd
656: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
657: pr_tax.non_cenvat := pr_tax.non_cenvat

Line 659: ELSIF tax_rec.tax_type = jai_constants.tax_type_exc_edu_cess

655: pr_tax.addl_cvd := pr_tax.addl_cvd
656: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
657: pr_tax.non_cenvat := pr_tax.non_cenvat
658: + round(tax_rec.tax_amount * (1 - tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
659: ELSIF tax_rec.tax_type = jai_constants.tax_type_exc_edu_cess
660: THEN
661: pr_tax.excise_edu_cess := pr_tax.excise_edu_cess +
662: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
663: pr_tax.non_cenvat := pr_tax.non_cenvat

Line 665: ELSIF tax_rec.tax_type = jai_constants.tax_type_cvd_edu_cess

661: pr_tax.excise_edu_cess := pr_tax.excise_edu_cess +
662: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
663: pr_tax.non_cenvat := pr_tax.non_cenvat
664: + round(tax_rec.tax_amount * (1 - tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
665: ELSIF tax_rec.tax_type = jai_constants.tax_type_cvd_edu_cess
666: THEN
667: pr_tax.cvd_edu_cess := pr_tax.cvd_edu_cess
668: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
669: pr_tax.non_cenvat := pr_tax.non_cenvat

Line 671: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess

667: pr_tax.cvd_edu_cess := pr_tax.cvd_edu_cess
668: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
669: pr_tax.non_cenvat := pr_tax.non_cenvat
670: + round(tax_rec.tax_amount * (1 - tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
671: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess
672: THEN
673: pr_tax.sh_exc_edu_cess := nvl(pr_tax.sh_exc_edu_cess,0)+
674: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
675: pr_tax.non_cenvat := pr_tax.non_cenvat

Line 677: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess

673: pr_tax.sh_exc_edu_cess := nvl(pr_tax.sh_exc_edu_cess,0)+
674: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
675: pr_tax.non_cenvat := pr_tax.non_cenvat
676: + round(tax_rec.tax_amount * (1 - tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
677: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess
678: THEN
679: pr_tax.sh_cvd_edu_cess := nvl(pr_tax.sh_cvd_edu_cess,0)+
680: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
681: pr_tax.non_cenvat := pr_tax.non_cenvat

Line 687: ELSIF tax_rec.modvat_flag = 'N' and tax_rec.tax_type NOT IN (JAI_CONSTANTS.tax_type_tds, JAI_CONSTANTS.tax_type_modvat_recovery)

683: ELSE
684: ln_mod_problem_amt := ln_mod_problem_amt
685: + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
686: END IF;
687: ELSIF tax_rec.modvat_flag = 'N' and tax_rec.tax_type NOT IN (JAI_CONSTANTS.tax_type_tds, JAI_CONSTANTS.tax_type_modvat_recovery)
688: THEN
689: pr_tax.non_cenvat := pr_tax.non_cenvat
690: + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
691: ELSE

Line 1838: AND jr.regime_code = jai_constants.vat_regime

1834: FROM
1835: JAI_RGM_DEFINITIONS jr
1836: , JAI_RGM_REGISTRATIONS jrr
1837: WHERE jr.regime_id = jrr.regime_id
1838: AND jr.regime_code = jai_constants.vat_regime
1839: AND jrr.registration_type = jai_constants.regn_type_tax_types
1840: AND jrtc.tax_type =jrr.attribute_code
1841: )
1842: AND jrtc.recoverable_flag ='Y'

Line 1839: AND jrr.registration_type = jai_constants.regn_type_tax_types

1835: JAI_RGM_DEFINITIONS jr
1836: , JAI_RGM_REGISTRATIONS jrr
1837: WHERE jr.regime_id = jrr.regime_id
1838: AND jr.regime_code = jai_constants.vat_regime
1839: AND jrr.registration_type = jai_constants.regn_type_tax_types
1840: AND jrtc.tax_type =jrr.attribute_code
1841: )
1842: AND jrtc.recoverable_flag ='Y'
1843: AND jrtc.line_change_id = pn_line_change_id;

Line 2028: , p_organization_type => jai_constants.orgn_type_io

2024: --Get the Interim recovery account by calling the following function
2025: ln_interim_recovery_account :=
2026: jai_cmn_rgm_recording_pkg.get_account
2027: ( p_regime_id => ln_regime_id -- fetched above
2028: , p_organization_type => jai_constants.orgn_type_io
2029: , p_organization_id => ln_organization_id -- fetched above
2030: , p_location_id => ln_location_id -- fetched above
2031: , p_tax_type => claim_schedule_rec.tax_type -- current tax type in the LOOP
2032: , p_account_name => jai_constants.recovery_interim

Line 2032: , p_account_name => jai_constants.recovery_interim

2028: , p_organization_type => jai_constants.orgn_type_io
2029: , p_organization_id => ln_organization_id -- fetched above
2030: , p_location_id => ln_location_id -- fetched above
2031: , p_tax_type => claim_schedule_rec.tax_type -- current tax type in the LOOP
2032: , p_account_name => jai_constants.recovery_interim
2033: );
2034: IF ln_interim_recovery_account IS NULL THEN
2035: raise_application_error(-20110,'Recovery Account not defined in VAT Setup');
2036: END IF;

Line 2042: , p_organization_type => jai_constants.orgn_type_io

2038: --Get the recovery account by calling the following funcation
2039: ln_code_combination_id :=
2040: jai_cmn_rgm_recording_pkg.get_account
2041: ( p_regime_id => ln_regime_id -- fetched above
2042: , p_organization_type => jai_constants.orgn_type_io
2043: , p_organization_id => ln_organization_id -- fetched above
2044: , p_location_id => ln_location_id -- fetched above
2045: , p_tax_type => claim_schedule_rec.tax_type -- current tax type in the LOOP
2046: , p_account_name => jai_constants.recovery

Line 2046: , p_account_name => jai_constants.recovery

2042: , p_organization_type => jai_constants.orgn_type_io
2043: , p_organization_id => ln_organization_id -- fetched above
2044: , p_location_id => ln_location_id -- fetched above
2045: , p_tax_type => claim_schedule_rec.tax_type -- current tax type in the LOOP
2046: , p_account_name => jai_constants.recovery
2047: );
2048:
2049: IF ln_code_combination_id IS NULL THEN
2050: raise_application_error(-20110,'Recovery Account not defined in VAT Setup');

Line 2060: pv_organization_type => jai_constants.orgn_type_io,

2056: (
2057: pn_repository_id => ln_repository_id, -- OUT parameter
2058: pn_regime_id => ln_regime_id, -- fetched above
2059: pv_tax_type => claim_schedule_rec.tax_type, -- current tax type in the LOOP
2060: pv_organization_type => jai_constants.orgn_type_io,
2061: pn_organization_id => ln_organization_id, -- fetched above
2062: pn_location_id => ln_location_id, -- fetched above
2063: pv_source => jai_constants.source_rcv,
2064: pv_source_trx_type => 'RETROACTIVE VAT CLAIM:'||to_char(pn_version_number),

Line 2063: pv_source => jai_constants.source_rcv,

2059: pv_tax_type => claim_schedule_rec.tax_type, -- current tax type in the LOOP
2060: pv_organization_type => jai_constants.orgn_type_io,
2061: pn_organization_id => ln_organization_id, -- fetched above
2062: pn_location_id => ln_location_id, -- fetched above
2063: pv_source => jai_constants.source_rcv,
2064: pv_source_trx_type => 'RETROACTIVE VAT CLAIM:'||to_char(pn_version_number),
2065: pv_source_table_name => 'RCV_TRANSACTIONS',
2066: pn_source_id => pn_transaction_id,
2067: pd_transaction_date => trunc(sysdate),

Line 2068: pv_account_name => jai_constants.recovery,

2064: pv_source_trx_type => 'RETROACTIVE VAT CLAIM:'||to_char(pn_version_number),
2065: pv_source_table_name => 'RCV_TRANSACTIONS',
2066: pn_source_id => pn_transaction_id,
2067: pd_transaction_date => trunc(sysdate),
2068: pv_account_name => jai_constants.recovery,
2069: pn_charge_account_id => ln_code_combination_id,
2070: pn_balancing_account_id => ln_interim_recovery_account,
2071: pn_credit_amount => claim_schedule_rec.claim_amount, -- current claim amount in the LOOP
2072: pn_debit_amount => claim_schedule_rec.claim_amount,

Line 2091: IF lv_process_status <> jai_constants.successful

2087: pv_attribute4 => NULL,
2088: pv_attribute5 => NULL
2089: );
2090:
2091: IF lv_process_status <> jai_constants.successful
2092: THEN
2093: raise_application_error(-20120,'VAT repository Entry retruned with error : '||lv_process_message);
2094: END IF;
2095:

Line 2129: IF lv_process_status <> jai_constants.successful THEN

2125: p_reference_name => 'RETROACTIVE VAT CLAIM:'||to_char(pn_version_number),
2126: p_reference_id => claim_schedule_rec.claim_schedule_id
2127: );
2128:
2129: IF lv_process_status <> jai_constants.successful THEN
2130: raise_application_error(-20120,'VAT Claim accounting retruned with error : '||lv_process_message);
2131: END IF;
2132:
2133: --Call the following procedure to credit the recovery account

Line 2159: IF lv_process_status <> jai_constants.successful THEN

2155: p_reference_name => 'RETROACTIVE VAT CLAIM:'||to_char(pn_version_number),
2156: p_reference_id => claim_schedule_rec.claim_schedule_id
2157: );
2158:
2159: IF lv_process_status <> jai_constants.successful THEN
2160: raise_application_error(-20120,'VAT Claim accounting retruned with error : '||lv_process_message);
2161: END IF;
2162:
2163: --Update jai_rcv_rgm_claims to set the claimed amount equal to installment amount as claim is made

Line 2692: AND NVL(receipt_processed_flag,'N') <>jai_constants.yes

2688: AND vendor_site_id = NVL(pn_vendor_site_id,vendor_site_id)
2689: AND ( (doc_type = 'RELEASE' AND doc_header_id = NVL(pn_po_header_id ,doc_header_id))
2690: OR (doc_type = 'STANDARD PO' AND from_header_id = NVL(pn_po_header_id ,from_header_id))
2691: )
2692: AND NVL(receipt_processed_flag,'N') <>jai_constants.yes
2693: --AND creation_date <= NVL(ld_from_eff_date,creation_date) , eric remomved according to review comment #36
2694: AND (original_unit_price < modified_unit_price OR pv_process_downward = jai_constants.yes )
2695: AND doc_version_number =( SELECT MAX(doc_version_number)
2696: FROM jai_retro_line_changes a

Line 2694: AND (original_unit_price < modified_unit_price OR pv_process_downward = jai_constants.yes )

2690: OR (doc_type = 'STANDARD PO' AND from_header_id = NVL(pn_po_header_id ,from_header_id))
2691: )
2692: AND NVL(receipt_processed_flag,'N') <>jai_constants.yes
2693: --AND creation_date <= NVL(ld_from_eff_date,creation_date) , eric remomved according to review comment #36
2694: AND (original_unit_price < modified_unit_price OR pv_process_downward = jai_constants.yes )
2695: AND doc_version_number =( SELECT MAX(doc_version_number)
2696: FROM jai_retro_line_changes a
2697: WHERE a.line_location_id = jrlc.line_location_id
2698: ) ;