APPS.PER_GB_ABSENCE_RULES dependencies on HR_API

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

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

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

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

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

275: -- logic
276: -- if not updating start or end date then skip
277: -- if not updating start or end date, but date is pass in then skip
278: -- if updating start/end and exists a future absence then error
279: if trunc(p_date_start) = trunc(hr_api.g_date) and
280: trunc(p_date_end) = trunc(hr_api.g_date) then
281: -- not updating sickness start/end date so skip
282: null;
283: else

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

276: -- if not updating start or end date then skip
277: -- if not updating start or end date, but date is pass in then skip
278: -- if updating start/end and exists a future absence then error
279: if trunc(p_date_start) = trunc(hr_api.g_date) and
280: trunc(p_date_end) = trunc(hr_api.g_date) then
281: -- not updating sickness start/end date so skip
282: null;
283: else
284: if trunc(l_current_start) = trunc(p_date_start) and

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

294: CLOSE get_abs_category;
295: --
296: --
297: IF l_abs_category = 'S' THEN
298: if trunc(p_date_start) = trunc(hr_api.g_date) then
299: l_param_start := trunc(l_current_start);
300: else
301: l_param_start := trunc(p_date_start);
302: end if;

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

313: end if;
314: end if;
315:
316: --7287548 begin
317: If (p_date_start = hr_api.g_date) then
318: hr_utility.trace(' p_date_start value is defaulted '||p_date_start||' Repl by'||l_date_start);
319: v_date_start := l_date_start;
320: else
321: v_date_start := p_date_start;

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

320: else
321: v_date_start := p_date_start;
322: End If;
323:
324: If (p_date_end = hr_api.g_date) then
325: hr_utility.trace(' p_date_end value is defaulted '||p_date_end||' Repl by'||l_date_end);
326: v_date_end := l_date_end;
327: else
328: v_date_end := p_date_end;

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

327: else
328: v_date_end := p_date_end;
329: End If;
330:
331: If (p_time_start = hr_api.g_varchar2) then
332: hr_utility.trace(' p_time_start value is defaulted '||p_time_start||' Repl by'||l_time_start);
333: v_time_start := l_time_start;
334: else
335: v_time_start := p_time_start;

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

334: else
335: v_time_start := p_time_start;
336: End If;
337:
338: If (p_time_end = hr_api.g_varchar2) then
339: hr_utility.trace(' p_time_end value is defaulted '||p_time_end||' Repl by'||l_time_end);
340: v_time_end := l_time_end;
341: else
342: v_time_end := p_time_end;