APPS.BEN_EAR_BUS dependencies on HR_API

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

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

Line 133: and enrld_anthr_plip_rt_id <> nvl(p_enrld_anthr_plip_rt_id,hr_api.g_number)

129: from ben_enrld_anthr_plip_rt_f
130: where plip_id = p_plip_id
131: and enrl_det_dt_cd = p_enrl_det_dt_cd
132: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
133: and enrld_anthr_plip_rt_id <> nvl(p_enrld_anthr_plip_rt_id,hr_api.g_number)
134: and business_group_id + 0 = p_business_group_id
135: and p_validation_start_date <= effective_end_date
136: and p_validation_end_date >= effective_start_date;
137: --

Line 149: (p_plip_id <> nvl(ben_ear_shd.g_old_rec.plip_id,hr_api.g_number) or

145: p_object_version_number => p_object_version_number);
146: --
147: if (l_api_updating
148: and
149: (p_plip_id <> nvl(ben_ear_shd.g_old_rec.plip_id,hr_api.g_number) or
150: p_enrl_det_dt_cd <> nvl(ben_ear_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)
151: )
152: or not l_api_updating) then
153:

Line 150: p_enrl_det_dt_cd <> nvl(ben_ear_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)

146: --
147: if (l_api_updating
148: and
149: (p_plip_id <> nvl(ben_ear_shd.g_old_rec.plip_id,hr_api.g_number) or
150: p_enrl_det_dt_cd <> nvl(ben_ear_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)
151: )
152: or not l_api_updating) then
153:
154: open c_dup;

Line 222: <> nvl(ben_ear_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)

218: p_object_version_number => p_object_version_number);
219: --
220: if (l_api_updating
221: and p_enrl_det_dt_cd
222: <> nvl(ben_ear_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)
223: or not l_api_updating)
224: and p_enrl_det_dt_cd is not null then
225: --
226: -- check if value of lookup falls within lookup type.

Line 228: if hr_api.not_exists_in_hr_lookups

224: and p_enrl_det_dt_cd is not null then
225: --
226: -- check if value of lookup falls within lookup type.
227: --
228: if hr_api.not_exists_in_hr_lookups
229: (p_lookup_type => 'BEN_ENRL_DET_DT',
230: p_lookup_code => p_enrl_det_dt_cd,
231: p_effective_date => p_effective_date) then
232: --

Line 293: <> nvl(ben_ear_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

289: p_object_version_number => p_object_version_number);
290: --
291: if (l_api_updating
292: and p_excld_flag
293: <> nvl(ben_ear_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
294: or not l_api_updating) then
295: --
296: -- check if value of lookup falls within lookup type.
297: --

Line 299: if hr_api.not_exists_in_hr_lookups

295: --
296: -- check if value of lookup falls within lookup type.
297: --
298: --
299: if hr_api.not_exists_in_hr_lookups
300: (p_lookup_type => 'YES_NO',
301: p_lookup_code => p_excld_flag,
302: p_effective_date => p_effective_date) then
303: --

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

414: --
415: -- {End Of Comments}
416: -- ----------------------------------------------------------------------------
417: Procedure dt_update_validate
418: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
419: p_plip_id in number default hr_api.g_number,
420: p_datetrack_mode in varchar2,
421: p_validation_start_date in date,
422: p_validation_end_date in date) Is

Line 419: p_plip_id in number default hr_api.g_number,

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

Line 433: hr_api.mandatory_arg_error

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

Line 445: hr_api.mandatory_arg_error

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

Line 450: hr_api.mandatory_arg_error

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

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

451: (p_api_name => l_proc,
452: p_argument => 'validation_end_date',
453: p_argument_value => p_validation_end_date);
454: --
455: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
456: NOT (dt_api.check_min_max_dates
457: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
458: p_base_key_column => 'vrbl_rt_prfl_id',
459: p_base_key_value => p_vrbl_rt_prfl_id,

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

461: p_to_date => p_validation_end_date))) Then
462: l_table_name := 'ben_vrbl_rt_prfl_f';
463: Raise l_integrity_error;
464: End If;
465: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
466: NOT (dt_api.check_min_max_dates
467: (p_base_table_name => 'ben_plip_f',
468: p_base_key_column => 'plip_id',
469: p_base_key_value => p_plip_id,

Line 548: hr_api.mandatory_arg_error

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

Line 562: hr_api.mandatory_arg_error

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

Line 567: hr_api.mandatory_arg_error

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

Line 572: hr_api.mandatory_arg_error

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

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

616: --
617: -- Call all supporting business operations
618: --
619: --
620: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
621: --
622: chk_enrld_anthr_plip_rt_id
623: (p_enrld_anthr_plip_rt_id => p_rec.enrld_anthr_plip_rt_id,
624: p_effective_date => p_effective_date,

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

678: --
679: -- Call all supporting business operations
680: --
681: --
682: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
683: --
684: chk_enrld_anthr_plip_rt_id
685: (p_enrld_anthr_plip_rt_id => p_rec.enrld_anthr_plip_rt_id,
686: p_effective_date => p_effective_date,

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

786: hr_utility.set_location('Entering:'|| l_proc, 10);
787: --
788: -- Ensure that all the mandatory parameter are not null
789: --
790: hr_api.mandatory_arg_error(p_api_name => l_proc,
791: p_argument => 'enrld_anthr_plip_rt_id',
792: p_argument_value => p_enrld_anthr_plip_rt_id);
793: --
794: open csr_leg_code;