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

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

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

Line 124: <> nvl(ben_esa_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_esa_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 195: and esa.ELIG_SVC_AREA_PRTE_ID <> nvl(p_elig_svc_area_prte_id, hr_api.g_number)

191: select null
192: from ben_elig_svc_area_prte_f esa
193: where esa.eligy_prfl_id = p_eligy_prfl_id
194: and esa.svc_area_id = p_svc_area_id
195: and esa.ELIG_SVC_AREA_PRTE_ID <> nvl(p_elig_svc_area_prte_id, hr_api.g_number)
196: and esa.business_group_id= p_business_group_id
197: and ((p_effective_date between esa.effective_start_date and esa.effective_end_date)
198: or (esa.effective_start_date > p_effective_date)) ;
199: --

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

319: --
320: -- {End Of Comments}
321: -- ----------------------------------------------------------------------------
322: Procedure dt_update_validate
323: (p_eligy_prfl_id in number default hr_api.g_number,
324: p_svc_area_id in number default hr_api.g_number,
325: p_datetrack_mode in varchar2,
326: p_validation_start_date in date,
327: p_validation_end_date in date) Is

Line 324: p_svc_area_id in number default hr_api.g_number,

320: -- {End Of Comments}
321: -- ----------------------------------------------------------------------------
322: Procedure dt_update_validate
323: (p_eligy_prfl_id in number default hr_api.g_number,
324: p_svc_area_id in number default hr_api.g_number,
325: p_datetrack_mode in varchar2,
326: p_validation_start_date in date,
327: p_validation_end_date in date) Is
328: --

Line 338: hr_api.mandatory_arg_error

334: hr_utility.set_location('Entering:'||l_proc, 5);
335: --
336: -- Ensure that the p_datetrack_mode argument is not null
337: --
338: hr_api.mandatory_arg_error
339: (p_api_name => l_proc,
340: p_argument => 'datetrack_mode',
341: p_argument_value => p_datetrack_mode);
342: --

Line 350: hr_api.mandatory_arg_error

346: --
347: --
348: -- Ensure the arguments are not null
349: --
350: hr_api.mandatory_arg_error
351: (p_api_name => l_proc,
352: p_argument => 'validation_start_date',
353: p_argument_value => p_validation_start_date);
354: --

Line 355: hr_api.mandatory_arg_error

351: (p_api_name => l_proc,
352: p_argument => 'validation_start_date',
353: p_argument_value => p_validation_start_date);
354: --
355: hr_api.mandatory_arg_error
356: (p_api_name => l_proc,
357: p_argument => 'validation_end_date',
358: p_argument_value => p_validation_end_date);
359: --

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

356: (p_api_name => l_proc,
357: p_argument => 'validation_end_date',
358: p_argument_value => p_validation_end_date);
359: --
360: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
361: NOT (dt_api.check_min_max_dates
362: (p_base_table_name => 'ben_eligy_prfl_f',
363: p_base_key_column => 'eligy_prfl_id',
364: p_base_key_value => p_eligy_prfl_id,

Line 370: If ((nvl(p_svc_area_id, hr_api.g_number) <> hr_api.g_number) and

366: p_to_date => p_validation_end_date))) Then
367: l_table_name := 'ben_eligy_prfl_f';
368: Raise l_integrity_error;
369: End If;
370: If ((nvl(p_svc_area_id, hr_api.g_number) <> hr_api.g_number) and
371: NOT (dt_api.check_min_max_dates
372: (p_base_table_name => 'ben_svc_area_f',
373: p_base_key_column => 'svc_area_id',
374: p_base_key_value => p_svc_area_id,

Line 453: hr_api.mandatory_arg_error

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

Line 467: hr_api.mandatory_arg_error

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

Line 472: hr_api.mandatory_arg_error

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

Line 477: hr_api.mandatory_arg_error

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

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

520: --
521: -- Call all supporting business operations
522: --
523: --
524: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
525: --
526: chk_elig_svc_area_prte_id
527: (p_elig_svc_area_prte_id => p_rec.elig_svc_area_prte_id,
528: p_effective_date => p_effective_date,

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

570: --
571: -- Call all supporting business operations
572: --
573: --
574: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
575: --
576: chk_elig_svc_area_prte_id
577: (p_elig_svc_area_prte_id => p_rec.elig_svc_area_prte_id,
578: 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_svc_area_prte_id',
673: p_argument_value => p_elig_svc_area_prte_id);
674: --
675: open csr_leg_code;