DBA Data[Home] [Help]

APPS.GHR_NOAC_LAS_API dependencies on GHR_NOAC_LAS

Line 1: Package Body ghr_noac_las_api as

1: Package Body ghr_noac_las_api as
2: /* $Header: ghnlaapi.pkb 120.1.12010000.1 2009/03/26 10:10:34 utokachi noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' ghr_noac_las_api.';

2: /* $Header: ghnlaapi.pkb 120.1.12010000.1 2009/03/26 10:10:34 utokachi noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ghr_noac_las_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_noac_las >----------------------|
10: -- ----------------------------------------------------------------------------

Line 28: l_noac_la_id ghr_noac_las.noac_la_id%TYPE;

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) ;
30: l_object_version_number ghr_noac_las.object_version_number%TYPE;
31: --
32: begin

Line 30: l_object_version_number ghr_noac_las.object_version_number%TYPE;

26: -- Declare cursors and local variables
27: --
28: l_noac_la_id ghr_noac_las.noac_la_id%TYPE;
29: l_proc varchar2(72) ;
30: l_object_version_number ghr_noac_las.object_version_number%TYPE;
31: --
32: begin
33: --
34: l_proc := g_package||'create_noac_las';

Line 49: ghr_noac_las_bk1.create_noac_las_b

45: begin
46: --
47: -- Start of API User Hook for the before hook of create_noac_las
48: --
49: ghr_noac_las_bk1.create_noac_las_b
50: (
51: p_nature_of_action_id => p_nature_of_action_id
52: ,p_lac_lookup_code => p_lac_lookup_code
53: ,p_enabled_flag => p_enabled_flag

Line 90: ghr_noac_las_bk1.create_noac_las_a

86: begin
87: --
88: -- Start of API User Hook for the after hook of create_noac_las
89: --
90: ghr_noac_las_bk1.create_noac_las_a
91: (
92: p_noac_la_id => l_noac_la_id
93: ,p_nature_of_action_id => p_nature_of_action_id
94: ,p_lac_lookup_code => p_lac_lookup_code

Line 177: l_object_version_number ghr_noac_las.object_version_number%TYPE;

173: --
174: -- Declare cursors and local variables
175: --
176: l_proc varchar2(72) ;
177: l_object_version_number ghr_noac_las.object_version_number%TYPE;
178: l_obj_version_number ghr_noac_las.object_version_number%TYPE; -- NOCOPY Changes
179: --
180: begin
181: --

Line 178: l_obj_version_number ghr_noac_las.object_version_number%TYPE; -- NOCOPY Changes

174: -- Declare cursors and local variables
175: --
176: l_proc varchar2(72) ;
177: l_object_version_number ghr_noac_las.object_version_number%TYPE;
178: l_obj_version_number ghr_noac_las.object_version_number%TYPE; -- NOCOPY Changes
179: --
180: begin
181: --
182: l_proc := g_package||'update_noac_las';

Line 202: ghr_noac_las_bk2.update_noac_las_b

198: begin
199: --
200: -- Start of API User Hook for the before hook of update_noac_las
201: --
202: ghr_noac_las_bk2.update_noac_las_b
203: (
204: p_noac_la_id => p_noac_la_id
205: ,p_nature_of_action_id => p_nature_of_action_id
206: ,p_lac_lookup_code => p_lac_lookup_code

Line 245: ghr_noac_las_bk2.update_noac_las_a

241: begin
242: --
243: -- Start of API User Hook for the after hook of update_noac_las
244: --
245: ghr_noac_las_bk2.update_noac_las_a
246: (
247: p_noac_la_id => p_noac_la_id
248: ,p_nature_of_action_id => p_nature_of_action_id
249: ,p_lac_lookup_code => p_lac_lookup_code

Line 323: l_object_version_number ghr_noac_las.object_version_number%TYPE;

319: --
320: -- Declare cursors and local variables
321: --
322: l_proc varchar2(72) ;
323: l_object_version_number ghr_noac_las.object_version_number%TYPE;
324: l_obj_version_number ghr_noac_las.object_version_number%TYPE;
325: --
326: begin
327: --

Line 324: l_obj_version_number ghr_noac_las.object_version_number%TYPE;

320: -- Declare cursors and local variables
321: --
322: l_proc varchar2(72) ;
323: l_object_version_number ghr_noac_las.object_version_number%TYPE;
324: l_obj_version_number ghr_noac_las.object_version_number%TYPE;
325: --
326: begin
327: --
328: l_proc := g_package||'update_noac_las';

Line 347: ghr_noac_las_bk3.delete_noac_las_b

343: begin
344: --
345: -- Start of API User Hook for the before hook of delete_noac_las
346: --
347: ghr_noac_las_bk3.delete_noac_las_b
348: (
349: p_noac_la_id => p_noac_la_id
350: ,p_object_version_number => p_object_version_number
351: ,p_effective_date => trunc(p_effective_date)

Line 376: ghr_noac_las_bk3.delete_noac_las_a

372: begin
373: --
374: -- Start of API User Hook for the after hook of delete_noac_las
375: --
376: ghr_noac_las_bk3.delete_noac_las_a
377: (
378: p_noac_la_id => p_noac_la_id
379: ,p_object_version_number => l_object_version_number
380: ,p_effective_date => trunc(p_effective_date)

Line 459: end ghr_noac_las_api;

455: hr_utility.set_location(' Leaving:'||l_proc, 70);
456: --
457: end lck;
458: --
459: end ghr_noac_las_api;