[Home] [Help]
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
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;
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;
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;
366: l_dummy varchar2(1);
367: --
368: cursor c1 is
369: select null
370: from ben_perf_rtng_rt_f prr
371: where nvl(prr.event_type,-1) = nvl(p_event_type,-1)
372: and nvl(prr.perf_rtng_cd,-1) = nvl(p_perf_rtng_cd,-1)
373: and prr.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
374: and prr.perf_rtng_rt_id <> nvl(p_perf_rtng_rt_id,hr_api.g_number)
440: is
441: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
442: l_dummy char(1);
443: cursor c1 is select null
444: from ben_perf_rtng_rt_f
445: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
446: -- changed against bug: 5113011
447: and perf_rtng_rt_id <> nvl(p_perf_rtng_rt_id ,-1)
448: -- and perf_rtng_cd <> nvl(p_perf_rtng_cd ,-1)
856: --
857: cursor csr_leg_code is
858: select a.legislation_code
859: from per_business_groups a,
860: ben_perf_rtng_rt_f b
861: where b.perf_rtng_rt_id = p_perf_rtng_rt_id
862: and a.business_group_id = b.business_group_id;
863: --
864: -- Declare local variables