APPS.BEN_BRG_BUS dependencies on HR_API

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

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

Line 183: <> nvl(ben_brg_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_brg_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 benfts_grp_rt_id <> nvl(p_benfts_grp_rt_id,hr_api.g_number)

308: select null
309: from ben_benfts_grp_rt_f
310: where benfts_grp_id = p_benfts_grp_id
311: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
312: and benfts_grp_rt_id <> nvl(p_benfts_grp_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_benfts_grp_id <> nvl(ben_brg_shd.g_old_rec.benfts_grp_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_benfts_grp_id <> nvl(ben_brg_shd.g_old_rec.benfts_grp_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 381: (p_vrbl_rt_prfl_id in number default hr_api.g_number,

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

Line 395: hr_api.mandatory_arg_error

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

Line 407: hr_api.mandatory_arg_error

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

Line 412: hr_api.mandatory_arg_error

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

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

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

Line 500: hr_api.mandatory_arg_error

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

Line 514: hr_api.mandatory_arg_error

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

Line 519: hr_api.mandatory_arg_error

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

Line 524: hr_api.mandatory_arg_error

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

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

568: --
569: -- Call all supporting business operations
570: --
571: --
572: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
573: --
574: chk_benfts_grp_rt_id
575: (p_benfts_grp_rt_id => p_rec.benfts_grp_rt_id,
576: p_effective_date => p_effective_date,

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

623: --
624: -- Call all supporting business operations
625: --
626: --
627: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
628: --
629: chk_benfts_grp_rt_id
630: (p_benfts_grp_rt_id => p_rec.benfts_grp_rt_id,
631: p_effective_date => p_effective_date,

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

723: hr_utility.set_location('Entering:'|| l_proc, 10);
724: --
725: -- Ensure that all the mandatory parameter are not null
726: --
727: hr_api.mandatory_arg_error(p_api_name => l_proc,
728: p_argument => 'benfts_grp_rt_id',
729: p_argument_value => p_benfts_grp_rt_id);
730: --
731: open csr_leg_code;