APPS.BEN_EOM_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_eom_shd.g_old_rec.exlcd_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_exlcd_flag
124: <> nvl(ben_eom_shd.g_old_rec.exlcd_flag,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if value of lookup falls within lookup type.
128: --

Line 130: if hr_api.not_exists_in_hr_lookups

126: --
127: -- check if value of lookup falls within lookup type.
128: --
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'YES_NO',
132: p_lookup_code => p_exlcd_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 196: <> nvl(ben_eom_shd.g_old_rec.optd_mdcr_flag,hr_api.g_varchar2)

192: p_object_version_number => p_object_version_number);
193: --
194: if (l_api_updating
195: and p_optd_mdcr_flag
196: <> nvl(ben_eom_shd.g_old_rec.optd_mdcr_flag,hr_api.g_varchar2)
197: or not l_api_updating) then
198: --
199: -- check if value of lookup falls within lookup type.
200: --

Line 202: if hr_api.not_exists_in_hr_lookups

198: --
199: -- check if value of lookup falls within lookup type.
200: --
201: --
202: if hr_api.not_exists_in_hr_lookups
203: (p_lookup_type => 'YES_NO',
204: p_lookup_code => p_optd_mdcr_flag,
205: p_effective_date => p_effective_date) then
206: --

Line 253: (p_eligy_prfl_id in number default hr_api.g_number,

249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Procedure dt_update_validate
253: (p_eligy_prfl_id in number default hr_api.g_number,
254: p_datetrack_mode in varchar2,
255: p_validation_start_date in date,
256: p_validation_end_date in date) Is
257: --

Line 267: hr_api.mandatory_arg_error

263: hr_utility.set_location('Entering:'||l_proc, 5);
264: --
265: -- Ensure that the p_datetrack_mode argument is not null
266: --
267: hr_api.mandatory_arg_error
268: (p_api_name => l_proc,
269: p_argument => 'datetrack_mode',
270: p_argument_value => p_datetrack_mode);
271: --

Line 279: hr_api.mandatory_arg_error

275: --
276: --
277: -- Ensure the arguments are not null
278: --
279: hr_api.mandatory_arg_error
280: (p_api_name => l_proc,
281: p_argument => 'validation_start_date',
282: p_argument_value => p_validation_start_date);
283: --

Line 284: hr_api.mandatory_arg_error

280: (p_api_name => l_proc,
281: p_argument => 'validation_start_date',
282: p_argument_value => p_validation_start_date);
283: --
284: hr_api.mandatory_arg_error
285: (p_api_name => l_proc,
286: p_argument => 'validation_end_date',
287: p_argument_value => p_validation_end_date);
288: --

Line 289: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and

285: (p_api_name => l_proc,
286: p_argument => 'validation_end_date',
287: p_argument_value => p_validation_end_date);
288: --
289: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
290: NOT (dt_api.check_min_max_dates
291: (p_base_table_name => 'ben_eligy_prfl_f',
292: p_base_key_column => 'eligy_prfl_id',
293: p_base_key_value => p_eligy_prfl_id,

Line 371: hr_api.mandatory_arg_error

367: hr_utility.set_location('Entering:'||l_proc, 5);
368: --
369: -- Ensure that the p_datetrack_mode argument is not null
370: --
371: hr_api.mandatory_arg_error
372: (p_api_name => l_proc,
373: p_argument => 'datetrack_mode',
374: p_argument_value => p_datetrack_mode);
375: --

Line 385: hr_api.mandatory_arg_error

381: --
382: --
383: -- Ensure the arguments are not null
384: --
385: hr_api.mandatory_arg_error
386: (p_api_name => l_proc,
387: p_argument => 'validation_start_date',
388: p_argument_value => p_validation_start_date);
389: --

Line 390: hr_api.mandatory_arg_error

386: (p_api_name => l_proc,
387: p_argument => 'validation_start_date',
388: p_argument_value => p_validation_start_date);
389: --
390: hr_api.mandatory_arg_error
391: (p_api_name => l_proc,
392: p_argument => 'validation_end_date',
393: p_argument_value => p_validation_end_date);
394: --

Line 395: hr_api.mandatory_arg_error

391: (p_api_name => l_proc,
392: p_argument => 'validation_end_date',
393: p_argument_value => p_validation_end_date);
394: --
395: hr_api.mandatory_arg_error
396: (p_api_name => l_proc,
397: p_argument => 'elig_optd_mdcr_prte_id',
398: p_argument_value => p_elig_optd_mdcr_prte_id);
399: --

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

439: --
440: -- Call all supporting business operations
441: --
442: --
443: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
444: --
445: chk_elig_optd_mdcr_prte_id
446: (p_elig_optd_mdcr_prte_id => p_rec.elig_optd_mdcr_prte_id,
447: p_effective_date => p_effective_date,

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

479: --
480: -- Call all supporting business operations
481: --
482: --
483: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
484: --
485: chk_elig_optd_mdcr_prte_id
486: (p_elig_optd_mdcr_prte_id => p_rec.elig_optd_mdcr_prte_id,
487: p_effective_date => p_effective_date,

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

563: hr_utility.set_location('Entering:'|| l_proc, 10);
564: --
565: -- Ensure that all the mandatory parameter are not null
566: --
567: hr_api.mandatory_arg_error(p_api_name => l_proc,
568: p_argument => 'elig_optd_mdcr_prte_id',
569: p_argument_value => p_elig_optd_mdcr_prte_id);
570: --
571: open csr_leg_code;