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

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

50: p_elig_pstl_cd_r_rng_prte_id => p_elig_pstl_cd_r_rng_prte_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_prte_id,hr_api.g_number)
55: <> ben_epz_shd.g_old_rec.elig_pstl_cd_r_rng_prte_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 134: and elig_pstl_cd_r_rng_prte_id <> nvl(p_elig_pstl_cd_r_rng_prte_id,hr_api.g_number)

130: select null
131: from ben_elig_pstl_cd_r_rng_prte_f
132: where pstl_zip_rng_id = p_pstl_zip_rng_id
133: and eligy_prfl_id = p_eligy_prfl_id
134: and elig_pstl_cd_r_rng_prte_id <> nvl(p_elig_pstl_cd_r_rng_prte_id,hr_api.g_number)
135: and business_group_id + 0 = p_business_group_id
136: and p_validation_start_date <= effective_end_date
137: and p_validation_end_date >= effective_start_date
138: ;

Line 151: and nvl(p_pstl_zip_rng_id,hr_api.g_number)

147: p_effective_date => p_effective_date,
148: p_object_version_number => p_object_version_number);
149: --
150: if (l_api_updating
151: and nvl(p_pstl_zip_rng_id,hr_api.g_number)
152: <> nvl(ben_epz_shd.g_old_rec.pstl_zip_rng_id,hr_api.g_number)
153: or not l_api_updating) then
154: --
155: -- check if pstl_zip_rng_id value exists in ben_pstl_zip_rng_f table

Line 152: <> nvl(ben_epz_shd.g_old_rec.pstl_zip_rng_id,hr_api.g_number)

148: p_object_version_number => p_object_version_number);
149: --
150: if (l_api_updating
151: and nvl(p_pstl_zip_rng_id,hr_api.g_number)
152: <> nvl(ben_epz_shd.g_old_rec.pstl_zip_rng_id,hr_api.g_number)
153: or not l_api_updating) then
154: --
155: -- check if pstl_zip_rng_id value exists in ben_pstl_zip_rng_f table
156: --

Line 239: <> nvl(ben_epz_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

235: p_object_version_number => p_object_version_number);
236: --
237: if (l_api_updating
238: and p_excld_flag
239: <> nvl(ben_epz_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
240: or not l_api_updating) then
241: --
242: -- check if value of lookup falls within lookup type.
243: --

Line 245: if hr_api.not_exists_in_hr_lookups

241: --
242: -- check if value of lookup falls within lookup type.
243: --
244: --
245: if hr_api.not_exists_in_hr_lookups
246: (p_lookup_type => 'YES_NO',
247: p_lookup_code => p_excld_flag,
248: p_effective_date => p_effective_date) then
249: --

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

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

Line 353: p_pstl_zip_rng_id in number default hr_api.g_number,

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

Line 367: hr_api.mandatory_arg_error

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

Line 379: hr_api.mandatory_arg_error

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

Line 384: hr_api.mandatory_arg_error

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

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

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

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

395: p_to_date => p_validation_end_date))) Then
396: l_table_name := 'ben_eligy_prfl_f';
397: Raise l_integrity_error;
398: End If;
399: If ((nvl(p_pstl_zip_rng_id, hr_api.g_number) <> hr_api.g_number) and
400: NOT (dt_api.check_min_max_dates
401: (p_base_table_name => 'ben_pstl_zip_rng_f',
402: p_base_key_column => 'pstl_zip_rng_id',
403: p_base_key_value => p_pstl_zip_rng_id,

Line 483: hr_api.mandatory_arg_error

479: hr_utility.set_location('Entering:'||l_proc, 5);
480: --
481: -- Ensure that the p_datetrack_mode argument is not null
482: --
483: hr_api.mandatory_arg_error
484: (p_api_name => l_proc,
485: p_argument => 'datetrack_mode',
486: p_argument_value => p_datetrack_mode);
487: --

Line 497: hr_api.mandatory_arg_error

493: --
494: --
495: -- Ensure the arguments are not null
496: --
497: hr_api.mandatory_arg_error
498: (p_api_name => l_proc,
499: p_argument => 'validation_start_date',
500: p_argument_value => p_validation_start_date);
501: --

Line 502: hr_api.mandatory_arg_error

498: (p_api_name => l_proc,
499: p_argument => 'validation_start_date',
500: p_argument_value => p_validation_start_date);
501: --
502: hr_api.mandatory_arg_error
503: (p_api_name => l_proc,
504: p_argument => 'validation_end_date',
505: p_argument_value => p_validation_end_date);
506: --

Line 507: hr_api.mandatory_arg_error

503: (p_api_name => l_proc,
504: p_argument => 'validation_end_date',
505: p_argument_value => p_validation_end_date);
506: --
507: hr_api.mandatory_arg_error
508: (p_api_name => l_proc,
509: p_argument => 'elig_pstl_cd_r_rng_prte_id',
510: p_argument_value => p_elig_pstl_cd_r_rng_prte_id);
511: --

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

551: --
552: -- Call all supporting business operations
553: --
554: --
555: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
556: --
557: chk_elig_pstl_cd_r_rng_prte_id
558: (p_elig_pstl_cd_r_rng_prte_id => p_rec.elig_pstl_cd_r_rng_prte_id,
559: p_effective_date => p_effective_date,

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

600: --
601: -- Call all supporting business operations
602: --
603: --
604: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
605: --
606: chk_elig_pstl_cd_r_rng_prte_id
607: (p_elig_pstl_cd_r_rng_prte_id => p_rec.elig_pstl_cd_r_rng_prte_id,
608: p_effective_date => p_effective_date,

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

694: hr_utility.set_location('Entering:'|| l_proc, 10);
695: --
696: -- Ensure that all the mandatory parameter are not null
697: --
698: hr_api.mandatory_arg_error(p_api_name => l_proc,
699: p_argument => 'elig_pstl_cd_r_rng_prte_id',
700: p_argument_value => p_elig_pstl_cd_r_rng_prte_id);
701: --
702: open csr_leg_code;