[Home] [Help]
52: <> ben_xre_shd.g_old_rec.ext_rslt_err_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_xre_shd.constraint_error('BEN_EXT_RSLT_ERR_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null
62: if p_ext_rslt_err_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_xre_shd.constraint_error('BEN_EXT_RSLT_ERR_PK');
67: --
68: end if;
69: --
70: end if;
140: --
141: -- raise error as FK does not relate to PK in per_all_people_f
142: -- table.
143: --
144: ben_xre_shd.constraint_error('BEN_EXT_RSLT_ERR_DT1');
145: --
146: end if;
147: --
148: close c1;
257: l_dummy varchar2(1);
258: --
259: cursor c1 is
260: select null
261: from ben_ext_rslt a
262: where a.ext_rslt_id = p_ext_rslt_id;
263: --
264: Begin
265: --
274: and nvl(p_ext_rslt_id, hr_api.g_number)
275: <> nvl(ben_xre_shd.g_old_rec.ext_rslt_id, hr_api.g_number)
276: or not l_api_updating) then
277: --
278: -- check if ext_rslt_id value exists in ben_ext_rslt table
279: --
280: open c1;
281: --
282: fetch c1 into l_dummy;
285: close c1;
286: --
287: -- raise error for constraint violation
288: --
289: ben_xre_shd.constraint_error('BEN_EXT_RSLT_ERR_FK2');
290: --
291: end if;
292: --
293: close c1;
396: --
397: cursor csr_leg_code is
398: select a.legislation_code
399: from per_business_groups a,
400: ben_ext_rslt_err b
401: where b.ext_rslt_err_id = p_ext_rslt_err_id
402: and a.business_group_id = b.business_group_id;
403: --
404: -- Declare local variables