DBA Data[Home] [Help]

APPS.BEN_EPP_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_epp_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_epp_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 237: (p_eligy_prfl_id in number default hr_api.g_number,

233: --
234: -- {End Of Comments}
235: -- ----------------------------------------------------------------------------
236: Procedure dt_update_validate
237: (p_eligy_prfl_id in number default hr_api.g_number,
238: p_datetrack_mode in varchar2,
239: p_validation_start_date in date,
240: p_validation_end_date in date) Is
241: --

Line 251: hr_api.mandatory_arg_error

247: hr_utility.set_location('Entering:'||l_proc, 5);
248: --
249: -- Ensure that the p_datetrack_mode argument is not null
250: --
251: hr_api.mandatory_arg_error
252: (p_api_name => l_proc,
253: p_argument => 'datetrack_mode',
254: p_argument_value => p_datetrack_mode);
255: --

Line 263: hr_api.mandatory_arg_error

259: --
260: --
261: -- Ensure the arguments are not null
262: --
263: hr_api.mandatory_arg_error
264: (p_api_name => l_proc,
265: p_argument => 'validation_start_date',
266: p_argument_value => p_validation_start_date);
267: --

Line 268: hr_api.mandatory_arg_error

264: (p_api_name => l_proc,
265: p_argument => 'validation_start_date',
266: p_argument_value => p_validation_start_date);
267: --
268: hr_api.mandatory_arg_error
269: (p_api_name => l_proc,
270: p_argument => 'validation_end_date',
271: p_argument_value => p_validation_end_date);
272: --

Line 273: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and

269: (p_api_name => l_proc,
270: p_argument => 'validation_end_date',
271: p_argument_value => p_validation_end_date);
272: --
273: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
274: NOT (dt_api.check_min_max_dates
275: (p_base_table_name => 'ben_eligy_prfl_f',
276: p_base_key_column => 'eligy_prfl_id',
277: p_base_key_value => p_eligy_prfl_id,

Line 357: hr_api.mandatory_arg_error

353: hr_utility.set_location('Entering:'||l_proc, 5);
354: --
355: -- Ensure that the p_datetrack_mode argument is not null
356: --
357: hr_api.mandatory_arg_error
358: (p_api_name => l_proc,
359: p_argument => 'datetrack_mode',
360: p_argument_value => p_datetrack_mode);
361: --

Line 371: hr_api.mandatory_arg_error

367: --
368: --
369: -- Ensure the arguments are not null
370: --
371: hr_api.mandatory_arg_error
372: (p_api_name => l_proc,
373: p_argument => 'validation_start_date',
374: p_argument_value => p_validation_start_date);
375: --

Line 376: hr_api.mandatory_arg_error

372: (p_api_name => l_proc,
373: p_argument => 'validation_start_date',
374: p_argument_value => p_validation_start_date);
375: --
376: hr_api.mandatory_arg_error
377: (p_api_name => l_proc,
378: p_argument => 'validation_end_date',
379: p_argument_value => p_validation_end_date);
380: --

Line 381: hr_api.mandatory_arg_error

377: (p_api_name => l_proc,
378: p_argument => 'validation_end_date',
379: p_argument_value => p_validation_end_date);
380: --
381: hr_api.mandatory_arg_error
382: (p_api_name => l_proc,
383: p_argument => 'elig_prtt_anthr_pl_prte_id',
384: p_argument_value => p_elig_prtt_anthr_pl_prte_id);
385: --

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

425: --
426: -- Call all supporting business operations
427: --
428: --
429: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
430: --
431: chk_elig_prtt_anthr_pl_prte_id
432: (p_elig_prtt_anthr_pl_prte_id => p_rec.elig_prtt_anthr_pl_prte_id,
433: p_effective_date => p_effective_date,

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

465: --
466: -- Call all supporting business operations
467: --
468: --
469: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
470: --
471: chk_elig_prtt_anthr_pl_prte_id
472: (p_elig_prtt_anthr_pl_prte_id => p_rec.elig_prtt_anthr_pl_prte_id,
473: p_effective_date => p_effective_date,

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

549: hr_utility.set_location('Entering:'|| l_proc, 10);
550: --
551: -- Ensure that all the mandatory parameter are not null
552: --
553: hr_api.mandatory_arg_error(p_api_name => l_proc,
554: p_argument => 'elig_prtt_anthr_pl_prte_id',
555: p_argument_value => p_elig_prtt_anthr_pl_prte_id);
556: --
557: open csr_leg_code;