DBA Data[Home] [Help]

APPS.BEN_AVA_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_ava_shd.g_old_rec.rt_trtmt_cd,hr_api.g_varchar2)

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

Line 130: if hr_api.not_exists_in_hr_lookups

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

Line 209: and nvl(p_formula_id,hr_api.g_number)

205: p_effective_date => p_effective_date,
206: p_object_version_number => p_object_version_number);
207: --
208: if (l_api_updating
209: and nvl(p_formula_id,hr_api.g_number)
210: <> ben_ava_shd.g_old_rec.formula_id
211: or not l_api_updating)
212: and p_formula_id is not null then
213: --

Line 412: (p_actl_prem_id in number default hr_api.g_number,

408: --
409: -- {End Of Comments}
410: -- ----------------------------------------------------------------------------
411: Procedure dt_update_validate
412: (p_actl_prem_id in number default hr_api.g_number,
413: p_datetrack_mode in varchar2,
414: p_validation_start_date in date,
415: p_validation_end_date in date) Is
416: --

Line 426: hr_api.mandatory_arg_error

422: hr_utility.set_location('Entering:'||l_proc, 5);
423: --
424: -- Ensure that the p_datetrack_mode argument is not null
425: --
426: hr_api.mandatory_arg_error
427: (p_api_name => l_proc,
428: p_argument => 'datetrack_mode',
429: p_argument_value => p_datetrack_mode);
430: --

Line 438: hr_api.mandatory_arg_error

434: --
435: --
436: -- Ensure the arguments are not null
437: --
438: hr_api.mandatory_arg_error
439: (p_api_name => l_proc,
440: p_argument => 'validation_start_date',
441: p_argument_value => p_validation_start_date);
442: --

Line 443: hr_api.mandatory_arg_error

439: (p_api_name => l_proc,
440: p_argument => 'validation_start_date',
441: p_argument_value => p_validation_start_date);
442: --
443: hr_api.mandatory_arg_error
444: (p_api_name => l_proc,
445: p_argument => 'validation_end_date',
446: p_argument_value => p_validation_end_date);
447: --

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

444: (p_api_name => l_proc,
445: p_argument => 'validation_end_date',
446: p_argument_value => p_validation_end_date);
447: --
448: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and
449: NOT (dt_api.check_min_max_dates
450: (p_base_table_name => 'ben_actl_prem_f',
451: p_base_key_column => 'actl_prem_id',
452: p_base_key_value => p_actl_prem_id,

Line 530: hr_api.mandatory_arg_error

526: hr_utility.set_location('Entering:'||l_proc, 5);
527: --
528: -- Ensure that the p_datetrack_mode argument is not null
529: --
530: hr_api.mandatory_arg_error
531: (p_api_name => l_proc,
532: p_argument => 'datetrack_mode',
533: p_argument_value => p_datetrack_mode);
534: --

Line 544: hr_api.mandatory_arg_error

540: --
541: --
542: -- Ensure the arguments are not null
543: --
544: hr_api.mandatory_arg_error
545: (p_api_name => l_proc,
546: p_argument => 'validation_start_date',
547: p_argument_value => p_validation_start_date);
548: --

Line 549: hr_api.mandatory_arg_error

545: (p_api_name => l_proc,
546: p_argument => 'validation_start_date',
547: p_argument_value => p_validation_start_date);
548: --
549: hr_api.mandatory_arg_error
550: (p_api_name => l_proc,
551: p_argument => 'validation_end_date',
552: p_argument_value => p_validation_end_date);
553: --

Line 554: hr_api.mandatory_arg_error

550: (p_api_name => l_proc,
551: p_argument => 'validation_end_date',
552: p_argument_value => p_validation_end_date);
553: --
554: hr_api.mandatory_arg_error
555: (p_api_name => l_proc,
556: p_argument => 'actl_prem_vrbl_rt_rl_id',
557: p_argument_value => p_actl_prem_vrbl_rt_rl_id);
558: --

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

596: --
597: -- Call all supporting business operations
598: --
599: --
600: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
601: --
602: chk_actl_prem_vrbl_rt_rl_id
603: (p_actl_prem_vrbl_rt_rl_id => p_rec.actl_prem_vrbl_rt_rl_id,
604: p_effective_date => p_effective_date,

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

650: --
651: -- Call all supporting business operations
652: --
653: --
654: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
655: --
656: chk_actl_prem_vrbl_rt_rl_id
657: (p_actl_prem_vrbl_rt_rl_id => p_rec.actl_prem_vrbl_rt_rl_id,
658: p_effective_date => p_effective_date,

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

748: hr_utility.set_location('Entering:'|| l_proc, 10);
749: --
750: -- Ensure that all the mandatory parameter are not null
751: --
752: hr_api.mandatory_arg_error(p_api_name => l_proc,
753: p_argument => 'actl_prem_vrbl_rt_rl_id',
754: p_argument_value => p_actl_prem_vrbl_rt_rl_id);
755: --
756: open csr_leg_code;