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 428: AND tax_type IN ( JAI_CONSTANTS.tax_type_excise

424: , tax_id
425: FROM
426: jai_retro_tax_changes
427: WHERE line_change_id = pn_line_change_id
428: AND tax_type IN ( JAI_CONSTANTS.tax_type_excise
429: , JAI_CONSTANTS.tax_type_exc_additional
430: , JAI_CONSTANTS.tax_type_exc_other
431: , JAI_CONSTANTS.tax_type_exc_edu_cess
432: , JAI_CONSTANTS.tax_type_sh_exc_edu_cess

Line 429: , JAI_CONSTANTS.tax_type_exc_additional

425: FROM
426: jai_retro_tax_changes
427: WHERE line_change_id = pn_line_change_id
428: AND tax_type IN ( JAI_CONSTANTS.tax_type_excise
429: , JAI_CONSTANTS.tax_type_exc_additional
430: , JAI_CONSTANTS.tax_type_exc_other
431: , JAI_CONSTANTS.tax_type_exc_edu_cess
432: , JAI_CONSTANTS.tax_type_sh_exc_edu_cess
433: )

Line 430: , JAI_CONSTANTS.tax_type_exc_other

426: jai_retro_tax_changes
427: WHERE line_change_id = pn_line_change_id
428: AND tax_type IN ( JAI_CONSTANTS.tax_type_excise
429: , JAI_CONSTANTS.tax_type_exc_additional
430: , JAI_CONSTANTS.tax_type_exc_other
431: , JAI_CONSTANTS.tax_type_exc_edu_cess
432: , JAI_CONSTANTS.tax_type_sh_exc_edu_cess
433: )
434: AND recoverable_flag ='Y';

Line 431: , JAI_CONSTANTS.tax_type_exc_edu_cess

427: WHERE line_change_id = pn_line_change_id
428: AND tax_type IN ( JAI_CONSTANTS.tax_type_excise
429: , JAI_CONSTANTS.tax_type_exc_additional
430: , JAI_CONSTANTS.tax_type_exc_other
431: , JAI_CONSTANTS.tax_type_exc_edu_cess
432: , JAI_CONSTANTS.tax_type_sh_exc_edu_cess
433: )
434: AND recoverable_flag ='Y';
435:

Line 432: , JAI_CONSTANTS.tax_type_sh_exc_edu_cess

428: AND tax_type IN ( JAI_CONSTANTS.tax_type_excise
429: , JAI_CONSTANTS.tax_type_exc_additional
430: , JAI_CONSTANTS.tax_type_exc_other
431: , JAI_CONSTANTS.tax_type_exc_edu_cess
432: , JAI_CONSTANTS.tax_type_sh_exc_edu_cess
433: )
434: AND recoverable_flag ='Y';
435:
436: CURSOR get_vat_tax_info_cur

Line 450: AND jr.regime_code = jai_constants.vat_regime

446: FROM
447: JAI_RGM_DEFINITIONS jr
448: , JAI_RGM_REGISTRATIONS jrr
449: WHERE jr.regime_id = jrr.regime_id
450: AND jr.regime_code = jai_constants.vat_regime
451: AND jrr.registration_type = jai_constants.regn_type_tax_types
452: AND jrtc.tax_type = jrr.attribute_code
453: )
454: AND recoverable_flag ='Y'

Line 451: AND jrr.registration_type = jai_constants.regn_type_tax_types

447: JAI_RGM_DEFINITIONS jr
448: , JAI_RGM_REGISTRATIONS jrr
449: WHERE jr.regime_id = jrr.regime_id
450: AND jr.regime_code = jai_constants.vat_regime
451: AND jrr.registration_type = jai_constants.regn_type_tax_types
452: AND jrtc.tax_type = jrr.attribute_code
453: )
454: AND recoverable_flag ='Y'
455: AND line_change_id = pn_line_change_id;

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

590: END IF;
591:
592: IF pv_breakup_type = 'RG23D'
593: THEN -- trading case
594: IF upper(tax_rec.tax_type) = JAI_CONSTANTS.excise_regime
595: THEN
596: pr_tax.basic_excise := pr_tax.basic_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
597: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_additional
598: THEN

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

593: THEN -- trading case
594: IF upper(tax_rec.tax_type) = JAI_CONSTANTS.excise_regime
595: THEN
596: pr_tax.basic_excise := pr_tax.basic_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
597: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_additional
598: THEN
599: pr_tax.addl_excise := pr_tax.addl_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
600: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_other
601: THEN

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

596: pr_tax.basic_excise := pr_tax.basic_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
597: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_additional
598: THEN
599: pr_tax.addl_excise := pr_tax.addl_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
600: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_other
601: THEN
602: pr_tax.other_excise := pr_tax.other_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
603: ELSIF tax_rec.tax_type = JAI_CONSTANTS.tax_type_cvd
604: THEN

Line 603: ELSIF tax_rec.tax_type = JAI_CONSTANTS.tax_type_cvd

599: pr_tax.addl_excise := pr_tax.addl_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
600: ELSIF upper(tax_rec.tax_type) = JAI_CONSTANTS.tax_type_exc_other
601: THEN
602: pr_tax.other_excise := pr_tax.other_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
603: ELSIF tax_rec.tax_type = JAI_CONSTANTS.tax_type_cvd
604: THEN
605: pr_tax.cvd := pr_tax.cvd + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
606: ELSIF tax_rec.tax_type = jai_constants.tax_type_exc_edu_cess
607: THEN

Line 606: ELSIF tax_rec.tax_type = jai_constants.tax_type_exc_edu_cess

602: pr_tax.other_excise := pr_tax.other_excise + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
603: ELSIF tax_rec.tax_type = JAI_CONSTANTS.tax_type_cvd
604: THEN
605: pr_tax.cvd := pr_tax.cvd + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
606: ELSIF tax_rec.tax_type = jai_constants.tax_type_exc_edu_cess
607: THEN
608: pr_tax.excise_edu_cess := pr_tax.excise_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
609: ELSIF tax_rec.tax_type = jai_constants.tax_type_cvd_edu_cess
610: THEN

Line 609: ELSIF tax_rec.tax_type = jai_constants.tax_type_cvd_edu_cess

605: pr_tax.cvd := pr_tax.cvd + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
606: ELSIF tax_rec.tax_type = jai_constants.tax_type_exc_edu_cess
607: THEN
608: pr_tax.excise_edu_cess := pr_tax.excise_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
609: ELSIF tax_rec.tax_type = jai_constants.tax_type_cvd_edu_cess
610: THEN
611: pr_tax.cvd_edu_cess := pr_tax.cvd_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
612: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess
613: THEN

Line 612: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess

608: pr_tax.excise_edu_cess := pr_tax.excise_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
609: ELSIF tax_rec.tax_type = jai_constants.tax_type_cvd_edu_cess
610: THEN
611: pr_tax.cvd_edu_cess := pr_tax.cvd_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
612: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess
613: THEN
614: 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);
615: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess
616: THEN

Line 615: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess

611: pr_tax.cvd_edu_cess := pr_tax.cvd_edu_cess + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
612: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess
613: THEN
614: 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);
615: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess
616: THEN
617: 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);
618: ELSIF tax_rec.tax_type = jai_constants.tax_type_add_cvd
619: THEN

Line 618: ELSIF tax_rec.tax_type = jai_constants.tax_type_add_cvd

614: 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);
615: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess
616: THEN
617: 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);
618: ELSIF tax_rec.tax_type = jai_constants.tax_type_add_cvd
619: THEN
620: pr_tax.addl_cvd := pr_tax.addl_cvd + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
621: ELSE
622: pr_tax.non_cenvat := pr_tax.non_cenvat + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);

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

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

Line 627: JAI_CONSTANTS.tax_type_exc_other, JAI_CONSTANTS.tax_type_cvd,

623: END IF;
624: ELSE -- manufacturing case
625: IF tax_rec.modvat_flag = 'Y' AND
626: upper(tax_rec.tax_type) IN (JAI_CONSTANTS.excise_regime, JAI_CONSTANTS.tax_type_exc_additional,
627: JAI_CONSTANTS.tax_type_exc_other, JAI_CONSTANTS.tax_type_cvd,
628: JAI_CONSTANTS.tax_type_add_cvd,
629: jai_constants.tax_type_exc_edu_cess,
630: jai_constants.tax_type_cvd_edu_cess,
631: jai_constants.tax_type_sh_cvd_edu_cess,

Line 628: JAI_CONSTANTS.tax_type_add_cvd,

624: ELSE -- manufacturing case
625: IF tax_rec.modvat_flag = 'Y' AND
626: upper(tax_rec.tax_type) IN (JAI_CONSTANTS.excise_regime, JAI_CONSTANTS.tax_type_exc_additional,
627: JAI_CONSTANTS.tax_type_exc_other, JAI_CONSTANTS.tax_type_cvd,
628: JAI_CONSTANTS.tax_type_add_cvd,
629: jai_constants.tax_type_exc_edu_cess,
630: jai_constants.tax_type_cvd_edu_cess,
631: jai_constants.tax_type_sh_cvd_edu_cess,
632: jai_constants.tax_type_sh_exc_edu_cess)

Line 629: jai_constants.tax_type_exc_edu_cess,

625: IF tax_rec.modvat_flag = 'Y' AND
626: upper(tax_rec.tax_type) IN (JAI_CONSTANTS.excise_regime, JAI_CONSTANTS.tax_type_exc_additional,
627: JAI_CONSTANTS.tax_type_exc_other, JAI_CONSTANTS.tax_type_cvd,
628: JAI_CONSTANTS.tax_type_add_cvd,
629: jai_constants.tax_type_exc_edu_cess,
630: jai_constants.tax_type_cvd_edu_cess,
631: jai_constants.tax_type_sh_cvd_edu_cess,
632: jai_constants.tax_type_sh_exc_edu_cess)
633: THEN

Line 630: jai_constants.tax_type_cvd_edu_cess,

626: upper(tax_rec.tax_type) IN (JAI_CONSTANTS.excise_regime, JAI_CONSTANTS.tax_type_exc_additional,
627: JAI_CONSTANTS.tax_type_exc_other, JAI_CONSTANTS.tax_type_cvd,
628: JAI_CONSTANTS.tax_type_add_cvd,
629: jai_constants.tax_type_exc_edu_cess,
630: jai_constants.tax_type_cvd_edu_cess,
631: jai_constants.tax_type_sh_cvd_edu_cess,
632: jai_constants.tax_type_sh_exc_edu_cess)
633: THEN
634: IF upper(tax_rec.tax_type) = JAI_CONSTANTS.excise_regime

Line 631: jai_constants.tax_type_sh_cvd_edu_cess,

627: JAI_CONSTANTS.tax_type_exc_other, JAI_CONSTANTS.tax_type_cvd,
628: JAI_CONSTANTS.tax_type_add_cvd,
629: jai_constants.tax_type_exc_edu_cess,
630: jai_constants.tax_type_cvd_edu_cess,
631: jai_constants.tax_type_sh_cvd_edu_cess,
632: jai_constants.tax_type_sh_exc_edu_cess)
633: THEN
634: IF upper(tax_rec.tax_type) = JAI_CONSTANTS.excise_regime
635: THEN

Line 632: jai_constants.tax_type_sh_exc_edu_cess)

628: JAI_CONSTANTS.tax_type_add_cvd,
629: jai_constants.tax_type_exc_edu_cess,
630: jai_constants.tax_type_cvd_edu_cess,
631: jai_constants.tax_type_sh_cvd_edu_cess,
632: jai_constants.tax_type_sh_exc_edu_cess)
633: THEN
634: IF upper(tax_rec.tax_type) = JAI_CONSTANTS.excise_regime
635: THEN
636: pr_tax.basic_excise := pr_tax.basic_excise

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

630: jai_constants.tax_type_cvd_edu_cess,
631: jai_constants.tax_type_sh_cvd_edu_cess,
632: jai_constants.tax_type_sh_exc_edu_cess)
633: THEN
634: IF upper(tax_rec.tax_type) = JAI_CONSTANTS.excise_regime
635: THEN
636: pr_tax.basic_excise := pr_tax.basic_excise
637: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
638: pr_tax.non_cenvat := pr_tax.non_cenvat

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

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

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

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

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

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

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

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

Line 664: ELSIF tax_rec.tax_type = jai_constants.tax_type_exc_edu_cess

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

Line 670: ELSIF tax_rec.tax_type = jai_constants.tax_type_cvd_edu_cess

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

Line 676: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_exc_edu_cess

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

Line 682: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess

678: pr_tax.sh_exc_edu_cess := nvl(pr_tax.sh_exc_edu_cess,0)+
679: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
680: pr_tax.non_cenvat := pr_tax.non_cenvat
681: + round(tax_rec.tax_amount * (1 - tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
682: ELSIF tax_rec.tax_type = jai_constants.tax_type_sh_cvd_edu_cess
683: THEN
684: pr_tax.sh_cvd_edu_cess := nvl(pr_tax.sh_cvd_edu_cess,0)+
685: + round(tax_rec.tax_amount * (tax_rec.mod_cr_percentage/100) * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
686: pr_tax.non_cenvat := pr_tax.non_cenvat

Line 692: 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: ELSE
689: ln_mod_problem_amt := ln_mod_problem_amt
690: + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
691: END IF;
692: ELSIF tax_rec.modvat_flag = 'N' and tax_rec.tax_type NOT IN (JAI_CONSTANTS.tax_type_tds, JAI_CONSTANTS.tax_type_modvat_recovery)
693: THEN
694: pr_tax.non_cenvat := pr_tax.non_cenvat
695: + round(tax_rec.tax_amount * ln_curr_conv * ln_apportion_factor, tax_rec.rnd);
696: ELSE

Line 1843: AND jr.regime_code = jai_constants.vat_regime

1839: FROM
1840: JAI_RGM_DEFINITIONS jr
1841: , JAI_RGM_REGISTRATIONS jrr
1842: WHERE jr.regime_id = jrr.regime_id
1843: AND jr.regime_code = jai_constants.vat_regime
1844: AND jrr.registration_type = jai_constants.regn_type_tax_types
1845: AND jrtc.tax_type =jrr.attribute_code
1846: )
1847: AND jrtc.recoverable_flag ='Y'

Line 1844: AND jrr.registration_type = jai_constants.regn_type_tax_types

1840: JAI_RGM_DEFINITIONS jr
1841: , JAI_RGM_REGISTRATIONS jrr
1842: WHERE jr.regime_id = jrr.regime_id
1843: AND jr.regime_code = jai_constants.vat_regime
1844: AND jrr.registration_type = jai_constants.regn_type_tax_types
1845: AND jrtc.tax_type =jrr.attribute_code
1846: )
1847: AND jrtc.recoverable_flag ='Y'
1848: AND jrtc.line_change_id = pn_line_change_id;

Line 2033: , p_organization_type => jai_constants.orgn_type_io

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

Line 2037: , p_account_name => jai_constants.recovery_interim

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

Line 2047: , p_organization_type => jai_constants.orgn_type_io

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

Line 2051: , p_account_name => jai_constants.recovery

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

Line 2065: pv_organization_type => jai_constants.orgn_type_io,

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

Line 2068: pv_source => jai_constants.source_rcv,

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

Line 2073: pv_account_name => jai_constants.recovery,

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

Line 2100: IF lv_process_status <> jai_constants.successful

2096: ----------------------------------------------
2097: --Added by Bo Li for bug9305067 2010-4-14 BEGIN
2098: );
2099:
2100: IF lv_process_status <> jai_constants.successful
2101: THEN
2102: raise_application_error(-20120,'VAT repository Entry retruned with error : '||lv_process_message);
2103: END IF;
2104:

Line 2138: IF lv_process_status <> jai_constants.successful THEN

2134: p_reference_name => 'RETROACTIVE VAT CLAIM:'||to_char(pn_version_number),
2135: p_reference_id => claim_schedule_rec.claim_schedule_id
2136: );
2137:
2138: IF lv_process_status <> jai_constants.successful THEN
2139: raise_application_error(-20120,'VAT Claim accounting retruned with error : '||lv_process_message);
2140: END IF;
2141:
2142: --Call the following procedure to credit the recovery account

Line 2168: IF lv_process_status <> jai_constants.successful THEN

2164: p_reference_name => 'RETROACTIVE VAT CLAIM:'||to_char(pn_version_number),
2165: p_reference_id => claim_schedule_rec.claim_schedule_id
2166: );
2167:
2168: IF lv_process_status <> jai_constants.successful THEN
2169: raise_application_error(-20120,'VAT Claim accounting retruned with error : '||lv_process_message);
2170: END IF;
2171:
2172: --Update jai_rcv_rgm_claims to set the claimed amount equal to installment amount as claim is made

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

2701: AND vendor_site_id = NVL(pn_vendor_site_id,vendor_site_id)
2702: AND ( (doc_type = 'RELEASE' AND doc_header_id = NVL(pn_po_header_id ,doc_header_id))
2703: OR (doc_type = 'STANDARD PO' AND from_header_id = NVL(pn_po_header_id ,from_header_id))
2704: )
2705: AND NVL(receipt_processed_flag,'N') <>jai_constants.yes
2706: --AND creation_date <= NVL(ld_from_eff_date,creation_date) , eric remomved according to review comment #36
2707: AND (original_unit_price < modified_unit_price OR pv_process_downward = jai_constants.yes )
2708: AND doc_version_number =( SELECT MAX(doc_version_number)
2709: FROM jai_retro_line_changes a

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

2703: OR (doc_type = 'STANDARD PO' AND from_header_id = NVL(pn_po_header_id ,from_header_id))
2704: )
2705: AND NVL(receipt_processed_flag,'N') <>jai_constants.yes
2706: --AND creation_date <= NVL(ld_from_eff_date,creation_date) , eric remomved according to review comment #36
2707: AND (original_unit_price < modified_unit_price OR pv_process_downward = jai_constants.yes )
2708: AND doc_version_number =( SELECT MAX(doc_version_number)
2709: FROM jai_retro_line_changes a
2710: WHERE a.line_location_id = jrlc.line_location_id
2711: ) ;