DBA Data[Home] [Help]

APPS.BEN_ADS_BUS dependencies on HR_API

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

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

Line 129: and nvl(p_ded_sched_py_freq_id,hr_api.g_number)

125: p_effective_date => p_effective_date,
126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_ded_sched_py_freq_id,hr_api.g_number)
130: <> nvl(ben_ads_shd.g_old_rec.ded_sched_py_freq_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if ded_sched_py_freq_id value exists in ben_ded_sched_py_freq table

Line 130: <> nvl(ben_ads_shd.g_old_rec.ded_sched_py_freq_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_ded_sched_py_freq_id,hr_api.g_number)
130: <> nvl(ben_ads_shd.g_old_rec.ded_sched_py_freq_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if ded_sched_py_freq_id value exists in ben_ded_sched_py_freq table
134: --

Line 204: <> nvl(ben_ads_shd.g_old_rec.ded_sched_cd,hr_api.g_varchar2)

200: p_object_version_number => p_object_version_number);
201: --
202: if (l_api_updating
203: and p_ded_sched_cd
204: <> nvl(ben_ads_shd.g_old_rec.ded_sched_cd,hr_api.g_varchar2)
205: or not l_api_updating) then
206: --
207: -- check if value of lookup falls within lookup type.
208: --

Line 210: if hr_api.not_exists_in_hr_lookups

206: --
207: -- check if value of lookup falls within lookup type.
208: --
209: --
210: if hr_api.not_exists_in_hr_lookups
211: (p_lookup_type => 'BEN_DED_SCHED',
212: p_lookup_code => p_ded_sched_cd,
213: p_effective_date => p_effective_date) then
214: --

Line 289: and nvl(p_ded_sched_rl,hr_api.g_number)

285: p_effective_date => p_effective_date,
286: p_object_version_number => p_object_version_number);
287: --
288: if (l_api_updating
289: and nvl(p_ded_sched_rl,hr_api.g_number)
290: <> ben_ads_shd.g_old_rec.ded_sched_rl
291: or not l_api_updating)
292: and p_ded_sched_rl is not null then
293: --

Line 415: (p_acty_base_rt_id in number default hr_api.g_number,

411: --
412: -- {End Of Comments}
413: -- ----------------------------------------------------------------------------
414: Procedure dt_update_validate
415: (p_acty_base_rt_id in number default hr_api.g_number,
416: p_datetrack_mode in varchar2,
417: p_validation_start_date in date,
418: p_validation_end_date in date) Is
419: --

Line 429: hr_api.mandatory_arg_error

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

Line 441: hr_api.mandatory_arg_error

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

Line 446: hr_api.mandatory_arg_error

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

Line 451: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and

447: (p_api_name => l_proc,
448: p_argument => 'validation_end_date',
449: p_argument_value => p_validation_end_date);
450: --
451: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
452: NOT (dt_api.check_min_max_dates
453: (p_base_table_name => 'ben_acty_base_rt_f',
454: p_base_key_column => 'acty_base_rt_id',
455: p_base_key_value => p_acty_base_rt_id,

Line 534: hr_api.mandatory_arg_error

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

Line 548: hr_api.mandatory_arg_error

544: --
545: --
546: -- Ensure the arguments are not null
547: --
548: hr_api.mandatory_arg_error
549: (p_api_name => l_proc,
550: p_argument => 'validation_start_date',
551: p_argument_value => p_validation_start_date);
552: --

Line 553: hr_api.mandatory_arg_error

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

Line 558: hr_api.mandatory_arg_error

554: (p_api_name => l_proc,
555: p_argument => 'validation_end_date',
556: p_argument_value => p_validation_end_date);
557: --
558: hr_api.mandatory_arg_error
559: (p_api_name => l_proc,
560: p_argument => 'acty_rt_ded_sched_id',
561: p_argument_value => p_acty_rt_ded_sched_id);
562: --

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

608: --
609: -- Call all supporting business operations
610: --
611: --
612: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
613: --
614: chk_acty_rt_ded_sched_id
615: (p_acty_rt_ded_sched_id => p_rec.acty_rt_ded_sched_id,
616: p_effective_date => p_effective_date,

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

655: --
656: -- Call all supporting business operations
657: --
658: --
659: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
660: --
661: chk_acty_rt_ded_sched_id
662: (p_acty_rt_ded_sched_id => p_rec.acty_rt_ded_sched_id,
663: p_effective_date => p_effective_date,

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

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