APPS.BEN_DCP_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_dcp_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_dcp_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 196: <> nvl(ben_dcp_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 202: if hr_api.not_exists_in_hr_lookups

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

Line 274: and dpnt_cvrd_plip_rt_id <> nvl(p_dpnt_cvrd_plip_rt_id,hr_api.g_number)

270: from ben_dpnt_cvrd_plip_rt_f
271: where plip_id = p_plip_id
272: and enrl_det_dt_cd = p_enrl_det_dt_cd
273: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
274: and dpnt_cvrd_plip_rt_id <> nvl(p_dpnt_cvrd_plip_rt_id,hr_api.g_number)
275: and business_group_id + 0 = p_business_group_id
276: and p_validation_start_date <= effective_end_date
277: and p_validation_end_date >= effective_start_date;
278: --

Line 289: and (p_plip_id <> nvl(ben_dcp_shd.g_old_rec.plip_id,hr_api.g_number)

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

Line 290: or p_enrl_det_dt_cd <> nvl(ben_dcp_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2))

286: p_object_version_number => p_object_version_number);
287: --
288: if (l_api_updating
289: and (p_plip_id <> nvl(ben_dcp_shd.g_old_rec.plip_id,hr_api.g_number)
290: or p_enrl_det_dt_cd <> nvl(ben_dcp_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2))
291: or not l_api_updating) then
292:
293: open c_dup;
294: fetch c_dup into l_exists;

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

409: --
410: -- {End Of Comments}
411: -- ----------------------------------------------------------------------------
412: Procedure dt_update_validate
413: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
414: p_plip_id in number default hr_api.g_number,
415: p_datetrack_mode in varchar2,
416: p_validation_start_date in date,
417: p_validation_end_date in date) Is

Line 414: p_plip_id in number default hr_api.g_number,

410: -- {End Of Comments}
411: -- ----------------------------------------------------------------------------
412: Procedure dt_update_validate
413: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
414: p_plip_id in number default hr_api.g_number,
415: p_datetrack_mode in varchar2,
416: p_validation_start_date in date,
417: p_validation_end_date in date) Is
418: --

Line 428: hr_api.mandatory_arg_error

424: hr_utility.set_location('Entering:'||l_proc, 5);
425: --
426: -- Ensure that the p_datetrack_mode argument is not null
427: --
428: hr_api.mandatory_arg_error
429: (p_api_name => l_proc,
430: p_argument => 'datetrack_mode',
431: p_argument_value => p_datetrack_mode);
432: --

Line 440: hr_api.mandatory_arg_error

436: --
437: --
438: -- Ensure the arguments are not null
439: --
440: hr_api.mandatory_arg_error
441: (p_api_name => l_proc,
442: p_argument => 'validation_start_date',
443: p_argument_value => p_validation_start_date);
444: --

Line 445: hr_api.mandatory_arg_error

441: (p_api_name => l_proc,
442: p_argument => 'validation_start_date',
443: p_argument_value => p_validation_start_date);
444: --
445: hr_api.mandatory_arg_error
446: (p_api_name => l_proc,
447: p_argument => 'validation_end_date',
448: p_argument_value => p_validation_end_date);
449: --

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

446: (p_api_name => l_proc,
447: p_argument => 'validation_end_date',
448: p_argument_value => p_validation_end_date);
449: --
450: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
451: NOT (dt_api.check_min_max_dates
452: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
453: p_base_key_column => 'vrbl_rt_prfl_id',
454: p_base_key_value => p_vrbl_rt_prfl_id,

Line 460: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and

456: p_to_date => p_validation_end_date))) Then
457: l_table_name := 'ben_vrbl_rt_prfl_f';
458: Raise l_integrity_error;
459: End If;
460: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
461: NOT (dt_api.check_min_max_dates
462: (p_base_table_name => 'ben_plip_f',
463: p_base_key_column => 'plip_id',
464: p_base_key_value => p_plip_id,

Line 544: hr_api.mandatory_arg_error

540: hr_utility.set_location('Entering:'||l_proc, 5);
541: --
542: -- Ensure that the p_datetrack_mode argument is not null
543: --
544: hr_api.mandatory_arg_error
545: (p_api_name => l_proc,
546: p_argument => 'datetrack_mode',
547: p_argument_value => p_datetrack_mode);
548: --

Line 558: hr_api.mandatory_arg_error

554: --
555: --
556: -- Ensure the arguments are not null
557: --
558: hr_api.mandatory_arg_error
559: (p_api_name => l_proc,
560: p_argument => 'validation_start_date',
561: p_argument_value => p_validation_start_date);
562: --

Line 563: hr_api.mandatory_arg_error

559: (p_api_name => l_proc,
560: p_argument => 'validation_start_date',
561: p_argument_value => p_validation_start_date);
562: --
563: hr_api.mandatory_arg_error
564: (p_api_name => l_proc,
565: p_argument => 'validation_end_date',
566: p_argument_value => p_validation_end_date);
567: --

Line 568: hr_api.mandatory_arg_error

564: (p_api_name => l_proc,
565: p_argument => 'validation_end_date',
566: p_argument_value => p_validation_end_date);
567: --
568: hr_api.mandatory_arg_error
569: (p_api_name => l_proc,
570: p_argument => 'dpnt_cvrd_plip_rt_id',
571: p_argument_value => p_dpnt_cvrd_plip_rt_id);
572: --

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

649: ,p_validation_end_date => p_validation_end_date
650: ,p_business_group_id => p_rec.business_group_id);
651:
652: --
653: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
654: --
655: hr_utility.set_location(' Leaving:'||l_proc, 10);
656: End insert_validate;
657: --

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

708: ,p_validation_end_date => p_validation_end_date
709: ,p_business_group_id => p_rec.business_group_id);
710:
711: --
712: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
713: --
714: -- Call the datetrack update integrity operation
715: --
716: dt_update_validate

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

776: hr_utility.set_location('Entering:'|| l_proc, 10);
777: --
778: -- Ensure that all the mandatory parameter are not null
779: --
780: hr_api.mandatory_arg_error(p_api_name => l_proc,
781: p_argument => 'dpnt_cvrd_plip_rt_id',
782: p_argument_value => p_dpnt_cvrd_plip_rt_id);
783: --
784: open csr_leg_code;