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

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

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

Line 131: and elig_asnt_set_prte_id <> nvl(p_elig_asnt_set_prte_id,hr_api.g_number)

127: select null
128: from ben_elig_asnt_set_prte_f
129: where assignment_set_id = p_assignment_set_id
130: and eligy_prfl_id = p_eligy_prfl_id
131: and elig_asnt_set_prte_id <> nvl(p_elig_asnt_set_prte_id,hr_api.g_number)
132: and business_group_id + 0 = p_business_group_id
133: and p_validation_start_date <= effective_end_date
134: and p_validation_end_date >= effective_start_date
135: ;

Line 148: and nvl(p_assignment_set_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_assignment_set_id,hr_api.g_number)
149: <> nvl(ben_ean_shd.g_old_rec.assignment_set_id,hr_api.g_number)
150: or not l_api_updating) then
151: --
152: -- check if assignment_set_id value exists in hr_assignment_sets table

Line 149: <> nvl(ben_ean_shd.g_old_rec.assignment_set_id,hr_api.g_number)

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

Line 235: <> nvl(ben_ean_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 241: if hr_api.not_exists_in_hr_lookups

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

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

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

Line 364: hr_api.mandatory_arg_error

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

Line 376: hr_api.mandatory_arg_error

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

Line 381: hr_api.mandatory_arg_error

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

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

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

Line 469: hr_api.mandatory_arg_error

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

Line 483: hr_api.mandatory_arg_error

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

Line 488: hr_api.mandatory_arg_error

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

Line 493: hr_api.mandatory_arg_error

489: (p_api_name => l_proc,
490: p_argument => 'validation_end_date',
491: p_argument_value => p_validation_end_date);
492: --
493: hr_api.mandatory_arg_error
494: (p_api_name => l_proc,
495: p_argument => 'elig_asnt_set_prte_id',
496: p_argument_value => p_elig_asnt_set_prte_id);
497: --

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

536: --
537: -- Call all supporting business operations
538: --
539: --
540: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
541: --
542: chk_elig_asnt_set_prte_id
543: (p_elig_asnt_set_prte_id => p_rec.elig_asnt_set_prte_id,
544: p_effective_date => p_effective_date,

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

586: --
587: -- Call all supporting business operations
588: --
589: --
590: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
591: --
592: chk_elig_asnt_set_prte_id
593: (p_elig_asnt_set_prte_id => p_rec.elig_asnt_set_prte_id,
594: p_effective_date => p_effective_date,

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

680: hr_utility.set_location('Entering:'|| l_proc, 10);
681: --
682: -- Ensure that all the mandatory parameter are not null
683: --
684: hr_api.mandatory_arg_error(p_api_name => l_proc,
685: p_argument => 'elig_asnt_set_prte_id',
686: p_argument_value => p_elig_asnt_set_prte_id);
687: --
688: open csr_leg_code;