[Home] [Help]
52: <> per_bil_shd.g_old_rec.id_value) then
53: --
54: -- raise error as PK has changed
55: --
56: per_bil_shd.constraint_error('hr_summary_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null
62: if p_id_value is not null then
63: --
64: -- raise error as PK is not null
65: --
66: per_bil_shd.constraint_error('hr_summary_PK');
67: --
68: end if;
69: --
70: end if;
78: -- ----------------------------------------------------------------------------
79: Procedure insert_validate(p_rec in per_bil_shd.g_rec_type) is
80: --
81: l_proc varchar2(72) := g_package||'insert_validate';
82: l_stmt hr_summary_restriction_type.restriction_sql%type;
83: --
84: Begin
85: hr_utility.set_location('Entering:'||l_proc, 5);
86: --
144: -- ----------------------------------------------------------------------------
145: Procedure update_validate(p_rec in per_bil_shd.g_rec_type) is
146: --
147: l_proc varchar2(72) := g_package||'update_validate';
148: l_stmt hr_summary_restriction_type.restriction_sql%type;
149: --
150: Begin
151: hr_utility.set_location('Entering:'||l_proc, 5);
152: --
213: -- ----------------------------------------------------------------------------
214: Procedure delete_validate(p_rec in per_bil_shd.g_rec_type) is
215: --
216: l_proc varchar2(72) := g_package||'delete_validate';
217: l_type hr_summary.type%type;
218: --
219: cursor csr_check_children is
220: select type
221: from hr_summary
217: l_type hr_summary.type%type;
218: --
219: cursor csr_check_children is
220: select type
221: from hr_summary
222: where (fk_value1 = p_rec.id_value
223: or fk_value2 = p_rec.id_value
224: or fk_value3 = p_rec.id_value);
225: --
268: --
269: cursor csr_leg_code is
270: select a.legislation_code
271: from per_business_groups a,
272: hr_summary b
273: where b.id_value = p_id_value
274: and a.business_group_id = b.business_group_id;
275: --
276: -- Declare local variables