DBA Data[Home] [Help]

APPS.BEN_EPG_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_epg_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_epg_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 236: (p_eligy_prfl_id in number default hr_api.g_number,

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

Line 250: hr_api.mandatory_arg_error

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

Line 262: hr_api.mandatory_arg_error

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

Line 267: hr_api.mandatory_arg_error

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

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

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

Line 356: hr_api.mandatory_arg_error

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

Line 370: hr_api.mandatory_arg_error

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

Line 375: hr_api.mandatory_arg_error

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

Line 380: hr_api.mandatory_arg_error

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

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

424: --
425: -- Call all supporting business operations
426: --
427: --
428: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
429: --
430: chk_elig_ppl_grp_prte_id
431: (p_elig_ppl_grp_prte_id => p_rec.elig_ppl_grp_prte_id,
432: p_effective_date => p_effective_date,

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

464: --
465: -- Call all supporting business operations
466: --
467: --
468: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
469: --
470: chk_elig_ppl_grp_prte_id
471: (p_elig_ppl_grp_prte_id => p_rec.elig_ppl_grp_prte_id,
472: p_effective_date => p_effective_date,

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

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