[Home] [Help]
54: -- 18-Sep-00 vravikan 01-Oct-99 Add Z
55: -- 11-Oct-07 Raju 01-Jul-08 delete Z(Bug#6469079)
56: /* If rating of record (pattern) is A, Then rating of record(level) must
57: be 1,3,X or Z. */
58: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01')
59: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
60: if p_rating_of_record_pattern = 'A' and
61: p_rating_of_record_level not in ('1','3','X','Z') and
62: p_rating_of_record_level is not null then
78: -- 18-Sep-00 vravikan 01-Oct-99 Add Z
79: -- 11-Oct-07 Raju 01-Jul-08 delete Z(Bug#6469079)
80: /* If rating of record (pattern) is B, Then rating of record(level) must
81: be 1,3,5,X or Z. */
82: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01')
83: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
84: if p_rating_of_record_pattern = 'B' and
85: p_rating_of_record_level not in ('1','3','5','X','Z') and
86: p_rating_of_record_level is not null then
102: -- 18-Sep-00 vravikan 01-Oct-99 Add Z
103: -- 11-Oct-07 Raju 01-Jul-08 delete Z(Bug#6469079)
104: /* If rating of record (pattern) is C, Then rating of record(level) must
105: be 1,3,4,X or Z. */
106: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01')
107: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
108: if p_rating_of_record_pattern = 'C' and
109: p_rating_of_record_level not in ('1','3','4','X','Z') and
110: p_rating_of_record_level is not null then
126: -- 18-Sep-00 vravikan 01-Oct-99 Add Z
127: -- 11-Oct-07 Raju 01-Jul-08 delete Z(Bug#6469079)
128: /* If rating of record (pattern) is D, Then rating of record(level) must
129: be 1,2,3,X or Z. */
130: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01')
131: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
132: if p_rating_of_record_pattern = 'D' and
133: p_rating_of_record_level not in ('1','2','3','X','Z') and
134: p_rating_of_record_level is not null then
151: -- 18-Sep-00 vravikan 01-Oct-99 Add Z
152: -- 11-Oct-07 Raju 01-Jul-08 delete Z(Bug#6469079)
153: /* If rating of record (pattern) is E, Then rating of record(level) must
154: be 1,3,4,5,X or Z. */
155: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01')
156: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
157: if p_rating_of_record_pattern = 'E' and
158: p_rating_of_record_level not in ('1','3','4','5','X','Z') and
159: p_rating_of_record_level is not null then
175: -- 18-Sep-00 vravikan 01-Oct-99 Add Z
176: -- 11-Oct-07 Raju 01-Jul-08 delete Z(Bug#6469079)
177: /* If rating of record (pattern) is F, Then rating of record(level) must
178: be 1,2,3,5,X or Z. */
179: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01')
180: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
181: if p_rating_of_record_pattern = 'F' and
182: p_rating_of_record_level not in ('1','2','3','5','X','Z') and
183: p_rating_of_record_level is not null then
199: -- 18-Sep-00 vravikan 01-Oct-99 Add Z
200: -- 11-Oct-07 Raju 01-Jul-08 delete Z(Bug#6469079)
201: /* If rating of record (pattern) is G, Then rating of record(level) must
202: be 1,2,3,4,X or Z. */
203: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01')
204: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
205: if p_rating_of_record_pattern = 'G' and
206: p_rating_of_record_level not in ('1','2','3','4','X','Z') and
207: p_rating_of_record_level is not null then
223: -- 02/16/00 vravikan 1196230 Add record_level 'Z'
224: -- 11-Oct-07 Raju 01-Jul-08 delete Z(Bug#6469079)
225: /* If rating of record (pattern) is H, Then rating of record(level) must
226: be 1,2,3,4,5,X or Z. */
227: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01')
228: and p_effective_date < to_date('2008/07/01','RRRR/MM/DD') then --Bug#6469079
229: if p_rating_of_record_pattern = 'H' and
230: p_rating_of_record_level not in ('1','2','3','4','5','X','Z') and
231: p_rating_of_record_level is not null then
254: end if;
255:
256: --471.03.3
257: -- 10/6 08/16/99 vravikan 01-Oct-99 New Edit
258: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/10/01') then
259: if p_to_pay_plan in ('ES') and
260: (p_rating_of_record_pattern is not null and
261: p_rating_of_record_pattern in ('A','B','C','E') ) then
262: hr_utility.set_message(8301, 'GHR_37184_ALL_PROCEDURE_FAIL');
278:
279: /* void due to lack of submission date
280: --472.02.1
281: if p_rating_of_record_period is not null and
282: fnd_date.canonical_to_date(p_rating_of_record_period) > p_submission_date then
283: hr_utility.set_message(8301, 'GHR_37503_ALL_PROCEDURE_FAIL');
284: hr_utility.raise_error;
285: end if;
286: */
288: --bug description
289:
290: /*--472.02.2
291: if p_rating_of_record_period is not null and
292: fnd_date.canonical_to_date(p_rating_of_record_period) > p_effective_date then
293: hr_utility.set_message(8301, 'GHR_37504_ALL_PROCEDURE_FAIL');
294: hr_utility.raise_error;
295: end if;
296: */
296: */
297:
298: --472.03.3
299: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
300: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
301: if p_rating_of_record_level = 'X' and
302: p_rating_of_record_period is not null then
303: hr_utility.set_message(8301, 'GHR_37505_ALL_PROCEDURE_FAIL');
304: hr_utility.raise_error;
314: personnel action.
315: */
316: --Bug# 15942707, commented out this edit, as we cannot raise warning msgs from packages
317: -- moved this edit to RPA form(GHRWS52L.fmb)
318: /* l_end_date := fnd_date.canonical_to_date(p_rating_of_record_period);
319: l_start_date := fnd_date.canonical_to_date(p_rating_of_record_per_starts);
320: if p_effective_date >= to_date('2000/10/01','yyyy/mm/dd') and
321: ((p_rating_of_record_period is not null and
322: months_between(p_effective_date,l_end_date ) > 60) or
315: */
316: --Bug# 15942707, commented out this edit, as we cannot raise warning msgs from packages
317: -- moved this edit to RPA form(GHRWS52L.fmb)
318: /* l_end_date := fnd_date.canonical_to_date(p_rating_of_record_period);
319: l_start_date := fnd_date.canonical_to_date(p_rating_of_record_per_starts);
320: if p_effective_date >= to_date('2000/10/01','yyyy/mm/dd') and
321: ((p_rating_of_record_period is not null and
322: months_between(p_effective_date,l_end_date ) > 60) or
323: (p_rating_of_record_per_starts is not null and
431: -- amrchakr 26-SEP-2006 Removed the NOACS- '150','151','153',
432: -- '154','155', '157' effective from 2003/07/01
433: -------------------------------------------------------------
434: -- 500.16.2
435: if p_effective_date < fnd_date.canonical_to_date('2003/07/01') then
436: if p_first_noac_lookup_code in ('150','151','153','154','155',
437: '157','170','171','550','551',
438: '553','554','555','570','571')
439: and
478: --22-Jan-07 upd 49 Raju From 01-Apr-2006 delete 894
479: --05-MAR-07 AVR Modify the CPDF edit 520.02.2 by adding 890 NOA.
480: ------------- do not change the message until OPM Guidelines.
481: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
482: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
483: --BUG# 8264475 modified for dual actions to consider both of the dual noacs in
484: -- dual correction while comparing with cpdf edits as occupation code may change
485: -- in any of the NOACs
486: if NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'N' then
540: end if;
541: -- 520.04.2
542: -- 12/12/01 Change 2200 to 2500
543: -- U58 Raju 01-jan-2010 Bug 9503972
544: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
545: if ( (p_prior_pay_plan ='LG' or p_prior_pay_plan ='ST') or
546: substr(p_prior_pay_plan,1,1)='G' ) and
547: to_number(p_prior_occupation_code) >= 2500 and
548: p_prior_occupation_code is not null then
562: END IF;
563:
564: -- 520.07.2
565: -- U58 Raju 01-jan-2010 Bug 9503972
566: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
567: if substr(p_prior_pay_plan,1,1) in ('K','W','X') and
568: to_number(p_prior_occupation_code) <= 2499 and
569: p_prior_occupation_code is not null then
570: hr_utility.set_message(8301, 'GHR_37513_ALL_PROCEDURE_FAIL');
777: hr_utility.raise_error;
778: END IF;
779: END IF;
780: --Begin Bug 11726461
781: ELSIF p_effective_date < fnd_date.canonical_to_date('2011/02/01') then-- if after 11th Jan 2004
782: -- From: If prior pay basis is PA, PH, PM, BW, or WC, Then prior basic pay must not be greater than the maximum shown in table 18.
783: -- To: If prior pay basis is BW, PA, PD, PH, or WC, Then prior basic pay must be within the range for the pay basis shown in Table 56.
784:
785: max_basic_pay := GHR_CPDF_CHECK.get_basic_pay('CPDF Oracle Federal Table 56',
926: end if;
927:
928: -- 540.03.2
929: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
930: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
931: if p_prior_pay_plan = 'FG' and
932: p_prior_grade not between '01' and '15'
933: and
934: p_prior_grade is not null
946: end if;
947:
948: -- 540.05.2
949: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
950: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
951: if p_prior_pay_plan = 'FM' and
952: p_prior_grade not between '13' and '15'
953: and
954: p_prior_grade is not null
961: -- 540.06.2
962: -- Update/Change Date By Effective Date Comment
963: -- 9/2 08/16/99 vravikan 01-Mar-1999 New Edit
964: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
965: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
966: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then
967: if p_prior_pay_plan = 'EZ' and
968: p_prior_grade not between '01' and '08'
969: and
962: -- Update/Change Date By Effective Date Comment
963: -- 9/2 08/16/99 vravikan 01-Mar-1999 New Edit
964: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
965: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
966: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then
967: if p_prior_pay_plan = 'EZ' and
968: p_prior_grade not between '01' and '08'
969: and
970: p_prior_grade is not null
978: -- 540.07.2
979: -- Update Date By Effective Date Comment
980: -- 9 14/05/99 vravikan Add prior pay plans CG and MG
981: -- UPD 56 8309414 Raju From 17-apr-08 Remove MG
982: if p_effective_date < fnd_date.canonical_to_date('2008/04/17') then
983: if p_prior_pay_plan in ( 'CG','MG','WL','XG' ) and
984: p_prior_grade not between '01' and '15'
985: and p_prior_grade is not null then
986: hr_utility.set_message(8301, 'GHR_37525_ALL_PROCEDURE_FAIL');
1009: end if;
1010:
1011: -- 540.13.2
1012: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1013: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1014: if p_prior_pay_plan = 'FA' and
1015: p_prior_pay_rate_det_code <>'S' and
1016: p_prior_grade not in ( 'CA','CM','MC','NC','OC','01','02','03','04','13','14')
1017: and
1023: end if;
1024:
1025: -- 540.16.2
1026: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1027: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1028: if p_prior_pay_plan = 'CE' and
1029: p_prior_grade not between '01' and '17' and
1030: p_prior_grade is not null
1031: then
1039: -- Then prior grade must be 01 through 24 or asterisks.
1040: --
1041: -- Included effective date on 16-jul-1998
1042: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1043: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1044: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1045: if p_prior_pay_plan = 'CY' and
1046: p_prior_grade not between '01' and '24' and
1047: p_prior_grade is not null then
1040: --
1041: -- Included effective date on 16-jul-1998
1042: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1043: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1044: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1045: if p_prior_pay_plan = 'CY' and
1046: p_prior_grade not between '01' and '24' and
1047: p_prior_grade is not null then
1048: hr_utility.set_message(8301, 'GHR_37874_ALL_PROCEDURE_FAIL');
1083:
1084: -- 540.22.2
1085: -- Update/Change Date By Effective Date Comment
1086: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
1087: IF p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1088: if p_prior_pay_plan = 'VM' and
1089: p_prior_grade not in ('11','12','13','14','15','96','97') and
1090: p_prior_grade is not null
1091: then
1117: end if;
1118:
1119: -- 540.29.2
1120: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1121: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1122: if p_prior_pay_plan = 'DR' and
1123: p_prior_grade not between '01' and '04'
1124: and
1125: p_prior_grade is not null
1140: end if;
1141:
1142: -- 540.32.2
1143: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1144: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1145: if (p_prior_pay_plan = 'ND' or p_prior_pay_plan = 'NT') and
1146: p_prior_grade not between '01' and '06'
1147: and
1148: p_prior_grade is not null
1153: end if;
1154:
1155: -- 540.33.2
1156: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1157: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1158: if p_prior_pay_plan = 'NG' and
1159: p_prior_grade not between '01' and '05'
1160: and
1161: p_prior_grade is not null
1178: -- 540.35.2
1179: --
1180: -- added on 16 jul 98 as per update 7
1181: --
1182: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1183: if p_prior_pay_plan in ('NH', 'NJ') and
1184: p_prior_grade not between '01' and '04' and
1185: p_prior_grade is not null then
1186: hr_utility.set_message(8301, 'GHR_37871_ALL_PROCEDURE_FAIL');
1192: --
1193: -- added on 16 jul 98 as per update 7
1194: --
1195: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1196: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1197: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1198: if p_prior_pay_plan = 'NK' and
1199: p_prior_grade not between '01' and '03' and
1200: p_prior_grade is not null then
1193: -- added on 16 jul 98 as per update 7
1194: --
1195: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1196: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1197: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1198: if p_prior_pay_plan = 'NK' and
1199: p_prior_grade not between '01' and '03' and
1200: p_prior_grade is not null then
1201: hr_utility.set_message(8301, 'GHR_37872_ALL_PROCEDURE_FAIL');
1220: -- 8 01/28/99 vravikan 10/01/1998 New Edit
1221: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
1222: -- If prior pay plan is FV, then prior grade must be 'AA' through 'MM' or asterisks
1223: --
1224: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') and
1225: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1226: if p_prior_pay_plan = 'FV' and
1227: p_prior_grade not in ('AA','BB','CC','DD','EE','FF','GG','HH','II',
1228: 'JJ','KK','LL','MM') and
1221: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
1222: -- If prior pay plan is FV, then prior grade must be 'AA' through 'MM' or asterisks
1223: --
1224: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') and
1225: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1226: if p_prior_pay_plan = 'FV' and
1227: p_prior_grade not in ('AA','BB','CC','DD','EE','FF','GG','HH','II',
1228: 'JJ','KK','LL','MM') and
1229: p_prior_grade is not null then
1238: -- 8 01/28/99 vravikan 10/01/1998 New Edit
1239: -- If prior pay plan is EV, then prior grade must be 01 through 03 or asterisks
1240: --
1241: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1242: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1243: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then
1244: if p_prior_pay_plan = 'EV' and
1245: p_prior_grade not in ('01', '02', '03') and
1246: p_prior_grade is not null then
1239: -- If prior pay plan is EV, then prior grade must be 01 through 03 or asterisks
1240: --
1241: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1242: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1243: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then
1244: if p_prior_pay_plan = 'EV' and
1245: p_prior_grade not in ('01', '02', '03') and
1246: p_prior_grade is not null then
1247: hr_utility.set_message(8301, 'GHR_37034_ALL_PROCEDURE_FAIL');
1251: end if;
1252:
1253: -- 540.40.2
1254: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1255: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1256: if p_prior_pay_plan = 'NY' and
1257: p_prior_grade not between '01' and '04'
1258: and
1259: p_prior_grade is not null
1296: end if;
1297:
1298: -- 540.49.2
1299: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1300: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1301: if p_prior_pay_plan = 'AF' and
1302: p_prior_grade not in ('AA','BB','CC','DD','EE')
1303: and
1304: p_prior_grade is not null
1309: end if;
1310:
1311: -- 540.52.2
1312: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1313: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1314: if p_prior_pay_plan = 'FC' and
1315: p_prior_grade not between '02' and '14'
1316: and
1317: p_prior_grade is not null
1334: -- 540.56.2
1335: -- Update/Change Date By Effective Date Comment
1336: -- 9/5 08/13/99 vravikan 01-Apr-99 New Edit
1337: /* If prior pay plan is NC, then prior grade must be 01 through 03 */
1338: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1339: if p_prior_pay_plan = 'NC' and
1340: not( p_prior_grade in ('01','02','03') or
1341: p_prior_grade is null )
1342: then
1350: --upd47 26-Jun-06 Raju 01-Apr-2006 Change prior grade 04 to 05
1351: --7642919 16-Dec-08 Raju 01-Apr-2006 Included grade 04
1352: /* If prior pay plan is NO, then prior grade must be 01 through 04 */
1353: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1354: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1355: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1356: if p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1357: if p_prior_pay_plan = 'NO' and
1358: not( p_prior_grade in ('01','02','03','04') or
1351: --7642919 16-Dec-08 Raju 01-Apr-2006 Included grade 04
1352: /* If prior pay plan is NO, then prior grade must be 01 through 04 */
1353: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1354: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1355: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1356: if p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1357: if p_prior_pay_plan = 'NO' and
1358: not( p_prior_grade in ('01','02','03','04') or
1359: p_prior_grade is null ) then
1352: /* If prior pay plan is NO, then prior grade must be 01 through 04 */
1353: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1354: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1355: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1356: if p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1357: if p_prior_pay_plan = 'NO' and
1358: not( p_prior_grade in ('01','02','03','04') or
1359: p_prior_grade is null ) then
1360: hr_utility.set_message(8301, 'GHR_37072_ALL_PROCEDURE_FAIL');
1377: -- Update/Change Date By Effective Date Comment
1378: -- 9/5 08/13/99 vravikan 01-Apr-99 New Edit
1379: /* If prior pay plan is NP or NR, then prior grade must be 01 through 05 */
1380: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1381: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1382: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1383: if p_prior_pay_plan in ( 'NP','NR') and
1384: not( p_prior_grade in ('01','02','03','04','05') or
1385: p_prior_grade is null )
1378: -- 9/5 08/13/99 vravikan 01-Apr-99 New Edit
1379: /* If prior pay plan is NP or NR, then prior grade must be 01 through 05 */
1380: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1381: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1382: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1383: if p_prior_pay_plan in ( 'NP','NR') and
1384: not( p_prior_grade in ('01','02','03','04','05') or
1385: p_prior_grade is null )
1386: then
1400: end if;
1401:
1402: -- 540.61.2
1403: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1404: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1405: if (p_prior_pay_plan = 'SL' or p_prior_pay_plan = 'XE')
1406: and
1407: p_prior_grade <> '00'
1408: and
1420:
1421: /* If Prior Pay plan is VE,
1422: Then prior grade must be 01, 02, or asterisks */
1423: if p_effective_date >= to_date('2000/05/01', 'yyyy/mm/dd') and
1424: p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
1425: if p_prior_pay_plan = 'VE' and
1426: not( p_prior_grade in ('01','02') or
1427: p_prior_grade is null )
1428: then
1435: -- 18-Aug-00 vravikan 01-Jun-2000 New Edit
1436: /* If Prior Pay plan is NB,
1437: Then prior grade must be 01 through 09, or asterisks */
1438: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1439: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1440: if p_effective_date >= to_date('2000/06/01', 'yyyy/mm/dd') then
1441: if p_prior_pay_plan = 'NB' and
1442: p_prior_grade not in ('01', '02','03','04','05','06','07','08','09')
1443: and p_prior_grade is not null
1498: -- upd51 06-Feb-07 Raju From 01-Jan-2007 Bug#5745356 add 890
1499: --BuG# 6010943 Raju Modified the p_prior_effective_date to p_effective_date
1500: --
1501: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1502: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1503: --BUG# 8264475 modified for dual actions to consider both of the dual noacs in
1504: -- dual correction while comparing with cpdf edits as pay plan may change
1505: -- in any of the NOACs
1506: if NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'N' then
1503: --BUG# 8264475 modified for dual actions to consider both of the dual noacs in
1504: -- dual correction while comparing with cpdf edits as pay plan may change
1505: -- in any of the NOACs
1506: if NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'N' then
1507: if p_effective_date < fnd_date.canonical_to_date('1998/10/01') then
1508: if p_prior_pay_plan <> p_to_pay_plan and
1509: p_prior_pay_plan is not null and
1510: p_to_pay_plan is not null and
1511: not(p_first_noac_lookup_code in ('702','703','713','721','740','741','850','855','894') or
1512: substr(p_first_noac_lookup_code,1,1)= '5') then
1513: hr_utility.set_message(8301, 'GHR_37547_ALL_PROCEDURE_FAIL');
1514: hr_utility.raise_error;
1515: end if;
1516: elsif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1517: if p_prior_pay_plan <> p_to_pay_plan and
1518: p_prior_pay_plan is not null and
1519: p_to_pay_plan is not null and
1520: not(p_first_noac_lookup_code in ('600','601','602','603','604','605','606','607','608','609','610',
1523: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1524: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 850, 855 or 894');
1525: hr_utility.raise_error;
1526: end if;
1527: elsif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then
1528: if p_prior_pay_plan <> p_to_pay_plan and
1529: p_prior_pay_plan is not null and
1530: p_to_pay_plan is not null and
1531: not(p_first_noac_lookup_code in ('600','601','602','603','604','605','606','607','608','609','610',
1548: end if;
1549: end if;
1550: --Modified for dual actions
1551: elsif NVL(ghr_process_sf52.g_dual_action_yn,'N') = 'Y' then
1552: if p_effective_date < fnd_date.canonical_to_date('1998/10/01') then
1553: if p_prior_pay_plan <> p_to_pay_plan and
1554: p_prior_pay_plan is not null and
1555: p_to_pay_plan is not null and
1556: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('702','703','713','721','740','741','850','855','894') or
1559: substr(NVL(ghr_process_sf52.g_dual_second_noac,p_first_noac_lookup_code),1,1)= '5')then
1560: hr_utility.set_message(8301, 'GHR_37547_ALL_PROCEDURE_FAIL');
1561: hr_utility.raise_error;
1562: end if;
1563: elsif p_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1564: if p_prior_pay_plan <> p_to_pay_plan and
1565: p_prior_pay_plan is not null and
1566: p_to_pay_plan is not null and
1567: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1573: hr_utility.set_message(8301, 'GHR_37035_ALL_PROCEDURE_FAIL');
1574: hr_utility.set_message_token('NOA_CODE','702, 703, 713, 721, 740, 741, 850, 855 or 894');
1575: hr_utility.raise_error;
1576: end if;
1577: elsif p_effective_date < fnd_date.canonical_to_date('2007/01/01') then
1578: if p_prior_pay_plan <> p_to_pay_plan and
1579: p_prior_pay_plan is not null and
1580: p_to_pay_plan is not null and
1581: not(NVL(ghr_process_sf52.g_dual_first_noac,p_first_noac_lookup_code) in ('600','601','602','603','604','605','606','607','608','609','610',
1653: -- 560.04.2
1654: -- 06/25/03 vravikan By passing this edit if the
1655: -- employee on RG Temporary promotion
1656: --upd47 26-Jun-06 Raju From 01-Apr-2006 Added pay plan is other than Yx condition
1657: if P_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1658: IF GHR_GHRWS52L.g_temp_step IS NULL THEN
1659: if p_First_NOAC_Lookup_Code = '703' and
1660: p_prior_pay_rate_det_code in ('A','B','E','F','U','V') and
1661: p_pay_rate_determinant not in ('A','B','E','F','U','V') and
1682: END IF;
1683:
1684: -- 560.06.2
1685: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1686: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1687: if p_prior_pay_rate_det_code = 'C' and
1688: (p_prior_pay_plan in ('ED','EE','EF','EG','EH','EI','ZZ') or
1689: substr(p_prior_pay_plan,1,1) in ('B','W','X'))
1690: then
1775: --Bug#825741 03/08/99 vravikan Code correction
1776: -- 18/10/04 Madhuri start of the edit including the PRD - 2 to the list
1777: --
1778: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1779: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1780: if p_prior_pay_plan = 'ES' and
1781: p_prior_pay_rate_det_code not in ('C','0','2') and
1782: p_prior_pay_rate_det_code is not null
1783: then
1796: -- Modified by Date Comments
1797: -------------------------------------------------------------------------------
1798: -- Madhuri 01-MAR-05 Retroactively end dating as of 31-JAN-2002
1799: -------------------------------------------------------------------------------
1800: IF p_prior_effective_date <= fnd_date.canonical_to_date('20'||'02/01/31') THEN
1801:
1802: ghr_history_api.get_g_session_var(l_session);
1803: If l_session.noa_id_correct is null then
1804:
1972: -- 560.40.2
1973: -- Update/Change Date By Effective Date Comment
1974: -- 9/4 08/10/99 vravikan 01-Mar-99 Exclude PRD T.
1975: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1976: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1977: If p_prior_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then
1978: if p_prior_pay_plan in ('GM','GS') and
1979: p_prior_pay_rate_det_code in ('P','T') then
1980: hr_utility.set_message(8301, 'GHR_37063_ALL_PROCEDURE_FAIL');
1973: -- Update/Change Date By Effective Date Comment
1974: -- 9/4 08/10/99 vravikan 01-Mar-99 Exclude PRD T.
1975: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1976: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1977: If p_prior_effective_date >= fnd_date.canonical_to_date('19'||'99/03/01') then
1978: if p_prior_pay_plan in ('GM','GS') and
1979: p_prior_pay_rate_det_code in ('P','T') then
1980: hr_utility.set_message(8301, 'GHR_37063_ALL_PROCEDURE_FAIL');
1981: hr_utility.raise_error;
2104: END IF;
2105:
2106: -- 580.03.2
2107: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2108: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2109: if p_prior_pay_plan = 'FG'
2110: and
2111: p_prior_step_or_rate not in ('00','01','02','03','04','05','06',
2112: '07','08','09','10')
2160:
2161: -- 580.10.2
2162: -- 17-Aug-00 vravikan 01-jan-2000 Delete 99 form step/rate codes
2163: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2164: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2165: if p_prior_effective_date >= to_date('2000/01/01','yyyy/mm/dd') then
2166: if p_prior_pay_plan = 'GM' and p_prior_step_or_rate <> '00'
2167: and
2168: p_prior_step_or_rate is not null
2187: -- Madhuri 21-JAN-2004 End Dating this edit as on 10-JAN-04
2188: -- For SES Pay Calculations
2189: --p_effective_date
2190: --upd47 26-Jun-06 Raju From 01-Jan-2004 Terminate the edit
2191: if p_effective_date < fnd_date.canonical_to_date('2004/01/01') then
2192: if (p_effective_date < to_date('2004/01/11', 'yyyy/mm/dd') and
2193: (p_prior_pay_plan = 'ES' or p_prior_pay_plan = 'FE') and
2194: (to_number(p_prior_step_or_rate) not between 1 and 6) and
2195: p_prior_step_or_rate is not null ) then
2198: end if;
2199: end if;
2200: -- 580.19.2
2201: --upd47 26-Jun-06 Raju From 01-Apr-2003 Terminate the edit
2202: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then
2203: if (p_prior_pay_rate_det_code in ('2','3','4') or
2204: p_prior_pay_rate_det_code in ('A','B','C','D','E','F','G','H','I','J',
2205: 'K','L','N','O','P','Q','R','S','T','U',
2206: 'V','W','X','Y','Z')) and
2248: -- 18-Sep-00 vravikan From the Start Add VE
2249: -- 19-MAY-04 Madhuri From Start Removed pay plan VP from list
2250: -- 13-Jun-06 Raju 01-Jan-03 Terminate the edit
2251: --
2252: IF p_effective_date < fnd_date.canonical_to_date('2003/01/01') then --Bug# 5073313
2253: if (p_prior_pay_plan in ('VE','VM'/*,'VP'*/)) and
2254: p_prior_grade <> '97' and
2255: (to_number(p_prior_step_or_rate) not between 0 and 10) and
2256: p_prior_step_or_rate is not null
2261: END IF;
2262:
2263: -- 580.26.2
2264: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2265: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2266: if p_prior_pay_plan = 'VM' and p_prior_grade = '97' and
2267: (to_number(p_prior_step_or_rate) not between 0 and 9)
2268: and
2269: p_prior_step_or_rate is not null
2284: end if;
2285:
2286: -- 580.29.2
2287: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2288: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2289: if p_prior_pay_plan = 'XE' and
2290: (to_number(p_prior_step_or_rate) not between 1 and 3)
2291: and
2292: p_prior_step_or_rate is not null
2317: end if;
2318:
2319: -- 580.33.2
2320: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2321: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2322: if (p_prior_pay_plan = 'FP' and p_prior_grade in ('AA','BB','CC','DD','EE') and
2323: to_number(p_prior_step_or_rate) not between 1 and 5)
2324: and
2325: p_prior_step_or_rate is not null
2330: end if;
2331:
2332: -- 580.34.2
2333: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2334: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2335: if p_prior_pay_plan = 'AF' and
2336: (to_number(p_prior_step_or_rate) not between 1 and 5)
2337: and
2338: p_prior_step_or_rate is not null
2343: end if;
2344:
2345: -- 580.37.2
2346: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2347: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2348: if (p_prior_pay_plan = 'FC' and
2349: p_prior_grade between '02' and '12') and
2350: (to_number(p_prior_step_or_rate) not between 1 and 10)
2351: and
2357: end if;
2358:
2359: -- 580.40.2
2360: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2361: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2362: if (p_prior_pay_plan = 'FC' and p_prior_grade = '13') and
2363: (to_number(p_prior_step_or_rate) not between 1 and 9)
2364: and
2365: p_prior_step_or_rate is not null
2370: end if;
2371:
2372: -- 580.43.2
2373: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2374: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2375: if (p_prior_pay_plan = 'FC' and p_prior_grade = '14') and
2376: (to_number(p_prior_step_or_rate) not between 1 and 5)
2377: and
2378: p_prior_step_or_rate is not null
2383: end if;
2384:
2385: -- 580.46.2
2386: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2387: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2388: if p_prior_pay_plan in ('CA','SL','ST') and
2389: p_prior_step_or_rate <>'00'
2390: and
2391: p_prior_step_or_rate is not null
2396: end if;
2397:
2398: -- 580.49.2
2399: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2400: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2401: if p_prior_pay_plan = 'AL'
2402: and
2403: (p_prior_grade ='01' or p_prior_grade ='02')
2404: and
2423: end if;
2424:
2425: -- 580.55.2
2426: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2427: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2428: if p_prior_pay_plan = 'GG' and p_prior_grade = 'SL' and
2429: p_prior_step_or_rate <>'00'
2430: and
2431: p_prior_step_or_rate is not null
2436: end if;
2437:
2438: -- 580.57.2
2439: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
2440: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
2441: if (p_prior_pay_plan = 'IJ' and p_prior_pay_rate_det_code in ('0','7')) then
2442: if NVL(p_prior_step_or_rate, '01') not in ('01','02','03','04') then
2443: hr_utility.set_message(8301, 'GHR_38413_ALL_PROCEDURE_FAIL');
2444: hr_utility.raise_error;