29: l_proc varchar2(72) := g_package||'set_security_group_id';
30: --
31: begin
32: --
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Ensure that all the mandatory parameter are not null
36: --
37: hr_api.mandatory_arg_error
41: );
42: --
43: -- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS.
44: --
45: hr_utility.set_location(' Leaving:'|| l_proc, 20);
46: --
47: end set_security_group_id;
48: --
49: --
134: l_exists varchar2(1);
135: l_proc varchar2(72) := g_package||'chk_ath_dsn';
136: --
137: begin
138: hr_utility.set_location('Entering: '|| l_proc, 1);
139: --
140: -- Check mandatory parameters have been set
141: --
142: hr_api.mandatory_arg_error
144: p_argument => 'ath_dsn',
145: p_argument_value => p_ath_dsn
146: );
147: --
148: hr_utility.set_location(l_proc, 2);
149: --
150: --
151: hr_utility.set_location(l_proc, 3);
152: --
147: --
148: hr_utility.set_location(l_proc, 2);
149: --
150: --
151: hr_utility.set_location(l_proc, 3);
152: --
153: hr_utility.set_location(' Leaving: '|| l_proc, 4);
154: end chk_ath_dsn;
155: --
149: --
150: --
151: hr_utility.set_location(l_proc, 3);
152: --
153: hr_utility.set_location(' Leaving: '|| l_proc, 4);
154: end chk_ath_dsn;
155: --
156:
157: --
187: l_exists varchar2(1);
188: l_proc varchar2(72) := g_package||'chk_ath_tablename';
189: --
190: begin
191: hr_utility.set_location('Entering: '|| l_proc, 1);
192: --
193: -- Check mandatory parameters have been set
194: --
195: hr_api.mandatory_arg_error
197: p_argument => 'ath_tablename',
198: p_argument_value => p_ath_tablename
199: );
200: --
201: hr_utility.set_location(l_proc, 2);
202: --
203: --
204: hr_utility.set_location(l_proc, 3);
205: --
200: --
201: hr_utility.set_location(l_proc, 2);
202: --
203: --
204: hr_utility.set_location(l_proc, 3);
205: --
206: hr_utility.set_location(' Leaving: '|| l_proc, 4);
207: end chk_ath_tablename;
208: --
202: --
203: --
204: hr_utility.set_location(l_proc, 3);
205: --
206: hr_utility.set_location(' Leaving: '|| l_proc, 4);
207: end chk_ath_tablename;
208: --
209:
210: --
240: l_exists varchar2(1);
241: l_proc varchar2(72) := g_package||'chk_ath_columnname';
242: --
243: begin
244: hr_utility.set_location('Entering: '|| l_proc, 1);
245: --
246: -- Check mandatory parameters have been set
247: --
248: hr_api.mandatory_arg_error
250: p_argument => 'ath_columnname',
251: p_argument_value => p_ath_columnname
252: );
253: --
254: hr_utility.set_location(l_proc, 2);
255: --
256: --
257: hr_utility.set_location(l_proc, 3);
258: --
253: --
254: hr_utility.set_location(l_proc, 2);
255: --
256: --
257: hr_utility.set_location(l_proc, 3);
258: --
259: hr_utility.set_location(' Leaving: '|| l_proc, 4);
260: end chk_ath_columnname;
261: --
255: --
256: --
257: hr_utility.set_location(l_proc, 3);
258: --
259: hr_utility.set_location(' Leaving: '|| l_proc, 4);
260: end chk_ath_columnname;
261: --
262:
263: --
299: l_exists varchar2(1);
300: l_proc varchar2(72) := g_package||'chk_ath_varname';
301: --
302: begin
303: hr_utility.set_location('Entering: '|| l_proc, 1);
304: --
305: -- Check mandatory parameters have been set
306: --
307: hr_api.mandatory_arg_error
309: p_argument => 'ath_varname',
310: p_argument_value => p_ath_varname
311: );
312: --
313: hr_utility.set_location(l_proc, 2);
314: --
315: hr_utility.set_location(l_proc, 3);
316: --
317: hr_utility.set_location(' Leaving: '|| l_proc, 4);
311: );
312: --
313: hr_utility.set_location(l_proc, 2);
314: --
315: hr_utility.set_location(l_proc, 3);
316: --
317: hr_utility.set_location(' Leaving: '|| l_proc, 4);
318: end chk_ath_varname;
319: --
313: hr_utility.set_location(l_proc, 2);
314: --
315: hr_utility.set_location(l_proc, 3);
316: --
317: hr_utility.set_location(' Leaving: '|| l_proc, 4);
318: end chk_ath_varname;
319: --
320:
321: --
328: --
329: l_proc varchar2(72) := g_package||'insert_validate';
330: --
331: Begin
332: hr_utility.set_location('Entering:'||l_proc, 5);
333: --
334: -- Call all supporting business operations
335:
336: -- validate ath_dsn
355: --
356: -- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS.
357: --
358: --
359: hr_utility.set_location(' Leaving:'||l_proc, 10);
360: End insert_validate;
361: --
362: -- ----------------------------------------------------------------------------
363: -- |---------------------------< update_validate >----------------------------|
368: --
369: l_proc varchar2(72) := g_package||'update_validate';
370: --
371: Begin
372: hr_utility.set_location('Entering:'||l_proc, 5);
373: --
374: -- Call all supporting business operations
375:
376: -- validate ath_dsn
402: (p_rec => p_rec
403: );
404: --
405: --
406: hr_utility.set_location(' Leaving:'||l_proc, 10);
407: End update_validate;
408: --
409: -- ----------------------------------------------------------------------------
410: -- |---------------------------< delete_validate >----------------------------|
415: --
416: l_proc varchar2(72) := g_package||'delete_validate';
417: --
418: Begin
419: hr_utility.set_location('Entering:'||l_proc, 5);
420: --
421: -- Call all supporting business operations
422: --
423: hr_utility.set_location(' Leaving:'||l_proc, 10);
419: hr_utility.set_location('Entering:'||l_proc, 5);
420: --
421: -- Call all supporting business operations
422: --
423: hr_utility.set_location(' Leaving:'||l_proc, 10);
424: End delete_validate;
425: --
426: end hr_avm_bus;