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

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

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

Line 124: <> nvl(ben_dco_shd.g_old_rec.only_pls_subj_cobra_flag,hr_api.g_varchar2)

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

Line 130: if hr_api.not_exists_in_hr_lookups

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

Line 195: <> nvl(ben_dco_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)

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

Line 201: if hr_api.not_exists_in_hr_lookups

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

Line 275: and dpnt_cvrd_othr_ptip_rt_id <> nvl(p_dpnt_cvrd_othr_ptip_rt_id,hr_api.g_number)

271: where ptip_id = p_ptip_id
272: and enrl_det_dt_cd = p_enrl_det_dt_cd
273: -- and nvl(only_pls_subj_cobra_flag,'N') = p_only_pls_subj_cobra_flag
274: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
275: and dpnt_cvrd_othr_ptip_rt_id <> nvl(p_dpnt_cvrd_othr_ptip_rt_id,hr_api.g_number)
276: and business_group_id + 0 = p_business_group_id
277: and p_validation_start_date <= effective_end_date
278: and p_validation_end_date >= effective_start_date;
279: --

Line 290: and (p_ptip_id <> nvl(ben_dco_shd.g_old_rec.ptip_id,hr_api.g_number)

286: p_effective_date => p_effective_date,
287: p_object_version_number => p_object_version_number);
288: --
289: if (l_api_updating
290: and (p_ptip_id <> nvl(ben_dco_shd.g_old_rec.ptip_id,hr_api.g_number)
291: or p_enrl_det_dt_cd <> nvl(ben_dco_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2))
292: or not l_api_updating) then
293:
294: open c_dup;

Line 291: or p_enrl_det_dt_cd <> nvl(ben_dco_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_ptip_id <> nvl(ben_dco_shd.g_old_rec.ptip_id,hr_api.g_number)
291: or p_enrl_det_dt_cd <> nvl(ben_dco_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2))
292: or not l_api_updating) then
293:
294: open c_dup;
295: fetch c_dup into l_exists;

Line 360: <> nvl(ben_dco_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 366: if hr_api.not_exists_in_hr_lookups

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

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

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

Line 485: p_ptip_id in number default hr_api.g_number,

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

Line 499: hr_api.mandatory_arg_error

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

Line 511: hr_api.mandatory_arg_error

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

Line 516: hr_api.mandatory_arg_error

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

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

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

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

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

Line 614: hr_api.mandatory_arg_error

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

Line 628: hr_api.mandatory_arg_error

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

Line 633: hr_api.mandatory_arg_error

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

Line 638: hr_api.mandatory_arg_error

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

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

682: --
683: -- Call all supporting business operations
684: --
685: --
686: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
687: --
688: chk_dpnt_cvrd_othr_ptip_rt_id
689: (p_dpnt_cvrd_othr_ptip_rt_id => p_rec.dpnt_cvrd_othr_ptip_rt_id,
690: 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_ptip_rt_id
757: (p_dpnt_cvrd_othr_ptip_rt_id => p_rec.dpnt_cvrd_othr_ptip_rt_id,
758: p_effective_date => p_effective_date,

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

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