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

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

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

Line 123: and lrn.lvg_rsn_rt_id <> nvl(p_lvg_rsn_rt_id,hr_api.g_number)

119: select null
120: from ben_lvg_rsn_rt_f lrn
121: where lrn.lvg_rsn_cd = p_lvg_rsn_cd
122: and lrn.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
123: and lrn.lvg_rsn_rt_id <> nvl(p_lvg_rsn_rt_id,hr_api.g_number)
124: and lrn.business_group_id + 0 = p_business_group_id
125: and p_validation_start_date <= lrn.effective_end_date
126: and p_validation_end_date >= lrn.effective_start_date
127: ;

Line 141: <> nvl(ben_lrn_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_lrn_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 227: <> nvl(ben_lrn_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 233: if hr_api.not_exists_in_hr_lookups

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

Line 352: (p_vrbl_rt_prfl_id in number default hr_api.g_number,

348: --
349: -- {End Of Comments}
350: -- ----------------------------------------------------------------------------
351: Procedure dt_update_validate
352: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
353: p_datetrack_mode in varchar2,
354: p_validation_start_date in date,
355: p_validation_end_date in date) Is
356: --

Line 366: hr_api.mandatory_arg_error

362: hr_utility.set_location('Entering:'||l_proc, 5);
363: --
364: -- Ensure that the p_datetrack_mode argument is not null
365: --
366: hr_api.mandatory_arg_error
367: (p_api_name => l_proc,
368: p_argument => 'datetrack_mode',
369: p_argument_value => p_datetrack_mode);
370: --

Line 378: hr_api.mandatory_arg_error

374: --
375: --
376: -- Ensure the arguments are not null
377: --
378: hr_api.mandatory_arg_error
379: (p_api_name => l_proc,
380: p_argument => 'validation_start_date',
381: p_argument_value => p_validation_start_date);
382: --

Line 383: hr_api.mandatory_arg_error

379: (p_api_name => l_proc,
380: p_argument => 'validation_start_date',
381: p_argument_value => p_validation_start_date);
382: --
383: hr_api.mandatory_arg_error
384: (p_api_name => l_proc,
385: p_argument => 'validation_end_date',
386: p_argument_value => p_validation_end_date);
387: --

Line 388: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

384: (p_api_name => l_proc,
385: p_argument => 'validation_end_date',
386: p_argument_value => p_validation_end_date);
387: --
388: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
389: NOT (dt_api.check_min_max_dates
390: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
391: p_base_key_column => 'vrbl_rt_prfl_id',
392: p_base_key_value => p_vrbl_rt_prfl_id,

Line 470: hr_api.mandatory_arg_error

466: hr_utility.set_location('Entering:'||l_proc, 5);
467: --
468: -- Ensure that the p_datetrack_mode argument is not null
469: --
470: hr_api.mandatory_arg_error
471: (p_api_name => l_proc,
472: p_argument => 'datetrack_mode',
473: p_argument_value => p_datetrack_mode);
474: --

Line 484: hr_api.mandatory_arg_error

480: --
481: --
482: -- Ensure the arguments are not null
483: --
484: hr_api.mandatory_arg_error
485: (p_api_name => l_proc,
486: p_argument => 'validation_start_date',
487: p_argument_value => p_validation_start_date);
488: --

Line 489: hr_api.mandatory_arg_error

485: (p_api_name => l_proc,
486: p_argument => 'validation_start_date',
487: p_argument_value => p_validation_start_date);
488: --
489: hr_api.mandatory_arg_error
490: (p_api_name => l_proc,
491: p_argument => 'validation_end_date',
492: p_argument_value => p_validation_end_date);
493: --

Line 494: hr_api.mandatory_arg_error

490: (p_api_name => l_proc,
491: p_argument => 'validation_end_date',
492: p_argument_value => p_validation_end_date);
493: --
494: hr_api.mandatory_arg_error
495: (p_api_name => l_proc,
496: p_argument => 'lvg_rsn_rt_id',
497: p_argument_value => p_lvg_rsn_rt_id);
498: --

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

538: --
539: -- Call all supporting business operations
540: --
541: --
542: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
543: --
544: chk_lvg_rsn_rt_id
545: (p_lvg_rsn_rt_id => p_rec.lvg_rsn_rt_id,
546: p_effective_date => p_effective_date,

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

592: --
593: -- Call all supporting business operations
594: --
595: --
596: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
597: --
598: chk_lvg_rsn_rt_id
599: (p_lvg_rsn_rt_id => p_rec.lvg_rsn_rt_id,
600: p_effective_date => p_effective_date,

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

690: hr_utility.set_location('Entering:'|| l_proc, 10);
691: --
692: -- Ensure that all the mandatory parameter are not null
693: --
694: hr_api.mandatory_arg_error(p_api_name => l_proc,
695: p_argument => 'lvg_rsn_rt_id',
696: p_argument_value => p_lvg_rsn_rt_id);
697: --
698: open csr_leg_code;