APPS.BEN_CMR_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_cmr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_excld_flag
124: <> nvl(ben_cmr_shd.g_old_rec.excld_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_excld_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 252: and cmbn_age_los_rt_id <> nvl(p_cmbn_age_los_rt_id,hr_api.g_number)

248: select null
249: from ben_cmbn_age_los_rt_f
250: where cmbn_age_los_fctr_id = p_cmbn_age_los_fctr_id
251: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
252: and cmbn_age_los_rt_id <> nvl(p_cmbn_age_los_rt_id,hr_api.g_number)
253: and business_group_id + 0 = p_business_group_id
254: and p_validation_start_date <= effective_end_date
255: and p_validation_end_date >= effective_start_date;
256: --

Line 267: and p_cmbn_age_los_fctr_id <> nvl(ben_cmr_shd.g_old_rec.cmbn_age_los_fctr_id,hr_api.g_number)

263: p_effective_date => p_effective_date,
264: p_object_version_number => p_object_version_number);
265: --
266: if (l_api_updating
267: and p_cmbn_age_los_fctr_id <> nvl(ben_cmr_shd.g_old_rec.cmbn_age_los_fctr_id,hr_api.g_number)
268: or not l_api_updating) then
269:
270: open c_dup;
271: fetch c_dup into l_exists;

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

383: --
384: -- {End Of Comments}
385: -- ----------------------------------------------------------------------------
386: Procedure dt_update_validate
387: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
388: p_datetrack_mode in varchar2,
389: p_validation_start_date in date,
390: p_validation_end_date in date) Is
391: --

Line 401: hr_api.mandatory_arg_error

397: hr_utility.set_location('Entering:'||l_proc, 5);
398: --
399: -- Ensure that the p_datetrack_mode argument is not null
400: --
401: hr_api.mandatory_arg_error
402: (p_api_name => l_proc,
403: p_argument => 'datetrack_mode',
404: p_argument_value => p_datetrack_mode);
405: --

Line 413: hr_api.mandatory_arg_error

409: --
410: --
411: -- Ensure the arguments are not null
412: --
413: hr_api.mandatory_arg_error
414: (p_api_name => l_proc,
415: p_argument => 'validation_start_date',
416: p_argument_value => p_validation_start_date);
417: --

Line 418: hr_api.mandatory_arg_error

414: (p_api_name => l_proc,
415: p_argument => 'validation_start_date',
416: p_argument_value => p_validation_start_date);
417: --
418: hr_api.mandatory_arg_error
419: (p_api_name => l_proc,
420: p_argument => 'validation_end_date',
421: p_argument_value => p_validation_end_date);
422: --

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

419: (p_api_name => l_proc,
420: p_argument => 'validation_end_date',
421: p_argument_value => p_validation_end_date);
422: --
423: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
424: NOT (dt_api.check_min_max_dates
425: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
426: p_base_key_column => 'vrbl_rt_prfl_id',
427: p_base_key_value => p_vrbl_rt_prfl_id,

Line 506: hr_api.mandatory_arg_error

502: hr_utility.set_location('Entering:'||l_proc, 5);
503: --
504: -- Ensure that the p_datetrack_mode argument is not null
505: --
506: hr_api.mandatory_arg_error
507: (p_api_name => l_proc,
508: p_argument => 'datetrack_mode',
509: p_argument_value => p_datetrack_mode);
510: --

Line 520: hr_api.mandatory_arg_error

516: --
517: --
518: -- Ensure the arguments are not null
519: --
520: hr_api.mandatory_arg_error
521: (p_api_name => l_proc,
522: p_argument => 'validation_start_date',
523: p_argument_value => p_validation_start_date);
524: --

Line 525: hr_api.mandatory_arg_error

521: (p_api_name => l_proc,
522: p_argument => 'validation_start_date',
523: p_argument_value => p_validation_start_date);
524: --
525: hr_api.mandatory_arg_error
526: (p_api_name => l_proc,
527: p_argument => 'validation_end_date',
528: p_argument_value => p_validation_end_date);
529: --

Line 530: hr_api.mandatory_arg_error

526: (p_api_name => l_proc,
527: p_argument => 'validation_end_date',
528: p_argument_value => p_validation_end_date);
529: --
530: hr_api.mandatory_arg_error
531: (p_api_name => l_proc,
532: p_argument => 'cmbn_age_los_rt_id',
533: p_argument_value => p_cmbn_age_los_rt_id);
534: --

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

573: --
574: -- Call all supporting business operations
575: --
576: --
577: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
578: --
579: chk_cmbn_age_los_rt_id
580: (p_cmbn_age_los_rt_id => p_rec.cmbn_age_los_rt_id,
581: p_effective_date => p_effective_date,

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

630: --
631: -- Call all supporting business operations
632: --
633: --
634: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
635: --
636: chk_cmbn_age_los_rt_id
637: (p_cmbn_age_los_rt_id => p_rec.cmbn_age_los_rt_id,
638: p_effective_date => p_effective_date,

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

730: hr_utility.set_location('Entering:'|| l_proc, 10);
731: --
732: -- Ensure that all the mandatory parameter are not null
733: --
734: hr_api.mandatory_arg_error(p_api_name => l_proc,
735: p_argument => 'cmbn_age_los_rt_id',
736: p_argument_value => p_cmbn_age_los_rt_id);
737: --
738: open csr_leg_code;