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

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

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

Line 132: and nvl(p_position_id,hr_api.g_number)

128: p_effective_date => p_effective_date,
129: p_object_version_number => p_object_version_number);
130: --
131: if (l_api_updating
132: and nvl(p_position_id,hr_api.g_number)
133: <> nvl(ben_eps_shd.g_old_rec.position_id,hr_api.g_number)
134: or not l_api_updating)
135: and p_position_id is not null then
136: --

Line 133: <> nvl(ben_eps_shd.g_old_rec.position_id,hr_api.g_number)

129: p_object_version_number => p_object_version_number);
130: --
131: if (l_api_updating
132: and nvl(p_position_id,hr_api.g_number)
133: <> nvl(ben_eps_shd.g_old_rec.position_id,hr_api.g_number)
134: or not l_api_updating)
135: and p_position_id is not null then
136: --
137: -- check if position_id value exists in

Line 207: <> nvl(ben_eps_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

203: p_object_version_number => p_object_version_number);
204: --
205: if (l_api_updating
206: and p_excld_flag
207: <> nvl(ben_eps_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
208: or not l_api_updating) then
209: --
210: -- check if value of lookup falls within lookup type.
211: --

Line 213: if hr_api.not_exists_in_hr_lookups

209: --
210: -- check if value of lookup falls within lookup type.
211: --
212: --
213: if hr_api.not_exists_in_hr_lookups
214: (p_lookup_type => 'YES_NO',
215: p_lookup_code => p_excld_flag,
216: p_effective_date => p_effective_date) then
217: --

Line 271: and eps.elig_pstn_prte_id <> nvl(p_elig_pstn_prte_id, hr_api.g_number) ;

267: select null
268: from ben_elig_pstn_prte_f eps
269: where eps.eligy_prfl_id = p_eligy_prfl_id
270: and eps.position_id = p_position_id
271: and eps.elig_pstn_prte_id <> nvl(p_elig_pstn_prte_id, hr_api.g_number) ;
272: --
273: Begin
274: --
275: hr_utility.set_location('Entering:'||l_proc, 5);

Line 393: p_eligy_prfl_id in number default hr_api.g_number,

389: -- {End Of Comments}
390: -- ----------------------------------------------------------------------------
391: Procedure dt_update_validate
392: (
393: p_eligy_prfl_id in number default hr_api.g_number,
394: p_position_id in number default hr_api.g_number,
395: p_datetrack_mode in varchar2,
396: p_validation_start_date in date,
397: p_validation_end_date in date) Is

Line 394: p_position_id in number default hr_api.g_number,

390: -- ----------------------------------------------------------------------------
391: Procedure dt_update_validate
392: (
393: p_eligy_prfl_id in number default hr_api.g_number,
394: p_position_id in number default hr_api.g_number,
395: p_datetrack_mode in varchar2,
396: p_validation_start_date in date,
397: p_validation_end_date in date) Is
398: --

Line 408: hr_api.mandatory_arg_error

404: hr_utility.set_location('Entering:'||l_proc, 5);
405: --
406: -- Ensure that the p_datetrack_mode argument is not null
407: --
408: hr_api.mandatory_arg_error
409: (p_api_name => l_proc,
410: p_argument => 'datetrack_mode',
411: p_argument_value => p_datetrack_mode);
412: --

Line 420: hr_api.mandatory_arg_error

416: --
417: --
418: -- Ensure the arguments are not null
419: --
420: hr_api.mandatory_arg_error
421: (p_api_name => l_proc,
422: p_argument => 'validation_start_date',
423: p_argument_value => p_validation_start_date);
424: --

Line 425: hr_api.mandatory_arg_error

421: (p_api_name => l_proc,
422: p_argument => 'validation_start_date',
423: p_argument_value => p_validation_start_date);
424: --
425: hr_api.mandatory_arg_error
426: (p_api_name => l_proc,
427: p_argument => 'validation_end_date',
428: p_argument_value => p_validation_end_date);
429: --

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

426: (p_api_name => l_proc,
427: p_argument => 'validation_end_date',
428: p_argument_value => p_validation_end_date);
429: --
430: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
431: NOT (dt_api.check_min_max_dates
432: (p_base_table_name => 'ben_eligy_prfl_f',
433: p_base_key_column => 'eligy_prfl_id',
434: p_base_key_value => p_eligy_prfl_id,

Line 512: hr_api.mandatory_arg_error

508: hr_utility.set_location('Entering:'||l_proc, 5);
509: --
510: -- Ensure that the p_datetrack_mode argument is not null
511: --
512: hr_api.mandatory_arg_error
513: (p_api_name => l_proc,
514: p_argument => 'datetrack_mode',
515: p_argument_value => p_datetrack_mode);
516: --

Line 526: hr_api.mandatory_arg_error

522: --
523: --
524: -- Ensure the arguments are not null
525: --
526: hr_api.mandatory_arg_error
527: (p_api_name => l_proc,
528: p_argument => 'validation_start_date',
529: p_argument_value => p_validation_start_date);
530: --

Line 531: hr_api.mandatory_arg_error

527: (p_api_name => l_proc,
528: p_argument => 'validation_start_date',
529: p_argument_value => p_validation_start_date);
530: --
531: hr_api.mandatory_arg_error
532: (p_api_name => l_proc,
533: p_argument => 'validation_end_date',
534: p_argument_value => p_validation_end_date);
535: --

Line 536: hr_api.mandatory_arg_error

532: (p_api_name => l_proc,
533: p_argument => 'validation_end_date',
534: p_argument_value => p_validation_end_date);
535: --
536: hr_api.mandatory_arg_error
537: (p_api_name => l_proc,
538: p_argument => 'elig_pstn_prte_id',
539: p_argument_value => p_elig_pstn_prte_id);
540: --

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

601: p_position_id => p_rec.position_id,
602: p_effective_date => p_effective_date,
603: p_object_version_number => p_rec.object_version_number);
604: --
605: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
606: --
607: hr_utility.set_location(' Leaving:'||l_proc, 10);
608: End insert_validate;
609: --

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

647: p_position_id => p_rec.position_id,
648: p_effective_date => p_effective_date,
649: p_object_version_number => p_rec.object_version_number);
650: --
651: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
652: --
653: -- Call the datetrack update integrity operation
654: --
655: dt_update_validate

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

716: hr_utility.set_location('Entering:'|| l_proc, 10);
717: --
718: -- Ensure that all the mandatory parameter are not null
719: --
720: hr_api.mandatory_arg_error(p_api_name => l_proc,
721: p_argument => 'elig_pstn_prte_id',
722: p_argument_value => p_elig_pstn_prte_id);
723: --
724: open csr_leg_code;