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

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

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

Line 124: <> nvl(ben_efp_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_excld_flag
124: <> nvl(ben_efp_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if value of lookup falls within lookup type.
128: --

Line 130: if hr_api.not_exists_in_hr_lookups

126: --
127: -- check if value of lookup falls within lookup type.
128: --
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'YES_NO',
132: p_lookup_code => p_excld_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 193: and elig_fl_tm_pt_tm_prte_id <> nvl(p_elig_fl_tm_pt_tm_prte_id,hr_api.g_number)

189: select null
190: from ben_elig_fl_tm_pt_tm_prte_f
191: where fl_tm_pt_tm_cd = p_fl_tm_pt_tm_cd
192: and eligy_prfl_id = p_eligy_prfl_id
193: and elig_fl_tm_pt_tm_prte_id <> nvl(p_elig_fl_tm_pt_tm_prte_id,hr_api.g_number)
194: and business_group_id + 0 = p_business_group_id
195: and p_validation_start_date <= effective_end_date
196: and p_validation_end_date >= effective_start_date
197: ;

Line 211: <> nvl(ben_efp_shd.g_old_rec.fl_tm_pt_tm_cd,hr_api.g_varchar2)

207: p_object_version_number => p_object_version_number);
208: --
209: if (l_api_updating
210: and p_fl_tm_pt_tm_cd
211: <> nvl(ben_efp_shd.g_old_rec.fl_tm_pt_tm_cd,hr_api.g_varchar2)
212: or not l_api_updating)
213: and p_fl_tm_pt_tm_cd is not null then
214: --
215: -- check if value of lookup falls within lookup type.

Line 217: if hr_api.not_exists_in_hr_lookups

213: and p_fl_tm_pt_tm_cd is not null then
214: --
215: -- check if value of lookup falls within lookup type.
216: --
217: if hr_api.not_exists_in_hr_lookups
218: (p_lookup_type => 'EMP_CAT',
219: p_lookup_code => p_fl_tm_pt_tm_cd,
220: p_effective_date => p_effective_date) then
221: --

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

333: --
334: -- {End Of Comments}
335: -- ----------------------------------------------------------------------------
336: Procedure dt_update_validate
337: (p_eligy_prfl_id in number default hr_api.g_number,
338: p_datetrack_mode in varchar2,
339: p_validation_start_date in date,
340: p_validation_end_date in date) Is
341: --

Line 351: hr_api.mandatory_arg_error

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

Line 363: hr_api.mandatory_arg_error

359: --
360: --
361: -- Ensure the arguments are not null
362: --
363: hr_api.mandatory_arg_error
364: (p_api_name => l_proc,
365: p_argument => 'validation_start_date',
366: p_argument_value => p_validation_start_date);
367: --

Line 368: hr_api.mandatory_arg_error

364: (p_api_name => l_proc,
365: p_argument => 'validation_start_date',
366: p_argument_value => p_validation_start_date);
367: --
368: hr_api.mandatory_arg_error
369: (p_api_name => l_proc,
370: p_argument => 'validation_end_date',
371: p_argument_value => p_validation_end_date);
372: --

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

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

Line 456: hr_api.mandatory_arg_error

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

Line 470: hr_api.mandatory_arg_error

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

Line 475: hr_api.mandatory_arg_error

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

Line 480: hr_api.mandatory_arg_error

476: (p_api_name => l_proc,
477: p_argument => 'validation_end_date',
478: p_argument_value => p_validation_end_date);
479: --
480: hr_api.mandatory_arg_error
481: (p_api_name => l_proc,
482: p_argument => 'elig_fl_tm_pt_tm_prte_id',
483: p_argument_value => p_elig_fl_tm_pt_tm_prte_id);
484: --

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

523: --
524: -- Call all supporting business operations
525: --
526: --
527: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
528: --
529: chk_elig_fl_tm_pt_tm_prte_id
530: (p_elig_fl_tm_pt_tm_prte_id => p_rec.elig_fl_tm_pt_tm_prte_id,
531: p_effective_date => p_effective_date,

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

573: --
574: -- Call all supporting business operations
575: --
576: --
577: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
578: --
579: chk_elig_fl_tm_pt_tm_prte_id
580: (p_elig_fl_tm_pt_tm_prte_id => p_rec.elig_fl_tm_pt_tm_prte_id,
581: p_effective_date => p_effective_date,

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

667: hr_utility.set_location('Entering:'|| l_proc, 10);
668: --
669: -- Ensure that all the mandatory parameter are not null
670: --
671: hr_api.mandatory_arg_error(p_api_name => l_proc,
672: p_argument => 'elig_fl_tm_pt_tm_prte_id',
673: p_argument_value => p_elig_fl_tm_pt_tm_prte_id);
674: --
675: open csr_leg_code;