APPS.GHR_NOAC_REMARKS_API dependencies on GHR_NOAC_REMARKS

Line 1: Package Body ghr_noac_remarks_api as

1: Package Body ghr_noac_remarks_api as
2: /* $Header: ghnreapi.pkb 115.1 99/10/14 12:10:50 porting ship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: ghnreapi.pkb 115.1 99/10/14 12:10:50 porting ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ghr_noac_remarks_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_noac_remarks >----------------------|
10: -- ----------------------------------------------------------------------------

Line 27: l_noac_remark_id ghr_noac_remarks.noac_remark_id%TYPE;

23: ) is
24: --
25: -- Declare cursors and local variables
26: --
27: l_noac_remark_id ghr_noac_remarks.noac_remark_id%TYPE;
28: l_proc varchar2(72) := g_package||'create_noac_remarks';
29: l_object_version_number ghr_noac_remarks.object_version_number%TYPE;
30: l_date_from date;
31: l_date_to date;

Line 29: l_object_version_number ghr_noac_remarks.object_version_number%TYPE;

25: -- Declare cursors and local variables
26: --
27: l_noac_remark_id ghr_noac_remarks.noac_remark_id%TYPE;
28: l_proc varchar2(72) := g_package||'create_noac_remarks';
29: l_object_version_number ghr_noac_remarks.object_version_number%TYPE;
30: l_date_from date;
31: l_date_to date;
32: --
33: begin

Line 55: ghr_noac_remarks_bk1.create_noac_remarks_b

51: begin
52: --
53: -- Start of API User Hook for the before hook of create_noac_remarks
54: --
55: ghr_noac_remarks_bk1.create_noac_remarks_b
56: (
57: p_nature_of_action_id => p_nature_of_action_id
58: ,p_remark_id => p_remark_id
59: ,p_required_flag => p_required_flag

Line 94: ghr_noac_remarks_bk1.create_noac_remarks_a

90: begin
91: --
92: -- Start of API User Hook for the after hook of create_noac_remarks
93: --
94: ghr_noac_remarks_bk1.create_noac_remarks_a
95: (
96: p_noac_remark_id => l_noac_remark_id
97: ,p_nature_of_action_id => p_nature_of_action_id
98: ,p_remark_id => p_remark_id

Line 177: l_object_version_number ghr_noac_remarks.object_version_number%TYPE;

173: --
174: -- Declare cursors and local variables
175: --
176: l_proc varchar2(72) := g_package||'update_noac_remarks';
177: l_object_version_number ghr_noac_remarks.object_version_number%TYPE;
178: l_date_from date;
179: l_date_to date;
180: --
181: begin

Line 206: ghr_noac_remarks_bk2.update_noac_remarks_b

202: begin
203: --
204: -- Start of API User Hook for the before hook of update_noac_remarks
205: --
206: ghr_noac_remarks_bk2.update_noac_remarks_b
207: (
208: p_noac_remark_id => p_noac_remark_id
209: ,p_nature_of_action_id => p_nature_of_action_id
210: ,p_remark_id => p_remark_id

Line 246: ghr_noac_remarks_bk2.update_noac_remarks_a

242: begin
243: --
244: -- Start of API User Hook for the after hook of update_noac_remarks
245: --
246: ghr_noac_remarks_bk2.update_noac_remarks_a
247: (
248: p_noac_remark_id => p_noac_remark_id
249: ,p_nature_of_action_id => p_nature_of_action_id
250: ,p_remark_id => p_remark_id

Line 320: l_object_version_number ghr_noac_remarks.object_version_number%TYPE;

316: --
317: -- Declare cursors and local variables
318: --
319: l_proc varchar2(72) := g_package||'update_noac_remarks';
320: l_object_version_number ghr_noac_remarks.object_version_number%TYPE;
321: --
322: begin
323: --
324: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 341: ghr_noac_remarks_bk3.delete_noac_remarks_b

337: begin
338: --
339: -- Start of API User Hook for the before hook of delete_noac_remarks
340: --
341: ghr_noac_remarks_bk3.delete_noac_remarks_b
342: (
343: p_noac_remark_id => p_noac_remark_id
344: ,p_object_version_number => p_object_version_number
345: ,p_effective_date => trunc(p_effective_date)

Line 369: ghr_noac_remarks_bk3.delete_noac_remarks_a

365: begin
366: --
367: -- Start of API User Hook for the after hook of delete_noac_remarks
368: --
369: ghr_noac_remarks_bk3.delete_noac_remarks_a
370: (
371: p_noac_remark_id => p_noac_remark_id
372: ,p_object_version_number => l_object_version_number
373: ,p_effective_date => trunc(p_effective_date)

Line 448: end ghr_noac_remarks_api;

444: hr_utility.set_location(' Leaving:'||l_proc, 70);
445: --
446: end lck;
447: --
448: end ghr_noac_remarks_api;