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.GHR_CPDF_CHECK7 dependencies on HR_API

Line 2645: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP','FE','ES','ST','AL','CA','SL')

2641: --
2642: -- Commented the edit for bug 557188 on 7-aug-98
2643: --
2644: if (
2645: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP','FE','ES','ST','AL','CA','SL')
2646: ) then
2647:
2648: if (p_prior_basic_pay is not null or to_number(p_prior_basic_pay) <> 0) then
2649: if (

Line 2686: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and

2682: -- U58 Raju 01-jan-2010 Bug 9503972
2683: -------------------------------------------------------------------------------
2684: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN
2685: if (
2686: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2687: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','3','7','J','K') and
2688: nvl(p_locality_pay_area,hr_api.g_varchar2) between '02' and '88' and
2689: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2690: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)

Line 2687: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','3','7','J','K') and

2683: -------------------------------------------------------------------------------
2684: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN
2685: if (
2686: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2687: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','3','7','J','K') and
2688: nvl(p_locality_pay_area,hr_api.g_varchar2) between '02' and '88' and
2689: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2690: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2691: ) then

Line 2688: nvl(p_locality_pay_area,hr_api.g_varchar2) between '02' and '88' and

2684: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN
2685: if (
2686: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2687: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','3','7','J','K') and
2688: nvl(p_locality_pay_area,hr_api.g_varchar2) between '02' and '88' and
2689: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2690: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2691: ) then
2692: if (

Line 2703: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and

2699: end if;
2700: end if;
2701: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN
2702: if (
2703: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2704: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','3','7','J','K') and
2705: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2706: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2707: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)

Line 2704: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','3','7','J','K') and

2700: end if;
2701: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN
2702: if (
2703: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2704: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','3','7','J','K') and
2705: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2706: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2707: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2708: ) then

Line 2705: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and

2701: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN
2702: if (
2703: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2704: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','3','7','J','K') and
2705: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2706: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2707: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2708: ) then
2709: if (

Line 2725: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and

2721: AND
2722: p_effective_date < to_date('01/07/2006', 'dd/mm/yyyy')
2723: ) THEN
2724: if (
2725: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2726: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2727: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2728: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2729: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)

Line 2726: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and

2722: p_effective_date < to_date('01/07/2006', 'dd/mm/yyyy')
2723: ) THEN
2724: if (
2725: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2726: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2727: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2728: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2729: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2730: ) then

Line 2727: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and

2723: ) THEN
2724: if (
2725: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2726: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2727: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2728: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2729: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2730: ) then
2731: if (

Line 2745: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and

2741:
2742: ELSIF ( p_effective_date >= to_date('01/07/2006', 'dd/mm/yyyy') )
2743: AND( p_effective_date < to_date('13/08/2007', 'dd/mm/yyyy')) THEN
2744: if (
2745: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2746: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2747: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZZ') and
2748: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2749: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)

Line 2746: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and

2742: ELSIF ( p_effective_date >= to_date('01/07/2006', 'dd/mm/yyyy') )
2743: AND( p_effective_date < to_date('13/08/2007', 'dd/mm/yyyy')) THEN
2744: if (
2745: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2746: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2747: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZZ') and
2748: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2749: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2750: ) then

Line 2747: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZZ') and

2743: AND( p_effective_date < to_date('13/08/2007', 'dd/mm/yyyy')) THEN
2744: if (
2745: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2746: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2747: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZZ') and
2748: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2749: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2750: ) then
2751: if (

Line 2761: if (nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','GL','FO','FP') and

2757: hr_utility.raise_error;
2758: end if;
2759: end if;
2760: ELSIF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
2761: if (nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','GL','FO','FP') and
2762: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2763: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZZ') and
2764: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2765: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)

Line 2762: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and

2758: end if;
2759: end if;
2760: ELSIF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
2761: if (nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','GL','FO','FP') and
2762: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2763: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZZ') and
2764: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2765: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2766: ) then

Line 2763: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZZ') and

2759: end if;
2760: ELSIF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
2761: if (nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','GL','FO','FP') and
2762: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2763: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZZ') and
2764: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2765: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2766: ) then
2767:

Line 2781: if (nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','GL','FO','FP') and

2777: hr_utility.raise_error;
2778: end if;
2779: end if;
2780: ELSE
2781: if (nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','GL','FO','FP') and
2782: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2783: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('AK','HI','ON','ZZ') and
2784: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2785: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)

Line 2782: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and

2778: end if;
2779: end if;
2780: ELSE
2781: if (nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','GL','FO','FP') and
2782: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2783: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('AK','HI','ON','ZZ') and
2784: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2785: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2786: ) then

Line 2783: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('AK','HI','ON','ZZ') and

2779: end if;
2780: ELSE
2781: if (nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','GL','FO','FP') and
2782: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2783: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('AK','HI','ON','ZZ') and
2784: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2785: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2786: ) then
2787:

Line 2828: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and

2824:
2825: -- check for 09-JAN-05 starts here
2826: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN
2827:
2828: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2829: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6','M') and
2830: nvl(p_locality_pay_area,hr_api.g_varchar2) between '02' and '88' and
2831: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2832: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)

Line 2829: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6','M') and

2825: -- check for 09-JAN-05 starts here
2826: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN
2827:
2828: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2829: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6','M') and
2830: nvl(p_locality_pay_area,hr_api.g_varchar2) between '02' and '88' and
2831: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2832: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2833: ) then

Line 2830: nvl(p_locality_pay_area,hr_api.g_varchar2) between '02' and '88' and

2826: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN
2827:
2828: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2829: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6','M') and
2830: nvl(p_locality_pay_area,hr_api.g_varchar2) between '02' and '88' and
2831: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2832: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2833: ) then
2834:

Line 2847: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and

2843: end if;
2844: -- FWFA Changes Bug#4444609
2845: ELSIF p_effective_date < to_date('2005/05/01','yyyy/mm/dd') THEN
2846:
2847: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2848: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6','M') and
2849: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2850: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2851: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)

Line 2848: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6','M') and

2844: -- FWFA Changes Bug#4444609
2845: ELSIF p_effective_date < to_date('2005/05/01','yyyy/mm/dd') THEN
2846:
2847: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2848: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6','M') and
2849: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2850: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2851: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2852: ) then

Line 2849: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and

2845: ELSIF p_effective_date < to_date('2005/05/01','yyyy/mm/dd') THEN
2846:
2847: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2848: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6','M') and
2849: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2850: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2851: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2852: ) then
2853: if (

Line 2863: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH') and

2859: hr_utility.raise_error;
2860: end if;
2861: end if;
2862: ELSE
2863: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH') and
2864: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6')
2865: ) then
2866: if to_number(p_prior_locality_adj) <= 0 then
2867: GHR_GHRWS52L.CPDF_Parameter_Check;

Line 2864: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6')

2860: end if;
2861: end if;
2862: ELSE
2863: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH') and
2864: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6')
2865: ) then
2866: if to_number(p_prior_locality_adj) <= 0 then
2867: GHR_GHRWS52L.CPDF_Parameter_Check;
2868: hr_utility.set_message(8301,'GHR_38979_ALL_PROCEDURE_FAIL');

Line 3039: if (nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('ES','EX','FE','SL','ST','ZZ') AND

3035: -- Update Date By Effective Date Comment
3036: -- U58 20/04/10 Raju 01/01/2010 Bug 9503972
3037:
3038: IF p_effective_date >= fnd_date.canonical_to_date('2010/01/01') THEN
3039: if (nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('ES','EX','FE','SL','ST','ZZ') AND
3040: p_prior_pay_rate_det_code NOT IN ('A','B','E','F','S') and
3041: p_prior_locality_pay_area NOT IN ('AK','HI','ON') AND
3042: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)) then
3043: