APPS.BEN_EPM_BUS dependencies on HR_API

Line 54: and nvl(p_enrld_anthr_pgm_rt_id,hr_api.g_number)

50: p_enrld_anthr_pgm_rt_id => p_enrld_anthr_pgm_rt_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_enrld_anthr_pgm_rt_id,hr_api.g_number)
55: <> ben_epm_shd.g_old_rec.enrld_anthr_pgm_rt_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 132: and epm.enrld_anthr_pgm_rt_id <> nvl(p_enrld_anthr_pgm_rt_id,hr_api.g_number)

128: select null
129: from ben_enrld_anthr_pgm_rt_f epm
130: where epm.pgm_id = p_pgm_id
131: and epm.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
132: and epm.enrld_anthr_pgm_rt_id <> nvl(p_enrld_anthr_pgm_rt_id,hr_api.g_number)
133:
134: and epm.business_group_id + 0 = p_business_group_id
135: and p_validation_start_date <= epm.effective_end_date
136: and p_validation_end_date >= epm.effective_start_date;

Line 148: and nvl(p_pgm_id,hr_api.g_number)

144: p_effective_date => p_effective_date,
145: p_object_version_number => p_object_version_number);
146: --
147: if (l_api_updating
148: and nvl(p_pgm_id,hr_api.g_number)
149: <> nvl(ben_epm_shd.g_old_rec.pgm_id,hr_api.g_number)
150: or not l_api_updating) then
151: --
152: -- check if pgm_id value exists in the program table

Line 149: <> nvl(ben_epm_shd.g_old_rec.pgm_id,hr_api.g_number)

145: p_object_version_number => p_object_version_number);
146: --
147: if (l_api_updating
148: and nvl(p_pgm_id,hr_api.g_number)
149: <> nvl(ben_epm_shd.g_old_rec.pgm_id,hr_api.g_number)
150: or not l_api_updating) then
151: --
152: -- check if pgm_id value exists in the program table
153: open c1;

Line 236: <> nvl(ben_epm_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)

232: p_object_version_number => p_object_version_number);
233: --
234: if (l_api_updating
235: and p_enrl_det_dt_cd
236: <> nvl(ben_epm_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)
237: or not l_api_updating)
238: and p_enrl_det_dt_cd is not null then
239: --
240: -- check if value of lookup falls within lookup type.

Line 242: if hr_api.not_exists_in_hr_lookups

238: and p_enrl_det_dt_cd is not null then
239: --
240: -- check if value of lookup falls within lookup type.
241: --
242: if hr_api.not_exists_in_hr_lookups
243: (p_lookup_type => 'BEN_ENRL_DET_DT',
244: p_lookup_code => p_enrl_det_dt_cd,
245: p_effective_date => p_effective_date) then
246: --

Line 307: <> nvl(ben_epm_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

303: p_object_version_number => p_object_version_number);
304: --
305: if (l_api_updating
306: and p_excld_flag
307: <> nvl(ben_epm_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
308: or not l_api_updating) then
309: --
310: -- check if value of lookup falls within lookup type.
311: --

Line 313: if hr_api.not_exists_in_hr_lookups

309: --
310: -- check if value of lookup falls within lookup type.
311: --
312: --
313: if hr_api.not_exists_in_hr_lookups
314: (p_lookup_type => 'YES_NO',
315: p_lookup_code => p_excld_flag,
316: p_effective_date => p_effective_date) then
317: --

Line 431: (p_vrbl_rt_prfl_id in number default hr_api.g_number,

427: --
428: -- {End Of Comments}
429: -- ----------------------------------------------------------------------------
430: Procedure dt_update_validate
431: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
432: p_pgm_id in number default hr_api.g_number,
433: p_datetrack_mode in varchar2,
434: p_validation_start_date in date,
435: p_validation_end_date in date) Is

Line 432: p_pgm_id in number default hr_api.g_number,

428: -- {End Of Comments}
429: -- ----------------------------------------------------------------------------
430: Procedure dt_update_validate
431: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
432: p_pgm_id in number default hr_api.g_number,
433: p_datetrack_mode in varchar2,
434: p_validation_start_date in date,
435: p_validation_end_date in date) Is
436: --

Line 446: hr_api.mandatory_arg_error

442: hr_utility.set_location('Entering:'||l_proc, 5);
443: --
444: -- Ensure that the p_datetrack_mode argument is not null
445: --
446: hr_api.mandatory_arg_error
447: (p_api_name => l_proc,
448: p_argument => 'datetrack_mode',
449: p_argument_value => p_datetrack_mode);
450: --

Line 458: hr_api.mandatory_arg_error

454: --
455: --
456: -- Ensure the arguments are not null
457: --
458: hr_api.mandatory_arg_error
459: (p_api_name => l_proc,
460: p_argument => 'validation_start_date',
461: p_argument_value => p_validation_start_date);
462: --

Line 463: hr_api.mandatory_arg_error

459: (p_api_name => l_proc,
460: p_argument => 'validation_start_date',
461: p_argument_value => p_validation_start_date);
462: --
463: hr_api.mandatory_arg_error
464: (p_api_name => l_proc,
465: p_argument => 'validation_end_date',
466: p_argument_value => p_validation_end_date);
467: --

Line 468: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

464: (p_api_name => l_proc,
465: p_argument => 'validation_end_date',
466: p_argument_value => p_validation_end_date);
467: --
468: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
469: NOT (dt_api.check_min_max_dates
470: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
471: p_base_key_column => 'vrbl_rt_prfl_id',
472: p_base_key_value => p_vrbl_rt_prfl_id,

Line 478: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and

474: p_to_date => p_validation_end_date))) Then
475: l_table_name := 'ben_vrbl_rt_prfl_f';
476: Raise l_integrity_error;
477: End If;
478: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
479: NOT (dt_api.check_min_max_dates
480: (p_base_table_name => 'ben_pgm_f',
481: p_base_key_column => 'pgm_id',
482: p_base_key_value => p_pgm_id,

Line 560: hr_api.mandatory_arg_error

556: hr_utility.set_location('Entering:'||l_proc, 5);
557: --
558: -- Ensure that the p_datetrack_mode argument is not null
559: --
560: hr_api.mandatory_arg_error
561: (p_api_name => l_proc,
562: p_argument => 'datetrack_mode',
563: p_argument_value => p_datetrack_mode);
564: --

Line 574: hr_api.mandatory_arg_error

570: --
571: --
572: -- Ensure the arguments are not null
573: --
574: hr_api.mandatory_arg_error
575: (p_api_name => l_proc,
576: p_argument => 'validation_start_date',
577: p_argument_value => p_validation_start_date);
578: --

Line 579: hr_api.mandatory_arg_error

575: (p_api_name => l_proc,
576: p_argument => 'validation_start_date',
577: p_argument_value => p_validation_start_date);
578: --
579: hr_api.mandatory_arg_error
580: (p_api_name => l_proc,
581: p_argument => 'validation_end_date',
582: p_argument_value => p_validation_end_date);
583: --

Line 584: hr_api.mandatory_arg_error

580: (p_api_name => l_proc,
581: p_argument => 'validation_end_date',
582: p_argument_value => p_validation_end_date);
583: --
584: hr_api.mandatory_arg_error
585: (p_api_name => l_proc,
586: p_argument => 'enrld_anthr_pgm_rt_id',
587: p_argument_value => p_enrld_anthr_pgm_rt_id);
588: --

Line 632: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

628: --
629: -- Call all supporting business operations
630: --
631: --
632: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
633: --
634: chk_enrld_anthr_pgm_rt_id
635: (p_enrld_anthr_pgm_rt_id => p_rec.enrld_anthr_pgm_rt_id,
636: p_effective_date => p_effective_date,

Line 692: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

688: --
689: -- Call all supporting business operations
690: --
691: --
692: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
693: --
694: chk_enrld_anthr_pgm_rt_id
695: (p_enrld_anthr_pgm_rt_id => p_rec.enrld_anthr_pgm_rt_id,
696: p_effective_date => p_effective_date,

Line 797: hr_api.mandatory_arg_error(p_api_name => l_proc,

793: hr_utility.set_location('Entering:'|| l_proc, 10);
794: --
795: -- Ensure that all the mandatory parameter are not null
796: --
797: hr_api.mandatory_arg_error(p_api_name => l_proc,
798: p_argument => 'enrld_anthr_pgm_rt_id',
799: p_argument_value => p_enrld_anthr_pgm_rt_id);
800: --
801: open csr_leg_code;