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

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

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

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

123: Begin
124: --
125: hr_utility.set_location('Entering:'||l_proc,5);
126: --
127: hr_api.mandatory_arg_error(p_api_name => l_proc,
128: p_argument => 'pl_typ_opt_typ_id',
129: p_argument_value => p_pl_typ_opt_typ_id);
130:
131: l_api_updating := ben_ehc_shd.api_updating

Line 137: and nvl(p_pl_typ_opt_typ_id,hr_api.g_number)

133: p_effective_date => p_effective_date,
134: p_object_version_number => p_object_version_number);
135: --
136: if (l_api_updating
137: and nvl(p_pl_typ_opt_typ_id,hr_api.g_number)
138: <> nvl(ben_ehc_shd.g_old_rec.pl_typ_opt_typ_id,hr_api.g_number)
139: or not l_api_updating)
140: and p_pl_typ_opt_typ_id is not null then
141: --

Line 138: <> nvl(ben_ehc_shd.g_old_rec.pl_typ_opt_typ_id,hr_api.g_number)

134: p_object_version_number => p_object_version_number);
135: --
136: if (l_api_updating
137: and nvl(p_pl_typ_opt_typ_id,hr_api.g_number)
138: <> nvl(ben_ehc_shd.g_old_rec.pl_typ_opt_typ_id,hr_api.g_number)
139: or not l_api_updating)
140: and p_pl_typ_opt_typ_id is not null then
141: --
142: -- check if pl_typ_opt_typ_id value exists in

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

211: Begin
212: --
213: hr_utility.set_location('Entering:'||l_proc,5);
214: --
215: hr_api.mandatory_arg_error(p_api_name => l_proc,
216: p_argument => 'oipl_id',
217: p_argument_value => p_oipl_id);
218:
219: l_api_updating := ben_ehc_shd.api_updating

Line 225: and nvl(p_oipl_id,hr_api.g_number)

221: p_effective_date => p_effective_date,
222: p_object_version_number => p_object_version_number);
223: --
224: if (l_api_updating
225: and nvl(p_oipl_id,hr_api.g_number)
226: <> nvl(ben_ehc_shd.g_old_rec.oipl_id,hr_api.g_number)
227: or not l_api_updating)
228: and p_oipl_id is not null then
229: --

Line 226: <> nvl(ben_ehc_shd.g_old_rec.oipl_id,hr_api.g_number)

222: p_object_version_number => p_object_version_number);
223: --
224: if (l_api_updating
225: and nvl(p_oipl_id,hr_api.g_number)
226: <> nvl(ben_ehc_shd.g_old_rec.oipl_id,hr_api.g_number)
227: or not l_api_updating)
228: and p_oipl_id is not null then
229: --
230: -- check if oipl_id value exists in

Line 300: <> nvl(ben_ehc_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

296: p_object_version_number => p_object_version_number);
297: --
298: if (l_api_updating
299: and p_excld_flag
300: <> nvl(ben_ehc_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
301: or not l_api_updating) then
302: --
303: -- check if value of lookup falls within lookup type.
304: --

Line 306: if hr_api.not_exists_in_hr_lookups

302: --
303: -- check if value of lookup falls within lookup type.
304: --
305: --
306: if hr_api.not_exists_in_hr_lookups
307: (p_lookup_type => 'YES_NO',
308: p_lookup_code => p_excld_flag,
309: p_effective_date => p_effective_date) then
310: --

Line 413: p_eligy_prfl_id in number default hr_api.g_number,

409: -- {End Of Comments}
410: -- ----------------------------------------------------------------------------
411: Procedure dt_update_validate
412: (
413: p_eligy_prfl_id in number default hr_api.g_number,
414: p_datetrack_mode in varchar2,
415: p_validation_start_date in date,
416: p_validation_end_date in date) Is
417: --

Line 427: hr_api.mandatory_arg_error

423: hr_utility.set_location('Entering:'||l_proc, 5);
424: --
425: -- Ensure that the p_datetrack_mode argument is not null
426: --
427: hr_api.mandatory_arg_error
428: (p_api_name => l_proc,
429: p_argument => 'datetrack_mode',
430: p_argument_value => p_datetrack_mode);
431: --

Line 439: hr_api.mandatory_arg_error

435: --
436: --
437: -- Ensure the arguments are not null
438: --
439: hr_api.mandatory_arg_error
440: (p_api_name => l_proc,
441: p_argument => 'validation_start_date',
442: p_argument_value => p_validation_start_date);
443: --

Line 444: hr_api.mandatory_arg_error

440: (p_api_name => l_proc,
441: p_argument => 'validation_start_date',
442: p_argument_value => p_validation_start_date);
443: --
444: hr_api.mandatory_arg_error
445: (p_api_name => l_proc,
446: p_argument => 'validation_end_date',
447: p_argument_value => p_validation_end_date);
448: --

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

445: (p_api_name => l_proc,
446: p_argument => 'validation_end_date',
447: p_argument_value => p_validation_end_date);
448: --
449: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
450: NOT (dt_api.check_min_max_dates
451: (p_base_table_name => 'ben_eligy_prfl_f',
452: p_base_key_column => 'eligy_prfl_id',
453: p_base_key_value => p_eligy_prfl_id,

Line 531: hr_api.mandatory_arg_error

527: hr_utility.set_location('Entering:'||l_proc, 5);
528: --
529: -- Ensure that the p_datetrack_mode argument is not null
530: --
531: hr_api.mandatory_arg_error
532: (p_api_name => l_proc,
533: p_argument => 'datetrack_mode',
534: p_argument_value => p_datetrack_mode);
535: --

Line 545: hr_api.mandatory_arg_error

541: --
542: --
543: -- Ensure the arguments are not null
544: --
545: hr_api.mandatory_arg_error
546: (p_api_name => l_proc,
547: p_argument => 'validation_start_date',
548: p_argument_value => p_validation_start_date);
549: --

Line 550: hr_api.mandatory_arg_error

546: (p_api_name => l_proc,
547: p_argument => 'validation_start_date',
548: p_argument_value => p_validation_start_date);
549: --
550: hr_api.mandatory_arg_error
551: (p_api_name => l_proc,
552: p_argument => 'validation_end_date',
553: p_argument_value => p_validation_end_date);
554: --

Line 555: hr_api.mandatory_arg_error

551: (p_api_name => l_proc,
552: p_argument => 'validation_end_date',
553: p_argument_value => p_validation_end_date);
554: --
555: hr_api.mandatory_arg_error
556: (p_api_name => l_proc,
557: p_argument => 'ELIG_HLTH_CVG_PRTE_id',
558: p_argument_value => p_ELIG_HLTH_CVG_PRTE_id);
559: --

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

627: p_eligy_prfl_id => p_rec.eligy_prfl_id,
628: p_ordr_num => p_rec.ordr_num,
629: p_business_group_id => p_rec.business_group_id);
630: --
631: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
632: --
633: hr_utility.set_location(' Leaving:'||l_proc, 10);
634: End insert_validate;
635: --

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

680: p_eligy_prfl_id => p_rec.eligy_prfl_id,
681: p_ordr_num => p_rec.ordr_num,
682: p_business_group_id => p_rec.business_group_id);
683: --
684: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
685: --
686: -- Call the datetrack update integrity operation
687: --
688: dt_update_validate

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

748: hr_utility.set_location('Entering:'|| l_proc, 10);
749: --
750: -- Ensure that all the mandatory parameter are not null
751: --
752: hr_api.mandatory_arg_error(p_api_name => l_proc,
753: p_argument => 'ELIG_HLTH_CVG_PRTE_id',
754: p_argument_value => p_ELIG_HLTH_CVG_PRTE_id);
755: --
756: open csr_leg_code;