APPS.BEN_ASR_BUS dependencies on HR_API

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

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

Line 131: and asnt_set_rt_id <> nvl(p_asnt_set_rt_id,hr_api.g_number)

127: select null
128: from ben_asnt_set_rt_f
129: where assignment_set_id = p_assignment_set_id
130: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
131: and asnt_set_rt_id <> nvl(p_asnt_set_rt_id,hr_api.g_number)
132: and business_group_id + 0 = p_business_group_id
133: and p_validation_start_date <= effective_end_date
134: and p_validation_end_date >= effective_start_date;
135: --

Line 146: and p_assignment_set_id <> nvl(ben_asr_shd.g_old_rec.assignment_set_id,hr_api.g_number)

142: p_effective_date => p_effective_date,
143: p_object_version_number => p_object_version_number);
144: --
145: if (l_api_updating
146: and p_assignment_set_id <> nvl(ben_asr_shd.g_old_rec.assignment_set_id,hr_api.g_number)
147: or not l_api_updating) then
148:
149: open c_dup;
150: fetch c_dup into l_exists;

Line 215: <> nvl(ben_asr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

211: p_object_version_number => p_object_version_number);
212: --
213: if (l_api_updating
214: and p_excld_flag
215: <> nvl(ben_asr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
216: or not l_api_updating) then
217: --
218: -- check if value of lookup falls within lookup type.
219: --

Line 221: if hr_api.not_exists_in_hr_lookups

217: --
218: -- check if value of lookup falls within lookup type.
219: --
220: --
221: if hr_api.not_exists_in_hr_lookups
222: (p_lookup_type => 'YES_NO',
223: p_lookup_code => p_excld_flag,
224: p_effective_date => p_effective_date) then
225: --

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

329: --
330: -- {End Of Comments}
331: -- ----------------------------------------------------------------------------
332: Procedure dt_update_validate
333: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
334: p_datetrack_mode in varchar2,
335: p_validation_start_date in date,
336: p_validation_end_date in date) Is
337: --

Line 347: hr_api.mandatory_arg_error

343: hr_utility.set_location('Entering:'||l_proc, 5);
344: --
345: -- Ensure that the p_datetrack_mode argument is not null
346: --
347: hr_api.mandatory_arg_error
348: (p_api_name => l_proc,
349: p_argument => 'datetrack_mode',
350: p_argument_value => p_datetrack_mode);
351: --

Line 359: hr_api.mandatory_arg_error

355: --
356: --
357: -- Ensure the arguments are not null
358: --
359: hr_api.mandatory_arg_error
360: (p_api_name => l_proc,
361: p_argument => 'validation_start_date',
362: p_argument_value => p_validation_start_date);
363: --

Line 364: hr_api.mandatory_arg_error

360: (p_api_name => l_proc,
361: p_argument => 'validation_start_date',
362: p_argument_value => p_validation_start_date);
363: --
364: hr_api.mandatory_arg_error
365: (p_api_name => l_proc,
366: p_argument => 'validation_end_date',
367: p_argument_value => p_validation_end_date);
368: --

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

365: (p_api_name => l_proc,
366: p_argument => 'validation_end_date',
367: p_argument_value => p_validation_end_date);
368: --
369: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
370: NOT (dt_api.check_min_max_dates
371: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
372: p_base_key_column => 'vrbl_rt_prfl_id',
373: p_base_key_value => p_vrbl_rt_prfl_id,

Line 451: hr_api.mandatory_arg_error

447: hr_utility.set_location('Entering:'||l_proc, 5);
448: --
449: -- Ensure that the p_datetrack_mode argument is not null
450: --
451: hr_api.mandatory_arg_error
452: (p_api_name => l_proc,
453: p_argument => 'datetrack_mode',
454: p_argument_value => p_datetrack_mode);
455: --

Line 465: hr_api.mandatory_arg_error

461: --
462: --
463: -- Ensure the arguments are not null
464: --
465: hr_api.mandatory_arg_error
466: (p_api_name => l_proc,
467: p_argument => 'validation_start_date',
468: p_argument_value => p_validation_start_date);
469: --

Line 470: hr_api.mandatory_arg_error

466: (p_api_name => l_proc,
467: p_argument => 'validation_start_date',
468: p_argument_value => p_validation_start_date);
469: --
470: hr_api.mandatory_arg_error
471: (p_api_name => l_proc,
472: p_argument => 'validation_end_date',
473: p_argument_value => p_validation_end_date);
474: --

Line 475: hr_api.mandatory_arg_error

471: (p_api_name => l_proc,
472: p_argument => 'validation_end_date',
473: p_argument_value => p_validation_end_date);
474: --
475: hr_api.mandatory_arg_error
476: (p_api_name => l_proc,
477: p_argument => 'asnt_set_rt_id',
478: p_argument_value => p_asnt_set_rt_id);
479: --

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

518: --
519: -- Call all supporting business operations
520: --
521: --
522: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
523: --
524: chk_asnt_set_rt_id
525: (p_asnt_set_rt_id => p_rec.asnt_set_rt_id,
526: p_effective_date => p_effective_date,

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

569: --
570: -- Call all supporting business operations
571: --
572: --
573: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
574: --
575: chk_asnt_set_rt_id
576: (p_asnt_set_rt_id => p_rec.asnt_set_rt_id,
577: p_effective_date => p_effective_date,

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

664: hr_utility.set_location('Entering:'|| l_proc, 10);
665: --
666: -- Ensure that all the mandatory parameter are not null
667: --
668: hr_api.mandatory_arg_error(p_api_name => l_proc,
669: p_argument => 'asnt_set_rt_id',
670: p_argument_value => p_asnt_set_rt_id);
671: --
672: open csr_leg_code;