DBA Data[Home] [Help]

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 120.1.12010000.1 2009/03/26 10:13:21 utokachi noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: ghnreapi.pkb 120.1.12010000.1 2009/03/26 10:13:21 utokachi noship $ */
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);
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);
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 57: ghr_noac_remarks_bk1.create_noac_remarks_b

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

Line 96: ghr_noac_remarks_bk1.create_noac_remarks_a

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

Line 181: l_object_version_number ghr_noac_remarks.object_version_number%TYPE;

177: --
178: -- Declare cursors and local variables
179: --
180: l_proc varchar2(72);
181: l_object_version_number ghr_noac_remarks.object_version_number%TYPE;
182: l_obj_version_number ghr_noac_remarks.object_version_number%TYPE; -- NOCOPY changes
183: l_date_from date;
184: l_date_to date;
185: --

Line 182: l_obj_version_number ghr_noac_remarks.object_version_number%TYPE; -- NOCOPY changes

178: -- Declare cursors and local variables
179: --
180: l_proc varchar2(72);
181: l_object_version_number ghr_noac_remarks.object_version_number%TYPE;
182: l_obj_version_number ghr_noac_remarks.object_version_number%TYPE; -- NOCOPY changes
183: l_date_from date;
184: l_date_to date;
185: --
186: begin

Line 214: ghr_noac_remarks_bk2.update_noac_remarks_b

210: begin
211: --
212: -- Start of API User Hook for the before hook of update_noac_remarks
213: --
214: ghr_noac_remarks_bk2.update_noac_remarks_b
215: (
216: p_noac_remark_id => p_noac_remark_id
217: ,p_nature_of_action_id => p_nature_of_action_id
218: ,p_remark_id => p_remark_id

Line 255: ghr_noac_remarks_bk2.update_noac_remarks_a

251: begin
252: --
253: -- Start of API User Hook for the after hook of update_noac_remarks
254: --
255: ghr_noac_remarks_bk2.update_noac_remarks_a
256: (
257: p_noac_remark_id => p_noac_remark_id
258: ,p_nature_of_action_id => p_nature_of_action_id
259: ,p_remark_id => p_remark_id

Line 332: l_object_version_number ghr_noac_remarks.object_version_number%TYPE;

328: --
329: -- Declare cursors and local variables
330: --
331: l_proc varchar2(72);
332: l_object_version_number ghr_noac_remarks.object_version_number%TYPE;
333: l_obj_version_number ghr_noac_remarks.object_version_number%TYPE;
334: --
335: begin
336: --

Line 333: l_obj_version_number ghr_noac_remarks.object_version_number%TYPE;

329: -- Declare cursors and local variables
330: --
331: l_proc varchar2(72);
332: l_object_version_number ghr_noac_remarks.object_version_number%TYPE;
333: l_obj_version_number ghr_noac_remarks.object_version_number%TYPE;
334: --
335: begin
336: --
337: l_proc := g_package||'update_noac_remarks';

Line 356: ghr_noac_remarks_bk3.delete_noac_remarks_b

352: begin
353: --
354: -- Start of API User Hook for the before hook of delete_noac_remarks
355: --
356: ghr_noac_remarks_bk3.delete_noac_remarks_b
357: (
358: p_noac_remark_id => p_noac_remark_id
359: ,p_object_version_number => p_object_version_number
360: ,p_effective_date => trunc(p_effective_date)

Line 385: ghr_noac_remarks_bk3.delete_noac_remarks_a

381: begin
382: --
383: -- Start of API User Hook for the after hook of delete_noac_remarks
384: --
385: ghr_noac_remarks_bk3.delete_noac_remarks_a
386: (
387: p_noac_remark_id => p_noac_remark_id
388: ,p_object_version_number => l_object_version_number
389: ,p_effective_date => trunc(p_effective_date)

Line 468: end ghr_noac_remarks_api;

464: hr_utility.set_location(' Leaving:'||l_proc, 70);
465: --
466: end lck;
467: --
468: end ghr_noac_remarks_api;