APPS.BEN_PBR_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_pbr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_excld_flag
124: <> nvl(ben_pbr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if value of lookup falls within lookup type.
128: --

Line 130: if hr_api.not_exists_in_hr_lookups

126: --
127: -- check if value of lookup falls within lookup type.
128: --
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'YES_NO',
132: p_lookup_code => p_excld_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 250: and py_bss_rt_id <> nvl(p_py_bss_rt_id,hr_api.g_number)

246: select null
247: from ben_py_bss_rt_f
248: where pay_basis_id = p_pay_basis_id
249: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
250: and py_bss_rt_id <> nvl(p_py_bss_rt_id,hr_api.g_number)
251: and business_group_id + 0 = p_business_group_id
252: and p_validation_start_date <= effective_end_date
253: and p_validation_end_date >= effective_start_date;
254: --

Line 265: and p_pay_basis_id <> nvl(ben_pbr_shd.g_old_rec.pay_basis_id,hr_api.g_number)

261: p_effective_date => p_effective_date,
262: p_object_version_number => p_object_version_number);
263: --
264: if (l_api_updating
265: and p_pay_basis_id <> nvl(ben_pbr_shd.g_old_rec.pay_basis_id,hr_api.g_number)
266: or not l_api_updating) then
267:
268: open c_dup;
269: fetch c_dup into l_exists;

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

385: --
386: -- {End Of Comments}
387: -- ----------------------------------------------------------------------------
388: Procedure dt_update_validate
389: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
390: p_datetrack_mode in varchar2,
391: p_validation_start_date in date,
392: p_validation_end_date in date) Is
393: --

Line 403: hr_api.mandatory_arg_error

399: hr_utility.set_location('Entering:'||l_proc, 5);
400: --
401: -- Ensure that the p_datetrack_mode argument is not null
402: --
403: hr_api.mandatory_arg_error
404: (p_api_name => l_proc,
405: p_argument => 'datetrack_mode',
406: p_argument_value => p_datetrack_mode);
407: --

Line 415: hr_api.mandatory_arg_error

411: --
412: --
413: -- Ensure the arguments are not null
414: --
415: hr_api.mandatory_arg_error
416: (p_api_name => l_proc,
417: p_argument => 'validation_start_date',
418: p_argument_value => p_validation_start_date);
419: --

Line 420: hr_api.mandatory_arg_error

416: (p_api_name => l_proc,
417: p_argument => 'validation_start_date',
418: p_argument_value => p_validation_start_date);
419: --
420: hr_api.mandatory_arg_error
421: (p_api_name => l_proc,
422: p_argument => 'validation_end_date',
423: p_argument_value => p_validation_end_date);
424: --

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

421: (p_api_name => l_proc,
422: p_argument => 'validation_end_date',
423: p_argument_value => p_validation_end_date);
424: --
425: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
426: NOT (dt_api.check_min_max_dates
427: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
428: p_base_key_column => 'vrbl_rt_prfl_id',
429: p_base_key_value => p_vrbl_rt_prfl_id,

Line 508: hr_api.mandatory_arg_error

504: hr_utility.set_location('Entering:'||l_proc, 5);
505: --
506: -- Ensure that the p_datetrack_mode argument is not null
507: --
508: hr_api.mandatory_arg_error
509: (p_api_name => l_proc,
510: p_argument => 'datetrack_mode',
511: p_argument_value => p_datetrack_mode);
512: --

Line 522: hr_api.mandatory_arg_error

518: --
519: --
520: -- Ensure the arguments are not null
521: --
522: hr_api.mandatory_arg_error
523: (p_api_name => l_proc,
524: p_argument => 'validation_start_date',
525: p_argument_value => p_validation_start_date);
526: --

Line 527: hr_api.mandatory_arg_error

523: (p_api_name => l_proc,
524: p_argument => 'validation_start_date',
525: p_argument_value => p_validation_start_date);
526: --
527: hr_api.mandatory_arg_error
528: (p_api_name => l_proc,
529: p_argument => 'validation_end_date',
530: p_argument_value => p_validation_end_date);
531: --

Line 532: hr_api.mandatory_arg_error

528: (p_api_name => l_proc,
529: p_argument => 'validation_end_date',
530: p_argument_value => p_validation_end_date);
531: --
532: hr_api.mandatory_arg_error
533: (p_api_name => l_proc,
534: p_argument => 'py_bss_rt_id',
535: p_argument_value => p_py_bss_rt_id);
536: --

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

576: --
577: -- Call all supporting business operations
578: --
579: --
580: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
581: --
582: chk_py_bss_rt_id
583: (p_py_bss_rt_id => p_rec.py_bss_rt_id,
584: p_effective_date => p_effective_date,

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

633: --
634: -- Call all supporting business operations
635: --
636: --
637: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
638: --
639: chk_py_bss_rt_id
640: (p_py_bss_rt_id => p_rec.py_bss_rt_id,
641: p_effective_date => p_effective_date,

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

735: hr_utility.set_location('Entering:'|| l_proc, 10);
736: --
737: -- Ensure that all the mandatory parameter are not null
738: --
739: hr_api.mandatory_arg_error(p_api_name => l_proc,
740: p_argument => 'py_bss_rt_id',
741: p_argument_value => p_py_bss_rt_id);
742: --
743: open csr_leg_code;