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

Line 56: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/25') then

52:
53: --170.04.1
54: -- Update Date By Effective Date Comment
55: -- ? 05/06/99 vravikan 04/25/99 Fegli changes
56: if p_effective_date >= fnd_date.canonical_to_date('19'||'99/04/25') then
57: if p_to_basic_pay = '0'
58: and
59: p_to_pay_plan <> 'VC'
60: and

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

96: --Venkat 03/27/2000 -- Bug # 1246822 -- replacing or with and
97:
98: -- 180.02.1
99: --upd49 08-Jan-07 Raju Bug#5619873 From 01-Sep-2006 Terminate the edit
100: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then
101: if (substr(upper(p_duty_station_lookup_code),1,2) between 'AA' and 'ZZ')
102: and (substr(p_duty_station_lookup_code,1,2)<>'US'
103: and -- Bug # 1246822
104: substr(p_duty_station_lookup_code,2,1)<>'Q' )

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

110: end if;
111: end if;
112: -- 180.04.1
113: --upd49 08-Jan-07 Raju Bug#5619873 From 01-Sep-2006 Terminate the edit
114: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then
115: if (p_to_pay_plan = 'WG' or p_to_pay_plan = 'WL')
116: and
117: p_agency_subelement not in ('AFNG','AFZG','ARNG')
118: and

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

131: end if;
132: end if;
133: -- 180.07.1
134: --upd49 08-Jan-07 Raju Bug#5619873 From 01-Sep-2006 Terminate the edit
135: if p_effective_date < fnd_date.canonical_to_date('2006/09/01') then
136: if p_to_pay_plan = 'GS'
137: and
138: p_agency_subelement not in ('AFNG','AFZG','ARNG')
139: and

Line 184: if p_effective_date < fnd_date.canonical_to_date('2006/10/01') then

180:
181: -- 200.04.1
182: --upd49 08-Jan-07 Raju Bug#5619873 From 01-Oct-2006 change 0470-0493 to 0470-0487
183: -- remove occu code 1540
184: if p_effective_date < fnd_date.canonical_to_date('2006/10/01') then
185:
186: if (p_to_occ_code in
187: ('0020','0101','0110','0140','0150','0170','0180','0184'
188: ,'0185','0190','0193','0401','0403','0457','0460','0601'

Line 248: if p_effective_date < fnd_date.canonical_to_date('2006/10/01') then

244:
245: -- 200.07.1
246: --upd49 08-Jan-07 Raju Bug#5619873 From 01-Oct-2006 change 0470-0493 to 0470-0487
247: -- remove occu code 1540
248: if p_effective_date < fnd_date.canonical_to_date('2006/10/01') then
249: if (p_to_occ_code not in
250: ('0020','0101','0110','0140','0150','0170','0180','0184'
251: ,'0185','0190','0193','0401','0403','0457','0460','0601'
252: ,'0602','0610','0644','0660','0662','0665','0668','0680'

Line 439: if p_effective_date < fnd_date.canonical_to_date('2005/05/01') then

435:
436:
437: -- 610.16.1
438: -- UPD 43(Bug 4567571) Raju 09-Nov-2005 Delete PRD M effective date from 01-May-2005
439: if p_effective_date < fnd_date.canonical_to_date('2005/05/01') then
440: if p_retain_grade is not null and
441: p_pay_rate_determinant_code not in ('A','B','E','F','M','U','V')
442: then
443: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');

Line 447: elsif p_effective_date >= fnd_date.canonical_to_date('2005/05/01') then

443: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');
444: hr_utility.set_message_token('PRD_LIST','A, B, E, F, M, U, or V');
445: hr_utility.raise_error;
446: end if;
447: elsif p_effective_date >= fnd_date.canonical_to_date('2005/05/01') then
448: if p_retain_grade is not null and
449: p_pay_rate_determinant_code not in ('A','B','E','F','U','V')
450: then
451: hr_utility.set_message(8301, 'GHR_37014_ALL_PROCEDURE_FAIL');

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

508: -- 620.02.1
509: -- If Pay rate determinant is A, B, E, F, U, or V,
510: -- Then retained pay plan may not be GH or GM
511: -- 12/8/00 vravikan 01-Oct-2000 New Edit
512: if p_effective_date >= fnd_date.canonical_to_date('2000/10/01') then
513: if p_pay_rate_determinant_code is not null and
514: p_pay_rate_determinant_code in ('A','B','E','F','U','V') and
515: p_retain_pay_plan in ('GH','GM') then
516: hr_utility.set_message(8301, 'GHR_37663_ALL_PROCEDURE_FAIL');

Line 836: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_period), 'yyyy'))

832: hr_utility.raise_error;
833: end if;
834:
835: -- 472.00.3
836: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_period), 'yyyy'))
837: NOT BETWEEN 1900 and 2099 then
838: hr_utility.set_message(8301, 'GHR_37891_ALL_PROCEDURE_FAIL');
839: hr_utility.raise_error;
840: end if;

Line 842: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_per_starts), 'yyyy'))

838: hr_utility.set_message(8301, 'GHR_37891_ALL_PROCEDURE_FAIL');
839: hr_utility.raise_error;
840: end if;
841: --Bug# 4753117 28-Feb-07 Veeramani adding edit for the Appraisal start date
842: if to_number(to_char(fnd_date.canonical_to_date(p_rating_of_record_per_starts), 'yyyy'))
843: NOT BETWEEN 1900 and 2099 then
844: hr_utility.set_message(8301, 'GHR_37891_ALL_PROCEDURE_FAIL');
845: hr_utility.raise_error;
846: end if;