[Home] [Help]
484: --
485: -- 100.03.3 If either current appointment authority is ZTA,
486: -- And position occupied is 1,
487: -- Then agency/subelement must be DJ03.
488: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
489: if ( p_Cur_Appt_Auth_1= 'ZTA' or p_Cur_Appt_Auth_2='ZTA' ) and
490: p_Position_Occupied_Code = '1' and
491: p_Agency_Subelement <> 'DJ03' then
492: hr_utility.set_message(8301, 'GHR_37892_ALL_PROCEDURE_FAIL');
537: -- ============================================
538: -- 19-MAR-2003 vnarasim Added agency/subelement HSBC.
539: -- 30-OCT-2003 Ashley Deleted agency/subelement TD19
540: --
541: if p_effective_date >= fnd_date.canonical_to_date('20'||'00/10/01') then
542: if (p_Cur_Appt_Auth_1 = 'ZVC' OR p_Cur_Appt_Auth_2 = 'ZVC') AND
543: (p_agency_subelement NOT IN ('HSBC'))
544: then
545: hr_utility.set_message(8301, 'GHR_37925_ALL_PROCEDURE_FAIL');
566: -- 11 01/03/00 vravikan 11/01/99 Add Edit
567:
568: -- 100.09.3 If either current appointment authority is UDM
569: -- Then agency must be TR.
570: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/11/01') then
571: if ( p_Cur_Appt_Auth_1= 'UDM' or p_Cur_Appt_Auth_2='UDM' ) and
572: substr(p_Agency_Subelement,1,2) <> 'TR' then
573: hr_utility.set_message(8301, 'GHR_37411_ALL_PROCEDURE_FAIL');
574: hr_utility.raise_error;
578:
579: -- 100.10.3 --100.10.1 Renumbered this edit to 100.10.3
580: -- Dec 01 Patch 12/10/01 vravikan Delete KDM, KFM, KHM
581: --upd49 08-Jan-07 Raju From 01-Sep-2006 Delete JYM
582: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then
583: if (p_Cur_Appt_Auth_1 in ('BPM','H2L','J8M',
584: 'JYM','UFM','V8K','VEM','VPE','ZVB','ZVC')
585: or
586: substr(p_Cur_Appt_Auth_1,1,1) in ('W','X','Y')
620:
621: -- 100.11.2
622: -- Dec 01 Patch 12/10/01 vravikan Delete KDM, KFM, KHM, and TXX
623: --upd47 26-Jun-06 Raju From 01-Apr-2003 Terminate the edit
624: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then
625: if ( p_Cur_Appt_Auth_1 in ('BPM','H2L','J8M','JYM',
626: 'UFM','V8K','VEM','VPE','ZVB','ZVC') or
627: substr(p_Cur_Appt_Auth_1,1,1) in ('W','X','Y') or
628: p_Cur_Appt_Auth_2 in ('BPM','H2L','J8M','JYM',
642: --100.12.1
643: -- Update Date By Effective Date Comment
644: -- 8 04/01/99 vravikan 10/01/98 Add Edit
645: -- 48 26/09/06 amrchakr 01-jul-2006 Changed edit number from 100.12.1 to 100.12.3
646: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then
647: if
648: (
649: p_Cur_Appt_Auth_1 in ('ZRL')
650: or
653: p_agency_subelement <> 'DJ02'
654: and
655: p_agency_subelement is not null
656: then
657: if p_effective_date < fnd_date.canonical_to_date('2006/07/01') then
658: hr_utility.set_message(8301, 'GHR_37055_ALL_PROCEDURE_FAIL');
659: hr_utility.raise_error;
660: else
661: hr_utility.set_message(8301, 'GHR_37691_ALL_PROCEDURE_FAIL');
672: -- Update Date By Effective Date Comment
673: -- 8 04/19/99 vravikan 09/01/1998 Date Correction
674: -- from 1-mar-98 to 1-sep-98
675: -- Adding LAC P2M
676: if p_effective_date < fnd_date.canonical_to_date('1998/09/01') then
677: if p_To_Pay_Plan = 'ES' and
678: p_Cur_Appt_Auth_1 not in ('NRM','NSM','NTM','NVM','NWM','NXM','P2M','P3M','P5M','P7M',
679: 'V2M','VAG','VBJ','VCJ','V4L','V4M','V6M','V4P') and
680: p_Cur_Appt_Auth_1 is not null then
689: --
690: -- 8 04/19/99 vravikan 09/01/1998 Date Correction
691: -- from 1-mar-98 to 1-sep-98
692: -- Adding LAC P2M
693: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
694: if p_To_Pay_Plan = 'ES' and
695: p_Cur_Appt_Auth_1 not in ('NRM','NSM','NTM','NVM','NWM','NXM','P2M','P3M','P5M','P7M',
696: 'V2M','VAG','VBJ','VCJ','V4L','V4M','V6M','V4P') and
697: p_Cur_Appt_Auth_1 is not null then
725: end if;
726: -- 100.16.3
727: -- Dec 01 Patch vravikan Delete YKM
728: --upd49 08-Jan-07 Raju Bug#5619873 From 01-Sep-2006 Delete WTM
729: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then
730: if (p_Cur_Appt_Auth_1 in ('WTM','WUM') or
731: p_Cur_Appt_Auth_2 in ('WTM','WUM')) and
732: p_Handicap <>'04' and
733: to_number(p_Handicap) not between 6 and 94 and
751: --
752: -- 100.17.3 If either current appointment authority is Z2W,
753: -- Then agency must be AF, AR, DD, or NV.
754:
755: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
756: if ( p_Cur_Appt_Auth_1 = 'Z2W' or p_Cur_Appt_Auth_2 = 'Z2W') and
757: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV')
758: then
759: hr_utility.set_message(8301, 'GHR_37893_ALL_PROCEDURE_FAIL');
771: -- 23-Jun-06 Raju From Beginning Added ZTU, Z5B, Z5C, Z5D, Z5E, and Z5H
772: -- 26-sep-2006 amrchakr 01-jul-2003 Changed edit number from 100.19.1 to 100.19.3
773: -- 26-sep-2006 amrchakr 01-jul-2003 Remove Authorities 'JEM','JGM','JJM','JMM','JQM','JVM','J4M' from 100.19.3
774: --------------------------------------------------------------------------------------------
775: if p_effective_date < fnd_date.canonical_to_date('2003/07/01') then
776:
777: if (p_Cur_Appt_Auth_1 in
778: ('ABS','ACM','AYM','A2M','A7M','BBM','BEA','BGL','BKM','BLM','BMA','BMC',
779: 'BNE','BNK','BNW','BRM','BSE','BSS','BSW','BTM','BWA','BWE','HDM',
857: -- Dec 01 Patch 12/10/01 vravikan Delete CTM,MYM,MZM,M1M, and NEL
858: -- 23-Jun-06 Raju From Beginning Added Z5B, Z5C, Z5D, Z5E, and Z5H
859: -- 29-sep-2006 amrchakr 01-jul-2003 end dated the edit from 01-jul-2003
860:
861: IF p_effective_date < fnd_date.canonical_to_date('2003/07/01') THEN
862: if (
863: p_Cur_Appt_Auth_1 in
864: ('ABS','ACM','AYM','A2M','A7M','BBM','BEA','BGL','BKM','BLM','BMA','BMC',
865: 'BNE','BNK','BNW','BRM','BSE','BSS','BSW','BTM','BWA','BWE','HDM',
956: -- Delete YAM, Y4M
957: -- Upd 47 23-Jun-06 Raju From 01-Apr-06 Added condition pay plan is other than Yx
958: -- Bug 5735389 26-dec-2006 amrchakr Removed the condition 'p_Tenure_Goupe_Code <>'1'' from ELSE part.
959:
960: IF p_effective_date < fnd_date.canonical_to_date('2006/04/01') THEN
961: if ( p_Cur_Appt_Auth_1 in ('YBM','YCM','YGM','Y1M','Y2M','Y3M') or
962: p_Cur_Appt_Auth_2 in ('YBM','YCM','YGM','Y1M','Y2M','Y3M')) and
963: p_Tenure_Goupe_Code <>'1' and
964: p_Tenure_Goupe_Code <>'2' and
1050: -- 12/8/00 vravikan From the Start Add UAM
1051: -- If either current appointment authority is Z2U, then agency must be
1052: -- AF, AR, DD or NV.
1053: --
1054: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1055: if (p_Cur_Appt_Auth_1 in ( 'Z2U','UAM') or
1056: p_Cur_Appt_Auth_2 in ('Z2U','UAM') ) and
1057: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV') then
1058: hr_utility.set_message(8301, 'GHR_37876_ALL_PROCEDURE_FAIL');
1266: end if;
1267:
1268: -- 110.07.2
1269: -- end dated this edit on 27-oct-98 for bug 745246
1270: if p_effective_date <= fnd_date.canonical_to_date('1998/07/31') then
1271: if (
1272: (
1273: substr(p_Duty_Station_Lookup_Code,1,1) in ('0','1','2','3','4','5','6','7','8','9')
1274: and
1332: -- 120.03.3
1333: -- 10/4 08/13/99 vravikan 01-Apr-99 New Edit
1334: -- 20/2 20/02/03 Madhuri Commented Edit for Delete - March 2003 Legislative Patch
1335:
1336: /*if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1337: if substr(p_to_play_plan,1,2) in ('TW')
1338: and
1339: substr( p_duty_station_lookup,1,2) not in ( '11','24','51' )
1340: and
1500:
1501: -- 220.02.2
1502: -- Dec 01 Patch vravikan Delete YKM
1503: --upd49 08-Jan-07 Raju Bug#5619873 From 01-Sep-2006 Delete WTM
1504: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then
1505: if ( p_First_Action_NOA_Code1 in ('WTM','WUM') or
1506: p_First_Action_NOA_Code2 in ('WTM','WUM')) and
1507: to_number(p_Handicap) not between 6 and 94 and
1508: p_Handicap <>'04' and