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

Line 147: ,fnd_date.date_to_chardate(p_input_value1)

143: p_input_value7 := l_absence_percentage;
144:
145:
146: /*GET_WEEKEND_PUBLIC_HOLIDAYS(p_assignment_id
147: ,fnd_date.date_to_chardate(p_input_value1)
148: ,fnd_date.date_to_chardate(p_input_value2)
149: ,nvl(l_start_time,l_start_time_char)
150: ,nvl(l_end_time,l_end_time_char)
151: ,l_weekends

Line 148: ,fnd_date.date_to_chardate(p_input_value2)

144:
145:
146: /*GET_WEEKEND_PUBLIC_HOLIDAYS(p_assignment_id
147: ,fnd_date.date_to_chardate(p_input_value1)
148: ,fnd_date.date_to_chardate(p_input_value2)
149: ,nvl(l_start_time,l_start_time_char)
150: ,nvl(l_end_time,l_end_time_char)
151: ,l_weekends
152: ,l_public_holidays

Line 405: /*l_absence_start_date :=fnd_date.date_to_chardate(p_input_value3);

401:
402: --hr_utility.set_location(' Null ',10);
403: --ELSE
404: -- equivalent to p_input_value5 IS NULL and p_input_value6 IS NULL
405: /*l_absence_start_date :=fnd_date.date_to_chardate(p_input_value3);
406: l_absence_end_date := fnd_date.date_to_chardate(p_input_value4);
407:
408: --send starting date,time and ending date,time to get weekends and public holidays
409: GET_WEEKEND_PUBLIC_HOLIDAYS(p_assignment_id

Line 406: l_absence_end_date := fnd_date.date_to_chardate(p_input_value4);

402: --hr_utility.set_location(' Null ',10);
403: --ELSE
404: -- equivalent to p_input_value5 IS NULL and p_input_value6 IS NULL
405: /*l_absence_start_date :=fnd_date.date_to_chardate(p_input_value3);
406: l_absence_end_date := fnd_date.date_to_chardate(p_input_value4);
407:
408: --send starting date,time and ending date,time to get weekends and public holidays
409: GET_WEEKEND_PUBLIC_HOLIDAYS(p_assignment_id
410: ,fnd_date.date_to_chardate(p_input_value3)

Line 410: ,fnd_date.date_to_chardate(p_input_value3)

406: l_absence_end_date := fnd_date.date_to_chardate(p_input_value4);
407:
408: --send starting date,time and ending date,time to get weekends and public holidays
409: GET_WEEKEND_PUBLIC_HOLIDAYS(p_assignment_id
410: ,fnd_date.date_to_chardate(p_input_value3)
411: ,fnd_date.date_to_chardate(p_input_value4)
412: ,nvl(l_start_time,l_start_time_char)
413: ,nvl(l_end_time,l_end_time_char)
414: ,l_weekends

Line 411: ,fnd_date.date_to_chardate(p_input_value4)

407:
408: --send starting date,time and ending date,time to get weekends and public holidays
409: GET_WEEKEND_PUBLIC_HOLIDAYS(p_assignment_id
410: ,fnd_date.date_to_chardate(p_input_value3)
411: ,fnd_date.date_to_chardate(p_input_value4)
412: ,nvl(l_start_time,l_start_time_char)
413: ,nvl(l_end_time,l_end_time_char)
414: ,l_weekends
415: ,l_public_holidays

Line 605: SELECT fnd_date.canonical_to_date(peevf1.SCREEN_ENTRY_VALUE) start_date

601: csr_v_earn_start_date DATE,
602: csr_v_category_code VARCHAR2 ) --,
603: --csr_v_earn_end_date DATE)
604: IS
605: SELECT fnd_date.canonical_to_date(peevf1.SCREEN_ENTRY_VALUE) start_date
606: ,fnd_date.canonical_to_date(peevf2.SCREEN_ENTRY_VALUE) end_date
607: ,fnd_number.canonical_to_number(peevf4.SCREEN_ENTRY_VALUE) Absence_Percentage
608: FROM per_all_assignments_f paaf
609: ,pay_element_types_f et

Line 606: ,fnd_date.canonical_to_date(peevf2.SCREEN_ENTRY_VALUE) end_date

602: csr_v_category_code VARCHAR2 ) --,
603: --csr_v_earn_end_date DATE)
604: IS
605: SELECT fnd_date.canonical_to_date(peevf1.SCREEN_ENTRY_VALUE) start_date
606: ,fnd_date.canonical_to_date(peevf2.SCREEN_ENTRY_VALUE) end_date
607: ,fnd_number.canonical_to_number(peevf4.SCREEN_ENTRY_VALUE) Absence_Percentage
608: FROM per_all_assignments_f paaf
609: ,pay_element_types_f et
610: ,pay_element_entries_f ee

Line 652: ORDER BY fnd_date.canonical_to_date(peevf1.SCREEN_ENTRY_VALUE);

648: AND peevf3.effective_start_date<=csr_v_effective_date
649: AND peevf3.effective_end_date>=csr_v_earn_start_date
650: AND peevf4.effective_start_date<=csr_v_effective_date
651: AND peevf4.effective_end_date>=csr_v_earn_start_date
652: ORDER BY fnd_date.canonical_to_date(peevf1.SCREEN_ENTRY_VALUE);
653:
654: CURSOR csr_end_earn_month(csr_v_assignment_id NUMBER,
655: csr_v_effective_date DATE,
656: csr_v_business_group_id NUMBER)