DBA Data[Home] [Help]

APPS.OTA_GENERAL dependencies on HR_API

Line 220: hr_api.mandatory_arg_error ( g_package,

216: --
217: procedure check_parameters is
218: --
219: begin
220: hr_api.mandatory_arg_error ( g_package,
221: 'p_domain_type',
222: p_domain_type);
223: end check_parameters;
224: --

Line 299: If nvl( p_child_start, hr_api.g_sot) < p_par_start Then

295: If p_par_start is not null Then
296: --
297: -- Child startdate is earlier than parent startdate
298: --
299: If nvl( p_child_start, hr_api.g_sot) < p_par_start Then
300: --
301: -- ** TEMP ** Add error message with the following text.
302: fnd_message.set_name('OTA', 'OTA_13314_GEN_CS_PS');
303: fnd_message.raise_error;

Line 309: If nvl( p_child_end, hr_api.g_eot) < p_par_start Then

305: End if;
306: --
307: -- Child enddate is earlier than parent startdate
308: --
309: If nvl( p_child_end, hr_api.g_eot) < p_par_start Then
310: --
311: -- ** TEMP ** Add error message with the following text.
312: fnd_message.set_name('OTA', 'OTA_13314_GEN_CS_PS');
313: fnd_message.raise_error;

Line 325: If nvl( p_child_start, hr_api.g_sot) > p_par_end Then

321: If p_par_end is not null Then
322: --
323: -- Child startdate is later than parent enddate
324: --
325: If nvl( p_child_start, hr_api.g_sot) > p_par_end Then
326: --
327: -- ** TEMP ** Add error message with the following text.
328: fnd_message.set_name('OTA', 'OTA_13314_GEN_CS_PS');
329: fnd_message.raise_error;

Line 335: If nvl( p_child_end, hr_api.g_eot) > p_par_end Then

331: End if;
332: --
333: -- Child enddate is later than parent enddate
334: --
335: If nvl( p_child_end, hr_api.g_eot) > p_par_end Then
336: --
337: -- ** TEMP ** Add error message with the following text.
338: fnd_message.set_name('OTA', 'OTA_13314_GEN_CS_PS');
339: fnd_message.raise_error;

Line 374: If nvl( p_child_start, hr_api.g_sot) < p_par_start Then

370: If p_par_start is not null Then
371: --
372: -- Child startdate is earlier than parent startdate
373: --
374: If nvl( p_child_start, hr_api.g_sot) < p_par_start Then
375: --
376: return TRUE;
377: --
378: End if;

Line 382: If nvl( p_child_end, hr_api.g_eot) < p_par_start Then

378: End if;
379: --
380: -- Child enddate is earlier than parent startdate
381: --
382: If nvl( p_child_end, hr_api.g_eot) < p_par_start Then
383: --
384: return TRUE;
385: --
386: End if;

Line 396: If nvl( p_child_start, hr_api.g_sot) > p_par_end Then

392: If p_par_end is not null Then
393: --
394: -- Child startdate is later than parent enddate
395: --
396: If nvl( p_child_start, hr_api.g_sot) > p_par_end Then
397: --
398: return TRUE;
399: --
400: End if;

Line 404: If nvl( p_child_end, hr_api.g_eot) > p_par_end Then

400: End if;
401: --
402: -- Child enddate is later than parent enddate
403: --
404: If nvl( p_child_end, hr_api.g_eot) > p_par_end Then
405: --
406: return TRUE;
407: --
408: End if;

Line 565: if l_date = hr_api.g_date or l_date is null or l_date = hr_api.g_sot then

561: -- **** start added for bug #2154926
562: --
563: l_date := p_date;
564: --
565: if l_date = hr_api.g_date or l_date is null or l_date = hr_api.g_sot then
566: -- l_date := get_session_date(USERENV('SESSIONID'));
567: -- changed for bug 3242405.
568: l_date := trunc(sysdate);
569: end if;

Line 597: return nvl(p_old_value,hr_api.g_varchar2) <>

593: --
594: --
595: Begin
596: --
597: return nvl(p_old_value,hr_api.g_varchar2) <>
598: nvl(p_new_value,hr_api.g_varchar2);
599: --
600: End value_changed;
601: --

Line 598: nvl(p_new_value,hr_api.g_varchar2);

594: --
595: Begin
596: --
597: return nvl(p_old_value,hr_api.g_varchar2) <>
598: nvl(p_new_value,hr_api.g_varchar2);
599: --
600: End value_changed;
601: --
602: -- ----------------------------------------------------------------------------

Line 617: return nvl(p_old_value,hr_api.g_number) <>

613: --
614: --
615: Begin
616: --
617: return nvl(p_old_value,hr_api.g_number) <>
618: nvl(p_new_value,hr_api.g_number);
619: --
620: End value_changed;
621: --

Line 618: nvl(p_new_value,hr_api.g_number);

614: --
615: Begin
616: --
617: return nvl(p_old_value,hr_api.g_number) <>
618: nvl(p_new_value,hr_api.g_number);
619: --
620: End value_changed;
621: --
622: -- ----------------------------------------------------------------------------

Line 637: return nvl(p_old_value,hr_api.g_date) <>

633: --
634: --
635: Begin
636: --
637: return nvl(p_old_value,hr_api.g_date) <>
638: nvl(p_new_value,hr_api.g_date);
639: --
640: End value_changed;
641: --

Line 638: nvl(p_new_value,hr_api.g_date);

634: --
635: Begin
636: --
637: return nvl(p_old_value,hr_api.g_date) <>
638: nvl(p_new_value,hr_api.g_date);
639: --
640: End value_changed;
641: --
642: -- ----------------------------------------------------------------------------