APPS.BEN_ART_BUS dependencies on HR_API

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

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

Line 183: <> nvl(ben_art_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

179: p_object_version_number => p_object_version_number);
180: --
181: if (l_api_updating
182: and p_excld_flag
183: <> nvl(ben_art_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
184: or not l_api_updating) then
185: --
186: -- check if value of lookup falls within lookup type.
187: --

Line 189: if hr_api.not_exists_in_hr_lookups

185: --
186: -- check if value of lookup falls within lookup type.
187: --
188: --
189: if hr_api.not_exists_in_hr_lookups
190: (p_lookup_type => 'YES_NO',
191: p_lookup_code => p_excld_flag,
192: p_effective_date => p_effective_date) then
193: --

Line 312: and age_rt_id <> nvl(p_age_rt_id,hr_api.g_number)

308: select null
309: from ben_age_rt_f
310: where age_fctr_id = p_age_fctr_id
311: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
312: and age_rt_id <> nvl(p_age_rt_id,hr_api.g_number)
313: and business_group_id + 0 = p_business_group_id
314: and p_validation_start_date <= effective_end_date
315: and p_validation_end_date >= effective_start_date;
316: --

Line 327: and p_age_fctr_id <> nvl(ben_art_shd.g_old_rec.age_fctr_id,hr_api.g_number)

323: p_effective_date => p_effective_date,
324: p_object_version_number => p_object_version_number);
325: --
326: if (l_api_updating
327: and p_age_fctr_id <> nvl(ben_art_shd.g_old_rec.age_fctr_id,hr_api.g_number)
328: or not l_api_updating) then
329:
330: open c_dup;
331: fetch c_dup into l_exists;

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

376: --
377: -- {End Of Comments}
378: -- ----------------------------------------------------------------------------
379: Procedure dt_update_validate
380: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
381: p_datetrack_mode in varchar2,
382: p_validation_start_date in date,
383: p_validation_end_date in date) Is
384: --

Line 394: hr_api.mandatory_arg_error

390: hr_utility.set_location('Entering:'||l_proc, 5);
391: --
392: -- Ensure that the p_datetrack_mode argument is not null
393: --
394: hr_api.mandatory_arg_error
395: (p_api_name => l_proc,
396: p_argument => 'datetrack_mode',
397: p_argument_value => p_datetrack_mode);
398: --

Line 406: hr_api.mandatory_arg_error

402: --
403: --
404: -- Ensure the arguments are not null
405: --
406: hr_api.mandatory_arg_error
407: (p_api_name => l_proc,
408: p_argument => 'validation_start_date',
409: p_argument_value => p_validation_start_date);
410: --

Line 411: hr_api.mandatory_arg_error

407: (p_api_name => l_proc,
408: p_argument => 'validation_start_date',
409: p_argument_value => p_validation_start_date);
410: --
411: hr_api.mandatory_arg_error
412: (p_api_name => l_proc,
413: p_argument => 'validation_end_date',
414: p_argument_value => p_validation_end_date);
415: --

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

412: (p_api_name => l_proc,
413: p_argument => 'validation_end_date',
414: p_argument_value => p_validation_end_date);
415: --
416: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
417: NOT (dt_api.check_min_max_dates
418: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
419: p_base_key_column => 'vrbl_rt_prfl_id',
420: p_base_key_value => p_vrbl_rt_prfl_id,

Line 499: hr_api.mandatory_arg_error

495: hr_utility.set_location('Entering:'||l_proc, 5);
496: --
497: -- Ensure that the p_datetrack_mode argument is not null
498: --
499: hr_api.mandatory_arg_error
500: (p_api_name => l_proc,
501: p_argument => 'datetrack_mode',
502: p_argument_value => p_datetrack_mode);
503: --

Line 513: hr_api.mandatory_arg_error

509: --
510: --
511: -- Ensure the arguments are not null
512: --
513: hr_api.mandatory_arg_error
514: (p_api_name => l_proc,
515: p_argument => 'validation_start_date',
516: p_argument_value => p_validation_start_date);
517: --

Line 518: hr_api.mandatory_arg_error

514: (p_api_name => l_proc,
515: p_argument => 'validation_start_date',
516: p_argument_value => p_validation_start_date);
517: --
518: hr_api.mandatory_arg_error
519: (p_api_name => l_proc,
520: p_argument => 'validation_end_date',
521: p_argument_value => p_validation_end_date);
522: --

Line 523: hr_api.mandatory_arg_error

519: (p_api_name => l_proc,
520: p_argument => 'validation_end_date',
521: p_argument_value => p_validation_end_date);
522: --
523: hr_api.mandatory_arg_error
524: (p_api_name => l_proc,
525: p_argument => 'age_rt_id',
526: p_argument_value => p_age_rt_id);
527: --

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

566: --
567: -- Call all supporting business operations
568: --
569: --
570: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
571: --
572: chk_age_rt_id
573: (p_age_rt_id => p_rec.age_rt_id,
574: p_effective_date => p_effective_date,

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

621: --
622: -- Call all supporting business operations
623: --
624: --
625: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
626: --
627: chk_age_rt_id
628: (p_age_rt_id => p_rec.age_rt_id,
629: p_effective_date => p_effective_date,

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

720: hr_utility.set_location('Entering:'|| l_proc, 10);
721: --
722: -- Ensure that all the mandatory parameter are not null
723: --
724: hr_api.mandatory_arg_error(p_api_name => l_proc,
725: p_argument => 'age_rt_id',
726: p_argument_value => p_age_rt_id);
727: --
728: open csr_leg_code;