APPS.BEN_ETD_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_etd_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_etd_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: -- {End Of Comments}
234: -- ----------------------------------------------------------------------------
235: Procedure dt_update_validate
236: (
237: p_eligy_prfl_id in number default hr_api.g_number,
238: p_ptip_id in number default hr_api.g_number,
239: p_datetrack_mode in varchar2,
240: p_validation_start_date in date,
241: p_validation_end_date in date) Is

Line 238: p_ptip_id in number default hr_api.g_number,

234: -- ----------------------------------------------------------------------------
235: Procedure dt_update_validate
236: (
237: p_eligy_prfl_id in number default hr_api.g_number,
238: p_ptip_id in number default hr_api.g_number,
239: p_datetrack_mode in varchar2,
240: p_validation_start_date in date,
241: p_validation_end_date in date) Is
242: --

Line 252: hr_api.mandatory_arg_error

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

Line 264: hr_api.mandatory_arg_error

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

Line 269: hr_api.mandatory_arg_error

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

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

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

Line 284: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and

280: p_to_date => p_validation_end_date))) Then
281: l_table_name := 'ben_eligy_prfl_f';
282: Raise l_integrity_error;
283: End If;
284: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
285: NOT (dt_api.check_min_max_dates
286: (p_base_table_name => 'ben_ptip_f',
287: p_base_key_column => 'ptip_id',
288: p_base_key_value => p_ptip_id,

Line 366: hr_api.mandatory_arg_error

362: hr_utility.set_location('Entering:'||l_proc, 5);
363: --
364: -- Ensure that the p_datetrack_mode argument is not null
365: --
366: hr_api.mandatory_arg_error
367: (p_api_name => l_proc,
368: p_argument => 'datetrack_mode',
369: p_argument_value => p_datetrack_mode);
370: --

Line 380: hr_api.mandatory_arg_error

376: --
377: --
378: -- Ensure the arguments are not null
379: --
380: hr_api.mandatory_arg_error
381: (p_api_name => l_proc,
382: p_argument => 'validation_start_date',
383: p_argument_value => p_validation_start_date);
384: --

Line 385: hr_api.mandatory_arg_error

381: (p_api_name => l_proc,
382: p_argument => 'validation_start_date',
383: p_argument_value => p_validation_start_date);
384: --
385: hr_api.mandatory_arg_error
386: (p_api_name => l_proc,
387: p_argument => 'validation_end_date',
388: p_argument_value => p_validation_end_date);
389: --

Line 390: hr_api.mandatory_arg_error

386: (p_api_name => l_proc,
387: p_argument => 'validation_end_date',
388: p_argument_value => p_validation_end_date);
389: --
390: hr_api.mandatory_arg_error
391: (p_api_name => l_proc,
392: p_argument => 'elig_dpnt_othr_ptip_id',
393: p_argument_value => p_elig_dpnt_othr_ptip_id);
394: --

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

448: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
449: ,p_ordr_num => p_rec.ordr_num
450: ,p_business_group_id => p_rec.business_group_id);
451: --
452: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 10);
455: End insert_validate;
456: --

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

487: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
488: ,p_ordr_num => p_rec.ordr_num
489: ,p_business_group_id => p_rec.business_group_id);
490: --
491: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
492: --
493: -- Call the datetrack update integrity operation
494: --
495: dt_update_validate

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

556: hr_utility.set_location('Entering:'|| l_proc, 10);
557: --
558: -- Ensure that all the mandatory parameter are not null
559: --
560: hr_api.mandatory_arg_error(p_api_name => l_proc,
561: p_argument => 'elig_dpnt_othr_ptip_id',
562: p_argument_value => p_elig_dpnt_othr_ptip_id);
563: --
564: open csr_leg_code;