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

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

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

Line 124: and elig_cmbn_age_los_prte_id <> nvl(p_elig_cmbn_age_los_prte_id,hr_api.g_number)

120: select null
121: from ben_elig_cmbn_age_los_prte_f
122: where cmbn_age_los_fctr_id = p_cmbn_age_los_fctr_id
123: and eligy_prfl_id = p_eligy_prfl_id
124: and elig_cmbn_age_los_prte_id <> nvl(p_elig_cmbn_age_los_prte_id,hr_api.g_number)
125: and business_group_id + 0 = p_business_group_id
126: and p_validation_start_date <= effective_end_date
127: and p_validation_end_date >= effective_start_date
128: ;

Line 147: and nvl(p_cmbn_age_los_fctr_id,hr_api.g_number)

143: p_effective_date => p_effective_date,
144: p_object_version_number => p_object_version_number);
145: --
146: if (l_api_updating
147: and nvl(p_cmbn_age_los_fctr_id,hr_api.g_number)
148: <> nvl(ben_ecp_shd.g_old_rec.cmbn_age_los_fctr_id,hr_api.g_number)
149: or not l_api_updating) then
150: --
151: -- check if cmbn_age_los_fctr_id value exists in ben_cmbn_age_los_fctr table

Line 148: <> nvl(ben_ecp_shd.g_old_rec.cmbn_age_los_fctr_id,hr_api.g_number)

144: p_object_version_number => p_object_version_number);
145: --
146: if (l_api_updating
147: and nvl(p_cmbn_age_los_fctr_id,hr_api.g_number)
148: <> nvl(ben_ecp_shd.g_old_rec.cmbn_age_los_fctr_id,hr_api.g_number)
149: or not l_api_updating) then
150: --
151: -- check if cmbn_age_los_fctr_id value exists in ben_cmbn_age_los_fctr table
152: --

Line 233: <> nvl(ben_ecp_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)

229: p_object_version_number => p_object_version_number);
230: --
231: if (l_api_updating
232: and p_mndtry_flag
233: <> nvl(ben_ecp_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)
234: or not l_api_updating) then
235: --
236: -- check if value of lookup falls within lookup type.
237: --

Line 239: if hr_api.not_exists_in_hr_lookups

235: --
236: -- check if value of lookup falls within lookup type.
237: --
238: --
239: if hr_api.not_exists_in_hr_lookups
240: (p_lookup_type => 'YES_NO',
241: p_lookup_code => p_mndtry_flag,
242: p_effective_date => p_effective_date) then
243: --

Line 302: <> nvl(ben_ecp_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

298: p_object_version_number => p_object_version_number);
299: --
300: if (l_api_updating
301: and p_excld_flag
302: <> nvl(ben_ecp_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
303: or not l_api_updating) then
304: --
305: -- check if value of lookup falls within lookup type.
306: --

Line 308: if hr_api.not_exists_in_hr_lookups

304: --
305: -- check if value of lookup falls within lookup type.
306: --
307: --
308: if hr_api.not_exists_in_hr_lookups
309: (p_lookup_type => 'YES_NO',
310: p_lookup_code => p_excld_flag,
311: p_effective_date => p_effective_date) then
312: --

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

410: --
411: -- {End Of Comments}
412: -- ----------------------------------------------------------------------------
413: Procedure dt_update_validate
414: (p_eligy_prfl_id in number default hr_api.g_number,
415: p_datetrack_mode in varchar2,
416: p_validation_start_date in date,
417: p_validation_end_date in date) Is
418: --

Line 428: hr_api.mandatory_arg_error

424: hr_utility.set_location('Entering:'||l_proc, 5);
425: --
426: -- Ensure that the p_datetrack_mode argument is not null
427: --
428: hr_api.mandatory_arg_error
429: (p_api_name => l_proc,
430: p_argument => 'datetrack_mode',
431: p_argument_value => p_datetrack_mode);
432: --

Line 440: hr_api.mandatory_arg_error

436: --
437: --
438: -- Ensure the arguments are not null
439: --
440: hr_api.mandatory_arg_error
441: (p_api_name => l_proc,
442: p_argument => 'validation_start_date',
443: p_argument_value => p_validation_start_date);
444: --

Line 445: hr_api.mandatory_arg_error

441: (p_api_name => l_proc,
442: p_argument => 'validation_start_date',
443: p_argument_value => p_validation_start_date);
444: --
445: hr_api.mandatory_arg_error
446: (p_api_name => l_proc,
447: p_argument => 'validation_end_date',
448: p_argument_value => p_validation_end_date);
449: --

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

446: (p_api_name => l_proc,
447: p_argument => 'validation_end_date',
448: p_argument_value => p_validation_end_date);
449: --
450: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
451: NOT (dt_api.check_min_max_dates
452: (p_base_table_name => 'ben_eligy_prfl_f',
453: p_base_key_column => 'eligy_prfl_id',
454: p_base_key_value => p_eligy_prfl_id,

Line 533: hr_api.mandatory_arg_error

529: hr_utility.set_location('Entering:'||l_proc, 5);
530: --
531: -- Ensure that the p_datetrack_mode argument is not null
532: --
533: hr_api.mandatory_arg_error
534: (p_api_name => l_proc,
535: p_argument => 'datetrack_mode',
536: p_argument_value => p_datetrack_mode);
537: --

Line 547: hr_api.mandatory_arg_error

543: --
544: --
545: -- Ensure the arguments are not null
546: --
547: hr_api.mandatory_arg_error
548: (p_api_name => l_proc,
549: p_argument => 'validation_start_date',
550: p_argument_value => p_validation_start_date);
551: --

Line 552: hr_api.mandatory_arg_error

548: (p_api_name => l_proc,
549: p_argument => 'validation_start_date',
550: p_argument_value => p_validation_start_date);
551: --
552: hr_api.mandatory_arg_error
553: (p_api_name => l_proc,
554: p_argument => 'validation_end_date',
555: p_argument_value => p_validation_end_date);
556: --

Line 557: hr_api.mandatory_arg_error

553: (p_api_name => l_proc,
554: p_argument => 'validation_end_date',
555: p_argument_value => p_validation_end_date);
556: --
557: hr_api.mandatory_arg_error
558: (p_api_name => l_proc,
559: p_argument => 'elig_cmbn_age_los_prte_id',
560: p_argument_value => p_elig_cmbn_age_los_prte_id);
561: --

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_cmbn_age_los_prte_id
607: (p_elig_cmbn_age_los_prte_id => p_rec.elig_cmbn_age_los_prte_id,
608: p_effective_date => p_effective_date,

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

656: --
657: -- Call all supporting business operations
658: --
659: --
660: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
661: --
662: chk_elig_cmbn_age_los_prte_id
663: (p_elig_cmbn_age_los_prte_id => p_rec.elig_cmbn_age_los_prte_id,
664: p_effective_date => p_effective_date,

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

756: hr_utility.set_location('Entering:'|| l_proc, 10);
757: --
758: -- Ensure that all the mandatory parameter are not null
759: --
760: hr_api.mandatory_arg_error(p_api_name => l_proc,
761: p_argument => 'elig_cmbn_age_los_prte_id',
762: p_argument_value => p_elig_cmbn_age_los_prte_id);
763: --
764: open csr_leg_code;