APPS.BEN_EDP_BUS dependencies on HR_API

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

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

Line 133: and edp.elig_dpnt_cvrd_othr_pl_id <> nvl(p_elig_dpnt_cvrd_othr_pl_id,hr_api.g_number)

129: select null
130: from ben_elig_dpnt_cvrd_othr_pl_f edp
131: where edp.pl_id = p_pl_id
132: and edp.eligy_prfl_id = p_eligy_prfl_id
133: and edp.elig_dpnt_cvrd_othr_pl_id <> nvl(p_elig_dpnt_cvrd_othr_pl_id,hr_api.g_number)
134:
135: and edp.business_group_id + 0 = p_business_group_id
136: and p_validation_start_date <= edp.effective_end_date
137: and p_validation_end_date >= edp.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_edp_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_edp_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_edp_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 235: <> nvl(ben_edp_shd.g_old_rec.cvg_det_dt_cd,hr_api.g_varchar2)

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

Line 241: if hr_api.not_exists_in_hr_lookups

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

Line 306: <> nvl(ben_edp_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 312: if hr_api.not_exists_in_hr_lookups

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

Line 420: (p_eligy_prfl_id in number default hr_api.g_number,

416: --
417: -- {End Of Comments}
418: -- ----------------------------------------------------------------------------
419: Procedure dt_update_validate
420: (p_eligy_prfl_id in number default hr_api.g_number,
421: p_pl_id in number default hr_api.g_number,
422: p_datetrack_mode in varchar2,
423: p_validation_start_date in date,
424: p_validation_end_date in date) Is

Line 421: p_pl_id in number default hr_api.g_number,

417: -- {End Of Comments}
418: -- ----------------------------------------------------------------------------
419: Procedure dt_update_validate
420: (p_eligy_prfl_id in number default hr_api.g_number,
421: p_pl_id in number default hr_api.g_number,
422: p_datetrack_mode in varchar2,
423: p_validation_start_date in date,
424: p_validation_end_date in date) Is
425: --

Line 435: hr_api.mandatory_arg_error

431: hr_utility.set_location('Entering:'||l_proc, 5);
432: --
433: -- Ensure that the p_datetrack_mode argument is not null
434: --
435: hr_api.mandatory_arg_error
436: (p_api_name => l_proc,
437: p_argument => 'datetrack_mode',
438: p_argument_value => p_datetrack_mode);
439: --

Line 447: hr_api.mandatory_arg_error

443: --
444: --
445: -- Ensure the arguments are not null
446: --
447: hr_api.mandatory_arg_error
448: (p_api_name => l_proc,
449: p_argument => 'validation_start_date',
450: p_argument_value => p_validation_start_date);
451: --

Line 452: hr_api.mandatory_arg_error

448: (p_api_name => l_proc,
449: p_argument => 'validation_start_date',
450: p_argument_value => p_validation_start_date);
451: --
452: hr_api.mandatory_arg_error
453: (p_api_name => l_proc,
454: p_argument => 'validation_end_date',
455: p_argument_value => p_validation_end_date);
456: --

Line 457: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and

453: (p_api_name => l_proc,
454: p_argument => 'validation_end_date',
455: p_argument_value => p_validation_end_date);
456: --
457: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
458: NOT (dt_api.check_min_max_dates
459: (p_base_table_name => 'ben_eligy_prfl_f',
460: p_base_key_column => 'eligy_prfl_id',
461: p_base_key_value => p_eligy_prfl_id,

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

463: p_to_date => p_validation_end_date))) Then
464: l_table_name := 'ben_eligy_prfl_f';
465: Raise l_integrity_error;
466: End If;
467: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
468: NOT (dt_api.check_min_max_dates
469: (p_base_table_name => 'ben_pl_f',
470: p_base_key_column => 'pl_id',
471: p_base_key_value => p_pl_id,

Line 549: hr_api.mandatory_arg_error

545: hr_utility.set_location('Entering:'||l_proc, 5);
546: --
547: -- Ensure that the p_datetrack_mode argument is not null
548: --
549: hr_api.mandatory_arg_error
550: (p_api_name => l_proc,
551: p_argument => 'datetrack_mode',
552: p_argument_value => p_datetrack_mode);
553: --

Line 563: hr_api.mandatory_arg_error

559: --
560: --
561: -- Ensure the arguments are not null
562: --
563: hr_api.mandatory_arg_error
564: (p_api_name => l_proc,
565: p_argument => 'validation_start_date',
566: p_argument_value => p_validation_start_date);
567: --

Line 568: hr_api.mandatory_arg_error

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

Line 573: hr_api.mandatory_arg_error

569: (p_api_name => l_proc,
570: p_argument => 'validation_end_date',
571: p_argument_value => p_validation_end_date);
572: --
573: hr_api.mandatory_arg_error
574: (p_api_name => l_proc,
575: p_argument => 'elig_dpnt_cvrd_othr_pl_id',
576: p_argument_value => p_elig_dpnt_cvrd_othr_pl_id);
577: --

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

617: --
618: -- Call all supporting business operations
619: --
620: --
621: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
622: --
623: chk_elig_dpnt_cvrd_othr_pl_id
624: (p_elig_dpnt_cvrd_othr_pl_id => p_rec.elig_dpnt_cvrd_othr_pl_id,
625: p_effective_date => p_effective_date,

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

673: --
674: -- Call all supporting business operations
675: --
676: --
677: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
678: --
679: chk_elig_dpnt_cvrd_othr_pl_id
680: (p_elig_dpnt_cvrd_othr_pl_id => p_rec.elig_dpnt_cvrd_othr_pl_id,
681: p_effective_date => p_effective_date,

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

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