3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_fr_stat_situations_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------
11: -- ----------------------------------------------------------------------------
57: l_statutory_situation_id pqh_fr_stat_situations.statutory_situation_id%type;
58:
59: begin
60:
61: g_debug := hr_utility.debug_enabled;
62:
63: if g_debug then
64: --
65: hr_utility.set_location('Entering:'|| l_proc, 10);
61: g_debug := hr_utility.debug_enabled;
62:
63: if g_debug then
64: --
65: hr_utility.set_location('Entering:'|| l_proc, 10);
66: --
67: End if;
68:
69: --
229: p_object_version_number := l_object_version_number;
230: --
231: if g_debug then
232: --
233: hr_utility.set_location(' Leaving:'||l_proc, 70);
234: --
235: End if;
236:
237: exception
250: p_object_version_number := null;
251:
252: if g_debug then
253: --
254: hr_utility.set_location(' Leaving:'||l_proc, 80);
255: --
256: End if;
257:
258: when others then
324: l_statutory_situation_id pqh_fr_stat_situations.statutory_situation_id%type;
325:
326: begin
327:
328: g_debug := hr_utility.debug_enabled;
329:
330: if g_debug then
331: --
332: hr_utility.set_location('Entering:'|| l_proc, 10);
328: g_debug := hr_utility.debug_enabled;
329:
330: if g_debug then
331: --
332: hr_utility.set_location('Entering:'|| l_proc, 10);
333: --
334: End if;
335: --
336: -- Issue a savepoint
499: p_object_version_number := l_object_version_number;
500: --
501: if g_debug then
502: --
503: hr_utility.set_location(' Leaving:'||l_proc, 70);
504: --
505: End if;
506:
507: exception
519: p_object_version_number := l_object_version_number;
520:
521: if g_debug then
522: --
523: hr_utility.set_location(' Leaving:'||l_proc, 80);
524: --
525: End if;
526:
527: when others then
568: l_temp varchar2(1);
569:
570: begin
571:
572: g_debug := hr_utility.debug_enabled;
573:
574: if g_debug then
575: --
576: hr_utility.set_location('Entering:'|| l_proc, 10);
572: g_debug := hr_utility.debug_enabled;
573:
574: if g_debug then
575: --
576: hr_utility.set_location('Entering:'|| l_proc, 10);
577: --
578: End if;
579:
580: --
658: -- p_object_version_number := l_object_version_number;
659: --
660: if g_debug then
661: --
662: hr_utility.set_location(' Leaving:'||l_proc, 70);
663: --
664: End if;
665:
666: exception
676: -- when validation only mode is being used.)
677: --
678: if g_debug then
679: --
680: hr_utility.set_location(' Leaving:'||l_proc, 80);
681: --
682: End if;
683:
684: when others then