3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_scorecard_sharing_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8:
9: --
10: -- ----------------------------------------------------------------------------
11: -- |--------------------------< create_sharing_instance >---------------------|
59: begin
60:
61: IF g_debug THEN
62:
63: hr_utility.set_location('Entering:'|| l_proc, 10);
64:
65: hr_utility.trace(' ');
66: hr_utility.trace(' --------------------------------'||
67: '---------------------------------');
61: IF g_debug THEN
62:
63: hr_utility.set_location('Entering:'|| l_proc, 10);
64:
65: hr_utility.trace(' ');
66: hr_utility.trace(' --------------------------------'||
67: '---------------------------------');
68: hr_utility.trace(' IN / IN OUT PARAMETER '||
69: ' VALUE');
62:
63: hr_utility.set_location('Entering:'|| l_proc, 10);
64:
65: hr_utility.trace(' ');
66: hr_utility.trace(' --------------------------------'||
67: '---------------------------------');
68: hr_utility.trace(' IN / IN OUT PARAMETER '||
69: ' VALUE');
70: hr_utility.trace(' --------------------------------'||
64:
65: hr_utility.trace(' ');
66: hr_utility.trace(' --------------------------------'||
67: '---------------------------------');
68: hr_utility.trace(' IN / IN OUT PARAMETER '||
69: ' VALUE');
70: hr_utility.trace(' --------------------------------'||
71: '+--------------------------------');
72: hr_utility.trace(' p_scorecard_id '||
66: hr_utility.trace(' --------------------------------'||
67: '---------------------------------');
68: hr_utility.trace(' IN / IN OUT PARAMETER '||
69: ' VALUE');
70: hr_utility.trace(' --------------------------------'||
71: '+--------------------------------');
72: hr_utility.trace(' p_scorecard_id '||
73: to_char(p_scorecard_id));
74: hr_utility.trace(' p_person_id '||
68: hr_utility.trace(' IN / IN OUT PARAMETER '||
69: ' VALUE');
70: hr_utility.trace(' --------------------------------'||
71: '+--------------------------------');
72: hr_utility.trace(' p_scorecard_id '||
73: to_char(p_scorecard_id));
74: hr_utility.trace(' p_person_id '||
75: to_char(p_person_id));
76: hr_utility.trace(' --------------------------------'||
70: hr_utility.trace(' --------------------------------'||
71: '+--------------------------------');
72: hr_utility.trace(' p_scorecard_id '||
73: to_char(p_scorecard_id));
74: hr_utility.trace(' p_person_id '||
75: to_char(p_person_id));
76: hr_utility.trace(' --------------------------------'||
77: '---------------------------------');
78: hr_utility.trace(' ');
72: hr_utility.trace(' p_scorecard_id '||
73: to_char(p_scorecard_id));
74: hr_utility.trace(' p_person_id '||
75: to_char(p_person_id));
76: hr_utility.trace(' --------------------------------'||
77: '---------------------------------');
78: hr_utility.trace(' ');
79:
80: END IF;
74: hr_utility.trace(' p_person_id '||
75: to_char(p_person_id));
76: hr_utility.trace(' --------------------------------'||
77: '---------------------------------');
78: hr_utility.trace(' ');
79:
80: END IF;
81:
82: --
133:
134: --
135: -- Process Logic
136: --
137: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
138:
139: per_psh_ins.ins
140: (p_scorecard_id => p_scorecard_id
141: ,p_person_id => p_person_id
222: ,p_hook_type => 'AP'
223: );
224: end;
225:
226: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
227: --
228: -- When in validation only mode raise the Validate_Enabled exception
229: --
230: if p_validate then
240: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
241: --
242: IF g_debug THEN
243:
244: hr_utility.trace(' ');
245: hr_utility.trace(' --------------------------------'||
246: '---------------------------------');
247: hr_utility.trace(' IN OUT / OUT PARAMETER '||
248: ' VALUE');
241: --
242: IF g_debug THEN
243:
244: hr_utility.trace(' ');
245: hr_utility.trace(' --------------------------------'||
246: '---------------------------------');
247: hr_utility.trace(' IN OUT / OUT PARAMETER '||
248: ' VALUE');
249: hr_utility.trace(' --------------------------------'||
243:
244: hr_utility.trace(' ');
245: hr_utility.trace(' --------------------------------'||
246: '---------------------------------');
247: hr_utility.trace(' IN OUT / OUT PARAMETER '||
248: ' VALUE');
249: hr_utility.trace(' --------------------------------'||
250: '+--------------------------------');
251: hr_utility.trace(' p_sharing_instance_id '||
245: hr_utility.trace(' --------------------------------'||
246: '---------------------------------');
247: hr_utility.trace(' IN OUT / OUT PARAMETER '||
248: ' VALUE');
249: hr_utility.trace(' --------------------------------'||
250: '+--------------------------------');
251: hr_utility.trace(' p_sharing_instance_id '||
252: to_char(p_sharing_instance_id));
253: hr_utility.trace(' p_object_version_number '||
247: hr_utility.trace(' IN OUT / OUT PARAMETER '||
248: ' VALUE');
249: hr_utility.trace(' --------------------------------'||
250: '+--------------------------------');
251: hr_utility.trace(' p_sharing_instance_id '||
252: to_char(p_sharing_instance_id));
253: hr_utility.trace(' p_object_version_number '||
254: to_char(p_object_version_number));
255: hr_utility.trace(' --------------------------------'||
249: hr_utility.trace(' --------------------------------'||
250: '+--------------------------------');
251: hr_utility.trace(' p_sharing_instance_id '||
252: to_char(p_sharing_instance_id));
253: hr_utility.trace(' p_object_version_number '||
254: to_char(p_object_version_number));
255: hr_utility.trace(' --------------------------------'||
256: '---------------------------------');
257: hr_utility.trace(' ');
251: hr_utility.trace(' p_sharing_instance_id '||
252: to_char(p_sharing_instance_id));
253: hr_utility.trace(' p_object_version_number '||
254: to_char(p_object_version_number));
255: hr_utility.trace(' --------------------------------'||
256: '---------------------------------');
257: hr_utility.trace(' ');
258: hr_utility.set_location(' Leaving:'||l_proc, 970);
259:
253: hr_utility.trace(' p_object_version_number '||
254: to_char(p_object_version_number));
255: hr_utility.trace(' --------------------------------'||
256: '---------------------------------');
257: hr_utility.trace(' ');
258: hr_utility.set_location(' Leaving:'||l_proc, 970);
259:
260: END IF;
261:
254: to_char(p_object_version_number));
255: hr_utility.trace(' --------------------------------'||
256: '---------------------------------');
257: hr_utility.trace(' ');
258: hr_utility.set_location(' Leaving:'||l_proc, 970);
259:
260: END IF;
261:
262: exception
272: -- when validation only mode is being used.)
273: --
274: p_sharing_instance_id := null;
275: p_object_version_number := null;
276: hr_utility.set_location(' Leaving:'||l_proc, 980);
277: when others then
278: --
279: -- A validation or unexpected error has occured
280: --
284: -- OUT parameters, including warnings, to null
285: --
286: p_sharing_instance_id := null;
287: p_object_version_number := null;
288: hr_utility.set_location(' Leaving:'||l_proc, 990);
289: raise;
290: end create_sharing_instance;
291: --
292: -- ----------------------------------------------------------------------------
306: begin
307:
308: IF g_debug THEN
309:
310: hr_utility.set_location('Entering:'|| l_proc, 10);
311:
312: hr_utility.trace(' ');
313: hr_utility.trace(' --------------------------------'||
314: '---------------------------------');
308: IF g_debug THEN
309:
310: hr_utility.set_location('Entering:'|| l_proc, 10);
311:
312: hr_utility.trace(' ');
313: hr_utility.trace(' --------------------------------'||
314: '---------------------------------');
315: hr_utility.trace(' IN / IN OUT PARAMETER '||
316: ' VALUE');
309:
310: hr_utility.set_location('Entering:'|| l_proc, 10);
311:
312: hr_utility.trace(' ');
313: hr_utility.trace(' --------------------------------'||
314: '---------------------------------');
315: hr_utility.trace(' IN / IN OUT PARAMETER '||
316: ' VALUE');
317: hr_utility.trace(' --------------------------------'||
311:
312: hr_utility.trace(' ');
313: hr_utility.trace(' --------------------------------'||
314: '---------------------------------');
315: hr_utility.trace(' IN / IN OUT PARAMETER '||
316: ' VALUE');
317: hr_utility.trace(' --------------------------------'||
318: '+--------------------------------');
319: hr_utility.trace(' p_sharing_instance_id '||
313: hr_utility.trace(' --------------------------------'||
314: '---------------------------------');
315: hr_utility.trace(' IN / IN OUT PARAMETER '||
316: ' VALUE');
317: hr_utility.trace(' --------------------------------'||
318: '+--------------------------------');
319: hr_utility.trace(' p_sharing_instance_id '||
320: to_char(p_sharing_instance_id));
321: hr_utility.trace(' p_object_version_number '||
315: hr_utility.trace(' IN / IN OUT PARAMETER '||
316: ' VALUE');
317: hr_utility.trace(' --------------------------------'||
318: '+--------------------------------');
319: hr_utility.trace(' p_sharing_instance_id '||
320: to_char(p_sharing_instance_id));
321: hr_utility.trace(' p_object_version_number '||
322: to_char(p_object_version_number));
323: hr_utility.trace(' --------------------------------'||
317: hr_utility.trace(' --------------------------------'||
318: '+--------------------------------');
319: hr_utility.trace(' p_sharing_instance_id '||
320: to_char(p_sharing_instance_id));
321: hr_utility.trace(' p_object_version_number '||
322: to_char(p_object_version_number));
323: hr_utility.trace(' --------------------------------'||
324: '---------------------------------');
325: hr_utility.trace(' ');
319: hr_utility.trace(' p_sharing_instance_id '||
320: to_char(p_sharing_instance_id));
321: hr_utility.trace(' p_object_version_number '||
322: to_char(p_object_version_number));
323: hr_utility.trace(' --------------------------------'||
324: '---------------------------------');
325: hr_utility.trace(' ');
326:
327: END IF;
321: hr_utility.trace(' p_object_version_number '||
322: to_char(p_object_version_number));
323: hr_utility.trace(' --------------------------------'||
324: '---------------------------------');
325: hr_utility.trace(' ');
326:
327: END IF;
328:
329: --
349:
350: --
351: -- Process Logic
352: --
353: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
354:
355: per_psh_del.del
356: (p_sharing_instance_id => p_sharing_instance_id
357: ,p_object_version_number => p_object_version_number
372: ,p_hook_type => 'AP'
373: );
374: end;
375:
376: IF g_debug THEN hr_utility.set_location(l_proc, 40); END IF;
377: --
378: -- When in validation only mode raise the Validate_Enabled exception
379: --
380: if p_validate then
385: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
386: --
387: IF g_debug THEN
388:
389: hr_utility.trace(' ');
390: hr_utility.trace(' --------------------------------'||
391: '---------------------------------');
392: hr_utility.trace(' IN OUT / OUT PARAMETER '||
393: ' VALUE');
386: --
387: IF g_debug THEN
388:
389: hr_utility.trace(' ');
390: hr_utility.trace(' --------------------------------'||
391: '---------------------------------');
392: hr_utility.trace(' IN OUT / OUT PARAMETER '||
393: ' VALUE');
394: hr_utility.trace(' --------------------------------'||
388:
389: hr_utility.trace(' ');
390: hr_utility.trace(' --------------------------------'||
391: '---------------------------------');
392: hr_utility.trace(' IN OUT / OUT PARAMETER '||
393: ' VALUE');
394: hr_utility.trace(' --------------------------------'||
395: '+--------------------------------');
396: hr_utility.trace(' ');
390: hr_utility.trace(' --------------------------------'||
391: '---------------------------------');
392: hr_utility.trace(' IN OUT / OUT PARAMETER '||
393: ' VALUE');
394: hr_utility.trace(' --------------------------------'||
395: '+--------------------------------');
396: hr_utility.trace(' ');
397: hr_utility.set_location(' Leaving:'||l_proc, 970);
398:
392: hr_utility.trace(' IN OUT / OUT PARAMETER '||
393: ' VALUE');
394: hr_utility.trace(' --------------------------------'||
395: '+--------------------------------');
396: hr_utility.trace(' ');
397: hr_utility.set_location(' Leaving:'||l_proc, 970);
398:
399: END IF;
400:
393: ' VALUE');
394: hr_utility.trace(' --------------------------------'||
395: '+--------------------------------');
396: hr_utility.trace(' ');
397: hr_utility.set_location(' Leaving:'||l_proc, 970);
398:
399: END IF;
400:
401: exception
404: -- As the Validate_Enabled exception has been raised
405: -- we must rollback to the savepoint
406: --
407: rollback to delete_sharing_instance;
408: hr_utility.set_location(' Leaving:'||l_proc, 980);
409: when others then
410: --
411: -- A validation or unexpected error has occured
412: --
410: --
411: -- A validation or unexpected error has occured
412: --
413: rollback to delete_sharing_instance;
414: hr_utility.set_location(' Leaving:'||l_proc, 990);
415: raise;
416: end delete_sharing_instance;
417: --
418: end hr_scorecard_sharing_api;