DBA Data[Home] [Help]

APPS.BEN_BVR_BUS dependencies on HR_API

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

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

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

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

Line 250: p_cvg_amt_calc_mthd_id in number default hr_api.g_number,

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

Line 264: hr_api.mandatory_arg_error

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

Line 276: hr_api.mandatory_arg_error

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

Line 281: hr_api.mandatory_arg_error

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

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

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

Line 296: If ((nvl(p_cvg_amt_calc_mthd_id, hr_api.g_number) <> hr_api.g_number) and

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

Line 379: hr_api.mandatory_arg_error

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

Line 393: hr_api.mandatory_arg_error

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

Line 398: hr_api.mandatory_arg_error

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

Line 403: hr_api.mandatory_arg_error

399: (p_api_name => l_proc,
400: p_argument => 'validation_end_date',
401: p_argument_value => p_validation_end_date);
402: --
403: hr_api.mandatory_arg_error
404: (p_api_name => l_proc,
405: p_argument => 'bnft_vrbl_rt_id',
406: p_argument_value => p_bnft_vrbl_rt_id);
407: --

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

446: --
447: -- Call all supporting business operations
448: --
449: --
450: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
451: --
452: chk_bnft_vrbl_rt_id
453: (p_bnft_vrbl_rt_id => p_rec.bnft_vrbl_rt_id,
454: p_effective_date => p_effective_date,

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

487: --
488: -- Call all supporting business operations
489: --
490: --
491: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
492: --
493: chk_bnft_vrbl_rt_id
494: (p_bnft_vrbl_rt_id => p_rec.bnft_vrbl_rt_id,
495: p_effective_date => p_effective_date,

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

573: hr_utility.set_location('Entering:'|| l_proc, 10);
574: --
575: -- Ensure that all the mandatory parameter are not null
576: --
577: hr_api.mandatory_arg_error(p_api_name => l_proc,
578: p_argument => 'bnft_vrbl_rt_id',
579: p_argument_value => p_bnft_vrbl_rt_id);
580: --
581: open csr_leg_code;