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 2448: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP','FE','ES','ST','AL','CA','SL')

2444: --
2445: -- Commented the edit for bug 557188 on 7-aug-98
2446: --
2447: if (
2448: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP','FE','ES','ST','AL','CA','SL')
2449: ) then
2450:
2451: if (p_prior_basic_pay is not null or to_number(p_prior_basic_pay) <> 0) then
2452: if (

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

2483: -- amrchakr 05-Oct-2006 Removed prior locality pay area 'ZY' effective from 01-jul-2006
2484: -------------------------------------------------------------------------------
2485: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN
2486: if (
2487: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2488: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','3','7','J','K') and
2489: nvl(p_locality_pay_area,hr_api.g_varchar2) between '02' and '88' and
2490: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2491: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)

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

2484: -------------------------------------------------------------------------------
2485: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN
2486: if (
2487: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2488: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','3','7','J','K') and
2489: nvl(p_locality_pay_area,hr_api.g_varchar2) between '02' and '88' and
2490: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2491: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2492: ) then

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

2485: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN
2486: if (
2487: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2488: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','3','7','J','K') and
2489: nvl(p_locality_pay_area,hr_api.g_varchar2) between '02' and '88' and
2490: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2491: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2492: ) then
2493: if (

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

2500: end if;
2501: end if;
2502: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN
2503: if (
2504: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2505: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','3','7','J','K') and
2506: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2507: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2508: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)

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

2501: end if;
2502: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN
2503: if (
2504: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2505: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','3','7','J','K') and
2506: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2507: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2508: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2509: ) then

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

2502: ELSIF ( p_effective_date < to_date('01/05/2005', 'dd/mm/yyyy') ) THEN
2503: if (
2504: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2505: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','3','7','J','K') and
2506: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2507: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2508: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2509: ) then
2510: if (

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

2522: AND
2523: p_effective_date < to_date('01/07/2006', 'dd/mm/yyyy')
2524: ) THEN
2525: if (
2526: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2527: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2528: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2529: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2530: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)

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

2523: p_effective_date < to_date('01/07/2006', 'dd/mm/yyyy')
2524: ) THEN
2525: if (
2526: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2527: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2528: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2529: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2530: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2531: ) then

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

2524: ) THEN
2525: if (
2526: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2527: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2528: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2529: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2530: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2531: ) then
2532: if (

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

2541: end if;
2542:
2543: ELSIF ( p_effective_date >= to_date('01/07/2006', 'dd/mm/yyyy') ) THEN
2544: if (
2545: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2546: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2547: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZZ') and
2548: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2549: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)

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

2542:
2543: ELSIF ( p_effective_date >= to_date('01/07/2006', 'dd/mm/yyyy') ) THEN
2544: if (
2545: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2546: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2547: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZZ') and
2548: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2549: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2550: ) then

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

2543: ELSIF ( p_effective_date >= to_date('01/07/2006', 'dd/mm/yyyy') ) THEN
2544: if (
2545: nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2546: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('0','7') and
2547: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZZ') and
2548: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2549: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2550: ) then
2551: if (

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

2585:
2586: -- check for 09-JAN-05 starts here
2587: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN
2588:
2589: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2590: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6','M') and
2591: nvl(p_locality_pay_area,hr_api.g_varchar2) between '02' and '88' and
2592: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2593: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)

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

2586: -- check for 09-JAN-05 starts here
2587: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN
2588:
2589: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2590: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6','M') and
2591: nvl(p_locality_pay_area,hr_api.g_varchar2) between '02' and '88' and
2592: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2593: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2594: ) then

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

2587: IF ( p_effective_date < to_date('09/01/2005', 'dd/mm/yyyy') ) THEN
2588:
2589: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2590: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6','M') and
2591: nvl(p_locality_pay_area,hr_api.g_varchar2) between '02' and '88' and
2592: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2593: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2594: ) then
2595:

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

2604: end if;
2605: -- FWFA Changes Bug#4444609
2606: ELSIF p_effective_date < to_date('2005/05/01','yyyy/mm/dd') THEN
2607:
2608: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2609: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6','M') and
2610: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2611: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2612: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)

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

2605: -- FWFA Changes Bug#4444609
2606: ELSIF p_effective_date < to_date('2005/05/01','yyyy/mm/dd') THEN
2607:
2608: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2609: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6','M') and
2610: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2611: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2612: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2613: ) then

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

2606: ELSIF p_effective_date < to_date('2005/05/01','yyyy/mm/dd') THEN
2607:
2608: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH','FO','FP') and
2609: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6','M') and
2610: nvl(p_locality_pay_area,hr_api.g_varchar2) NOT IN ('ZY','ZZ') and
2611: (p_prior_locality_adj is not null or to_number(p_prior_locality_adj) <> 0) and
2612: (p_prior_basic_pay is not null or p_prior_basic_pay <> 0)
2613: ) then
2614: if (

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

2620: hr_utility.raise_error;
2621: end if;
2622: end if;
2623: ELSE
2624: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH') and
2625: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6')
2626: ) then
2627: if to_number(p_prior_locality_adj) <= 0 then
2628: GHR_GHRWS52L.CPDF_Parameter_Check;

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

2621: end if;
2622: end if;
2623: ELSE
2624: if ( nvl(p_prior_pay_plan,hr_api.g_varchar2) in ('GS','GM','GG','GH') and
2625: nvl(p_prior_pay_rate_det_code,hr_api.g_varchar2) in ('5','6')
2626: ) then
2627: if to_number(p_prior_locality_adj) <= 0 then
2628: GHR_GHRWS52L.CPDF_Parameter_Check;
2629: hr_utility.set_message(8301,'GHR_38979_ALL_PROCEDURE_FAIL');