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

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

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

Line 124: and elig_pyrl_prte_id <> nvl(p_elig_pyrl_prte_id,hr_api.g_number)

120: select null
121: from ben_elig_pyrl_prte_f
122: where payroll_id = p_payroll_id
123: and eligy_prfl_id = p_eligy_prfl_id
124: and elig_pyrl_prte_id <> nvl(p_elig_pyrl_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 150: and nvl(p_payroll_id, hr_api.g_number)

146: p_object_version_number => p_object_version_number);
147: --
148: --
149: if (l_api_updating
150: and nvl(p_payroll_id, hr_api.g_number)
151: <> nvl(ben_epy_shd.g_old_rec.payroll_id,hr_api.g_number)
152: or not l_api_updating) then
153: --
154: -- check if payroll_id value exists in pay_all_payrolls_f table

Line 151: <> nvl(ben_epy_shd.g_old_rec.payroll_id,hr_api.g_number)

147: --
148: --
149: if (l_api_updating
150: and nvl(p_payroll_id, hr_api.g_number)
151: <> nvl(ben_epy_shd.g_old_rec.payroll_id,hr_api.g_number)
152: or not l_api_updating) then
153: --
154: -- check if payroll_id value exists in pay_all_payrolls_f table
155: --

Line 238: <> nvl(ben_epy_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 244: if hr_api.not_exists_in_hr_lookups

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

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 470: hr_api.mandatory_arg_error

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

Line 484: hr_api.mandatory_arg_error

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

Line 489: hr_api.mandatory_arg_error

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

Line 494: hr_api.mandatory_arg_error

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

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

538: --
539: -- Call all supporting business operations
540: --
541: --
542: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
543: --
544: chk_elig_pyrl_prte_id
545: (p_elig_pyrl_prte_id => p_rec.elig_pyrl_prte_id,
546: p_effective_date => p_effective_date,

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

588: --
589: -- Call all supporting business operations
590: --
591: --
592: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
593: --
594: chk_elig_pyrl_prte_id
595: (p_elig_pyrl_prte_id => p_rec.elig_pyrl_prte_id,
596: p_effective_date => p_effective_date,

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

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