[Home] [Help]
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ben_rts_bus.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- The following two global variables are only to be
12: -- used by the return_legislation_code function.
13: --
57: l_legislation_code varchar2(150);
58: --
59: begin
60: --
61: hr_utility.set_location('Entering:'|| l_proc, 10);
62: --
63: -- Ensure that all the mandatory parameter are not null
64: --
65: hr_api.mandatory_arg_error
111: --
112: hr_api.set_legislation_context(l_legislation_code);
113: end if;
114: --
115: hr_utility.set_location(' Leaving:'|| l_proc, 20);
116: --
117: end set_security_group_id;
118: --
119: -- ---------------------------------------------------------------------------
150: l_proc varchar2(72) := g_package||'return_legislation_code';
151: --
152: Begin
153: --
154: hr_utility.set_location('Entering:'|| l_proc, 10);
155: --
156: -- Ensure that all the mandatory parameter are not null
157: --
158: hr_api.mandatory_arg_error
182: -- call to this function. Just return the value in the global
183: -- variable.
184: --
185: l_legislation_code := ben_rts_bus.g_legislation_code;
186: hr_utility.set_location(l_proc, 20);
187: else
188: --
189: -- The ID is different to the last call to this function
190: -- or this is the first call to this function.
199: close csr_leg_code;
200: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
201: fnd_message.raise_error;
202: end if;
203: hr_utility.set_location(l_proc,30);
204: --
205: -- Set the global variables so the values are
206: -- available for the next call to this function.
207: --
210: ben_rts_bus.g_pl_id := p_pl_id;
211: ben_rts_bus.g_oipl_id := p_oipl_id;
212: ben_rts_bus.g_legislation_code := l_legislation_code;
213: end if;
214: hr_utility.set_location(' Leaving:'|| l_proc, 40);
215: return l_legislation_code;
216: end return_legislation_code;
217: End of commented code. */
218: --
305: l_proc varchar2(72) := g_package||'insert_validate';
306: --
307: Begin
308: if g_debug then
309: hr_utility.set_location('Entering:'||l_proc, 5);
310: end if;
311: --
312: -- No validations are required.
313: --
311: --
312: -- No validations are required.
313: --
314: if g_debug then
315: hr_utility.set_location(' Leaving:'||l_proc, 10);
316: end if;
317: End insert_validate;
318: --
319: -- ----------------------------------------------------------------------------
326: l_proc varchar2(72) := g_package||'update_validate';
327: --
328: Begin
329: if g_debug then
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: end if;
332: --
333: chk_non_updateable_args
334: (p_rec => p_rec
335: );
336: --
337: --
338: if g_debug then
339: hr_utility.set_location(' Leaving:'||l_proc, 10);
340: end if;
341: End update_validate;
342: --
343: -- ----------------------------------------------------------------------------
350: l_proc varchar2(72) := g_package||'delete_validate';
351: --
352: Begin
353: if g_debug then
354: hr_utility.set_location('Entering:'||l_proc, 5);
355: end if;
356: --
357: -- No validations required
358: --
356: --
357: -- No validations required
358: --
359: if g_debug then
360: hr_utility.set_location(' Leaving:'||l_proc, 10);
361: end if;
362: End delete_validate;
363: --
364: end ben_rts_bus;