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_CHECK2 dependencies on FND_DATE

Line 123: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN

119: end if;
120:
121: -- 005.15.2
122: -- U58 Raju 01-jan-2010 Bug 9503972
123: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
124: if substr(p_first_noac_lookup_code,1,1)='1' and
125: p_effective_date > TO_DATE('1993/09/30', 'YYYY/MM/DD') and
126: (p_tenure_group_code ='1' or p_tenure_group_code= '2' ) and
127: (p_education_level ='06' or p_education_level='10' ) and

Line 146: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN

142: END IF;
143:
144: -- 005.20.2
145: -- U58 Raju 01-jan-2010 Bug 9503972
146: IF p_effective_date < fnd_date.canonical_to_date('2010/01/01') THEN
147: if substr(p_first_noac_lookup_code,1,1)='1' and
148: p_effective_date > TO_DATE('1993/09/30', 'YYYY/MM/DD') and
149: p_to_pay_plan ='ES' and
150: (p_education_level ='06' or p_education_level='10' ) and

Line 504: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then

500: --
501: -- 100.03.3 If either current appointment authority is ZTA,
502: -- And position occupied is 1,
503: -- Then agency/subelement must be DJ03.
504: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
505: if ( p_Cur_Appt_Auth_1= 'ZTA' or p_Cur_Appt_Auth_2='ZTA' ) and
506: p_Position_Occupied_Code = '1' and
507: p_Agency_Subelement <> 'DJ03' then
508: hr_utility.set_message(8301, 'GHR_37892_ALL_PROCEDURE_FAIL');

Line 557: if p_effective_date >= fnd_date.canonical_to_date('20'||'00/10/01') then

553: -- ============================================
554: -- 19-MAR-2003 vnarasim Added agency/subelement HSBC.
555: -- 30-OCT-2003 Ashley Deleted agency/subelement TD19
556: --
557: if p_effective_date >= fnd_date.canonical_to_date('20'||'00/10/01') then
558: if (p_Cur_Appt_Auth_1 = 'ZVC' OR p_Cur_Appt_Auth_2 = 'ZVC') AND
559: (p_agency_subelement NOT IN ('HSBC'))
560: then
561: hr_utility.set_message(8301, 'GHR_37925_ALL_PROCEDURE_FAIL');

Line 586: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/11/01') then

582: -- 11 01/03/00 vravikan 11/01/99 Add Edit
583:
584: -- 100.09.3 If either current appointment authority is UDM
585: -- Then agency must be TR.
586: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/11/01') then
587: if ( p_Cur_Appt_Auth_1= 'UDM' or p_Cur_Appt_Auth_2='UDM' ) and
588: substr(p_Agency_Subelement,1,2) <> 'TR' then
589: hr_utility.set_message(8301, 'GHR_37411_ALL_PROCEDURE_FAIL');
590: hr_utility.raise_error;

Line 598: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then

594:
595: -- 100.10.3 --100.10.1 Renumbered this edit to 100.10.3
596: -- Dec 01 Patch 12/10/01 vravikan Delete KDM, KFM, KHM
597: --upd49 08-Jan-07 Raju From 01-Sep-2006 Delete JYM
598: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then
599: if (p_Cur_Appt_Auth_1 in ('BPM','H2L','J8M',
600: 'JYM','UFM','V8K','VEM','VPE','ZVB','ZVC')
601: or
602: substr(p_Cur_Appt_Auth_1,1,1) in ('W','X','Y')

Line 640: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then

636:
637: -- 100.11.2
638: -- Dec 01 Patch 12/10/01 vravikan Delete KDM, KFM, KHM, and TXX
639: --upd47 26-Jun-06 Raju From 01-Apr-2003 Terminate the edit
640: if p_effective_date < fnd_date.canonical_to_date('2003/04/01') then
641: if ( p_Cur_Appt_Auth_1 in ('BPM','H2L','J8M','JYM',
642: 'UFM','V8K','VEM','VPE','ZVB','ZVC') or
643: substr(p_Cur_Appt_Auth_1,1,1) in ('W','X','Y') or
644: p_Cur_Appt_Auth_2 in ('BPM','H2L','J8M','JYM',

Line 662: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then

658: --100.12.1
659: -- Update Date By Effective Date Comment
660: -- 8 04/01/99 vravikan 10/01/98 Add Edit
661: -- 48 26/09/06 amrchakr 01-jul-2006 Changed edit number from 100.12.1 to 100.12.3
662: if p_effective_date >= fnd_date.canonical_to_date('1998/10/01') then
663: if
664: (
665: p_Cur_Appt_Auth_1 in ('ZRL')
666: or

Line 673: if p_effective_date < fnd_date.canonical_to_date('2006/07/01') then

669: p_agency_subelement <> 'DJ02'
670: and
671: p_agency_subelement is not null
672: then
673: if p_effective_date < fnd_date.canonical_to_date('2006/07/01') then
674: hr_utility.set_message(8301, 'GHR_37055_ALL_PROCEDURE_FAIL');
675: hr_utility.raise_error;
676: else
677: hr_utility.set_message(8301, 'GHR_37691_ALL_PROCEDURE_FAIL');

Line 692: if p_effective_date < fnd_date.canonical_to_date('1998/09/01') then

688: -- Update Date By Effective Date Comment
689: -- 8 04/19/99 vravikan 09/01/1998 Date Correction
690: -- from 1-mar-98 to 1-sep-98
691: -- Adding LAC P2M
692: if p_effective_date < fnd_date.canonical_to_date('1998/09/01') then
693: if p_To_Pay_Plan = 'ES' and
694: p_Cur_Appt_Auth_1 not in ('NRM','NSM','NTM','NVM','NWM','NXM','P2M','P3M','P5M','P7M',
695: 'V2M','VAG','VBJ','VCJ','V4L','V4M','V6M','V4P') and
696: p_Cur_Appt_Auth_1 is not null then

Line 709: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then

705: --
706: -- 8 04/19/99 vravikan 09/01/1998 Date Correction
707: -- from 1-mar-98 to 1-sep-98
708: -- Adding LAC P2M
709: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
710: if p_To_Pay_Plan = 'ES' and
711: p_Cur_Appt_Auth_1 not in ('NRM','NSM','NTM','NVM','NWM','NXM','P2M','P3M','P5M','P7M',
712: 'V2M','VAG','VBJ','VCJ','V4L','V4M','V6M','V4P') and
713: p_Cur_Appt_Auth_1 is not null then

Line 745: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then

741: end if;
742: -- 100.16.3
743: -- Dec 01 Patch vravikan Delete YKM
744: --upd49 08-Jan-07 Raju Bug#5619873 From 01-Sep-2006 Delete WTM
745: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then
746: if (p_Cur_Appt_Auth_1 in ('WTM','WUM') or
747: p_Cur_Appt_Auth_2 in ('WTM','WUM')) and
748: p_Handicap <>'04' and
749: to_number(p_Handicap) not between 6 and 94 and

Line 756: ELSIF p_effective_date < fnd_date.canonical_to_date('2011/02/01') then

752: hr_utility.set_message_token('APP_AUTH','WTM, WUM');
753: hr_utility.raise_error;
754: end if;
755: --Bug #11726461
756: ELSIF p_effective_date < fnd_date.canonical_to_date('2011/02/01') then
757: if (p_Cur_Appt_Auth_1 in ('WUM') or
758: p_Cur_Appt_Auth_2 in ('WUM')) and
759: p_Handicap <>'04' and
760: to_number(p_Handicap) not between 6 and 94 and

Line 784: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then

780: -- 100.17.3 If either current appointment authority is Z2W,
781: -- Then agency must be AF, AR, DD, or NV.
782: -- U58 Raju 01-Sep-2009 Bug 9503972 added UAM,Z2U,Z6L
783:
784: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
785: if ( p_Cur_Appt_Auth_1 IN ('UAM','Z2U','Z2W','Z6L') or p_Cur_Appt_Auth_2 IN ('UAM','Z2U','Z2W','Z6L')) and
786: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV')
787: then
788: hr_utility.set_message(8301, 'GHR_37893_ALL_PROCEDURE_FAIL');

Line 804: if p_effective_date < fnd_date.canonical_to_date('2003/07/01') then

800: -- 23-Jun-06 Raju From Beginning Added ZTU, Z5B, Z5C, Z5D, Z5E, and Z5H
801: -- 26-sep-2006 amrchakr 01-jul-2003 Changed edit number from 100.19.1 to 100.19.3
802: -- 26-sep-2006 amrchakr 01-jul-2003 Remove Authorities 'JEM','JGM','JJM','JMM','JQM','JVM','J4M' from 100.19.3
803: --------------------------------------------------------------------------------------------
804: if p_effective_date < fnd_date.canonical_to_date('2003/07/01') then
805:
806: if (p_Cur_Appt_Auth_1 in
807: ('ABS','ACM','AYM','A2M','A7M','BBM','BEA','BGL','BKM','BLM','BMA','BMC',
808: 'BNE','BNK','BNW','BRM','BSE','BSS','BSW','BTM','BWA','BWE','HDM',

Line 890: IF p_effective_date < fnd_date.canonical_to_date('2003/07/01') THEN

886: -- Dec 01 Patch 12/10/01 vravikan Delete CTM,MYM,MZM,M1M, and NEL
887: -- 23-Jun-06 Raju From Beginning Added Z5B, Z5C, Z5D, Z5E, and Z5H
888: -- 29-sep-2006 amrchakr 01-jul-2003 end dated the edit from 01-jul-2003
889:
890: IF p_effective_date < fnd_date.canonical_to_date('2003/07/01') THEN
891: if (
892: p_Cur_Appt_Auth_1 in
893: ('ABS','ACM','AYM','A2M','A7M','BBM','BEA','BGL','BKM','BLM','BMA','BMC',
894: 'BNE','BNK','BNW','BRM','BSE','BSS','BSW','BTM','BWA','BWE','HDM',

Line 990: IF p_effective_date < fnd_date.canonical_to_date('2006/04/01') THEN

986: -- Upd 47 23-Jun-06 Raju From 01-Apr-06 Added condition pay plan is other than Yx
987: -- Bug 5735389 26-dec-2006 amrchakr Removed the condition 'p_Tenure_Goupe_Code <>'1'' from ELSE part.
988: --Bug 8653515 29-JUL-2009 Mani From 01-Mar-09 Removed pay plan condition
989:
990: IF p_effective_date < fnd_date.canonical_to_date('2006/04/01') THEN
991: if ( p_Cur_Appt_Auth_1 in ('YBM','YCM','YGM','Y1M','Y2M','Y3M') or
992: p_Cur_Appt_Auth_2 in ('YBM','YCM','YGM','Y1M','Y2M','Y3M')) and
993: p_Tenure_Goupe_Code <>'1' and
994: p_Tenure_Goupe_Code <>'2' and

Line 1001: ELSIF p_effective_date < fnd_date.canonical_to_date('2009/03/01') THEN

997: hr_utility.set_message(8301, 'GHR_37131_ALL_PROCEDURE_FAIL');
998: hr_utility.set_message_token('APP_ATRTY','YBM, YCM, YGM, Y1M, Y2M, or Y3M');
999: hr_utility.raise_error;
1000: end if;
1001: ELSIF p_effective_date < fnd_date.canonical_to_date('2009/03/01') THEN
1002: if ( p_Cur_Appt_Auth_1 in ('YBM','YCM','YGM','Y1M','Y2M','Y3M') or
1003: p_Cur_Appt_Auth_2 in ('YBM','YCM','YGM','Y1M','Y2M','Y3M')) and
1004: substr(p_To_Pay_Plan,1,1)<>'Y' and
1005: p_Tenure_Goupe_Code <>'2' and

Line 1097: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then

1093: -- AF, AR, DD or NV.
1094: --
1095: -- BUG # 8653515 Mani added LAC Z6L from 01-Mar-2009
1096: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
1097: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
1098: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1099: if p_effective_date < fnd_date.canonical_to_date('2009/03/01') then
1100: if (p_Cur_Appt_Auth_1 in ( 'Z2U','UAM') or
1101: p_Cur_Appt_Auth_2 in ('Z2U','UAM') ) and

Line 1098: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then

1094: --
1095: -- BUG # 8653515 Mani added LAC Z6L from 01-Mar-2009
1096: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
1097: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
1098: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1099: if p_effective_date < fnd_date.canonical_to_date('2009/03/01') then
1100: if (p_Cur_Appt_Auth_1 in ( 'Z2U','UAM') or
1101: p_Cur_Appt_Auth_2 in ('Z2U','UAM') ) and
1102: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV') then

Line 1099: if p_effective_date < fnd_date.canonical_to_date('2009/03/01') then

1095: -- BUG # 8653515 Mani added LAC Z6L from 01-Mar-2009
1096: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
1097: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
1098: if p_effective_date >= fnd_date.canonical_to_date('1998/03/01') then
1099: if p_effective_date < fnd_date.canonical_to_date('2009/03/01') then
1100: if (p_Cur_Appt_Auth_1 in ( 'Z2U','UAM') or
1101: p_Cur_Appt_Auth_2 in ('Z2U','UAM') ) and
1102: substr(p_Agency_Subelement,1,2) not in ('AF','AR','DD','NV') then
1103: hr_utility.set_message(8301, 'GHR_37876_ALL_PROCEDURE_FAIL');

Line 1325: if p_effective_date <= fnd_date.canonical_to_date('1998/07/31') then

1321: end if;
1322:
1323: -- 110.07.2
1324: -- end dated this edit on 27-oct-98 for bug 745246
1325: if p_effective_date <= fnd_date.canonical_to_date('1998/07/31') then
1326: if (
1327: (
1328: substr(p_Duty_Station_Lookup_Code,1,1) in ('0','1','2','3','4','5','6','7','8','9')
1329: and

Line 1391: /*if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then

1387: -- 120.03.3
1388: -- 10/4 08/13/99 vravikan 01-Apr-99 New Edit
1389: -- 20/2 20/02/03 Madhuri Commented Edit for Delete - March 2003 Legislative Patch
1390:
1391: /*if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/01') then
1392: if substr(p_to_play_plan,1,2) in ('TW')
1393: and
1394: substr( p_duty_station_lookup,1,2) not in ( '11','24','51' )
1395: and

Line 1408: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then

1404: -- Update Date By Effective Date Comment
1405: -- 9 04/28/99 vravikan Change Edit-May 99 Patch
1406: -- 48 26/09/06 amrchakr 01-jul-2006 Remove condition of agency DJ02
1407: -- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
1408: if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
1409: if p_effective_date < to_date('2006/07/01','yyyy/mm/dd')
1410: then
1411: if substr(p_to_play_plan,1,2) in ('WQ','WR','WU')
1412: and

Line 1542: if p_effective_date >= fnd_date.canonical_to_date('2010/05/01') then

1538: hr_utility.raise_error;
1539: end if;
1540: */
1541: --Begin Bug# 10189715
1542: if p_effective_date >= fnd_date.canonical_to_date('2010/05/01') then
1543: if Months_Between(p_Effective_Date,p_Production_Date)>6 then
1544: hr_utility.set_message(8301, 'GHR_37158_ALL_PROCEDURE_FAIL');
1545: hr_utility.raise_error;
1546: end if;

Line 1568: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then

1564:
1565: -- 220.02.2
1566: -- Dec 01 Patch vravikan Delete YKM
1567: --upd49 08-Jan-07 Raju Bug#5619873 From 01-Sep-2006 Delete WTM
1568: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then
1569: if ( p_First_Action_NOA_Code1 in ('WTM','WUM') or
1570: p_First_Action_NOA_Code2 in ('WTM','WUM')) and
1571: to_number(p_Handicap) not between 6 and 94 and
1572: p_Handicap <>'04' and

Line 1579: elsif p_effective_date < fnd_date.canonical_to_date('2011/02/01') then

1575: hr_utility.set_message_token('APP_AUTH','WTM, WUM');
1576: hr_utility.raise_error;
1577: end if;
1578: --bug 11726461
1579: elsif p_effective_date < fnd_date.canonical_to_date('2011/02/01') then
1580: if ( p_First_Action_NOA_Code1 in ('WUM') or
1581: p_First_Action_NOA_Code2 in ('WUM')) and
1582: to_number(p_Handicap) not between 6 and 94 and
1583: p_Handicap <>'04' and

Line 1650: if nvl(p_scd_retirement,p_scd_leave) >= fnd_date.canonical_to_date('2010/09/26')

1646: ,p_Handicap in varchar2) IS
1647:
1648: begin
1649: -- 220.07.3
1650: if nvl(p_scd_retirement,p_scd_leave) >= fnd_date.canonical_to_date('2010/09/26')
1651: AND p_Handicap IN ('04','16','17','57','81','89')
1652: AND to_number(p_Handicap) between 23 and 25
1653: AND to_number(p_Handicap) between 27 and 29
1654: AND to_number(p_Handicap) between 32 and 38