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.PER_GB_ABSENCE_RULES dependencies on HR_API

Line 41: to_date(to_char(nvl(p_date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||

37: between
38: to_date(to_char(p_date_start,'YYYY-MM-DD')|| ' ' ||
39: nvl(p_time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS')
40: AND
41: to_date(to_char(nvl(p_date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||
42: nvl(p_time_end,'23:59'),'YYYY-MM-DD HH24:MI:SS'))
43: OR
44: (
45: to_date(to_char(p_date_start,'YYYY-MM-DD')|| ' ' ||

Line 51: to_date(to_char(nvl(abs.date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||

47: between
48: to_date(to_char(abs.date_start,'YYYY-MM-DD')|| ' ' ||
49: nvl(abs.time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS')
50: AND
51: to_date(to_char(nvl(abs.date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||
52: nvl(abs.time_end,'23:59'),'YYYY-MM-DD HH24:MI:SS')
53: )
54: );
55:

Line 88: and (abs.date_start between p_date_start AND nvl(p_date_end,hr_api.g_eot)

84: and (p_absence_attendance_id is null or
85: p_absence_attendance_id <> abs.absence_attendance_id)
86: and abs.date_start is not null
87: and p_date_start is not null
88: and (abs.date_start between p_date_start AND nvl(p_date_end,hr_api.g_eot)
89: OR
90: p_date_start between abs.date_start and nvl(abs.date_end,hr_api.g_eot) )
91: order by 1;
92:

Line 90: p_date_start between abs.date_start and nvl(abs.date_end,hr_api.g_eot) )

86: and abs.date_start is not null
87: and p_date_start is not null
88: and (abs.date_start between p_date_start AND nvl(p_date_end,hr_api.g_eot)
89: OR
90: p_date_start between abs.date_start and nvl(abs.date_end,hr_api.g_eot) )
91: order by 1;
92:
93: b_over_lap boolean := false;
94:

Line 103: hr_utility.trace('check_abs_overlap hr_api.g_eot:'||hr_api.g_eot);

99: hr_utility.trace('check_abs_overlap p_date_end:'||p_date_end);
100: hr_utility.trace('check_abs_overlap p_time_start:'||nvl(p_time_start,'NULL'));
101: hr_utility.trace('check_abs_overlap p_time_end:'||nvl(p_time_end,'NULL'));
102: hr_utility.trace('check_abs_overlap p_absence_attendance_id:'||p_absence_attendance_id);
103: hr_utility.trace('check_abs_overlap hr_api.g_eot:'||hr_api.g_eot);
104:
105: for i in c_abs_overlap_another
106: loop
107: hr_utility.trace('check_abs_overlap i.end_time:'||i.end_time);

Line 329: hr_utility.trace(' to date ' || to_date(to_char(nvl(p_date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||nvl(p_time_end,'23:59'),'YYYY-MM-DD HH24:MI:SS'));

325: hr_utility.trace(' p_time_end '|| p_time_end);
326: hr_utility.trace(' p_absence_attendance_id '||p_absence_attendance_id);
327: /* Commented the debugging message with to_date function.
328: hr_utility.trace(' From date '|| to_date(to_char(p_date_start,'YYYY-MM-DD')|| ' ' ||nvl(p_time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS'));
329: hr_utility.trace(' to date ' || to_date(to_char(nvl(p_date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||nvl(p_time_end,'23:59'),'YYYY-MM-DD HH24:MI:SS'));
330: */
331: -- Added for GSI Bug 5472781
332: --
333: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN

Line 357: if trunc(p_date_start) = trunc(hr_api.g_date) and

353: -- logic
354: -- if not updating start or end date then skip
355: -- if not updating start or end date, but date is pass in then skip
356: -- if updating start/end and exists a future absence then error
357: if trunc(p_date_start) = trunc(hr_api.g_date) and
358: trunc(p_date_end) = trunc(hr_api.g_date) then
359: -- not updating sickness start/end date so skip
360: hr_utility.trace('Satisified IF');
361: null;

Line 358: trunc(p_date_end) = trunc(hr_api.g_date) then

354: -- if not updating start or end date then skip
355: -- if not updating start or end date, but date is pass in then skip
356: -- if updating start/end and exists a future absence then error
357: if trunc(p_date_start) = trunc(hr_api.g_date) and
358: trunc(p_date_end) = trunc(hr_api.g_date) then
359: -- not updating sickness start/end date so skip
360: hr_utility.trace('Satisified IF');
361: null;
362: else

Line 398: if trunc(p_date_start) = trunc(hr_api.g_date) then

394: hr_utility.trace(' after fetching abs category '||l_abs_category);
395:
396: IF l_abs_category = 'S' THEN
397: hr_utility.trace(' for sickness S');
398: if trunc(p_date_start) = trunc(hr_api.g_date) then
399: l_param_start := trunc(l_current_start);
400: else
401: l_param_start := trunc(p_date_start);
402: end if;

Line 419: If (p_date_start = hr_api.g_date) then

415: end if;
416: end if;
417:
418: --7287548 begin
419: If (p_date_start = hr_api.g_date) then
420: hr_utility.trace(' p_date_start value is defaulted '||p_date_start||' Repl by'||l_date_start);
421: v_date_start := l_date_start;
422: else
423: v_date_start := p_date_start;

Line 426: If (p_date_end = hr_api.g_date) then

422: else
423: v_date_start := p_date_start;
424: End If;
425:
426: If (p_date_end = hr_api.g_date) then
427: hr_utility.trace(' p_date_end value is defaulted '||p_date_end||' Repl by'||l_date_end);
428: v_date_end := l_date_end;
429: else
430: v_date_end := p_date_end;

Line 433: If (p_time_start = hr_api.g_varchar2) then

429: else
430: v_date_end := p_date_end;
431: End If;
432:
433: If (p_time_start = hr_api.g_varchar2) then
434: hr_utility.trace(' p_time_start value is defaulted '||p_time_start||' Repl by'||l_time_start);
435: v_time_start := l_time_start;
436: else
437: v_time_start := p_time_start;

Line 440: If (p_time_end = hr_api.g_varchar2) then

436: else
437: v_time_start := p_time_start;
438: End If;
439:
440: If (p_time_end = hr_api.g_varchar2) then
441: hr_utility.trace(' p_time_end value is defaulted '||p_time_end||' Repl by'||l_time_end);
442: v_time_end := l_time_end;
443: else
444: v_time_end := p_time_end;