APPS.BEN_APV_BUS dependencies on HR_API

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

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

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

244: --
245: -- {End Of Comments}
246: -- ----------------------------------------------------------------------------
247: Procedure dt_update_validate
248: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
249: p_actl_prem_id in number default hr_api.g_number,
250: p_datetrack_mode in varchar2,
251: p_validation_start_date in date,
252: p_validation_end_date in date) Is

Line 249: p_actl_prem_id in number default hr_api.g_number,

245: -- {End Of Comments}
246: -- ----------------------------------------------------------------------------
247: Procedure dt_update_validate
248: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
249: p_actl_prem_id in number default hr_api.g_number,
250: p_datetrack_mode in varchar2,
251: p_validation_start_date in date,
252: p_validation_end_date in date) Is
253: --

Line 263: hr_api.mandatory_arg_error

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

Line 275: hr_api.mandatory_arg_error

271: --
272: --
273: -- Ensure the arguments are not null
274: --
275: hr_api.mandatory_arg_error
276: (p_api_name => l_proc,
277: p_argument => 'validation_start_date',
278: p_argument_value => p_validation_start_date);
279: --

Line 280: hr_api.mandatory_arg_error

276: (p_api_name => l_proc,
277: p_argument => 'validation_start_date',
278: p_argument_value => p_validation_start_date);
279: --
280: hr_api.mandatory_arg_error
281: (p_api_name => l_proc,
282: p_argument => 'validation_end_date',
283: p_argument_value => p_validation_end_date);
284: --

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

281: (p_api_name => l_proc,
282: p_argument => 'validation_end_date',
283: p_argument_value => p_validation_end_date);
284: --
285: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
286: NOT (dt_api.check_min_max_dates
287: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
288: p_base_key_column => 'vrbl_rt_prfl_id',
289: p_base_key_value => p_vrbl_rt_prfl_id,

Line 295: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and

291: p_to_date => p_validation_end_date))) Then
292: l_table_name := 'ben_vrbl_rt_prfl_f';
293: Raise l_integrity_error;
294: End If;
295: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and
296: NOT (dt_api.check_min_max_dates
297: (p_base_table_name => 'ben_actl_prem_f',
298: p_base_key_column => 'actl_prem_id',
299: p_base_key_value => p_actl_prem_id,

Line 377: hr_api.mandatory_arg_error

373: hr_utility.set_location('Entering:'||l_proc, 5);
374: --
375: -- Ensure that the p_datetrack_mode argument is not null
376: --
377: hr_api.mandatory_arg_error
378: (p_api_name => l_proc,
379: p_argument => 'datetrack_mode',
380: p_argument_value => p_datetrack_mode);
381: --

Line 391: hr_api.mandatory_arg_error

387: --
388: --
389: -- Ensure the arguments are not null
390: --
391: hr_api.mandatory_arg_error
392: (p_api_name => l_proc,
393: p_argument => 'validation_start_date',
394: p_argument_value => p_validation_start_date);
395: --

Line 396: hr_api.mandatory_arg_error

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

Line 401: hr_api.mandatory_arg_error

397: (p_api_name => l_proc,
398: p_argument => 'validation_end_date',
399: p_argument_value => p_validation_end_date);
400: --
401: hr_api.mandatory_arg_error
402: (p_api_name => l_proc,
403: p_argument => 'actl_prem_vrbl_rt_id',
404: p_argument_value => p_actl_prem_vrbl_rt_id);
405: --

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

443: --
444: -- Call all supporting business operations
445: --
446: --
447: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
448: --
449: chk_actl_prem_vrbl_rt_id
450: (p_actl_prem_vrbl_rt_id => p_rec.actl_prem_vrbl_rt_id,
451: p_effective_date => p_effective_date,

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

484: --
485: -- Call all supporting business operations
486: --
487: --
488: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
489: --
490: chk_actl_prem_vrbl_rt_id
491: (p_actl_prem_vrbl_rt_id => p_rec.actl_prem_vrbl_rt_id,
492: p_effective_date => p_effective_date,

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

570: hr_utility.set_location('Entering:'|| l_proc, 10);
571: --
572: -- Ensure that all the mandatory parameter are not null
573: --
574: hr_api.mandatory_arg_error(p_api_name => l_proc,
575: p_argument => 'actl_prem_vrbl_rt_id',
576: p_argument_value => p_actl_prem_vrbl_rt_id);
577: --
578: open csr_leg_code;