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

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

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

Line 124: and elig_comp_lvl_prte_id <> nvl(p_elig_comp_lvl_prte_id,hr_api.g_number)

120: select null
121: from ben_elig_comp_lvl_prte_f
122: where comp_lvl_fctr_id = p_comp_lvl_fctr_id
123: and eligy_prfl_id = p_eligy_prfl_id
124: and elig_comp_lvl_prte_id <> nvl(p_elig_comp_lvl_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 146: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)

142: p_effective_date => p_effective_date,
143: p_object_version_number => p_object_version_number);
144: --
145: if (l_api_updating
146: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
147: <> nvl(ben_ecl_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
148: or not l_api_updating) then
149: --
150: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table

Line 147: <> nvl(ben_ecl_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)

143: p_object_version_number => p_object_version_number);
144: --
145: if (l_api_updating
146: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
147: <> nvl(ben_ecl_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
148: or not l_api_updating) then
149: --
150: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table
151: --

Line 378: <> nvl(ben_ecl_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

374: p_object_version_number => p_object_version_number);
375: --
376: if (l_api_updating
377: and p_excld_flag
378: <> nvl(ben_ecl_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
379: or not l_api_updating) then
380: --
381: -- check if value of lookup falls within lookup type.
382: --

Line 384: if hr_api.not_exists_in_hr_lookups

380: --
381: -- check if value of lookup falls within lookup type.
382: --
383: --
384: if hr_api.not_exists_in_hr_lookups
385: (p_lookup_type => 'YES_NO',
386: p_lookup_code => p_excld_flag,
387: p_effective_date => p_effective_date) then
388: --

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

486: --
487: -- {End Of Comments}
488: -- ----------------------------------------------------------------------------
489: Procedure dt_update_validate
490: (p_eligy_prfl_id in number default hr_api.g_number,
491: p_datetrack_mode in varchar2,
492: p_validation_start_date in date,
493: p_validation_end_date in date) Is
494: --

Line 504: hr_api.mandatory_arg_error

500: hr_utility.set_location('Entering:'||l_proc, 5);
501: --
502: -- Ensure that the p_datetrack_mode argument is not null
503: --
504: hr_api.mandatory_arg_error
505: (p_api_name => l_proc,
506: p_argument => 'datetrack_mode',
507: p_argument_value => p_datetrack_mode);
508: --

Line 516: hr_api.mandatory_arg_error

512: --
513: --
514: -- Ensure the arguments are not null
515: --
516: hr_api.mandatory_arg_error
517: (p_api_name => l_proc,
518: p_argument => 'validation_start_date',
519: p_argument_value => p_validation_start_date);
520: --

Line 521: hr_api.mandatory_arg_error

517: (p_api_name => l_proc,
518: p_argument => 'validation_start_date',
519: p_argument_value => p_validation_start_date);
520: --
521: hr_api.mandatory_arg_error
522: (p_api_name => l_proc,
523: p_argument => 'validation_end_date',
524: p_argument_value => p_validation_end_date);
525: --

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

522: (p_api_name => l_proc,
523: p_argument => 'validation_end_date',
524: p_argument_value => p_validation_end_date);
525: --
526: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
527: NOT (dt_api.check_min_max_dates
528: (p_base_table_name => 'ben_eligy_prfl_f',
529: p_base_key_column => 'eligy_prfl_id',
530: p_base_key_value => p_eligy_prfl_id,

Line 609: hr_api.mandatory_arg_error

605: hr_utility.set_location('Entering:'||l_proc, 5);
606: --
607: -- Ensure that the p_datetrack_mode argument is not null
608: --
609: hr_api.mandatory_arg_error
610: (p_api_name => l_proc,
611: p_argument => 'datetrack_mode',
612: p_argument_value => p_datetrack_mode);
613: --

Line 623: hr_api.mandatory_arg_error

619: --
620: --
621: -- Ensure the arguments are not null
622: --
623: hr_api.mandatory_arg_error
624: (p_api_name => l_proc,
625: p_argument => 'validation_start_date',
626: p_argument_value => p_validation_start_date);
627: --

Line 628: hr_api.mandatory_arg_error

624: (p_api_name => l_proc,
625: p_argument => 'validation_start_date',
626: p_argument_value => p_validation_start_date);
627: --
628: hr_api.mandatory_arg_error
629: (p_api_name => l_proc,
630: p_argument => 'validation_end_date',
631: p_argument_value => p_validation_end_date);
632: --

Line 633: hr_api.mandatory_arg_error

629: (p_api_name => l_proc,
630: p_argument => 'validation_end_date',
631: p_argument_value => p_validation_end_date);
632: --
633: hr_api.mandatory_arg_error
634: (p_api_name => l_proc,
635: p_argument => 'elig_comp_lvl_prte_id',
636: p_argument_value => p_elig_comp_lvl_prte_id);
637: --

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

676: --
677: -- Call all supporting business operations
678: --
679: --
680: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
681: --
682: chk_elig_comp_lvl_prte_id
683: (p_elig_comp_lvl_prte_id => p_rec.elig_comp_lvl_prte_id,
684: p_effective_date => p_effective_date,

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

730: --
731: -- Call all supporting business operations
732: --
733: --
734: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
735: --
736: chk_elig_comp_lvl_prte_id
737: (p_elig_comp_lvl_prte_id => p_rec.elig_comp_lvl_prte_id,
738: p_effective_date => p_effective_date,

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

824: hr_utility.set_location('Entering:'|| l_proc, 10);
825: --
826: -- Ensure that all the mandatory parameter are not null
827: --
828: hr_api.mandatory_arg_error(p_api_name => l_proc,
829: p_argument => 'elig_comp_lvl_prte_id',
830: p_argument_value => p_elig_comp_lvl_prte_id);
831: --
832: open csr_leg_code;