APPS.BEN_LSR_BUS dependencies on HR_API

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

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

Line 183: <> nvl(ben_lsr_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_lsr_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 310: and los_rt_id <> nvl(p_los_rt_id,hr_api.g_number)

306: select null
307: from ben_los_rt_f
308: where los_fctr_id = p_los_fctr_id
309: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
310: and los_rt_id <> nvl(p_los_rt_id,hr_api.g_number)
311: and business_group_id + 0 = p_business_group_id
312: and p_validation_start_date <= effective_end_date
313: and p_validation_end_date >= effective_start_date;
314: --

Line 325: and p_los_fctr_id <> nvl(ben_lsr_shd.g_old_rec.los_fctr_id,hr_api.g_number)

321: p_effective_date => p_effective_date,
322: p_object_version_number => p_object_version_number);
323: --
324: if (l_api_updating
325: and p_los_fctr_id <> nvl(ben_lsr_shd.g_old_rec.los_fctr_id,hr_api.g_number)
326: or not l_api_updating) then
327:
328: open c_dup;
329: fetch c_dup into l_exists;

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

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

Line 393: hr_api.mandatory_arg_error

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

Line 405: hr_api.mandatory_arg_error

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

Line 410: hr_api.mandatory_arg_error

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

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

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

Line 498: hr_api.mandatory_arg_error

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

Line 512: hr_api.mandatory_arg_error

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

Line 517: hr_api.mandatory_arg_error

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

Line 522: hr_api.mandatory_arg_error

518: (p_api_name => l_proc,
519: p_argument => 'validation_end_date',
520: p_argument_value => p_validation_end_date);
521: --
522: hr_api.mandatory_arg_error
523: (p_api_name => l_proc,
524: p_argument => 'los_rt_id',
525: p_argument_value => p_los_rt_id);
526: --

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

566: --
567: -- Call all supporting business operations
568: --
569: --
570: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
571: --
572: chk_los_rt_id
573: (p_los_rt_id => p_rec.los_rt_id,
574: p_effective_date => p_effective_date,

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

622: --
623: -- Call all supporting business operations
624: --
625: --
626: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
627: --
628: chk_los_rt_id
629: (p_los_rt_id => p_rec.los_rt_id,
630: p_effective_date => p_effective_date,

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

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