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

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

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

Line 124: <> nvl(ben_epl_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_epl_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 311: (p_dpnt_cvg_eligy_prfl_id in number default hr_api.g_number,

307: --
308: -- {End Of Comments}
309: -- ----------------------------------------------------------------------------
310: Procedure dt_update_validate
311: (p_dpnt_cvg_eligy_prfl_id in number default hr_api.g_number,
312: p_pstl_zip_rng_id in number default hr_api.g_number,
313: p_datetrack_mode in varchar2,
314: p_validation_start_date in date,
315: p_validation_end_date in date) Is

Line 312: p_pstl_zip_rng_id in number default hr_api.g_number,

308: -- {End Of Comments}
309: -- ----------------------------------------------------------------------------
310: Procedure dt_update_validate
311: (p_dpnt_cvg_eligy_prfl_id in number default hr_api.g_number,
312: p_pstl_zip_rng_id in number default hr_api.g_number,
313: p_datetrack_mode in varchar2,
314: p_validation_start_date in date,
315: p_validation_end_date in date) Is
316: --

Line 326: hr_api.mandatory_arg_error

322: hr_utility.set_location('Entering:'||l_proc, 5);
323: --
324: -- Ensure that the p_datetrack_mode argument is not null
325: --
326: hr_api.mandatory_arg_error
327: (p_api_name => l_proc,
328: p_argument => 'datetrack_mode',
329: p_argument_value => p_datetrack_mode);
330: --

Line 338: hr_api.mandatory_arg_error

334: --
335: --
336: -- Ensure the arguments are not null
337: --
338: hr_api.mandatory_arg_error
339: (p_api_name => l_proc,
340: p_argument => 'validation_start_date',
341: p_argument_value => p_validation_start_date);
342: --

Line 343: hr_api.mandatory_arg_error

339: (p_api_name => l_proc,
340: p_argument => 'validation_start_date',
341: p_argument_value => p_validation_start_date);
342: --
343: hr_api.mandatory_arg_error
344: (p_api_name => l_proc,
345: p_argument => 'validation_end_date',
346: p_argument_value => p_validation_end_date);
347: --

Line 348: If ((nvl(p_dpnt_cvg_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and

344: (p_api_name => l_proc,
345: p_argument => 'validation_end_date',
346: p_argument_value => p_validation_end_date);
347: --
348: If ((nvl(p_dpnt_cvg_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
349: NOT (dt_api.check_min_max_dates
350: (p_base_table_name => 'ben_dpnt_cvg_eligy_prfl_f',
351: p_base_key_column => 'dpnt_cvg_eligy_prfl_id',
352: p_base_key_value => p_dpnt_cvg_eligy_prfl_id,

Line 358: If ((nvl(p_pstl_zip_rng_id, hr_api.g_number) <> hr_api.g_number) and

354: p_to_date => p_validation_end_date))) Then
355: l_table_name := 'ben_dpnt_cvg_eligy_prfl_f';
356: Raise l_integrity_error;
357: End If;
358: If ((nvl(p_pstl_zip_rng_id, hr_api.g_number) <> hr_api.g_number) and
359: NOT (dt_api.check_min_max_dates
360: (p_base_table_name => 'ben_pstl_zip_rng_f',
361: p_base_key_column => 'pstl_zip_rng_id',
362: p_base_key_value => p_pstl_zip_rng_id,

Line 440: hr_api.mandatory_arg_error

436: hr_utility.set_location('Entering:'||l_proc, 5);
437: --
438: -- Ensure that the p_datetrack_mode argument is not null
439: --
440: hr_api.mandatory_arg_error
441: (p_api_name => l_proc,
442: p_argument => 'datetrack_mode',
443: p_argument_value => p_datetrack_mode);
444: --

Line 454: hr_api.mandatory_arg_error

450: --
451: --
452: -- Ensure the arguments are not null
453: --
454: hr_api.mandatory_arg_error
455: (p_api_name => l_proc,
456: p_argument => 'validation_start_date',
457: p_argument_value => p_validation_start_date);
458: --

Line 459: hr_api.mandatory_arg_error

455: (p_api_name => l_proc,
456: p_argument => 'validation_start_date',
457: p_argument_value => p_validation_start_date);
458: --
459: hr_api.mandatory_arg_error
460: (p_api_name => l_proc,
461: p_argument => 'validation_end_date',
462: p_argument_value => p_validation_end_date);
463: --

Line 464: hr_api.mandatory_arg_error

460: (p_api_name => l_proc,
461: p_argument => 'validation_end_date',
462: p_argument_value => p_validation_end_date);
463: --
464: hr_api.mandatory_arg_error
465: (p_api_name => l_proc,
466: p_argument => 'elig_pstl_cd_r_rng_cvg_id',
467: p_argument_value => p_elig_pstl_cd_r_rng_cvg_id);
468: --

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

506: --
507: -- Call all supporting business operations
508: --
509: --
510: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
511: --
512: chk_duplicate_rows
513: (p_elig_pstl_cd_r_rng_cvg_id => p_rec.elig_pstl_cd_r_rng_cvg_id,
514: p_pstl_zip_rng_id => p_rec.pstl_zip_rng_id,

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

558: --
559: -- Call all supporting business operations
560: --
561: --
562: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
563: --
564: chk_duplicate_rows
565: (p_elig_pstl_cd_r_rng_cvg_id => p_rec.elig_pstl_cd_r_rng_cvg_id,
566: p_pstl_zip_rng_id => p_rec.pstl_zip_rng_id,

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

654: hr_utility.set_location('Entering:'|| l_proc, 10);
655: --
656: -- Ensure that all the mandatory parameter are not null
657: --
658: hr_api.mandatory_arg_error(p_api_name => l_proc,
659: p_argument => 'elig_pstl_cd_r_rng_cvg_id',
660: p_argument_value => p_elig_pstl_cd_r_rng_cvg_id);
661: --
662: open csr_leg_code;