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

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

35: -- If either legal authority is Z2U, then agency must be AF,AR,DD or NV
36: -- U58 Raju Start Bug 9503972
37: -- U59 Raju Start Bug 9978991 removed LAC BAE
38: --
39: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') then
40: if (p_First_Action_NOA_LA_Code1 in ('Z2U','UAM','Z2W','Z6H','Z6J') or
41: p_First_Action_NOA_LA_Code2 in ('Z2U','UAM','Z2W','Z6H','Z6J') ) and
42: substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
43: hr_utility.set_message(8301, 'GHR_37883_ALL_PROCEDURE_FAIL');

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

50: -- Raju 09-Nov-2005 UPD 43(Bug 4567571) Add Edit
51: --
52: -- If either legal authority is ZPK, then agency must be PC
53: --
54: if p_effective_date > fnd_date.canonical_to_date('1998/03/01') then
55: if (p_First_Action_NOA_LA_Code1 = 'ZPK' or
56: p_First_Action_NOA_LA_Code2 = 'ZPK' ) and
57: substr(p_agency_sub_element,1,2) <> 'PC' then
58: hr_utility.set_message(8301, 'GHR_37885_ALL_PROCEDURE_FAIL');

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

63: -- 250.04.2
64: -- Begin Bug 4567571
65: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
66: -- U59 Raju Start Bug 9978991 Remove the End date
67: --if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
68: if (p_First_Action_NOA_LA_Code1 = 'BAE' or
69: p_First_Action_NOA_LA_Code2 = 'BAE' ) and
70: substr(p_agency_sub_element,1,2) IN('AF','AR','DD','NV') then
71: hr_utility.set_message(8301, 'GHR_38985_ALL_PROCEDURE_FAIL');

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

78: -- 250.05.2 If either legal authority is Z2W,
79: -- Then agency must be AF, AR, DD, or NV.
80: --
81: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
82: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
83: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
84: if (p_First_Action_NOA_LA_Code1 = 'Z2W' or
85: p_First_Action_NOA_LA_Code2 = 'Z2W' ) and
86: substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then

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

79: -- Then agency must be AF, AR, DD, or NV.
80: --
81: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
82: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
83: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
84: if (p_First_Action_NOA_LA_Code1 = 'Z2W' or
85: p_First_Action_NOA_LA_Code2 = 'Z2W' ) and
86: substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
87: hr_utility.set_message(8301, 'GHR_37894_ALL_PROCEDURE_FAIL');

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

94: -- 250.06.2 If either legal authority is ZTA,
95: -- And position occupied is 1,
96: -- Then agency/subelement must be DJ03.
97: --
98: if p_effective_date >= fnd_date.canonical_to_date('1998/09/01') then
99: if (p_First_Action_NOA_LA_Code1 = 'ZTA' or
100: p_First_Action_NOA_LA_Code2 = 'ZTA' ) and
101: p_position_occupied_code = '1' and
102: p_agency_sub_element <> 'DJ03' then

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

113: -- ============================================
114: -- 19-MAR-2003 vnarasim Added agency/subelement HSBC.
115: -- 30-OCT-2003 Ashley Deleted agency/subelement TD19
116: --
117: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
118: if (p_First_Action_NOA_LA_Code1 = 'ZVC' or
119: p_First_Action_NOA_LA_Code2 = 'ZVC' ) and
120: p_agency_sub_element NOT IN ('HSBC') then
121: hr_utility.set_message(8301, 'GHR_37926_ALL_PROCEDURE_FAIL');

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

218:
219: --Begin Bug# 5745356
220: -- 250.17.2
221: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
222: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
223: if p_effective_date >= to_date('2007/01/01','yyyy/mm/dd') then
224: if (p_First_Action_NOA_LA_Code1 = 'Z6H' or p_First_Action_NOA_LA_Code2 = 'Z6H')
225: and substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
226: hr_utility.set_message(8301, 'GHR_37000_ALL_PROCEDURE_FAIL');

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

229: end if;
230: end if;
231: -- 250.18.2
232: -- U58 Raju 31-Dec-2009 Bug 9503972 Terminate the Edit
233: if p_effective_date < fnd_date.canonical_to_date('2009/12/31') then
234: if p_effective_date >= to_date('2007/01/01','yyyy/mm/dd') then
235: if (p_First_Action_NOA_LA_Code1 = 'Z6J' or p_First_Action_NOA_LA_Code2 = 'Z6J')
236: and substr(p_agency_sub_element,1,2) not in ('AF','AR','DD','NV') then
237: hr_utility.set_message(8301, 'GHR_37148_ALL_PROCEDURE_FAIL');

Line 1022: if p_effective_date < fnd_date.canonical_to_date('19'||'99/02/27') then

1018: -- 8/5 03/09/99 vravikan 02/27/99 Delete ACM
1019: --- Upd 56 13-Mar-09 Manish 17-Feb-2009 Added LA code ZEA
1020: --- Upd 57 29-Jul-09 Mani 01-Jan-2009 Added LA code BAG
1021:
1022: if p_effective_date < fnd_date.canonical_to_date('19'||'99/02/27') then
1023: if p_First_NOAC_Lookup_Code= '107'
1024: and
1025: NOT(
1026: p_First_Action_NOA_LA_Code1 in

Line 1040: elsif p_effective_date < fnd_date.canonical_to_date('2009/01/01') then

1036: THEN
1037: hr_utility.set_message(8301, 'GHR_37313_ALL_PROCEDURE_FAIL');
1038: hr_utility.raise_error;
1039: end if;
1040: elsif p_effective_date < fnd_date.canonical_to_date('2009/01/01') then
1041: if p_First_NOAC_Lookup_Code= '107'
1042: and
1043: NOT(
1044: p_First_Action_NOA_LA_Code1 in

Line 1059: elsif p_effective_date < fnd_date.canonical_to_date('2009/02/17') then

1055: hr_utility.set_message(8301, 'GHR_37049_ALL_PROCEDURE_FAIL');
1056: hr_utility.set_message_token('LAC_CODE','ABL, ABM, ABR, ABS, ALM, AQM, BWA BWM, HAM, HDM, HGM, HJM, HLM, NUM, QBK, V1P, V8N, Z2U, ZLM, ZRM, ZSK.');
1057: hr_utility.raise_error;
1058: end if;
1059: elsif p_effective_date < fnd_date.canonical_to_date('2009/02/17') then
1060: if p_First_NOAC_Lookup_Code= '107'
1061: and
1062: NOT(
1063: p_First_Action_NOA_LA_Code1 in

Line 1755: if p_effective_date < fnd_date.canonical_to_date('1998/03/01') then

1751:
1752: --275.01.2
1753: -- added effective date
1754: -- added la code Z2U on 23-jul-98
1755: if p_effective_date < fnd_date.canonical_to_date('1998/03/01') then
1756: if p_First_NOAC_Lookup_Code= '130'
1757: and
1758: NOT ( p_First_Action_NOA_LA_Code1 in
1759: ('ABS','ABT','J8M','KTM','KVM','KXM','SZT',