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

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

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

Line 123: and elv.elig_lvg_rsn_prte_id <> nvl(p_elig_lvg_rsn_prte_id,hr_api.g_number)

119: select null
120: from ben_elig_lvg_rsn_prte_f elv
121: where elv.lvg_rsn_cd = p_lvg_rsn_cd
122: and elv.eligy_prfl_id = p_eligy_prfl_id
123: and elv.elig_lvg_rsn_prte_id <> nvl(p_elig_lvg_rsn_prte_id,hr_api.g_number)
124: and elv.business_group_id + 0 = p_business_group_id
125: and p_validation_start_date <= elv.effective_end_date
126: and p_validation_end_date >= elv.effective_start_date
127: ;

Line 141: <> nvl(ben_elv_shd.g_old_rec.lvg_rsn_cd,hr_api.g_varchar2)

137: p_object_version_number => p_object_version_number);
138: --
139: if (l_api_updating
140: and p_lvg_rsn_cd
141: <> nvl(ben_elv_shd.g_old_rec.lvg_rsn_cd,hr_api.g_varchar2)
142: or not l_api_updating)
143: and p_lvg_rsn_cd is not null then
144: --
145: -- check if value of lookup falls within lookup type.

Line 147: if hr_api.not_exists_in_hr_lookups

143: and p_lvg_rsn_cd is not null then
144: --
145: -- check if value of lookup falls within lookup type.
146: --
147: if hr_api.not_exists_in_hr_lookups
148: (p_lookup_type => 'LEAV_REAS',
149: p_lookup_code => p_lvg_rsn_cd,
150: p_effective_date => p_effective_date) then
151: --

Line 225: <> nvl(ben_elv_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

221: p_object_version_number => p_object_version_number);
222: --
223: if (l_api_updating
224: and p_excld_flag
225: <> nvl(ben_elv_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
226: or not l_api_updating) then
227: --
228: -- check if value of lookup falls within lookup type.
229: --

Line 231: if hr_api.not_exists_in_hr_lookups

227: --
228: -- check if value of lookup falls within lookup type.
229: --
230: --
231: if hr_api.not_exists_in_hr_lookups
232: (p_lookup_type => 'YES_NO',
233: p_lookup_code => p_excld_flag,
234: p_effective_date => p_effective_date) then
235: --

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

337: --
338: -- {End Of Comments}
339: -- ----------------------------------------------------------------------------
340: Procedure dt_update_validate
341: (p_eligy_prfl_id in number default hr_api.g_number,
342: p_datetrack_mode in varchar2,
343: p_validation_start_date in date,
344: p_validation_end_date in date) Is
345: --

Line 355: hr_api.mandatory_arg_error

351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: -- Ensure that the p_datetrack_mode argument is not null
354: --
355: hr_api.mandatory_arg_error
356: (p_api_name => l_proc,
357: p_argument => 'datetrack_mode',
358: p_argument_value => p_datetrack_mode);
359: --

Line 367: hr_api.mandatory_arg_error

363: --
364: --
365: -- Ensure the arguments are not null
366: --
367: hr_api.mandatory_arg_error
368: (p_api_name => l_proc,
369: p_argument => 'validation_start_date',
370: p_argument_value => p_validation_start_date);
371: --

Line 372: hr_api.mandatory_arg_error

368: (p_api_name => l_proc,
369: p_argument => 'validation_start_date',
370: p_argument_value => p_validation_start_date);
371: --
372: hr_api.mandatory_arg_error
373: (p_api_name => l_proc,
374: p_argument => 'validation_end_date',
375: p_argument_value => p_validation_end_date);
376: --

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

373: (p_api_name => l_proc,
374: p_argument => 'validation_end_date',
375: p_argument_value => p_validation_end_date);
376: --
377: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
378: NOT (dt_api.check_min_max_dates
379: (p_base_table_name => 'ben_eligy_prfl_f',
380: p_base_key_column => 'eligy_prfl_id',
381: p_base_key_value => p_eligy_prfl_id,

Line 459: hr_api.mandatory_arg_error

455: hr_utility.set_location('Entering:'||l_proc, 5);
456: --
457: -- Ensure that the p_datetrack_mode argument is not null
458: --
459: hr_api.mandatory_arg_error
460: (p_api_name => l_proc,
461: p_argument => 'datetrack_mode',
462: p_argument_value => p_datetrack_mode);
463: --

Line 473: hr_api.mandatory_arg_error

469: --
470: --
471: -- Ensure the arguments are not null
472: --
473: hr_api.mandatory_arg_error
474: (p_api_name => l_proc,
475: p_argument => 'validation_start_date',
476: p_argument_value => p_validation_start_date);
477: --

Line 478: hr_api.mandatory_arg_error

474: (p_api_name => l_proc,
475: p_argument => 'validation_start_date',
476: p_argument_value => p_validation_start_date);
477: --
478: hr_api.mandatory_arg_error
479: (p_api_name => l_proc,
480: p_argument => 'validation_end_date',
481: p_argument_value => p_validation_end_date);
482: --

Line 483: hr_api.mandatory_arg_error

479: (p_api_name => l_proc,
480: p_argument => 'validation_end_date',
481: p_argument_value => p_validation_end_date);
482: --
483: hr_api.mandatory_arg_error
484: (p_api_name => l_proc,
485: p_argument => 'elig_lvg_rsn_prte_id',
486: p_argument_value => p_elig_lvg_rsn_prte_id);
487: --

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

527: --
528: -- Call all supporting business operations
529: --
530: --
531: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
532: --
533: chk_elig_lvg_rsn_prte_id
534: (p_elig_lvg_rsn_prte_id => p_rec.elig_lvg_rsn_prte_id,
535: p_effective_date => p_effective_date,

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

577: --
578: -- Call all supporting business operations
579: --
580: --
581: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
582: --
583: chk_elig_lvg_rsn_prte_id
584: (p_elig_lvg_rsn_prte_id => p_rec.elig_lvg_rsn_prte_id,
585: p_effective_date => p_effective_date,

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

671: hr_utility.set_location('Entering:'|| l_proc, 10);
672: --
673: -- Ensure that all the mandatory parameter are not null
674: --
675: hr_api.mandatory_arg_error(p_api_name => l_proc,
676: p_argument => 'elig_lvg_rsn_prte_id',
677: p_argument_value => p_elig_lvg_rsn_prte_id);
678: --
679: open csr_leg_code;