DBA Data[Home] [Help]

APPS.BEN_PRR_BUS dependencies on BEN_PRR_SHD

Line 49: l_api_updating := ben_prr_shd.api_updating

45: Begin
46: --
47: hr_utility.set_location('Entering:'||l_proc, 5);
48: --
49: l_api_updating := ben_prr_shd.api_updating
50: (p_effective_date => p_effective_date,
51: p_perf_rtng_rt_id => p_perf_rtng_rt_id,
52: p_object_version_number => p_object_version_number);
53: --

Line 56: <> ben_prr_shd.g_old_rec.perf_rtng_rt_id) then

52: p_object_version_number => p_object_version_number);
53: --
54: if (l_api_updating
55: and nvl(p_perf_rtng_rt_id,hr_api.g_number)
56: <> ben_prr_shd.g_old_rec.perf_rtng_rt_id) then
57: --
58: -- raise error as PK has changed
59: --
60: ben_prr_shd.constraint_error('BEN_PERF_RTNG_RT_F_PK');

Line 60: ben_prr_shd.constraint_error('BEN_PERF_RTNG_RT_F_PK');

56: <> ben_prr_shd.g_old_rec.perf_rtng_rt_id) then
57: --
58: -- raise error as PK has changed
59: --
60: ben_prr_shd.constraint_error('BEN_PERF_RTNG_RT_F_PK');
61: --
62: elsif not l_api_updating then
63: --
64: -- check if PK is null

Line 70: ben_prr_shd.constraint_error('BEN_PERF_RTNG_RT_F_PK');

66: if p_perf_rtng_rt_id is not null then
67: --
68: -- raise error as PK is not null
69: --
70: ben_prr_shd.constraint_error('BEN_PERF_RTNG_RT_F_PK');
71: --
72: end if;
73: --
74: end if;

Line 118: l_api_updating := ben_prr_shd.api_updating

114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc, 5);
117: --
118: l_api_updating := ben_prr_shd.api_updating
119: (p_perf_rtng_rt_id => p_perf_rtng_rt_id,
120: p_effective_date => p_effective_date,
121: p_object_version_number => p_object_version_number);
122: --

Line 125: <> nvl(ben_prr_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_prr_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 201: l_api_updating := ben_prr_shd.api_updating

197: Begin
198: --
199: hr_utility.set_location('Entering:'||l_proc,5);
200: --
201: l_api_updating := ben_prr_shd.api_updating
202: (p_perf_rtng_rt_id => p_perf_rtng_rt_id,
203: p_effective_date => p_effective_date,
204: p_object_version_number => p_object_version_number);
205: --

Line 208: <> nvl(ben_prr_shd.g_old_rec.event_type,hr_api.g_varchar2)

204: p_object_version_number => p_object_version_number);
205: --
206: if (l_api_updating
207: and nvl(p_event_type,hr_api.g_varchar2)
208: <> nvl(ben_prr_shd.g_old_rec.event_type,hr_api.g_varchar2)
209: or not l_api_updating)
210: and p_event_type is not null
211: and p_event_type <> '-1' /* Bug 4031314 : Enter Event Type as -1, when user does not select it */
212: then

Line 227: ben_prr_shd.constraint_error('BEN_PERF_RTNG_RT_F_FK2');

223: --
224: -- raise error as FK does not relate to PK in
225: -- per_absence_attendance_types table.
226: --
227: ben_prr_shd.constraint_error('BEN_PERF_RTNG_RT_F_FK2');
228: --
229: end if;
230: --
231: close c1;

Line 290: l_api_updating := ben_prr_shd.api_updating

286: Begin
287: --
288: hr_utility.set_location('Entering:'||l_proc,5);
289: --
290: l_api_updating := ben_prr_shd.api_updating
291: (p_perf_rtng_rt_id => p_perf_rtng_rt_id,
292: p_effective_date => p_effective_date,
293: p_object_version_number => p_object_version_number);
294: --

Line 297: <> nvl(ben_prr_shd.g_old_rec.perf_rtng_cd,hr_api.g_varchar2)

293: p_object_version_number => p_object_version_number);
294: --
295: if (l_api_updating
296: and nvl(p_perf_rtng_cd,hr_api.g_varchar2)
297: <> nvl(ben_prr_shd.g_old_rec.perf_rtng_cd,hr_api.g_varchar2)
298: or not l_api_updating)
299: and p_perf_rtng_cd is not null then
300: --
301: -- check if event_type value exists in

Line 314: ben_prr_shd.constraint_error('BEN_PERF_RTNG_RT_F_FK3');

310: --
311: -- raise error as FK does not relate to PK in
312: -- per_absence_attendance_types table.
313: --
314: ben_prr_shd.constraint_error('BEN_PERF_RTNG_RT_F_FK3');
315: --
316: end if;
317: --
318: close c1;

Line 683: (p_rec in ben_prr_shd.g_rec_type,

679: -- ----------------------------------------------------------------------------
680: -- |---------------------------< insert_validate >----------------------------|
681: -- ----------------------------------------------------------------------------
682: Procedure insert_validate
683: (p_rec in ben_prr_shd.g_rec_type,
684: p_effective_date in date,
685: p_datetrack_mode in varchar2,
686: p_validation_start_date in date,
687: p_validation_end_date in date) is

Line 750: (p_rec in ben_prr_shd.g_rec_type,

746: -- ----------------------------------------------------------------------------
747: -- |---------------------------< update_validate >----------------------------|
748: -- ----------------------------------------------------------------------------
749: Procedure update_validate
750: (p_rec in ben_prr_shd.g_rec_type,
751: p_effective_date in date,
752: p_datetrack_mode in varchar2,
753: p_validation_start_date in date,
754: p_validation_end_date in date) is

Line 825: (p_rec in ben_prr_shd.g_rec_type,

821: -- ----------------------------------------------------------------------------
822: -- |---------------------------< delete_validate >----------------------------|
823: -- ----------------------------------------------------------------------------
824: Procedure delete_validate
825: (p_rec in ben_prr_shd.g_rec_type,
826: p_effective_date in date,
827: p_datetrack_mode in varchar2,
828: p_validation_start_date in date,
829: p_validation_end_date in date) is