40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := per_bil_shd.api_updating
47: (p_id_value => p_id_value,
48: p_object_version_number => p_object_version_number);
68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_id_value;
75: --
76: -- ----------------------------------------------------------------------------
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: --
87: -- Call all supporting business operations
88: --
89: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
135: per_bil_shd.valid_value(p_rec => p_rec);
136: --
137: end if;
138: --
139: hr_utility.set_location(' Leaving:'||l_proc, 10);
140: End insert_validate;
141: --
142: -- ----------------------------------------------------------------------------
143: -- |---------------------------< update_validate >----------------------------|
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: --
153: -- Call all supporting business operations
154: --
155: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
203: if p_rec.type = 'RESTRICTION_VALUE' then
204: per_bil_shd.valid_value(p_rec => p_rec);
205: end if;
206: --
207: hr_utility.set_location(' Leaving:'||l_proc, 10);
208: --
209: End update_validate;
210: --
211: -- ----------------------------------------------------------------------------
223: or fk_value2 = p_rec.id_value
224: or fk_value3 = p_rec.id_value);
225: --
226: Begin
227: hr_utility.set_location('Entering:'||l_proc, 5);
228: --
229: open csr_check_children;
230: fetch csr_check_children into l_type;
231: if csr_check_children%found then
252: else
253: close csr_check_children;
254: end if;
255: --
256: hr_utility.set_location(' Leaving:'||l_proc, 10);
257: End delete_validate;
258: --
259: --
260: -- ---------------------------------------------------------------------------
279: l_proc varchar2(72) := g_package||'return_legislation_code';
280: --
281: begin
282: --
283: hr_utility.set_location('Entering:'|| l_proc, 10);
284: --
285: -- Ensure that all the mandatory parameter are not null
286: --
287: hr_api.mandatory_arg_error(p_api_name => l_proc,
297: close csr_leg_code;
298: --
299: -- The primary key is invalid therefore we must error
300: --
301: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
302: hr_utility.raise_error;
303: --
304: end if;
305: --
298: --
299: -- The primary key is invalid therefore we must error
300: --
301: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
302: hr_utility.raise_error;
303: --
304: end if;
305: --
306: close csr_leg_code;
304: end if;
305: --
306: close csr_leg_code;
307: --
308: hr_utility.set_location(' Leaving:'|| l_proc, 20);
309: --
310: return l_legislation_code;
311: --
312: end return_legislation_code;