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.

[Home] [Help]

APPS.GHR_SS_RPA_CREATION dependencies on GHR_PA_REMARKS

Line 37: FROM GHR_PA_REMARKS parem,GHR_REMARKS rem

33: CURSOR del_exists_rem(p_pa_request_id in number)
34: IS
35: SELECT parem.pa_remark_id,
36: parem.object_version_number
37: FROM GHR_PA_REMARKS parem,GHR_REMARKS rem
38: WHERE parem.pa_request_id = p_pa_request_id
39: AND rem.remark_id = parem.remark_id
40: AND rem.code = 'B51';
41:

Line 157: ghr_pa_remarks_api.delete_pa_remarks

153: p_remark_code => 'B51');
154: ELSE
155: FOR cur_pa_rem IN del_exists_rem(p_pa_request_id => l_pa_request_id)
156: LOOP
157: ghr_pa_remarks_api.delete_pa_remarks
158: (p_pa_remark_id => cur_pa_rem.pa_remark_id
159: ,p_object_version_number => cur_pa_rem.object_version_number);
160: END LOOP;
161: END IF;

Line 278: l_object_version_number ghr_pa_remarks.object_version_number%type;

274: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
275: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
276: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
277: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
278: l_object_version_number ghr_pa_remarks.object_version_number%type;
279: l_full_name VARCHAR2(380);
280: l_employee_number per_people_f.employee_number%type;
281: l_routing_group_id ghr_pa_requests.routing_group_id%type;
282: l_old_fegli ghr_pa_requests.fegli%type;

Line 1368: FROM GHR_PA_REMARKS

1364:
1365: cursor chk_rem_exists(p_remark_id in NUMBER)
1366: is
1367: SELECT 1
1368: FROM GHR_PA_REMARKS
1369: WHERE pa_request_id = p_pa_request_id
1370: AND remark_id = p_remark_id;
1371:
1372: l_proc varchar2(72) := g_package || 'create_remarks';

Line 1374: l_description ghr_pa_remarks.description%type;

1370: AND remark_id = p_remark_id;
1371:
1372: l_proc varchar2(72) := g_package || 'create_remarks';
1373: l_remark_id ghr_remarks.remark_id%type;
1374: l_description ghr_pa_remarks.description%type;
1375: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
1376: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
1377: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
1378: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;

Line 1375: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;

1371:
1372: l_proc varchar2(72) := g_package || 'create_remarks';
1373: l_remark_id ghr_remarks.remark_id%type;
1374: l_description ghr_pa_remarks.description%type;
1375: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
1376: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
1377: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
1378: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
1379: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;

Line 1376: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;

1372: l_proc varchar2(72) := g_package || 'create_remarks';
1373: l_remark_id ghr_remarks.remark_id%type;
1374: l_description ghr_pa_remarks.description%type;
1375: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
1376: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
1377: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
1378: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
1379: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
1380: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;

Line 1377: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;

1373: l_remark_id ghr_remarks.remark_id%type;
1374: l_description ghr_pa_remarks.description%type;
1375: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
1376: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
1377: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
1378: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
1379: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
1380: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
1381: l_object_version_number ghr_pa_remarks.object_version_number%type;

Line 1378: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;

1374: l_description ghr_pa_remarks.description%type;
1375: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
1376: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
1377: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
1378: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
1379: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
1380: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
1381: l_object_version_number ghr_pa_remarks.object_version_number%type;
1382: rem_exists number;

Line 1379: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;

1375: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
1376: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
1377: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
1378: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
1379: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
1380: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
1381: l_object_version_number ghr_pa_remarks.object_version_number%type;
1382: rem_exists number;
1383:

Line 1380: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;

1376: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
1377: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
1378: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
1379: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
1380: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
1381: l_object_version_number ghr_pa_remarks.object_version_number%type;
1382: rem_exists number;
1383:
1384:

Line 1381: l_object_version_number ghr_pa_remarks.object_version_number%type;

1377: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
1378: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
1379: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
1380: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
1381: l_object_version_number ghr_pa_remarks.object_version_number%type;
1382: rem_exists number;
1383:
1384:
1385:

Line 1408: ghr_pa_remarks_api.create_pa_remarks

1404: l_remark_code_information3 := Null;
1405: l_remark_code_information4 := Null;
1406: l_remark_code_information5 := Null;
1407:
1408: ghr_pa_remarks_api.create_pa_remarks
1409: (
1410: P_PA_REQUEST_ID => p_pa_request_id,
1411: P_REMARK_ID => l_remark_id,
1412: P_DESCRIPTION => l_description,