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

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

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

Line 125: <> nvl(ben_eqt_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_eqt_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_qualification_type_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_qualification_type_id,hr_api.g_number)
203: <> nvl(ben_eqt_shd.g_old_rec.qualification_type_id,hr_api.g_number)
204: or not l_api_updating)
205: and p_qualification_type_id is not null then
206: --

Line 203: <> nvl(ben_eqt_shd.g_old_rec.qualification_type_id,hr_api.g_number)

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

Line 279: and eqt.elig_qual_titl_prte_id <> nvl(p_elig_qual_titl_prte_id,hr_api.g_number)

275: from ben_elig_qual_titl_prte_f eqt
276: where nvl(eqt.qualification_type_id,-1) = nvl(p_qualification_type_id,-1)
277: and nvl(eqt.title,-1) = nvl(p_title,-1)
278: and eqt.eligy_prfl_id = p_eligy_prfl_id
279: and eqt.elig_qual_titl_prte_id <> nvl(p_elig_qual_titl_prte_id,hr_api.g_number)
280: and eqt.business_group_id = p_business_group_id
281: and p_validation_start_date <= eqt.effective_end_date
282: and p_validation_end_date >= eqt.effective_start_date;
283:

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

392: --
393: -- {End Of Comments}
394: -- ----------------------------------------------------------------------------
395: Procedure dt_update_validate
396: (p_eligy_prfl_id in number default hr_api.g_number,
397: p_datetrack_mode in varchar2,
398: p_validation_start_date in date,
399: p_validation_end_date in date) Is
400: --

Line 410: hr_api.mandatory_arg_error

406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --
408: -- Ensure that the p_datetrack_mode argument is not null
409: --
410: hr_api.mandatory_arg_error
411: (p_api_name => l_proc,
412: p_argument => 'datetrack_mode',
413: p_argument_value => p_datetrack_mode);
414: --

Line 422: hr_api.mandatory_arg_error

418: --
419: --
420: -- Ensure the arguments are not null
421: --
422: hr_api.mandatory_arg_error
423: (p_api_name => l_proc,
424: p_argument => 'validation_start_date',
425: p_argument_value => p_validation_start_date);
426: --

Line 427: hr_api.mandatory_arg_error

423: (p_api_name => l_proc,
424: p_argument => 'validation_start_date',
425: p_argument_value => p_validation_start_date);
426: --
427: hr_api.mandatory_arg_error
428: (p_api_name => l_proc,
429: p_argument => 'validation_end_date',
430: p_argument_value => p_validation_end_date);
431: --

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

428: (p_api_name => l_proc,
429: p_argument => 'validation_end_date',
430: p_argument_value => p_validation_end_date);
431: --
432: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
433: NOT (dt_api.check_min_max_dates
434: (p_base_table_name => 'ben_eligy_prfl_f',
435: p_base_key_column => 'eligy_prfl_id',
436: p_base_key_value => p_eligy_prfl_id,

Line 515: hr_api.mandatory_arg_error

511: hr_utility.set_location('Entering:'||l_proc, 5);
512: --
513: -- Ensure that the p_datetrack_mode argument is not null
514: --
515: hr_api.mandatory_arg_error
516: (p_api_name => l_proc,
517: p_argument => 'datetrack_mode',
518: p_argument_value => p_datetrack_mode);
519: --

Line 529: hr_api.mandatory_arg_error

525: --
526: --
527: -- Ensure the arguments are not null
528: --
529: hr_api.mandatory_arg_error
530: (p_api_name => l_proc,
531: p_argument => 'validation_start_date',
532: p_argument_value => p_validation_start_date);
533: --

Line 534: hr_api.mandatory_arg_error

530: (p_api_name => l_proc,
531: p_argument => 'validation_start_date',
532: p_argument_value => p_validation_start_date);
533: --
534: hr_api.mandatory_arg_error
535: (p_api_name => l_proc,
536: p_argument => 'validation_end_date',
537: p_argument_value => p_validation_end_date);
538: --

Line 539: hr_api.mandatory_arg_error

535: (p_api_name => l_proc,
536: p_argument => 'validation_end_date',
537: p_argument_value => p_validation_end_date);
538: --
539: hr_api.mandatory_arg_error
540: (p_api_name => l_proc,
541: p_argument => 'elig_qual_titl_prte_id',
542: p_argument_value => p_elig_qual_titl_prte_id);
543: --

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

583: --
584: -- Call all supporting business operations
585: --
586: --
587: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
588: --
589: chk_elig_qual_titl_prte_id
590: (p_elig_qual_titl_prte_id => p_rec.elig_qual_titl_prte_id,
591: p_effective_date => p_effective_date,

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

640: --
641: -- Call all supporting business operations
642: --
643: --
644: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
645: --
646: chk_elig_qual_titl_prte_id
647: (p_elig_qual_titl_prte_id => p_rec.elig_qual_titl_prte_id,
648: p_effective_date => p_effective_date,

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

740: hr_utility.set_location('Entering:'|| l_proc, 10);
741: --
742: -- Ensure that all the mandatory parameter are not null
743: --
744: hr_api.mandatory_arg_error(p_api_name => l_proc,
745: p_argument => 'elig_qual_titl_prte_id',
746: p_argument_value => p_elig_qual_titl_prte_id);
747: --
748: open csr_leg_code;