eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ESP_BUS dependencies on HR_API

Line 55: and nvl(p_elig_sp_clng_prg_prte_id,hr_api.g_number)

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

Line 125: <> nvl(ben_esp_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and p_excld_flag
125: <> nvl(ben_esp_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
126: or not l_api_updating) then
127: --
128: -- check if value of lookup falls within lookup type.
129: --

Line 131: if hr_api.not_exists_in_hr_lookups

127: --
128: -- check if value of lookup falls within lookup type.
129: --
130: --
131: if hr_api.not_exists_in_hr_lookups
132: (p_lookup_type => 'YES_NO',
133: p_lookup_code => p_excld_flag,
134: p_effective_date => p_effective_date) then
135: --

Line 175: <> nvl(ben_esp_shd.g_old_rec.special_ceiling_step_id,hr_api.g_number)

171: p_object_version_number => p_object_version_number);
172:
173: if (l_api_updating
174: and p_special_ceiling_step_id
175: <> nvl(ben_esp_shd.g_old_rec.special_ceiling_step_id,hr_api.g_number)
176: or not l_api_updating) then
177: --
178: -- check if value of lookup falls within lookup type.
179: --

Line 232: p_eligy_prfl_id in number default hr_api.g_number,

228: -- {End Of Comments}
229: -- ----------------------------------------------------------------------------
230: Procedure dt_update_validate
231: (
232: p_eligy_prfl_id in number default hr_api.g_number,
233: p_special_ceiling_step_id in number default hr_api.g_number,
234: p_datetrack_mode in varchar2,
235: p_validation_start_date in date,
236: p_validation_end_date in date) Is

Line 233: p_special_ceiling_step_id in number default hr_api.g_number,

229: -- ----------------------------------------------------------------------------
230: Procedure dt_update_validate
231: (
232: p_eligy_prfl_id in number default hr_api.g_number,
233: p_special_ceiling_step_id in number default hr_api.g_number,
234: p_datetrack_mode in varchar2,
235: p_validation_start_date in date,
236: p_validation_end_date in date) Is
237: --

Line 247: hr_api.mandatory_arg_error

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

Line 259: hr_api.mandatory_arg_error

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

Line 264: hr_api.mandatory_arg_error

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

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

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

Line 279: If ((nvl(p_special_ceiling_step_id, hr_api.g_number) <> hr_api.g_number) and

275: p_to_date => p_validation_end_date))) Then
276: l_table_name := 'ben_eligy_prfl_f';
277: Raise l_integrity_error;
278: End If;
279: If ((nvl(p_special_ceiling_step_id, hr_api.g_number) <> hr_api.g_number) and
280: NOT (dt_api.check_min_max_dates
281: (p_base_table_name => 'per_spinal_point_steps_f',
282: p_base_key_column => 'step_id',
283: p_base_key_value => p_special_ceiling_step_id,

Line 361: hr_api.mandatory_arg_error

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

Line 375: hr_api.mandatory_arg_error

371: --
372: --
373: -- Ensure the arguments are not null
374: --
375: hr_api.mandatory_arg_error
376: (p_api_name => l_proc,
377: p_argument => 'validation_start_date',
378: p_argument_value => p_validation_start_date);
379: --

Line 380: hr_api.mandatory_arg_error

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

Line 385: hr_api.mandatory_arg_error

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

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

443: p_effective_date => p_effective_date,
444: p_object_version_number => p_rec.object_version_number);
445:
446: --
447: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
448: --
449: hr_utility.set_location(' Leaving:'||l_proc, 10);
450: End insert_validate;
451: --

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

482: p_effective_date =>p_effective_date,
483: p_object_version_number =>p_rec.object_version_number);
484:
485:
486: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
487: --
488: -- Call the datetrack update integrity operation
489: --
490: dt_update_validate

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

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