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_EBN_BUS dependencies on HR_API

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

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

Line 124: and elig_benfts_grp_prte_id <> nvl(p_elig_benfts_grp_prte_id,hr_api.g_number)

120: select null
121: from ben_elig_benfts_grp_prte_f
122: where benfts_grp_id = p_benfts_grp_id
123: and eligy_prfl_id = p_eligy_prfl_id
124: and elig_benfts_grp_prte_id <> nvl(p_elig_benfts_grp_prte_id,hr_api.g_number)
125: and business_group_id + 0 = p_business_group_id
126: and p_validation_start_date <= effective_end_date
127: and p_validation_end_date >= effective_start_date
128: ;

Line 148: and nvl(p_benfts_grp_id,hr_api.g_number)

144: p_effective_date => p_effective_date,
145: p_object_version_number => p_object_version_number);
146: --
147: if (l_api_updating
148: and nvl(p_benfts_grp_id,hr_api.g_number)
149: <> nvl(ben_ebn_shd.g_old_rec.benfts_grp_id,hr_api.g_number)
150: or not l_api_updating) then
151: --
152: -- check if benfts_grp_id value exists in ben_benfts_grp table

Line 149: <> nvl(ben_ebn_shd.g_old_rec.benfts_grp_id,hr_api.g_number)

145: p_object_version_number => p_object_version_number);
146: --
147: if (l_api_updating
148: and nvl(p_benfts_grp_id,hr_api.g_number)
149: <> nvl(ben_ebn_shd.g_old_rec.benfts_grp_id,hr_api.g_number)
150: or not l_api_updating) then
151: --
152: -- check if benfts_grp_id value exists in ben_benfts_grp table
153: --

Line 236: <> nvl(ben_ebn_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

232: p_object_version_number => p_object_version_number);
233: --
234: if (l_api_updating
235: and p_excld_flag
236: <> nvl(ben_ebn_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
237: or not l_api_updating) then
238: --
239: -- check if value of lookup falls within lookup type.
240: --

Line 242: if hr_api.not_exists_in_hr_lookups

238: --
239: -- check if value of lookup falls within lookup type.
240: --
241: --
242: if hr_api.not_exists_in_hr_lookups
243: (p_lookup_type => 'YES_NO',
244: p_lookup_code => p_excld_flag,
245: p_effective_date => p_effective_date) then
246: --

Line 348: (p_eligy_prfl_id in number default hr_api.g_number,

344: --
345: -- {End Of Comments}
346: -- ----------------------------------------------------------------------------
347: Procedure dt_update_validate
348: (p_eligy_prfl_id in number default hr_api.g_number,
349: p_datetrack_mode in varchar2,
350: p_validation_start_date in date,
351: p_validation_end_date in date) Is
352: --

Line 362: hr_api.mandatory_arg_error

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

Line 374: hr_api.mandatory_arg_error

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

Line 379: hr_api.mandatory_arg_error

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

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

380: (p_api_name => l_proc,
381: p_argument => 'validation_end_date',
382: p_argument_value => p_validation_end_date);
383: --
384: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
385: NOT (dt_api.check_min_max_dates
386: (p_base_table_name => 'ben_eligy_prfl_f',
387: p_base_key_column => 'eligy_prfl_id',
388: p_base_key_value => p_eligy_prfl_id,

Line 467: hr_api.mandatory_arg_error

463: hr_utility.set_location('Entering:'||l_proc, 5);
464: --
465: -- Ensure that the p_datetrack_mode argument is not null
466: --
467: hr_api.mandatory_arg_error
468: (p_api_name => l_proc,
469: p_argument => 'datetrack_mode',
470: p_argument_value => p_datetrack_mode);
471: --

Line 481: hr_api.mandatory_arg_error

477: --
478: --
479: -- Ensure the arguments are not null
480: --
481: hr_api.mandatory_arg_error
482: (p_api_name => l_proc,
483: p_argument => 'validation_start_date',
484: p_argument_value => p_validation_start_date);
485: --

Line 486: hr_api.mandatory_arg_error

482: (p_api_name => l_proc,
483: p_argument => 'validation_start_date',
484: p_argument_value => p_validation_start_date);
485: --
486: hr_api.mandatory_arg_error
487: (p_api_name => l_proc,
488: p_argument => 'validation_end_date',
489: p_argument_value => p_validation_end_date);
490: --

Line 491: hr_api.mandatory_arg_error

487: (p_api_name => l_proc,
488: p_argument => 'validation_end_date',
489: p_argument_value => p_validation_end_date);
490: --
491: hr_api.mandatory_arg_error
492: (p_api_name => l_proc,
493: p_argument => 'elig_benfts_grp_prte_id',
494: p_argument_value => p_elig_benfts_grp_prte_id);
495: --

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

534: --
535: -- Call all supporting business operations
536: --
537: --
538: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
539: --
540: chk_elig_benfts_grp_prte_id
541: (p_elig_benfts_grp_prte_id => p_rec.elig_benfts_grp_prte_id,
542: p_effective_date => p_effective_date,

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

584: --
585: -- Call all supporting business operations
586: --
587: --
588: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
589: --
590: chk_elig_benfts_grp_prte_id
591: (p_elig_benfts_grp_prte_id => p_rec.elig_benfts_grp_prte_id,
592: p_effective_date => p_effective_date,

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

677: hr_utility.set_location('Entering:'|| l_proc, 10);
678: --
679: -- Ensure that all the mandatory parameter are not null
680: --
681: hr_api.mandatory_arg_error(p_api_name => l_proc,
682: p_argument => 'elig_benfts_grp_prte_id',
683: p_argument_value => p_elig_benfts_grp_prte_id);
684: --
685: open csr_leg_code;