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_MASS_CHANGES dependencies on GHR_PA_REMARKS

Line 37: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;

33: l_multiple_error_flag boolean;
34: l_dummy varchar2(30);
35: l_remark_id ghr_remarks.remark_id%type;
36: l_description ghr_remarks.description%type;
37: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
38: l_object_version_number ghr_pa_remarks.object_version_number%type;
39: l_message varchar2(2000);
40: l_error varchar2(30);
41: l_log_text varchar2(2000);

Line 38: l_object_version_number ghr_pa_remarks.object_version_number%type;

34: l_dummy varchar2(30);
35: l_remark_id ghr_remarks.remark_id%type;
36: l_description ghr_remarks.description%type;
37: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
38: l_object_version_number ghr_pa_remarks.object_version_number%type;
39: l_message varchar2(2000);
40: l_error varchar2(30);
41: l_log_text varchar2(2000);
42: l_route_flag varchar2(1);

Line 49: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;

45: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
46: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
47: l_personnel_office_id ghr_pois.personnel_office_id%type;
48: l_personnel_officer_name per_people_f.full_name%type;
49: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
50: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
51: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
52: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
53: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;

Line 50: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;

46: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
47: l_personnel_office_id ghr_pois.personnel_office_id%type;
48: l_personnel_officer_name per_people_f.full_name%type;
49: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
50: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
51: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
52: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
53: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
54:

Line 51: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;

47: l_personnel_office_id ghr_pois.personnel_office_id%type;
48: l_personnel_officer_name per_people_f.full_name%type;
49: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
50: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
51: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
52: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
53: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
54:
55: l_au_overtime ghr_pa_requests.to_au_overtime%TYPE;

Line 52: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;

48: l_personnel_officer_name per_people_f.full_name%type;
49: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
50: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
51: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
52: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
53: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
54:
55: l_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
56: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;

Line 53: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;

49: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
50: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
51: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
52: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
53: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
54:
55: l_au_overtime ghr_pa_requests.to_au_overtime%TYPE;
56: l_auo_premium_pay_indicator ghr_pa_requests.to_auo_premium_pay_indicator%TYPE;
57: l_availability_pay ghr_pa_requests.to_availability_pay%TYPE;

Line 1213: l_description ghr_pa_remarks.description%type;

1209: is
1210:
1211: l_proc varchar2(72) := g_package || 'create_remarks';
1212: l_remark_id ghr_remarks.remark_id%type;
1213: l_description ghr_pa_remarks.description%type;
1214: -- Bug#4256022 Declared the variable l_description_out
1215: l_description_out ghr_pa_remarks.description%type;
1216: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
1217: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;

Line 1215: l_description_out ghr_pa_remarks.description%type;

1211: l_proc varchar2(72) := g_package || 'create_remarks';
1212: l_remark_id ghr_remarks.remark_id%type;
1213: l_description ghr_pa_remarks.description%type;
1214: -- Bug#4256022 Declared the variable l_description_out
1215: l_description_out ghr_pa_remarks.description%type;
1216: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
1217: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
1218: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
1219: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;

Line 1216: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;

1212: l_remark_id ghr_remarks.remark_id%type;
1213: l_description ghr_pa_remarks.description%type;
1214: -- Bug#4256022 Declared the variable l_description_out
1215: l_description_out ghr_pa_remarks.description%type;
1216: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
1217: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
1218: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
1219: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
1220: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;

Line 1217: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;

1213: l_description ghr_pa_remarks.description%type;
1214: -- Bug#4256022 Declared the variable l_description_out
1215: l_description_out ghr_pa_remarks.description%type;
1216: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
1217: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
1218: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
1219: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
1220: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
1221: l_retained_grade_rec ghr_pay_calc.retained_Grade_rec_type;

Line 1218: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;

1214: -- Bug#4256022 Declared the variable l_description_out
1215: l_description_out ghr_pa_remarks.description%type;
1216: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
1217: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
1218: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
1219: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
1220: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
1221: l_retained_grade_rec ghr_pay_calc.retained_Grade_rec_type;
1222: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;

Line 1219: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;

1215: l_description_out ghr_pa_remarks.description%type;
1216: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
1217: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
1218: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
1219: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
1220: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
1221: l_retained_grade_rec ghr_pay_calc.retained_Grade_rec_type;
1222: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
1223: l_object_version_number ghr_pa_remarks.object_version_number%type;

Line 1220: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;

1216: l_remark_code_information1 ghr_pa_remarks.remark_code_information1%type;
1217: l_remark_code_information2 ghr_pa_remarks.remark_code_information2%type;
1218: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
1219: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
1220: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
1221: l_retained_grade_rec ghr_pay_calc.retained_Grade_rec_type;
1222: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
1223: l_object_version_number ghr_pa_remarks.object_version_number%type;
1224:

Line 1222: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;

1218: l_remark_code_information3 ghr_pa_remarks.remark_code_information3%type;
1219: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
1220: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
1221: l_retained_grade_rec ghr_pay_calc.retained_Grade_rec_type;
1222: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
1223: l_object_version_number ghr_pa_remarks.object_version_number%type;
1224:
1225: begin
1226:

Line 1223: l_object_version_number ghr_pa_remarks.object_version_number%type;

1219: l_remark_code_information4 ghr_pa_remarks.remark_code_information4%type;
1220: l_remark_code_information5 ghr_pa_remarks.remark_code_information5%type;
1221: l_retained_grade_rec ghr_pay_calc.retained_Grade_rec_type;
1222: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
1223: l_object_version_number ghr_pa_remarks.object_version_number%type;
1224:
1225: begin
1226:
1227: -- get remark_id remark_desc, remark_code_information1, ...

Line 1269: ghr_pa_remarks_api.create_pa_remarks

1265: );
1266: l_description := l_description_out;
1267: End if;
1268:
1269: ghr_pa_remarks_api.create_pa_remarks
1270: (
1271: p_PA_REQUEST_ID => p_pa_request_rec.pa_request_id,
1272: p_REMARK_ID => l_remark_id,
1273: p_DESCRIPTION => l_description,