[Home] [Help]
1: Package Body ghr_noac_las_api as
2: /* $Header: ghnlaapi.pkb 115.2 99/10/14 12:10:42 porting ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: ghnlaapi.pkb 115.2 99/10/14 12:10:42 porting ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ghr_noac_las_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_noac_las >----------------------|
10: -- ----------------------------------------------------------------------------
24: ) is
25: --
26: -- Declare cursors and local variables
27: --
28: l_noac_la_id ghr_noac_las.noac_la_id%TYPE;
29: l_proc varchar2(72) := g_package||'create_noac_las';
30: l_object_version_number ghr_noac_las.object_version_number%TYPE;
31: --
32: begin
26: -- Declare cursors and local variables
27: --
28: l_noac_la_id ghr_noac_las.noac_la_id%TYPE;
29: l_proc varchar2(72) := g_package||'create_noac_las';
30: l_object_version_number ghr_noac_las.object_version_number%TYPE;
31: --
32: begin
33: --
34: hr_utility.set_location('Entering:'|| l_proc, 10);
44: begin
45: --
46: -- Start of API User Hook for the before hook of create_noac_las
47: --
48: ghr_noac_las_bk1.create_noac_las_b
49: (
50: p_nature_of_action_id => p_nature_of_action_id
51: ,p_lac_lookup_code => p_lac_lookup_code
52: ,p_enabled_flag => p_enabled_flag
85: begin
86: --
87: -- Start of API User Hook for the after hook of create_noac_las
88: --
89: ghr_noac_las_bk1.create_noac_las_a
90: (
91: p_noac_la_id => l_noac_la_id
92: ,p_nature_of_action_id => p_nature_of_action_id
93: ,p_lac_lookup_code => p_lac_lookup_code
170: --
171: -- Declare cursors and local variables
172: --
173: l_proc varchar2(72) := g_package||'update_noac_las';
174: l_object_version_number ghr_noac_las.object_version_number%TYPE;
175: --
176: begin
177: --
178: hr_utility.set_location('Entering:'|| l_proc, 10);
190: begin
191: --
192: -- Start of API User Hook for the before hook of update_noac_las
193: --
194: ghr_noac_las_bk2.update_noac_las_b
195: (
196: p_noac_la_id => p_noac_la_id
197: ,p_nature_of_action_id => p_nature_of_action_id
198: ,p_lac_lookup_code => p_lac_lookup_code
232: begin
233: --
234: -- Start of API User Hook for the after hook of update_noac_las
235: --
236: ghr_noac_las_bk2.update_noac_las_a
237: (
238: p_noac_la_id => p_noac_la_id
239: ,p_nature_of_action_id => p_nature_of_action_id
240: ,p_lac_lookup_code => p_lac_lookup_code
307: --
308: -- Declare cursors and local variables
309: --
310: l_proc varchar2(72) := g_package||'update_noac_las';
311: l_object_version_number ghr_noac_las.object_version_number%TYPE;
312: --
313: begin
314: --
315: hr_utility.set_location('Entering:'|| l_proc, 10);
328: begin
329: --
330: -- Start of API User Hook for the before hook of delete_noac_las
331: --
332: ghr_noac_las_bk3.delete_noac_las_b
333: (
334: p_noac_la_id => p_noac_la_id
335: ,p_object_version_number => p_object_version_number
336: ,p_effective_date => trunc(p_effective_date)
356: begin
357: --
358: -- Start of API User Hook for the after hook of delete_noac_las
359: --
360: ghr_noac_las_bk3.delete_noac_las_a
361: (
362: p_noac_la_id => p_noac_la_id
363: ,p_object_version_number => l_object_version_number
364: ,p_effective_date => trunc(p_effective_date)
435: hr_utility.set_location(' Leaving:'||l_proc, 70);
436: --
437: end lck;
438: --
439: end ghr_noac_las_api;