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

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

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

Line 133: and enrld_anthr_ptip_rt_id <> nvl(p_enrld_anthr_ptip_rt_id,hr_api.g_number)

129: from ben_enrld_anthr_ptip_rt_f
130: where ptip_id = p_ptip_id
131: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
132: and enrl_det_dt_cd = p_enrl_det_dt_cd
133: and enrld_anthr_ptip_rt_id <> nvl(p_enrld_anthr_ptip_rt_id,hr_api.g_number)
134: and business_group_id + 0 = p_business_group_id
135: and p_validation_start_date <= effective_end_date
136: and p_validation_end_date >= effective_start_date;
137: --

Line 149: (p_ptip_id <> nvl(ben_ent_shd.g_old_rec.ptip_id,hr_api.g_number) or

145: p_object_version_number => p_object_version_number);
146: --
147: if (l_api_updating
148: and
149: (p_ptip_id <> nvl(ben_ent_shd.g_old_rec.ptip_id,hr_api.g_number) or
150: p_enrl_det_dt_cd <> nvl(ben_ent_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)
151: )
152: or not l_api_updating) then
153:

Line 150: p_enrl_det_dt_cd <> nvl(ben_ent_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)

146: --
147: if (l_api_updating
148: and
149: (p_ptip_id <> nvl(ben_ent_shd.g_old_rec.ptip_id,hr_api.g_number) or
150: p_enrl_det_dt_cd <> nvl(ben_ent_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)
151: )
152: or not l_api_updating) then
153:
154: open c_dup;

Line 220: <> nvl(ben_ent_shd.g_old_rec.only_pls_subj_cobra_flag,hr_api.g_varchar2)

216: p_object_version_number => p_object_version_number);
217: --
218: if (l_api_updating
219: and p_only_pls_subj_cobra_flag
220: <> nvl(ben_ent_shd.g_old_rec.only_pls_subj_cobra_flag,hr_api.g_varchar2)
221: or not l_api_updating) then
222: --
223: -- check if value of lookup falls within lookup type.
224: --

Line 226: if hr_api.not_exists_in_hr_lookups

222: --
223: -- check if value of lookup falls within lookup type.
224: --
225: --
226: if hr_api.not_exists_in_hr_lookups
227: (p_lookup_type => 'YES_NO',
228: p_lookup_code => p_only_pls_subj_cobra_flag,
229: p_effective_date => p_effective_date) then
230: --

Line 291: <> nvl(ben_ent_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)

287: p_object_version_number => p_object_version_number);
288: --
289: if (l_api_updating
290: and p_enrl_det_dt_cd
291: <> nvl(ben_ent_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)
292: or not l_api_updating)
293: and p_enrl_det_dt_cd is not null then
294: --
295: -- check if value of lookup falls within lookup type.

Line 297: if hr_api.not_exists_in_hr_lookups

293: and p_enrl_det_dt_cd is not null then
294: --
295: -- check if value of lookup falls within lookup type.
296: --
297: if hr_api.not_exists_in_hr_lookups
298: (p_lookup_type => 'BEN_ENRL_DET_DT',
299: p_lookup_code => p_enrl_det_dt_cd,
300: p_effective_date => p_effective_date) then
301: --

Line 362: <> nvl(ben_ent_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

358: p_object_version_number => p_object_version_number);
359: --
360: if (l_api_updating
361: and p_excld_flag
362: <> nvl(ben_ent_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
363: or not l_api_updating) then
364: --
365: -- check if value of lookup falls within lookup type.
366: --

Line 368: if hr_api.not_exists_in_hr_lookups

364: --
365: -- check if value of lookup falls within lookup type.
366: --
367: --
368: if hr_api.not_exists_in_hr_lookups
369: (p_lookup_type => 'YES_NO',
370: p_lookup_code => p_excld_flag,
371: p_effective_date => p_effective_date) then
372: --

Line 491: (p_vrbl_rt_prfl_id in number default hr_api.g_number,

487: --
488: -- {End Of Comments}
489: -- ----------------------------------------------------------------------------
490: Procedure dt_update_validate
491: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
492: p_ptip_id in number default hr_api.g_number,
493: p_datetrack_mode in varchar2,
494: p_validation_start_date in date,
495: p_validation_end_date in date) Is

Line 492: p_ptip_id in number default hr_api.g_number,

488: -- {End Of Comments}
489: -- ----------------------------------------------------------------------------
490: Procedure dt_update_validate
491: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
492: p_ptip_id in number default hr_api.g_number,
493: p_datetrack_mode in varchar2,
494: p_validation_start_date in date,
495: p_validation_end_date in date) Is
496: --

Line 506: hr_api.mandatory_arg_error

502: hr_utility.set_location('Entering:'||l_proc, 5);
503: --
504: -- Ensure that the p_datetrack_mode argument is not null
505: --
506: hr_api.mandatory_arg_error
507: (p_api_name => l_proc,
508: p_argument => 'datetrack_mode',
509: p_argument_value => p_datetrack_mode);
510: --

Line 518: hr_api.mandatory_arg_error

514: --
515: --
516: -- Ensure the arguments are not null
517: --
518: hr_api.mandatory_arg_error
519: (p_api_name => l_proc,
520: p_argument => 'validation_start_date',
521: p_argument_value => p_validation_start_date);
522: --

Line 523: hr_api.mandatory_arg_error

519: (p_api_name => l_proc,
520: p_argument => 'validation_start_date',
521: p_argument_value => p_validation_start_date);
522: --
523: hr_api.mandatory_arg_error
524: (p_api_name => l_proc,
525: p_argument => 'validation_end_date',
526: p_argument_value => p_validation_end_date);
527: --

Line 528: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

524: (p_api_name => l_proc,
525: p_argument => 'validation_end_date',
526: p_argument_value => p_validation_end_date);
527: --
528: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
529: NOT (dt_api.check_min_max_dates
530: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
531: p_base_key_column => 'vrbl_rt_prfl_id',
532: p_base_key_value => p_vrbl_rt_prfl_id,

Line 538: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and

534: p_to_date => p_validation_end_date))) Then
535: l_table_name := 'ben_vrbl_rt_prfl_f';
536: Raise l_integrity_error;
537: End If;
538: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
539: NOT (dt_api.check_min_max_dates
540: (p_base_table_name => 'ben_ptip_f',
541: p_base_key_column => 'ptip_id',
542: p_base_key_value => p_ptip_id,

Line 621: hr_api.mandatory_arg_error

617: hr_utility.set_location('Entering:'||l_proc, 5);
618: --
619: -- Ensure that the p_datetrack_mode argument is not null
620: --
621: hr_api.mandatory_arg_error
622: (p_api_name => l_proc,
623: p_argument => 'datetrack_mode',
624: p_argument_value => p_datetrack_mode);
625: --

Line 635: hr_api.mandatory_arg_error

631: --
632: --
633: -- Ensure the arguments are not null
634: --
635: hr_api.mandatory_arg_error
636: (p_api_name => l_proc,
637: p_argument => 'validation_start_date',
638: p_argument_value => p_validation_start_date);
639: --

Line 640: hr_api.mandatory_arg_error

636: (p_api_name => l_proc,
637: p_argument => 'validation_start_date',
638: p_argument_value => p_validation_start_date);
639: --
640: hr_api.mandatory_arg_error
641: (p_api_name => l_proc,
642: p_argument => 'validation_end_date',
643: p_argument_value => p_validation_end_date);
644: --

Line 645: hr_api.mandatory_arg_error

641: (p_api_name => l_proc,
642: p_argument => 'validation_end_date',
643: p_argument_value => p_validation_end_date);
644: --
645: hr_api.mandatory_arg_error
646: (p_api_name => l_proc,
647: p_argument => 'enrld_anthr_ptip_rt_id',
648: p_argument_value => p_enrld_anthr_ptip_rt_id);
649: --

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

689: --
690: -- Call all supporting business operations
691: --
692: --
693: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
694: --
695: chk_enrld_anthr_ptip_rt_id
696: (p_enrld_anthr_ptip_rt_id => p_rec.enrld_anthr_ptip_rt_id,
697: p_effective_date => p_effective_date,

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

758: --
759: -- Call all supporting business operations
760: --
761: --
762: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
763: --
764: chk_enrld_anthr_ptip_rt_id
765: (p_enrld_anthr_ptip_rt_id => p_rec.enrld_anthr_ptip_rt_id,
766: p_effective_date => p_effective_date,

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

872: hr_utility.set_location('Entering:'|| l_proc, 10);
873: --
874: -- Ensure that all the mandatory parameter are not null
875: --
876: hr_api.mandatory_arg_error(p_api_name => l_proc,
877: p_argument => 'enrld_anthr_ptip_rt_id',
878: p_argument_value => p_enrld_anthr_ptip_rt_id);
879: --
880: open csr_leg_code;