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

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

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

Line 125: <> nvl(ben_est_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_est_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 202: and nvl(p_job_group_id,hr_api.g_number)

198: p_effective_date => p_effective_date,
199: p_object_version_number => p_object_version_number);
200: --
201: if (l_api_updating
202: and nvl(p_job_group_id,hr_api.g_number)
203: <> nvl(ben_est_shd.g_old_rec.job_group_id,hr_api.g_number)
204: or not l_api_updating)
205: and p_job_group_id is not null then
206: --

Line 203: <> nvl(ben_est_shd.g_old_rec.job_group_id,hr_api.g_number)

199: p_object_version_number => p_object_version_number);
200: --
201: if (l_api_updating
202: and nvl(p_job_group_id,hr_api.g_number)
203: <> nvl(ben_est_shd.g_old_rec.job_group_id,hr_api.g_number)
204: or not l_api_updating)
205: and p_job_group_id is not null then
206: --
207: -- check if job_group_id value exists in

Line 273: between date_from and nvl(date_to,hr_api.g_eot);

269: from per_jobs abr
270: where abr.job_id = p_job_id
271: and abr.business_group_id = p_business_group_id
272: and p_effective_date
273: between date_from and nvl(date_to,hr_api.g_eot);
274: --
275: Begin
276: --
277: hr_utility.set_location('Entering:'||l_proc,5);

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

281: p_effective_date => p_effective_date,
282: p_object_version_number => p_object_version_number);
283: --
284: if (l_api_updating
285: and nvl(p_job_id,hr_api.g_number)
286: <> nvl(ben_est_shd.g_old_rec.job_id,hr_api.g_number)
287: or not l_api_updating)
288: and p_job_id is not null then
289: --

Line 286: <> nvl(ben_est_shd.g_old_rec.job_id,hr_api.g_number)

282: p_object_version_number => p_object_version_number);
283: --
284: if (l_api_updating
285: and nvl(p_job_id,hr_api.g_number)
286: <> nvl(ben_est_shd.g_old_rec.job_id,hr_api.g_number)
287: or not l_api_updating)
288: and p_job_id is not null then
289: --
290: -- check if job_id value exists in

Line 362: and est.elig_suppl_role_prte_id <> nvl(p_elig_suppl_role_prte_id,hr_api.g_number)

358: from ben_elig_suppl_role_prte_f est
359: where nvl(est.job_group_id,-1) = nvl(p_job_group_id, -1)
360: and nvl(est.job_id,-1) = nvl(p_job_id,-1)
361: and est.eligy_prfl_id = p_eligy_prfl_id
362: and est.elig_suppl_role_prte_id <> nvl(p_elig_suppl_role_prte_id,hr_api.g_number)
363: and est.business_group_id = p_business_group_id
364: and p_validation_start_date <= est.effective_end_date
365: and p_validation_end_date >= est.effective_start_date;
366:

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

417: --
418: -- {End Of Comments}
419: -- ----------------------------------------------------------------------------
420: Procedure dt_update_validate
421: (p_eligy_prfl_id in number default hr_api.g_number,
422: p_datetrack_mode in varchar2,
423: p_validation_start_date in date,
424: p_validation_end_date in date) Is
425: --

Line 435: hr_api.mandatory_arg_error

431: hr_utility.set_location('Entering:'||l_proc, 5);
432: --
433: -- Ensure that the p_datetrack_mode argument is not null
434: --
435: hr_api.mandatory_arg_error
436: (p_api_name => l_proc,
437: p_argument => 'datetrack_mode',
438: p_argument_value => p_datetrack_mode);
439: --

Line 447: hr_api.mandatory_arg_error

443: --
444: --
445: -- Ensure the arguments are not null
446: --
447: hr_api.mandatory_arg_error
448: (p_api_name => l_proc,
449: p_argument => 'validation_start_date',
450: p_argument_value => p_validation_start_date);
451: --

Line 452: hr_api.mandatory_arg_error

448: (p_api_name => l_proc,
449: p_argument => 'validation_start_date',
450: p_argument_value => p_validation_start_date);
451: --
452: hr_api.mandatory_arg_error
453: (p_api_name => l_proc,
454: p_argument => 'validation_end_date',
455: p_argument_value => p_validation_end_date);
456: --

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

453: (p_api_name => l_proc,
454: p_argument => 'validation_end_date',
455: p_argument_value => p_validation_end_date);
456: --
457: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
458: NOT (dt_api.check_min_max_dates
459: (p_base_table_name => 'ben_eligy_prfl_f',
460: p_base_key_column => 'eligy_prfl_id',
461: p_base_key_value => p_eligy_prfl_id,

Line 540: hr_api.mandatory_arg_error

536: hr_utility.set_location('Entering:'||l_proc, 5);
537: --
538: -- Ensure that the p_datetrack_mode argument is not null
539: --
540: hr_api.mandatory_arg_error
541: (p_api_name => l_proc,
542: p_argument => 'datetrack_mode',
543: p_argument_value => p_datetrack_mode);
544: --

Line 554: hr_api.mandatory_arg_error

550: --
551: --
552: -- Ensure the arguments are not null
553: --
554: hr_api.mandatory_arg_error
555: (p_api_name => l_proc,
556: p_argument => 'validation_start_date',
557: p_argument_value => p_validation_start_date);
558: --

Line 559: hr_api.mandatory_arg_error

555: (p_api_name => l_proc,
556: p_argument => 'validation_start_date',
557: p_argument_value => p_validation_start_date);
558: --
559: hr_api.mandatory_arg_error
560: (p_api_name => l_proc,
561: p_argument => 'validation_end_date',
562: p_argument_value => p_validation_end_date);
563: --

Line 564: hr_api.mandatory_arg_error

560: (p_api_name => l_proc,
561: p_argument => 'validation_end_date',
562: p_argument_value => p_validation_end_date);
563: --
564: hr_api.mandatory_arg_error
565: (p_api_name => l_proc,
566: p_argument => 'elig_suppl_role_prte_id',
567: p_argument_value => p_elig_suppl_role_prte_id);
568: --

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

608: --
609: -- Call all supporting business operations
610: --
611: --
612: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
613: --
614: chk_elig_suppl_role_prte_id
615: (p_elig_suppl_role_prte_id => p_rec.elig_suppl_role_prte_id,
616: p_effective_date => p_effective_date,

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

666: --
667: -- Call all supporting business operations
668: --
669: --
670: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
671: --
672: chk_elig_suppl_role_prte_id
673: (p_elig_suppl_role_prte_id => p_rec.elig_suppl_role_prte_id,
674: p_effective_date => p_effective_date,

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

767: hr_utility.set_location('Entering:'|| l_proc, 10);
768: --
769: -- Ensure that all the mandatory parameter are not null
770: --
771: hr_api.mandatory_arg_error(p_api_name => l_proc,
772: p_argument => 'elig_suppl_role_prte_id',
773: p_argument_value => p_elig_suppl_role_prte_id);
774: --
775: open csr_leg_code;