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

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

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

Line 134: and elig_job_prte_id <> nvl(p_elig_job_prte_id,hr_api.g_number)

130: select null
131: from ben_elig_job_prte_f
132: where job_id = p_job_id
133: and eligy_prfl_id = p_eligy_prfl_id
134: and elig_job_prte_id <> nvl(p_elig_job_prte_id,hr_api.g_number)
135: and business_group_id + 0 = p_business_group_id
136: and p_validation_start_date <= effective_end_date
137: and p_validation_end_date >= effective_start_date
138: ;

Line 151: and nvl(p_job_id,hr_api.g_number)

147: p_effective_date => p_effective_date,
148: p_object_version_number => p_object_version_number);
149: --
150: if (l_api_updating
151: and nvl(p_job_id,hr_api.g_number)
152: <> nvl(ben_ejp_shd.g_old_rec.job_id,hr_api.g_number)
153: or not l_api_updating) then
154: --
155: -- check if job_id value exists in per_jobs table

Line 152: <> nvl(ben_ejp_shd.g_old_rec.job_id,hr_api.g_number)

148: p_object_version_number => p_object_version_number);
149: --
150: if (l_api_updating
151: and nvl(p_job_id,hr_api.g_number)
152: <> nvl(ben_ejp_shd.g_old_rec.job_id,hr_api.g_number)
153: or not l_api_updating) then
154: --
155: -- check if job_id value exists in per_jobs table
156: --

Line 238: <> nvl(ben_ejp_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_ejp_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 351: (p_eligy_prfl_id in number default hr_api.g_number,

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

Line 365: hr_api.mandatory_arg_error

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

Line 377: hr_api.mandatory_arg_error

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

Line 382: hr_api.mandatory_arg_error

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

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

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

Line 471: hr_api.mandatory_arg_error

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

Line 485: hr_api.mandatory_arg_error

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

Line 490: hr_api.mandatory_arg_error

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

Line 495: hr_api.mandatory_arg_error

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

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

539: --
540: -- Call all supporting business operations
541: --
542: --
543: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
544: --
545: chk_elig_job_prte_id
546: (p_elig_job_prte_id => p_rec.elig_job_prte_id,
547: p_effective_date => p_effective_date,

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

589: --
590: -- Call all supporting business operations
591: --
592: --
593: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
594: --
595: chk_elig_job_prte_id
596: (p_elig_job_prte_id => p_rec.elig_job_prte_id,
597: p_effective_date => p_effective_date,

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

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