[Home] [Help]
65: END IF;
66:
67: -- 570.23.2
68: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
69: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
70: if (p_prior_pay_plan = 'FG' and
71: (
72: p_prior_pay_rate_det_code = '0' or
73: p_prior_pay_rate_det_code = '7'
96: -- 840-848,878-879. Add 890
97: -- upd53 20-Apr-07 Raju From 01-Jan-2007 Bug#5996938 added 815-817, 825
98: -- 827,840-849,878-879.
99:
100: if p_effective_date < fnd_date.canonical_to_date('2006/10/01') then
101: if (
102: (substr(p_first_noac_lookup_code,1,1) in ('7','8') and
103: p_first_noac_lookup_code not in
104: ( '702','703','713','721','740','741','815','816','817','825','840','841',
116: hr_utility.set_message(8301,'GHR_37713_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 815-817, 825, 840-849, 855, 866-868, 871,878-879, 891-894');
118: hr_utility.raise_error;
119: end if;
120: ELSif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then
121: if (
122: (substr(p_first_noac_lookup_code,1,1) in ('7','8') and
123: p_first_noac_lookup_code not in
124: ( '702','703','713','721','740','741','815','816','817','825','840','841',
206: for the prior grade on Table 37 or Table 38
207: (depending on prior pay rate determinant) or be asterisks.
208: Default: Insert asterisks in pay basis and basic pay.
209:
210: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and
211: p_prior_pay_plan = 'NH' and
212: p_prior_pay_rate_det_code in ('0','5','6','7') then -- added for bug 726125
213: if p_prior_pay_rate_det_code in ('0','7') then
214: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 37',
244:
245: Default: Insert asterisks in prior pay basis and prior
246: basic pay.*/
247: --upd47 26-Jun-06 Raju From 01-Apr-2003 Terminate the edit
248: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then
249: if p_prior_pay_plan = 'GS' and
250: p_prior_pay_rate_det_code in ('2','3','4','J','K','R') then
251:
252: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
270: for the prior grade on Table 39 or Table 40
271: (depending on prior pay rate determinant) or be asterisks.
272: Default: Insert asterisks in pay basis and basic pay.
273:
274: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and
275: p_prior_pay_plan = 'NJ' and
276: p_prior_pay_rate_det_code in ('0','5','6','7') then -- added for bug 726125
277: if p_prior_pay_rate_det_code in ('0','7') then
278: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 39',
306: for the prior grade on Table 41 or Table 42
307: (depending on pay rate determinant) or be asterisks.
308: Default: Insert asterisks in pay basis and basic pay.
309:
310: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') and
311: p_prior_pay_plan = 'NK' and
312: p_prior_pay_rate_det_code in ('0','5','6','7') then -- added for bug 726125
313: if p_prior_pay_rate_det_code in ('0','7') then
314: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 41',
404: Default: Insert asterisks in prior pay basis and prior
405: basic pay.*/
406: --upd47 26-Jun-06 Raju From 01-Apr-2006 Added pay plan GS
407:
408: if p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
409: if p_prior_pay_plan in ('GH', 'GM') and
410: p_prior_pay_rate_det_code in ('2','3','4','J','K','R') then
411: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 2',
412: p_prior_grade_or_level || '-' || p_prior_step_or_rate,
592: Then prior basic pay must match the entry for
593: the prior grade and prior step on Table 57 or be asterisks.
594: */
595: -- 570.21.2
596: IF p_effective_date >= fnd_date.canonical_to_date('2007/08/13') THEN
597: IF (
598: p_prior_pay_plan = 'GL' and p_prior_pay_rate_det_code in ('0','7')
599: ) THEN
600: l_table_pay := GHR_CPDF_CHECK.get_basic_pay(
623: -- Modified by Date Comments
624: -------------------------------------------------------------------------------
625: -- Madhuri 01-MAR-05 Retroactively end dating as of 31-JAN-2002
626: -------------------------------------------------------------------------------
627: IF p_prior_effective_date <= fnd_date.canonical_to_date('20'||'02/01/31') THEN
628: if p_prior_pay_plan = 'KA' then
629: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 17',
630: p_prior_pay_plan ,
631: 'Minimum Basic Pay',
684:
685: Default: Insert asterisks in prior pay basis and prior
686: basic pay.*/
687: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
688: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
689: if p_prior_pay_plan = 'FT' then
690: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 21',
691: p_prior_pay_plan ,
692: 'Minimum Basic Pay',
747: Default: Insert asterisks in prior pay basis and prior
748: basic pay.*/
749: -- 17-Aug-00 vravikan 1-Jan-2000 Modify Edit to remove prior step or rate
750: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
751: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
752: if p_effective_date >= to_date('2000/01/01','yyyy/mm/dd') then
753: if p_prior_pay_plan = 'FM' and
754: p_prior_pay_rate_det_code in ('0','7') then
755:
854:
855: Default: Insert asterisks in prior pay basis and prior
856: basic pay.*/
857: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
858: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
859: if p_prior_pay_plan = 'NY' then
860: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 26',
861: p_prior_grade_or_level ,
862: 'Minimum Basic Pay',p_prior_effective_date);
879:
880: Default: Insert asterisks in prior pay basis and prior
881: basic pay.*/
882: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
883: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
884: if p_prior_pay_plan = 'NX' then
885:
886: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 27',
887: p_prior_grade_or_level ,
913: -- From Then Prior Basic Pay must match the entry for the grade on Table 8 or be asterisks.
914: -- to Then Prior Basic Pay must be within the range for prior grade on Table 8 or be asterisks.
915: --
916: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
917: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
918: if p_prior_pay_plan = 'FC' and
919: p_prior_pay_rate_det_code <> 'C' then
920:
921: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 8',
1037: is 0 or 7 then compare to table 44. If prior pay rate determinant is 5 or 6
1038: then compare to table 45.
1039:
1040:
1041: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1042: if p_prior_pay_plan = 'NC' then
1043: if p_prior_pay_rate_det_code in ('0','7')
1044: then
1045:
1080: Table 46 or Table 47 (depending on prior pay rate determinant).
1081: If prior pay rate determinant is 0 or 7 then compare to table 46.
1082: If prior pay rate determinant is 5 or 6 then compare to table 47.
1083:
1084: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1085: if p_prior_pay_plan = 'NO' then
1086: if p_prior_pay_rate_det_code in ('0','7')
1087: then
1088:
1122: or Table 49 (depending on prior pay rate determinant).
1123: If prior pay rate determinant is 0 or 7 then compare to table 48.
1124: If prior pay rate determinant is 5 or 6 then compare to table 49.
1125:
1126: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1127: if p_prior_pay_plan = 'NP' then
1128: if p_prior_pay_rate_det_code in ('0','7')
1129: then
1130:
1166: If prior pay rate determinant is 0 or 7 then compare to table 50.
1167: If prior pay rate determinant is 5 or 6 then compare to table 51.
1168:
1169:
1170: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1171: if p_prior_pay_plan = 'NR' then
1172: if p_prior_pay_rate_det_code in ('0','7')
1173: then
1174:
1540:
1541: Default: Insert asterisks in prior pay basis and prior
1542: basic pay.*/
1543: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1544: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1545: if p_prior_pay_plan = 'IJ' and
1546: p_prior_pay_rate_det_code in ('0','7') then
1547:
1548: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 36',
1595:
1596: Default: Insert asterisks in prior pay basis and prior
1597: basic pay.*/
1598: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1599: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1600: if p_prior_pay_plan = 'GH' and
1601: p_prior_pay_rate_det_code in ('0','7') then
1602:
1603: min_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 3',
1908: hr_utility.set_message(8301,'GHR_37695_ALL_PROCEDURE_FAIL');
1909: hr_utility.raise_error;
1910: end if;
1911: end if;
1912: ELSIF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
1913: if (p_to_pay_plan in ('GS','GM','GG','GL','GH','FO','FP') and
1914: p_pay_rate_determinant_code in ('0','7') and
1915: p_locality_pay_area NOT IN ('ZZ') and
1916: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0) and
1967: -- upd50 06-Feb-07 Raju From 01-Oct-2006 Bug#5745356
1968: -- upd50 27-Nov-11 Raju From 01-Oct-2006 Bug# 13257133 Modified to Greater than
1969: -- earlier wrongly coded as less then with bug 5745356
1970: -------------------------------------------------------------------------------
1971: IF p_effective_date < fnd_date.canonical_to_date('1998/03/01') then
1972: if (
1973: p_to_pay_plan in ('GS','GM','GG','GH') and
1974: p_pay_rate_determinant_code in ('6','5','M') and
1975: p_locality_pay_area between '02' and '88' and
2138: -- Raju 26-Jun-06 Validate for actions after 01-Jan-2006
2139: -- and added pay plan condition affective frm 01-Apr-06
2140: -- arbasu 26-Oct-06 Added PRD condition for GHR_38932_ALL_PROCEDURE_FAIL
2141: -------------------------------------------------------------------------------
2142: IF p_effective_date < fnd_date.canonical_to_date('1998/09/01') then
2143: if (p_locality_pay_area = '99' and
2144: (p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0)) then
2145: GHR_GHRWS52L.CPDF_Parameter_Check;
2146: hr_utility.set_message(8301,'GHR_37733_ALL_PROCEDURE_FAIL');
2174: hr_utility.set_message(8301,'GHR_38978_ALL_PROCEDURE_FAIL');
2175: hr_utility.raise_error;
2176: end if;
2177: -- Begin Bug# 5073313
2178: elsif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
2179: if substr(p_agency_subelement,1,2) not in ('HS') and p_locality_pay_area = 'ZZ' and
2180: p_pay_rate_determinant_code NOT in ('6','5','E','F')
2181: AND p_to_locality_adj is not null and to_number(p_to_locality_adj) <> 0
2182: then
2211: -- than CA or MX,
2212: -- Or pay plan is FO or FP,
2213: -- Then locality adjustment must be spaces or asterisks.
2214:
2215: /* if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
2216: if p_locality_pay_area = '99' and
2217: substr(p_agency_subelement,1,2) in ('AM','GY','HS','IB','ST') and
2218: (
2219: substr(p_duty_station_code,1,2) not in ('CA','MX') or
2265: hr_utility.set_message_token('PRD_LIST','A, B, E, F, or S');
2266: hr_utility.set_message_token('PP_LIST','EX, ES, FE or ZZ');
2267: hr_utility.raise_error;
2268: end if;
2269: ELSIF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
2270: if (
2271: ( p_to_pay_plan in ('EX','ZZ','ES','FE','SL','ST') or
2272: substr(p_to_pay_plan,1,1) in ('B','X') or
2273: (substr(p_to_pay_plan,1,1) in ('W') and p_to_pay_plan not in ('WM') )
2367: hr_utility.raise_error;
2368: end if;
2369:
2370: ELSIF ( p_effective_date >= to_date('01/07/2006', 'dd/mm/yyyy') ) AND
2371: p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
2372: if ( p_retained_pay_plan in ('GS','GG') and
2373: p_pay_rate_determinant_code in ('A','B') and
2374: p_locality_pay_area NOT IN ('ZZ') and
2375: (p_to_locality_adj is null)) and
2561: -- 652.95.2
2562: if ((p_to_pay_plan in ('GS','GM','GG','GH','FO','FP','FE','ES','ST','AL','CA','SL') and
2563: p_locality_pay_area <> '99' and
2564: p_pay_rate_determinant_code not in ('A','B','C','E','F','U','V') and
2565: p_effective_date >= fnd_date.canonical_to_date('1994/01/01')) and
2566: (
2567: substr(p_first_noac_lookup_code,1,1) <> '3' and
2568: substr(p_first_noac_lookup_code,1,1) <> '4'
2569: )
2756: hr_utility.set_message(8301,'GHR_37697_ALL_PROCEDURE_FAIL');
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
2887: --- Madhuri 01-MAR-05 Change the condition 'If prior locality pay area is 99'
2888: --- To:'If prior locality pay area is ZZ' as of 09-JAN-05
2889: --upd47 26-Jun-06 Raju From 01-Apr-2006 Added prior pay plan condition
2890: -------------------------------------------------------------------------------
2891: IF p_effective_date < fnd_date.canonical_to_date('1998/09/01') THEN
2892: if (p_prior_locality_pay_area = '99' and
2893: (p_prior_locality_adj is not null and to_number(p_prior_locality_adj) <> 0)) then
2894: GHR_GHRWS52L.CPDF_Parameter_Check;
2895: hr_utility.set_message(8301,'GHR_37743_ALL_PROCEDURE_FAIL');
2921: GHR_GHRWS52L.CPDF_Parameter_Check;
2922: hr_utility.set_message(8301,'GHR_38937_ALL_PROCEDURE_FAIL');
2923: hr_utility.raise_error;
2924: end if;
2925: ELSif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
2926: if p_prior_locality_pay_area = 'ZZ' and
2927: p_prior_pay_rate_det_code not in ('5','6','E','F') and
2928: p_prior_locality_adj is not null and
2929: to_number(p_prior_locality_adj) <> 0
2960: -- than CA or MX,
2961: -- Or prior pay plan is FO or FP,
2962: -- Then prior locality adjustment must be spaces or asterisks.
2963:
2964: /* if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
2965: if p_prior_locality_pay_area = '99' and
2966: substr(p_agency_subelement,1,2) in ('AM','GY','HS','IB','ST') and
2967: (
2968: substr(p_prior_duty_station,1,2) not in ('CA','MX') or
3034:
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