DBA Data[Home] [Help]

APPS.BEN_APF_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_apf_shd.g_old_rec.pymt_sched_cd,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_pymt_sched_cd
124: <> nvl(ben_apf_shd.g_old_rec.pymt_sched_cd,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 => 'BEN_PYMT_SCHED',
132: p_lookup_code => p_pymt_sched_cd,
133: p_effective_date => p_effective_date) then
134: --

Line 209: and nvl(p_pymt_sched_rl,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_pymt_sched_rl,hr_api.g_number)
210: <> ben_apf_shd.g_old_rec.pymt_sched_rl
211: or not l_api_updating)
212: and p_pymt_sched_rl is not null then
213: --

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

330: --
331: -- {End Of Comments}
332: -- ----------------------------------------------------------------------------
333: Procedure dt_update_validate
334: (p_acty_base_rt_id in number default hr_api.g_number,
335: p_datetrack_mode in varchar2,
336: p_validation_start_date in date,
337: p_validation_end_date in date) Is
338: --

Line 348: hr_api.mandatory_arg_error

344: hr_utility.set_location('Entering:'||l_proc, 5);
345: --
346: -- Ensure that the p_datetrack_mode argument is not null
347: --
348: hr_api.mandatory_arg_error
349: (p_api_name => l_proc,
350: p_argument => 'datetrack_mode',
351: p_argument_value => p_datetrack_mode);
352: --

Line 360: hr_api.mandatory_arg_error

356: --
357: --
358: -- Ensure the arguments are not null
359: --
360: hr_api.mandatory_arg_error
361: (p_api_name => l_proc,
362: p_argument => 'validation_start_date',
363: p_argument_value => p_validation_start_date);
364: --

Line 365: hr_api.mandatory_arg_error

361: (p_api_name => l_proc,
362: p_argument => 'validation_start_date',
363: p_argument_value => p_validation_start_date);
364: --
365: hr_api.mandatory_arg_error
366: (p_api_name => l_proc,
367: p_argument => 'validation_end_date',
368: p_argument_value => p_validation_end_date);
369: --

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

366: (p_api_name => l_proc,
367: p_argument => 'validation_end_date',
368: p_argument_value => p_validation_end_date);
369: --
370: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
371: NOT (dt_api.check_min_max_dates
372: (p_base_table_name => 'ben_acty_base_rt_f',
373: p_base_key_column => 'acty_base_rt_id',
374: p_base_key_value => p_acty_base_rt_id,

Line 455: hr_api.mandatory_arg_error

451: hr_utility.set_location('Entering:'||l_proc, 5);
452: --
453: -- Ensure that the p_datetrack_mode argument is not null
454: --
455: hr_api.mandatory_arg_error
456: (p_api_name => l_proc,
457: p_argument => 'datetrack_mode',
458: p_argument_value => p_datetrack_mode);
459: --

Line 469: hr_api.mandatory_arg_error

465: --
466: --
467: -- Ensure the arguments are not null
468: --
469: hr_api.mandatory_arg_error
470: (p_api_name => l_proc,
471: p_argument => 'validation_start_date',
472: p_argument_value => p_validation_start_date);
473: --

Line 474: hr_api.mandatory_arg_error

470: (p_api_name => l_proc,
471: p_argument => 'validation_start_date',
472: p_argument_value => p_validation_start_date);
473: --
474: hr_api.mandatory_arg_error
475: (p_api_name => l_proc,
476: p_argument => 'validation_end_date',
477: p_argument_value => p_validation_end_date);
478: --

Line 479: hr_api.mandatory_arg_error

475: (p_api_name => l_proc,
476: p_argument => 'validation_end_date',
477: p_argument_value => p_validation_end_date);
478: --
479: hr_api.mandatory_arg_error
480: (p_api_name => l_proc,
481: p_argument => 'acty_rt_pymt_sched_id',
482: p_argument_value => p_acty_rt_pymt_sched_id);
483: --

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

528: --
529: -- Call all supporting business operations
530: --
531: --
532: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
533: --
534: chk_acty_rt_pymt_sched_id
535: (p_acty_rt_pymt_sched_id => p_rec.acty_rt_pymt_sched_id,
536: p_effective_date => p_effective_date,

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

569: --
570: -- Call all supporting business operations
571: --
572: --
573: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
574: --
575: chk_acty_rt_pymt_sched_id
576: (p_acty_rt_pymt_sched_id => p_rec.acty_rt_pymt_sched_id,
577: p_effective_date => p_effective_date,

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

654: hr_utility.set_location('Entering:'|| l_proc, 10);
655: --
656: -- Ensure that all the mandatory parameter are not null
657: --
658: hr_api.mandatory_arg_error(p_api_name => l_proc,
659: p_argument => 'acty_rt_pymt_sched_id',
660: p_argument_value => p_acty_rt_pymt_sched_id);
661: --
662: open csr_leg_code;