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

Line 123: and nvl(p_elig_per_typ_prte_id,hr_api.g_number)

119: p_elig_per_typ_prte_id => p_elig_per_typ_prte_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_elig_per_typ_prte_id,hr_api.g_number)
124: <> ben_ept_shd.g_old_rec.elig_per_typ_prte_id) then
125: --
126: -- raise error as PK has changed
127: --

Line 208: and elig_per_typ_prte_id <> nvl(p_elig_per_typ_prte_id,hr_api.g_number)

204: select null
205: from ben_elig_per_typ_prte_f
206: where per_typ_cd = p_per_typ_cd
207: and eligy_prfl_id = p_eligy_prfl_id
208: and elig_per_typ_prte_id <> nvl(p_elig_per_typ_prte_id,hr_api.g_number)
209: and business_group_id + 0 = p_business_group_id
210: and p_validation_start_date <= effective_end_date
211: and p_validation_end_date >= effective_start_date
212: ;

Line 264: and nvl(p_per_typ_cd,hr_api.g_number)

260: p_effective_date => p_effective_date,
261: p_object_version_number => p_object_version_number);
262: --
263: if (l_api_updating
264: and nvl(p_per_typ_cd,hr_api.g_number)
265: <> nvl(ben_ept_shd.g_old_rec.per_typ_cd,hr_api.g_number)
266: or not l_api_updating) then
267: --
268: -- check if per_typ_cd value exists in per_person_types table

Line 265: <> nvl(ben_ept_shd.g_old_rec.per_typ_cd,hr_api.g_number)

261: p_object_version_number => p_object_version_number);
262: --
263: if (l_api_updating
264: and nvl(p_per_typ_cd,hr_api.g_number)
265: <> nvl(ben_ept_shd.g_old_rec.per_typ_cd,hr_api.g_number)
266: or not l_api_updating) then
267: --
268: -- check if per_typ_cd value exists in per_person_types table
269: --

Line 400: <>nvl(ben_ept_shd.g_old_rec.per_typ_cd,hr_api.g_varchar2)

396: --
397: /* --
398: if (l_api_updating
399: and p_per_typ_cd
400: <>nvl(ben_ept_shd.g_old_rec.per_typ_cd,hr_api.g_varchar2)
401: or not l_api_updating)
402: and p_per_typ_cd is not null then
403: -- */
404: --

Line 407: <>nvl(ben_ept_shd.g_old_rec.person_type_id,hr_api.g_number)

403: -- */
404: --
405: if (l_api_updating
406: and p_person_type_id
407: <>nvl(ben_ept_shd.g_old_rec.person_type_id,hr_api.g_number)
408: or not l_api_updating)
409: and p_person_type_id is not null then
410: --
411: open c1;

Line 477: <> nvl(ben_ept_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

473: p_object_version_number => p_object_version_number);
474: --
475: if (l_api_updating
476: and p_excld_flag
477: <> nvl(ben_ept_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
478: or not l_api_updating) then
479: --
480: -- check if value of lookup falls within lookup type.
481: --

Line 483: if hr_api.not_exists_in_hr_lookups

479: --
480: -- check if value of lookup falls within lookup type.
481: --
482: --
483: if hr_api.not_exists_in_hr_lookups
484: (p_lookup_type => 'YES_NO',
485: p_lookup_code => p_excld_flag,
486: p_effective_date => p_effective_date) then
487: --

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

585: --
586: -- {End Of Comments}
587: -- ----------------------------------------------------------------------------
588: Procedure dt_update_validate
589: (p_eligy_prfl_id in number default hr_api.g_number,
590: p_datetrack_mode in varchar2,
591: p_validation_start_date in date,
592: p_validation_end_date in date) Is
593: --

Line 603: hr_api.mandatory_arg_error

599: hr_utility.set_location('Entering:'||l_proc, 5);
600: --
601: -- Ensure that the p_datetrack_mode argument is not null
602: --
603: hr_api.mandatory_arg_error
604: (p_api_name => l_proc,
605: p_argument => 'datetrack_mode',
606: p_argument_value => p_datetrack_mode);
607: --

Line 615: hr_api.mandatory_arg_error

611: --
612: --
613: -- Ensure the arguments are not null
614: --
615: hr_api.mandatory_arg_error
616: (p_api_name => l_proc,
617: p_argument => 'validation_start_date',
618: p_argument_value => p_validation_start_date);
619: --

Line 620: hr_api.mandatory_arg_error

616: (p_api_name => l_proc,
617: p_argument => 'validation_start_date',
618: p_argument_value => p_validation_start_date);
619: --
620: hr_api.mandatory_arg_error
621: (p_api_name => l_proc,
622: p_argument => 'validation_end_date',
623: p_argument_value => p_validation_end_date);
624: --

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

621: (p_api_name => l_proc,
622: p_argument => 'validation_end_date',
623: p_argument_value => p_validation_end_date);
624: --
625: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
626: NOT (dt_api.check_min_max_dates
627: (p_base_table_name => 'ben_eligy_prfl_f',
628: p_base_key_column => 'eligy_prfl_id',
629: p_base_key_value => p_eligy_prfl_id,

Line 709: hr_api.mandatory_arg_error

705: hr_utility.set_location('Entering:'||l_proc, 5);
706: --
707: -- Ensure that the p_datetrack_mode argument is not null
708: --
709: hr_api.mandatory_arg_error
710: (p_api_name => l_proc,
711: p_argument => 'datetrack_mode',
712: p_argument_value => p_datetrack_mode);
713: --

Line 723: hr_api.mandatory_arg_error

719: --
720: --
721: -- Ensure the arguments are not null
722: --
723: hr_api.mandatory_arg_error
724: (p_api_name => l_proc,
725: p_argument => 'validation_start_date',
726: p_argument_value => p_validation_start_date);
727: --

Line 728: hr_api.mandatory_arg_error

724: (p_api_name => l_proc,
725: p_argument => 'validation_start_date',
726: p_argument_value => p_validation_start_date);
727: --
728: hr_api.mandatory_arg_error
729: (p_api_name => l_proc,
730: p_argument => 'validation_end_date',
731: p_argument_value => p_validation_end_date);
732: --

Line 733: hr_api.mandatory_arg_error

729: (p_api_name => l_proc,
730: p_argument => 'validation_end_date',
731: p_argument_value => p_validation_end_date);
732: --
733: hr_api.mandatory_arg_error
734: (p_api_name => l_proc,
735: p_argument => 'elig_per_typ_prte_id',
736: p_argument_value => p_elig_per_typ_prte_id);
737: --

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

777: --
778: -- Call all supporting business operations
779: --
780: --
781: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
782: --
783:
784: --Bug No 5054294
785: chk_valid_fctr(p_eligy_prfl_id => p_rec.eligy_prfl_id,

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

840: --
841: -- Call all supporting business operations
842: --
843: --
844: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
845: --
846:
847: --Bug 5054294
848: chk_valid_fctr(p_eligy_prfl_id => p_rec.eligy_prfl_id,

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

947: hr_utility.set_location('Entering:'|| l_proc, 10);
948: --
949: -- Ensure that all the mandatory parameter are not null
950: --
951: hr_api.mandatory_arg_error(p_api_name => l_proc,
952: p_argument => 'elig_per_typ_prte_id',
953: p_argument_value => p_elig_per_typ_prte_id);
954: --
955: open csr_leg_code;