eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PA_REMARKS_API dependencies on GHR_PA_REMARKS

Line 1: Package Body ghr_pa_remarks_api as

1: Package Body ghr_pa_remarks_api as
2: /* $Header: ghpreapi.pkb 120.1 2006/01/27 12:31:54 vravikan noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: ghpreapi.pkb 120.1 2006/01/27 12:31:54 vravikan noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'ghr_pa_remarks_api.';
7:
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< create_pa_remarks> >--------------------------|

Line 36: from ghr_pa_remarks pre,

32: --
33: Cursor C_Sel1 is
34: Select pre.pa_remark_id,
35: pre.object_version_number
36: from ghr_pa_remarks pre,
37: ghr_noac_remarks nre
38: where pre.pa_request_id = p_pa_request_id and
39: pre.remark_id = p_remark_id and
40: nre.remark_id = pre.remark_id and

Line 58: l_object_version_number ghr_pa_remarks.object_version_number%TYPE;

54:
55:
56: l_proc varchar2(72) := g_package || 'create_pa_remarks';
57: l_exists boolean := false;
58: l_object_version_number ghr_pa_remarks.object_version_number%TYPE;
59: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
60:
61: begin
62: -- check if required remarks already exists , as it might have been populated,by the create_sf52 bp,

Line 59: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;

55:
56: l_proc varchar2(72) := g_package || 'create_pa_remarks';
57: l_exists boolean := false;
58: l_object_version_number ghr_pa_remarks.object_version_number%TYPE;
59: l_pa_remark_id ghr_pa_remarks.pa_remark_id%TYPE;
60:
61: begin
62: -- check if required remarks already exists , as it might have been populated,by the create_sf52 bp,
63: -- prior to this call.

Line 80: ghr_pa_remarks_bk1.create_pa_remarks_b (

76: --
77: -- Call Before Process User Hook
78: --
79: begin
80: ghr_pa_remarks_bk1.create_pa_remarks_b (
81: p_pa_request_id => p_pa_request_id
82: ,p_remark_id => p_remark_id
83: ,p_description => p_description
84: ,p_remark_code_information1 => p_remark_code_information1

Line 93: (p_module_name => 'create_ghr_pa_remarks',

89: );
90: exception
91: when hr_api.cannot_find_prog_unit then
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'create_ghr_pa_remarks',
94: p_hook_type => 'BP'
95: );
96: end;
97: --

Line 140: ghr_pa_remarks_bk1.create_pa_remarks_a (

136: --
137: -- Call After Process User Hook
138: --
139: begin
140: ghr_pa_remarks_bk1.create_pa_remarks_a (
141: p_pa_remark_id => l_pa_remark_id
142: ,p_pa_request_id => p_pa_request_id
143: ,p_remark_id => p_remark_id
144: ,p_description => p_description

Line 155: (p_module_name => 'create_ghr_pa_remarks',

151: );
152: exception
153: when hr_api.cannot_find_prog_unit then
154: hr_api.cannot_find_prog_unit_error
155: (p_module_name => 'create_ghr_pa_remarks',
156: p_hook_type => 'AP'
157: );
158: end;
159: --

Line 216: l_object_version_number ghr_pa_remarks.object_version_number%TYPE;

212: ,p_description in varchar2 default hr_api.g_varchar2
213: )
214: is
215: l_proc varchar2(72) := g_package || 'update_pa_remarks';
216: l_object_version_number ghr_pa_remarks.object_version_number%TYPE;
217: l_init_ovn ghr_pa_remarks.object_version_number%TYPE;
218:
219: begin
220: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 217: l_init_ovn ghr_pa_remarks.object_version_number%TYPE;

213: )
214: is
215: l_proc varchar2(72) := g_package || 'update_pa_remarks';
216: l_object_version_number ghr_pa_remarks.object_version_number%TYPE;
217: l_init_ovn ghr_pa_remarks.object_version_number%TYPE;
218:
219: begin
220: hr_utility.set_location('Entering:'|| l_proc, 5);
221: --

Line 228: ghr_pa_remarks_bk2.update_pa_remarks_b (

224: --
225: -- Call Before Process User Hook
226: --
227: begin
228: ghr_pa_remarks_bk2.update_pa_remarks_b (
229: p_pa_remark_id => p_pa_remark_id
230: ,p_description => p_description
231: ,p_remark_code_information1 => p_remark_code_information1
232: ,p_remark_code_information2 => p_remark_code_information2

Line 241: (p_module_name => 'update_ghr_pa_remarks',

237: );
238: exception
239: when hr_api.cannot_find_prog_unit then
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'update_ghr_pa_remarks',
242: p_hook_type => 'BP'
243: );
244: end;
245: --

Line 270: ghr_pa_remarks_bk2.update_pa_remarks_a (

266: --
267: -- Call After Process User Hook
268: --
269: begin
270: ghr_pa_remarks_bk2.update_pa_remarks_a (
271: p_pa_remark_id => p_pa_remark_id
272: ,p_description => p_description
273: ,p_remark_code_information1 => p_remark_code_information1
274: ,p_remark_code_information2 => p_remark_code_information2

Line 283: (p_module_name => 'update_ghr_pa_remarks',

279: );
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'update_ghr_pa_remarks',
284: p_hook_type => 'AP'
285: );
286: end;
287: --

Line 343: ghr_pa_remarks pre,

339: --
340: Cursor C_remark_reqd1 is
341: select 1
342: from ghr_noac_remarks nre,
343: ghr_pa_remarks pre,
344: ghr_pa_requests par
345: where pre.pa_remark_id = p_pa_remark_id
346: and par.pa_request_id = pre.pa_request_id
347: and nre.remark_id = pre.remark_id

Line 362: ghr_pa_remarks pre,

358:
359: Cursor C_remark_reqd2 is
360: select 1
361: from ghr_noac_remarks nre,
362: ghr_pa_remarks pre,
363: ghr_pa_requests par
364: where pre.pa_remark_id = p_pa_remark_id
365: and par.pa_request_id = pre.pa_request_id
366: and nre.remark_id = pre.remark_id

Line 383: ghr_pa_remarks_bk3.delete_pa_remarks_b (

379: --
380: -- Call Before Process User Hook
381: --
382: begin
383: ghr_pa_remarks_bk3.delete_pa_remarks_b (
384: p_pa_remark_id => p_pa_remark_id
385: ,p_object_version_number => p_object_version_number
386: );
387: exception

Line 390: (p_module_name => 'delete_ghr_pa_remarks',

386: );
387: exception
388: when hr_api.cannot_find_prog_unit then
389: hr_api.cannot_find_prog_unit_error
390: (p_module_name => 'delete_ghr_pa_remarks',
391: p_hook_type => 'BP'
392: );
393: end;
394: --

Line 437: ghr_pa_remarks_bk3.delete_pa_remarks_a (

433: --
434: -- Call After Process User Hook
435: --
436: begin
437: ghr_pa_remarks_bk3.delete_pa_remarks_a (
438: p_pa_remark_id => p_pa_remark_id
439: ,p_object_version_number => p_object_version_number
440: );
441: exception

Line 444: (p_module_name => 'delete_ghr_pa_remarks',

440: );
441: exception
442: when hr_api.cannot_find_prog_unit then
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'delete_ghr_pa_remarks',
445: p_hook_type => 'AP'
446: );
447: end;
448: --

Line 474: end ghr_pa_remarks_api;

470: hr_utility.set_location(' Leaving:'||l_proc, 12);
471: end delete_pa_remarks;
472: --
473: --
474: end ghr_pa_remarks_api;