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.PAY_DK_ABSENCE_USER dependencies on FND_DATE

Line 116: p_input_value1 := fnd_date.date_to_displaydate(l_start_date); -- date conversion added for 7037491

112: END;
113: -- Check if absence category is S ( Sickness )
114: IF p_absence_category = 'S' THEN
115: p_input_value_name1 := 'Start Date';
116: p_input_value1 := fnd_date.date_to_displaydate(l_start_date); -- date conversion added for 7037491
117: p_input_value_name2 := 'End Date';
118: p_input_value2 := fnd_date.date_to_displaydate(l_end_date); -- date conversion added for 7037491
119: p_input_value_name3 := 'Start Time';
120: p_input_value3 := l_start_time;

Line 118: p_input_value2 := fnd_date.date_to_displaydate(l_end_date); -- date conversion added for 7037491

114: IF p_absence_category = 'S' THEN
115: p_input_value_name1 := 'Start Date';
116: p_input_value1 := fnd_date.date_to_displaydate(l_start_date); -- date conversion added for 7037491
117: p_input_value_name2 := 'End Date';
118: p_input_value2 := fnd_date.date_to_displaydate(l_end_date); -- date conversion added for 7037491
119: p_input_value_name3 := 'Start Time';
120: p_input_value3 := l_start_time;
121: p_input_value_name4 := 'End Time';
122: p_input_value4 := l_end_time;

Line 149: p_input_value1 := fnd_date.date_to_displaydate(l_start_date); -- date conversion added for 7037491

145: /* bug 13843742 start */
146: -- Check if absence category is HCR ( E- Holiday )
147: ELSIF p_absence_category = 'HCR' THEN
148: p_input_value_name1 := 'Start Date';
149: p_input_value1 := fnd_date.date_to_displaydate(l_start_date); -- date conversion added for 7037491
150: p_input_value_name2 := 'End Date';
151: p_input_value2 := fnd_date.date_to_displaydate(l_end_date); -- date conversion added for 7037491
152: p_input_value_name5 := 'Absent Reason';
153: -- Fetch absence reason from the lookup

Line 151: p_input_value2 := fnd_date.date_to_displaydate(l_end_date); -- date conversion added for 7037491

147: ELSIF p_absence_category = 'HCR' THEN
148: p_input_value_name1 := 'Start Date';
149: p_input_value1 := fnd_date.date_to_displaydate(l_start_date); -- date conversion added for 7037491
150: p_input_value_name2 := 'End Date';
151: p_input_value2 := fnd_date.date_to_displaydate(l_end_date); -- date conversion added for 7037491
152: p_input_value_name5 := 'Absent Reason';
153: -- Fetch absence reason from the lookup
154: BEGIN
155: SELECT Meaning

Line 178: p_input_value1 := fnd_date.date_to_displaydate(l_start_date); -- date conversion added for 7037491

174: /* bug 13843742 end */
175: -- Check if absence category is V ( Vacation or Holiday )
176: ELSIF p_absence_category = 'V' THEN
177: p_input_value_name1 := 'Start Date';
178: p_input_value1 := fnd_date.date_to_displaydate(l_start_date); -- date conversion added for 7037491
179: p_input_value_name2 := 'End Date';
180: p_input_value2 := fnd_date.date_to_displaydate(l_end_date); -- date conversion added for 7037491
181: p_input_value_name3 := 'Start Time';
182: p_input_value3 := l_start_time;

Line 180: p_input_value2 := fnd_date.date_to_displaydate(l_end_date); -- date conversion added for 7037491

176: ELSIF p_absence_category = 'V' THEN
177: p_input_value_name1 := 'Start Date';
178: p_input_value1 := fnd_date.date_to_displaydate(l_start_date); -- date conversion added for 7037491
179: p_input_value_name2 := 'End Date';
180: p_input_value2 := fnd_date.date_to_displaydate(l_end_date); -- date conversion added for 7037491
181: p_input_value_name3 := 'Start Time';
182: p_input_value3 := l_start_time;
183: p_input_value_name4 := 'End Time';
184: p_input_value4 := l_end_time;

Line 210: p_input_value1 := fnd_date.date_to_displaydate(l_start_date); -- date conversion added for 7037491

206:
207: -- Check if absence category is M ( Maternity )
208: ELSIF p_absence_category in ('M','PA','IE_AL','IE_PL','PTM') THEN
209: p_input_value_name1 := 'Start Date';
210: p_input_value1 := fnd_date.date_to_displaydate(l_start_date); -- date conversion added for 7037491
211: p_input_value_name2 := 'End Date';
212: p_input_value2 := fnd_date.date_to_displaydate(l_end_date); -- date conversion added for 7037491
213: p_input_value_name3 := 'Start Time';
214: p_input_value3 := l_start_time;

Line 212: p_input_value2 := fnd_date.date_to_displaydate(l_end_date); -- date conversion added for 7037491

208: ELSIF p_absence_category in ('M','PA','IE_AL','IE_PL','PTM') THEN
209: p_input_value_name1 := 'Start Date';
210: p_input_value1 := fnd_date.date_to_displaydate(l_start_date); -- date conversion added for 7037491
211: p_input_value_name2 := 'End Date';
212: p_input_value2 := fnd_date.date_to_displaydate(l_end_date); -- date conversion added for 7037491
213: p_input_value_name3 := 'Start Time';
214: p_input_value3 := l_start_time;
215: p_input_value_name4 := 'End Time';
216: p_input_value4 := l_end_time;

Line 392: fnd_date.canonical_to_date(abs_information4) expected_dob,

388: ,p_holiday_accrual OUT NOCOPY VARCHAR2
389: ,p_payment_during_leave OUT NOCOPY VARCHAR2 /* 11694807 */
390: ) Return varchar2 is
391: CURSOR csr_absence IS SELECT
392: fnd_date.canonical_to_date(abs_information4) expected_dob,
393: fnd_date.canonical_to_date(abs_information5) actual_dob,
394: abs_information8 pre_birth_duration,
395: abs_information9 post_birth_duration,
396: abs_information10 maternity_weeks_transfer,

Line 393: fnd_date.canonical_to_date(abs_information5) actual_dob,

389: ,p_payment_during_leave OUT NOCOPY VARCHAR2 /* 11694807 */
390: ) Return varchar2 is
391: CURSOR csr_absence IS SELECT
392: fnd_date.canonical_to_date(abs_information4) expected_dob,
393: fnd_date.canonical_to_date(abs_information5) actual_dob,
394: abs_information8 pre_birth_duration,
395: abs_information9 post_birth_duration,
396: abs_information10 maternity_weeks_transfer,
397: abs_information6 holiday_accrual,

Line 413: AND fnd_date.canonical_to_date(p_date_earned) BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE;

409: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
410: AND hoi.organization_id = scl.segment1
411: AND org_information_context = 'DK_EMPLOYMENT_DEFAULTS'
412: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
413: AND fnd_date.canonical_to_date(p_date_earned) BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE;
414: l_count VARCHAR2(2):='N';
415: l_duration_freq VARCHAR2(80);
416: Begin
417: hr_utility.trace('****************Inside***************');

Line 623: fnd_date.canonical_to_date(abs_information4) expected_dob,

619: ,p_sex OUT NOCOPY VARCHAR2
620: ,p_holiday_accrual OUT NOCOPY VARCHAR2
621: ) Return NUMBER is
622: CURSOR csr_absence IS SELECT
623: fnd_date.canonical_to_date(abs_information4) expected_dob,
624: fnd_date.canonical_to_date(abs_information5) actual_dob,
625: abs_information8 pre_adopt_duration,
626: abs_information9 post_adopt_duration,
627: abs_information10 adoption_weeks_transfer,

Line 624: fnd_date.canonical_to_date(abs_information5) actual_dob,

620: ,p_holiday_accrual OUT NOCOPY VARCHAR2
621: ) Return NUMBER is
622: CURSOR csr_absence IS SELECT
623: fnd_date.canonical_to_date(abs_information4) expected_dob,
624: fnd_date.canonical_to_date(abs_information5) actual_dob,
625: abs_information8 pre_adopt_duration,
626: abs_information9 post_adopt_duration,
627: abs_information10 adoption_weeks_transfer,
628: abs_information11 weeks_from_mother,

Line 797: fnd_date.canonical_to_date(abs_information4) actual_dob,

793: ,p_parental_type OUT NOCOPY VARCHAR2
794: ,p_holiday_accrual OUT NOCOPY VARCHAR2
795: ) Return varchar2 is
796: CURSOR csr_absence IS SELECT
797: fnd_date.canonical_to_date(abs_information4) actual_dob,
798: abs_information7 duration_override,
799: abs_information10 parental_type,
800: abs_information5 holiday_accrual
801: FROM PER_ABSENCE_ATTENDANCES PAA

Line 1076: fnd_date.canonical_to_date(abs_information4) actual_dob,

1072: ,p_holiday_accrual OUT NOCOPY VARCHAR2
1073: ,p_payment_during_leave OUT NOCOPY VARCHAR2 /* 11694807 */
1074: ) Return varchar2 is
1075: CURSOR csr_absence IS SELECT
1076: fnd_date.canonical_to_date(abs_information4) actual_dob,
1077: fnd_number.canonical_to_number(abs_information7) part_time_hours,
1078: abs_information8 part_time_hrs_freq,
1079: abs_information5 holiday_accrual
1080: ,abs_information6 payment_during_leave -- 11694807