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

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

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

Line 124: <> nvl(ben_dop_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_enrl_det_dt_cd
124: <> nvl(ben_dop_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_enrl_det_dt_cd is not null then
127: --
128: -- check if value of lookup falls within lookup type.

Line 130: if hr_api.not_exists_in_hr_lookups

126: and p_enrl_det_dt_cd is not null then
127: --
128: -- check if value of lookup falls within lookup type.
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'BEN_ENRL_DET_DT',
132: p_lookup_code => p_enrl_det_dt_cd,
133: p_effective_date => p_effective_date) then
134: --

Line 195: <> nvl(ben_dop_shd.g_old_rec.only_pls_subj_cobra_flag,hr_api.g_varchar2)

191: p_object_version_number => p_object_version_number);
192: --
193: if (l_api_updating
194: and p_only_pls_subj_cobra_flag
195: <> nvl(ben_dop_shd.g_old_rec.only_pls_subj_cobra_flag,hr_api.g_varchar2)
196: or not l_api_updating) then
197: --
198: -- check if value of lookup falls within lookup type.
199: --

Line 201: if hr_api.not_exists_in_hr_lookups

197: --
198: -- check if value of lookup falls within lookup type.
199: --
200: --
201: if hr_api.not_exists_in_hr_lookups
202: (p_lookup_type => 'YES_NO',
203: p_lookup_code => p_only_pls_subj_cobra_flag,
204: p_effective_date => p_effective_date) then
205: --

Line 272: and dpnt_cvrd_othr_pgm_rt_id <> nvl(p_dpnt_cvrd_othr_pgm_rt_id,hr_api.g_number)

268: from ben_dpnt_cvrd_othr_pgm_rt_f
269: where pgm_id = p_pgm_id
270: and enrl_det_dt_cd = p_enrl_det_dt_cd
271: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
272: and dpnt_cvrd_othr_pgm_rt_id <> nvl(p_dpnt_cvrd_othr_pgm_rt_id,hr_api.g_number)
273: and business_group_id + 0 = p_business_group_id
274: and p_validation_start_date <= effective_end_date
275: and p_validation_end_date >= effective_start_date;
276: --

Line 287: and (p_pgm_id <> nvl(ben_dop_shd.g_old_rec.pgm_id,hr_api.g_number)

283: p_effective_date => p_effective_date,
284: p_object_version_number => p_object_version_number);
285: --
286: if (l_api_updating
287: and (p_pgm_id <> nvl(ben_dop_shd.g_old_rec.pgm_id,hr_api.g_number)
288: or p_enrl_det_dt_cd <> nvl(ben_dco_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2))
289: or not l_api_updating) then
290:
291: open c_dup;

Line 288: or p_enrl_det_dt_cd <> nvl(ben_dco_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2))

284: p_object_version_number => p_object_version_number);
285: --
286: if (l_api_updating
287: and (p_pgm_id <> nvl(ben_dop_shd.g_old_rec.pgm_id,hr_api.g_number)
288: or p_enrl_det_dt_cd <> nvl(ben_dco_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2))
289: or not l_api_updating) then
290:
291: open c_dup;
292: fetch c_dup into l_exists;

Line 357: <> nvl(ben_dop_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

353: p_object_version_number => p_object_version_number);
354: --
355: if (l_api_updating
356: and p_excld_flag
357: <> nvl(ben_dop_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
358: or not l_api_updating) then
359: --
360: -- check if value of lookup falls within lookup type.
361: --

Line 363: if hr_api.not_exists_in_hr_lookups

359: --
360: -- check if value of lookup falls within lookup type.
361: --
362: --
363: if hr_api.not_exists_in_hr_lookups
364: (p_lookup_type => 'YES_NO',
365: p_lookup_code => p_excld_flag,
366: p_effective_date => p_effective_date) then
367: --

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

481: --
482: -- {End Of Comments}
483: -- ----------------------------------------------------------------------------
484: Procedure dt_update_validate
485: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
486: p_pgm_id in number default hr_api.g_number,
487: p_datetrack_mode in varchar2,
488: p_validation_start_date in date,
489: p_validation_end_date in date) Is

Line 486: p_pgm_id in number default hr_api.g_number,

482: -- {End Of Comments}
483: -- ----------------------------------------------------------------------------
484: Procedure dt_update_validate
485: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
486: p_pgm_id in number default hr_api.g_number,
487: p_datetrack_mode in varchar2,
488: p_validation_start_date in date,
489: p_validation_end_date in date) Is
490: --

Line 500: hr_api.mandatory_arg_error

496: hr_utility.set_location('Entering:'||l_proc, 5);
497: --
498: -- Ensure that the p_datetrack_mode argument is not null
499: --
500: hr_api.mandatory_arg_error
501: (p_api_name => l_proc,
502: p_argument => 'datetrack_mode',
503: p_argument_value => p_datetrack_mode);
504: --

Line 512: hr_api.mandatory_arg_error

508: --
509: --
510: -- Ensure the arguments are not null
511: --
512: hr_api.mandatory_arg_error
513: (p_api_name => l_proc,
514: p_argument => 'validation_start_date',
515: p_argument_value => p_validation_start_date);
516: --

Line 517: hr_api.mandatory_arg_error

513: (p_api_name => l_proc,
514: p_argument => 'validation_start_date',
515: p_argument_value => p_validation_start_date);
516: --
517: hr_api.mandatory_arg_error
518: (p_api_name => l_proc,
519: p_argument => 'validation_end_date',
520: p_argument_value => p_validation_end_date);
521: --

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

518: (p_api_name => l_proc,
519: p_argument => 'validation_end_date',
520: p_argument_value => p_validation_end_date);
521: --
522: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
523: NOT (dt_api.check_min_max_dates
524: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
525: p_base_key_column => 'vrbl_rt_prfl_id',
526: p_base_key_value => p_vrbl_rt_prfl_id,

Line 532: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and

528: p_to_date => p_validation_end_date))) Then
529: l_table_name := 'ben_vrbl_rt_prfl_f';
530: Raise l_integrity_error;
531: End If;
532: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
533: NOT (dt_api.check_min_max_dates
534: (p_base_table_name => 'ben_pgm_f',
535: p_base_key_column => 'pgm_id',
536: p_base_key_value => p_pgm_id,

Line 615: hr_api.mandatory_arg_error

611: hr_utility.set_location('Entering:'||l_proc, 5);
612: --
613: -- Ensure that the p_datetrack_mode argument is not null
614: --
615: hr_api.mandatory_arg_error
616: (p_api_name => l_proc,
617: p_argument => 'datetrack_mode',
618: p_argument_value => p_datetrack_mode);
619: --

Line 629: hr_api.mandatory_arg_error

625: --
626: --
627: -- Ensure the arguments are not null
628: --
629: hr_api.mandatory_arg_error
630: (p_api_name => l_proc,
631: p_argument => 'validation_start_date',
632: p_argument_value => p_validation_start_date);
633: --

Line 634: hr_api.mandatory_arg_error

630: (p_api_name => l_proc,
631: p_argument => 'validation_start_date',
632: p_argument_value => p_validation_start_date);
633: --
634: hr_api.mandatory_arg_error
635: (p_api_name => l_proc,
636: p_argument => 'validation_end_date',
637: p_argument_value => p_validation_end_date);
638: --

Line 639: hr_api.mandatory_arg_error

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

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

683: --
684: -- Call all supporting business operations
685: --
686: --
687: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
688: --
689: chk_dpnt_cvrd_othr_pgm_rt_id
690: (p_dpnt_cvrd_othr_pgm_rt_id => p_rec.dpnt_cvrd_othr_pgm_rt_id,
691: p_effective_date => p_effective_date,

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

750: --
751: -- Call all supporting business operations
752: --
753: --
754: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
755: --
756: chk_dpnt_cvrd_othr_pgm_rt_id
757: (p_dpnt_cvrd_othr_pgm_rt_id => p_rec.dpnt_cvrd_othr_pgm_rt_id,
758: p_effective_date => p_effective_date,

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

862: hr_utility.set_location('Entering:'|| l_proc, 10);
863: --
864: -- Ensure that all the mandatory parameter are not null
865: --
866: hr_api.mandatory_arg_error(p_api_name => l_proc,
867: p_argument => 'dpnt_cvrd_othr_pgm_rt_id',
868: p_argument_value => p_dpnt_cvrd_othr_pgm_rt_id);
869: --
870: open csr_leg_code;