APPS.BEN_DCL_BUS dependencies on HR_API

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

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

Line 133: and dcl.dpnt_cvrd_othr_pl_rt_id <> nvl(p_dpnt_cvrd_othr_pl_rt_id,hr_api.g_number)

129: select null
130: from ben_dpnt_cvrd_othr_pl_rt_f dcl
131: where dcl.pl_id = p_pl_id
132: and dcl.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
133: and dcl.dpnt_cvrd_othr_pl_rt_id <> nvl(p_dpnt_cvrd_othr_pl_rt_id,hr_api.g_number)
134:
135: and dcl.business_group_id + 0 = p_business_group_id
136: and p_validation_start_date <= dcl.effective_end_date
137: and p_validation_end_date >= dcl.effective_start_date;

Line 149: and nvl(p_pl_id,hr_api.g_number)

145: p_effective_date => p_effective_date,
146: p_object_version_number => p_object_version_number);
147: --
148: if (l_api_updating
149: and nvl(p_pl_id,hr_api.g_number)
150: <> nvl(ben_dcl_shd.g_old_rec.pl_id,hr_api.g_number)
151: or not l_api_updating) then
152: --
153: -- check if pl_id value exists in the plan table

Line 150: <> nvl(ben_dcl_shd.g_old_rec.pl_id,hr_api.g_number)

146: p_object_version_number => p_object_version_number);
147: --
148: if (l_api_updating
149: and nvl(p_pl_id,hr_api.g_number)
150: <> nvl(ben_dcl_shd.g_old_rec.pl_id,hr_api.g_number)
151: or not l_api_updating) then
152: --
153: -- check if pl_id value exists in the plan table
154: open c1;

Line 237: <> nvl(ben_dcl_shd.g_old_rec.cvg_det_dt_cd,hr_api.g_varchar2)

233: p_object_version_number => p_object_version_number);
234: --
235: if (l_api_updating
236: and p_cvg_det_dt_cd
237: <> nvl(ben_dcl_shd.g_old_rec.cvg_det_dt_cd,hr_api.g_varchar2)
238: or not l_api_updating)
239: and p_cvg_det_dt_cd is not null then
240: --
241: -- check if value of lookup falls within lookup type.

Line 243: if hr_api.not_exists_in_hr_lookups

239: and p_cvg_det_dt_cd is not null then
240: --
241: -- check if value of lookup falls within lookup type.
242: --
243: if hr_api.not_exists_in_hr_lookups
244: (p_lookup_type => 'BEN_CVG_DET_DT',
245: p_lookup_code => p_cvg_det_dt_cd,
246: p_effective_date => p_effective_date) then
247: --

Line 308: <> nvl(ben_dcl_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

304: p_object_version_number => p_object_version_number);
305: --
306: if (l_api_updating
307: and p_excld_flag
308: <> nvl(ben_dcl_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
309: or not l_api_updating) then
310: --
311: -- check if value of lookup falls within lookup type.
312: --

Line 314: if hr_api.not_exists_in_hr_lookups

310: --
311: -- check if value of lookup falls within lookup type.
312: --
313: --
314: if hr_api.not_exists_in_hr_lookups
315: (p_lookup_type => 'YES_NO',
316: p_lookup_code => p_excld_flag,
317: p_effective_date => p_effective_date) then
318: --

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

428: --
429: -- {End Of Comments}
430: -- ----------------------------------------------------------------------------
431: Procedure dt_update_validate
432: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
433: p_pl_id in number default hr_api.g_number,
434: p_datetrack_mode in varchar2,
435: p_validation_start_date in date,
436: p_validation_end_date in date) Is

Line 433: p_pl_id in number default hr_api.g_number,

429: -- {End Of Comments}
430: -- ----------------------------------------------------------------------------
431: Procedure dt_update_validate
432: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
433: p_pl_id in number default hr_api.g_number,
434: p_datetrack_mode in varchar2,
435: p_validation_start_date in date,
436: p_validation_end_date in date) Is
437: --

Line 447: hr_api.mandatory_arg_error

443: hr_utility.set_location('Entering:'||l_proc, 5);
444: --
445: -- Ensure that the p_datetrack_mode argument is not null
446: --
447: hr_api.mandatory_arg_error
448: (p_api_name => l_proc,
449: p_argument => 'datetrack_mode',
450: p_argument_value => p_datetrack_mode);
451: --

Line 459: hr_api.mandatory_arg_error

455: --
456: --
457: -- Ensure the arguments are not null
458: --
459: hr_api.mandatory_arg_error
460: (p_api_name => l_proc,
461: p_argument => 'validation_start_date',
462: p_argument_value => p_validation_start_date);
463: --

Line 464: hr_api.mandatory_arg_error

460: (p_api_name => l_proc,
461: p_argument => 'validation_start_date',
462: p_argument_value => p_validation_start_date);
463: --
464: hr_api.mandatory_arg_error
465: (p_api_name => l_proc,
466: p_argument => 'validation_end_date',
467: p_argument_value => p_validation_end_date);
468: --

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

465: (p_api_name => l_proc,
466: p_argument => 'validation_end_date',
467: p_argument_value => p_validation_end_date);
468: --
469: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
470: NOT (dt_api.check_min_max_dates
471: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
472: p_base_key_column => 'vrbl_rt_prfl_id',
473: p_base_key_value => p_vrbl_rt_prfl_id,

Line 479: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and

475: p_to_date => p_validation_end_date))) Then
476: l_table_name := 'ben_vrbl_rt_prfl_f';
477: Raise l_integrity_error;
478: End If;
479: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
480: NOT (dt_api.check_min_max_dates
481: (p_base_table_name => 'ben_pl_f',
482: p_base_key_column => 'pl_id',
483: p_base_key_value => p_pl_id,

Line 561: hr_api.mandatory_arg_error

557: hr_utility.set_location('Entering:'||l_proc, 5);
558: --
559: -- Ensure that the p_datetrack_mode argument is not null
560: --
561: hr_api.mandatory_arg_error
562: (p_api_name => l_proc,
563: p_argument => 'datetrack_mode',
564: p_argument_value => p_datetrack_mode);
565: --

Line 575: hr_api.mandatory_arg_error

571: --
572: --
573: -- Ensure the arguments are not null
574: --
575: hr_api.mandatory_arg_error
576: (p_api_name => l_proc,
577: p_argument => 'validation_start_date',
578: p_argument_value => p_validation_start_date);
579: --

Line 580: hr_api.mandatory_arg_error

576: (p_api_name => l_proc,
577: p_argument => 'validation_start_date',
578: p_argument_value => p_validation_start_date);
579: --
580: hr_api.mandatory_arg_error
581: (p_api_name => l_proc,
582: p_argument => 'validation_end_date',
583: p_argument_value => p_validation_end_date);
584: --

Line 585: hr_api.mandatory_arg_error

581: (p_api_name => l_proc,
582: p_argument => 'validation_end_date',
583: p_argument_value => p_validation_end_date);
584: --
585: hr_api.mandatory_arg_error
586: (p_api_name => l_proc,
587: p_argument => 'dpnt_cvrd_othr_pl_rt_id',
588: p_argument_value => p_dpnt_cvrd_othr_pl_rt_id);
589: --

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

629: --
630: -- Call all supporting business operations
631: --
632: --
633: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
634: --
635: chk_dpnt_cvrd_othr_pl_rt_id
636: (p_dpnt_cvrd_othr_pl_rt_id => p_rec.dpnt_cvrd_othr_pl_rt_id,
637: p_effective_date => p_effective_date,

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_dpnt_cvrd_othr_pl_rt_id
696: (p_dpnt_cvrd_othr_pl_rt_id => p_rec.dpnt_cvrd_othr_pl_rt_id,
697: p_effective_date => p_effective_date,

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

794: hr_utility.set_location('Entering:'|| l_proc, 10);
795: --
796: -- Ensure that all the mandatory parameter are not null
797: --
798: hr_api.mandatory_arg_error(p_api_name => l_proc,
799: p_argument => 'dpnt_cvrd_othr_pl_rt_id',
800: p_argument_value => p_dpnt_cvrd_othr_pl_rt_id);
801: --
802: open csr_leg_code;