APPS.BEN_ERG_BUS dependencies on HR_API

Line 55: and nvl(p_ELIG_PERF_RTNG_PRTE_id,hr_api.g_number)

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

Line 125: <> nvl(ben_erg_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 131: if hr_api.not_exists_in_hr_lookups

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

Line 197: and nvl(p_event_type,hr_api.g_varchar2)

193: p_effective_date => p_effective_date,
194: p_object_version_number => p_object_version_number);
195: --
196: if (l_api_updating
197: and nvl(p_event_type,hr_api.g_varchar2)
198: <> nvl(ben_erg_shd.g_old_rec.event_type,hr_api.g_varchar2)
199: or not l_api_updating)
200: and p_event_type is not null
201: and p_event_type <> '-1' /* Bug 4031314 : Enter Event Type as -1, when user does not select it */

Line 198: <> nvl(ben_erg_shd.g_old_rec.event_type,hr_api.g_varchar2)

194: p_object_version_number => p_object_version_number);
195: --
196: if (l_api_updating
197: and nvl(p_event_type,hr_api.g_varchar2)
198: <> nvl(ben_erg_shd.g_old_rec.event_type,hr_api.g_varchar2)
199: or not l_api_updating)
200: and p_event_type is not null
201: and p_event_type <> '-1' /* Bug 4031314 : Enter Event Type as -1, when user does not select it */
202: then

Line 207: if hr_api.not_exists_in_hr_lookups

203: --
204: -- check if value of lookup falls within lookup type.
205: --
206: --
207: if hr_api.not_exists_in_hr_lookups
208: (p_lookup_type => 'EMP_INTERVIEW_TYPE',
209: p_lookup_code => p_event_type,
210: p_effective_date => p_effective_date) then
211: --

Line 275: and nvl(p_perf_rtng_cd,hr_api.g_varchar2)

271: p_effective_date => p_effective_date,
272: p_object_version_number => p_object_version_number);
273: --
274: if (l_api_updating
275: and nvl(p_perf_rtng_cd,hr_api.g_varchar2)
276: <> nvl(ben_erg_shd.g_old_rec.perf_rtng_cd,hr_api.g_varchar2)
277: or not l_api_updating)
278: and p_perf_rtng_cd is not null then
279: --

Line 276: <> nvl(ben_erg_shd.g_old_rec.perf_rtng_cd,hr_api.g_varchar2)

272: p_object_version_number => p_object_version_number);
273: --
274: if (l_api_updating
275: and nvl(p_perf_rtng_cd,hr_api.g_varchar2)
276: <> nvl(ben_erg_shd.g_old_rec.perf_rtng_cd,hr_api.g_varchar2)
277: or not l_api_updating)
278: and p_perf_rtng_cd is not null then
279: --
280: -- check if value of lookup falls within lookup type.

Line 283: if hr_api.not_exists_in_hr_lookups

279: --
280: -- check if value of lookup falls within lookup type.
281: --
282: --
283: if hr_api.not_exists_in_hr_lookups
284: (p_lookup_type => 'PERFORMANCE_RATING',
285: p_lookup_code => p_perf_rtng_cd,
286: p_effective_date => p_effective_date) then
287: --

Line 351: and erg.ELIG_PERF_RTNG_PRTE_id <> nvl(p_ELIG_PERF_RTNG_PRTE_id,hr_api.g_number)

347: from ben_ELIG_PERF_RTNG_PRTE_f erg
348: where nvl(erg.event_type,'xxxx') = nvl(p_event_type,'xxxx')
349: and nvl(erg.perf_rtng_cd,'xxxx') = nvl(p_perf_rtng_cd,'xxxx')
350: and erg.ELIGY_PRFL_id = p_ELIGY_PRFL_id
351: and erg.ELIG_PERF_RTNG_PRTE_id <> nvl(p_ELIG_PERF_RTNG_PRTE_id,hr_api.g_number)
352: and erg.business_group_id = p_business_group_id;
353: --
354: Begin
355: --

Line 465: (p_ELIGY_PRFL_id in number default hr_api.g_number,

461: --
462: -- {End Of Comments}
463: -- ----------------------------------------------------------------------------
464: Procedure dt_update_validate
465: (p_ELIGY_PRFL_id in number default hr_api.g_number,
466: p_datetrack_mode in varchar2,
467: p_validation_start_date in date,
468: p_validation_end_date in date) Is
469: --

Line 479: hr_api.mandatory_arg_error

475: hr_utility.set_location('Entering:'||l_proc, 5);
476: --
477: -- Ensure that the p_datetrack_mode argument is not null
478: --
479: hr_api.mandatory_arg_error
480: (p_api_name => l_proc,
481: p_argument => 'datetrack_mode',
482: p_argument_value => p_datetrack_mode);
483: --

Line 491: hr_api.mandatory_arg_error

487: --
488: --
489: -- Ensure the arguments are not null
490: --
491: hr_api.mandatory_arg_error
492: (p_api_name => l_proc,
493: p_argument => 'validation_start_date',
494: p_argument_value => p_validation_start_date);
495: --

Line 496: hr_api.mandatory_arg_error

492: (p_api_name => l_proc,
493: p_argument => 'validation_start_date',
494: p_argument_value => p_validation_start_date);
495: --
496: hr_api.mandatory_arg_error
497: (p_api_name => l_proc,
498: p_argument => 'validation_end_date',
499: p_argument_value => p_validation_end_date);
500: --

Line 501: If ((nvl(p_ELIGY_PRFL_id, hr_api.g_number) <> hr_api.g_number) and

497: (p_api_name => l_proc,
498: p_argument => 'validation_end_date',
499: p_argument_value => p_validation_end_date);
500: --
501: If ((nvl(p_ELIGY_PRFL_id, hr_api.g_number) <> hr_api.g_number) and
502: NOT (dt_api.check_min_max_dates
503: (p_base_table_name => 'ben_ELIGY_PRFL_f',
504: p_base_key_column => 'ELIGY_PRFL_id',
505: p_base_key_value => p_ELIGY_PRFL_id,

Line 584: hr_api.mandatory_arg_error

580: hr_utility.set_location('Entering:'||l_proc, 5);
581: --
582: -- Ensure that the p_datetrack_mode argument is not null
583: --
584: hr_api.mandatory_arg_error
585: (p_api_name => l_proc,
586: p_argument => 'datetrack_mode',
587: p_argument_value => p_datetrack_mode);
588: --

Line 598: hr_api.mandatory_arg_error

594: --
595: --
596: -- Ensure the arguments are not null
597: --
598: hr_api.mandatory_arg_error
599: (p_api_name => l_proc,
600: p_argument => 'validation_start_date',
601: p_argument_value => p_validation_start_date);
602: --

Line 603: hr_api.mandatory_arg_error

599: (p_api_name => l_proc,
600: p_argument => 'validation_start_date',
601: p_argument_value => p_validation_start_date);
602: --
603: hr_api.mandatory_arg_error
604: (p_api_name => l_proc,
605: p_argument => 'validation_end_date',
606: p_argument_value => p_validation_end_date);
607: --

Line 608: hr_api.mandatory_arg_error

604: (p_api_name => l_proc,
605: p_argument => 'validation_end_date',
606: p_argument_value => p_validation_end_date);
607: --
608: hr_api.mandatory_arg_error
609: (p_api_name => l_proc,
610: p_argument => 'ELIG_PERF_RTNG_PRTE_id',
611: p_argument_value => p_ELIG_PERF_RTNG_PRTE_id);
612: --

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

652: --
653: -- Call all supporting business operations
654: --
655: --
656: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
657: --
658: chk_ELIG_PERF_RTNG_PRTE_id
659: (p_ELIG_PERF_RTNG_PRTE_id => p_rec.ELIG_PERF_RTNG_PRTE_id,
660: p_effective_date => p_effective_date,

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

713: --
714: -- Call all supporting business operations
715: --
716: --
717: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
718: --
719: chk_ELIG_PERF_RTNG_PRTE_id
720: (p_ELIG_PERF_RTNG_PRTE_id => p_rec.ELIG_PERF_RTNG_PRTE_id,
721: p_effective_date => p_effective_date,

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

818: hr_utility.set_location('Entering:'|| l_proc, 10);
819: --
820: -- Ensure that all the mandatory parameter are not null
821: --
822: hr_api.mandatory_arg_error(p_api_name => l_proc,
823: p_argument => 'ELIG_PERF_RTNG_PRTE_id',
824: p_argument_value => p_ELIG_PERF_RTNG_PRTE_id);
825: --
826: open csr_leg_code;