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_CPDF_DYNRPT dependencies on GHR_PA_REQUESTS

Line 195: FROM ghr_pa_requests par

191: ,p_information_type IN VARCHAR2
192: ,p_rei_rec OUT NOCOPY ghr_pa_request_extra_info%ROWTYPE) IS
193: CURSOR c_par IS
194: SELECT par.pa_request_id
195: FROM ghr_pa_requests par
196: CONNECT BY par.pa_request_id = prior par.altered_pa_request_id
197: START WITH par.pa_request_id = p_pa_request_id;
198: --
199: CURSOR cur_rei (cp_pa_request_id IN NUMBER) IS

Line 582: from ghr_pa_requests

578: --8275231
579: cursor get_first_noa_id
580: is
581: select first_noa_id
582: from ghr_pa_requests
583: where pa_request_id = (select min(pa_request_id)
584: from ghr_pa_requests
585: connect by pa_request_id = prior altered_pa_request_id
586: start with pa_request_id = p_pa_request_id);

Line 584: from ghr_pa_requests

580: is
581: select first_noa_id
582: from ghr_pa_requests
583: where pa_request_id = (select min(pa_request_id)
584: from ghr_pa_requests
585: connect by pa_request_id = prior altered_pa_request_id
586: start with pa_request_id = p_pa_request_id);
587:
588: cursor get_dual_det

Line 594: from ghr_pa_requests

590: select rpa_type,
591: mass_action_id,
592: first_noa_code,
593: second_noa_code
594: from ghr_pa_requests
595: where pa_request_id = p_pa_request_id;
596: --8275231
597:
598: BEGIN

Line 657: ghr_pa_requests_pkg.get_SF52_loc_ddf_details (l_asgn_data.location_id

653: ,p_noa_id_corrected => l_noa_id
654: ,p_date_effective => p_effective_date
655: ,p_assignment_data => l_asgn_data);
656: --
657: ghr_pa_requests_pkg.get_SF52_loc_ddf_details (l_asgn_data.location_id
658: ,l_duty_station_id);
659: --
660: ghr_pa_requests_pkg.get_duty_station_details (l_duty_station_id
661: ,p_effective_date

Line 660: ghr_pa_requests_pkg.get_duty_station_details (l_duty_station_id

656: --
657: ghr_pa_requests_pkg.get_SF52_loc_ddf_details (l_asgn_data.location_id
658: ,l_duty_station_id);
659: --
660: ghr_pa_requests_pkg.get_duty_station_details (l_duty_station_id
661: ,p_effective_date
662: ,l_duty_station_code
663: ,l_dummy_varchar);
664: p_from_duty_station_code := l_duty_station_code;

Line 717: ghr_pa_requests_pkg.get_SF52_loc_ddf_details (l_location_id

713: ,p_duty_station_location_id => l_location_id
714: ,p_pay_rate_determinant => p_from_pay_rate_determinant
715: ,p_work_schedule => p_from_work_schedule);
716: --
717: ghr_pa_requests_pkg.get_SF52_loc_ddf_details (l_location_id
718: ,l_duty_station_id);
719:
720: ghr_pa_requests_pkg.get_duty_station_details (l_duty_station_id
721: ,p_effective_date

Line 720: ghr_pa_requests_pkg.get_duty_station_details (l_duty_station_id

716: --
717: ghr_pa_requests_pkg.get_SF52_loc_ddf_details (l_location_id
718: ,l_duty_station_id);
719:
720: ghr_pa_requests_pkg.get_duty_station_details (l_duty_station_id
721: ,p_effective_date
722: ,l_duty_station_code
723: ,l_dummy_varchar);
724: p_from_duty_station_code := l_duty_station_code;

Line 746: FROM ghr_pa_requests par

742: ,p_from_national_identifier OUT NOCOPY VARCHAR2) IS
743: --
744: CURSOR cur_prev_ssn IS
745: SELECT par.employee_national_identifier prev_ssn
746: FROM ghr_pa_requests par
747: WHERE par.pa_request_id = p_altered_pa_request_id;
748: --
749: BEGIN
750: IF p_noa_family_code = 'CORRECT' THEN

Line 1174: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;

1170: --
1171: l_info_type VARCHAR2(200) := NULL;
1172: l_api_assignment_id per_assignments.assignment_id%TYPE;
1173: --
1174: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
1175: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
1176: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
1177: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
1178: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;

Line 1175: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;

1171: l_info_type VARCHAR2(200) := NULL;
1172: l_api_assignment_id per_assignments.assignment_id%TYPE;
1173: --
1174: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
1175: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
1176: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
1177: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
1178: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
1179: l_multi_error_flag boolean;

Line 1176: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;

1172: l_api_assignment_id per_assignments.assignment_id%TYPE;
1173: --
1174: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
1175: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
1176: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
1177: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
1178: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
1179: l_multi_error_flag boolean;
1180: --

Line 1177: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;

1173: --
1174: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
1175: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
1176: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
1177: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
1178: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
1179: l_multi_error_flag boolean;
1180: --
1181: -- This cursor drives of the PAR table to first see which PA Requests had 'Update HR'

Line 1178: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;

1174: l_first_noa_id ghr_pa_requests.first_noa_id%TYPE;
1175: l_first_noa_code ghr_pa_requests.first_noa_code%TYPE;
1176: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
1177: l_first_action_la_code2 ghr_pa_requests.first_action_la_code2%TYPE;
1178: l_noa_family_code ghr_pa_requests.noa_family_code%TYPE;
1179: l_multi_error_flag boolean;
1180: --
1181: -- This cursor drives of the PAR table to first see which PA Requests had 'Update HR'
1182: -- selected by a user in the given period

Line 1185: -- 3/13/02 -- Joined the ghr_pa_requests table with per_people_f table to view the

1181: -- This cursor drives of the PAR table to first see which PA Requests had 'Update HR'
1182: -- selected by a user in the given period
1183: -- may as well select everyting from the PA Request table (saves going back!)
1184:
1185: -- 3/13/02 -- Joined the ghr_pa_requests table with per_people_f table to view the
1186: -- records based on business group id/security group id
1187: -- Not added outer join for per_people_f because we are expecting existence of person_id
1188: -- in ghr_pa_requests for the actions with status in ('UPDATE_HR_COMPLETE','FUTURE_ACTION')
1189:

Line 1188: -- in ghr_pa_requests for the actions with status in ('UPDATE_HR_COMPLETE','FUTURE_ACTION')

1184:
1185: -- 3/13/02 -- Joined the ghr_pa_requests table with per_people_f table to view the
1186: -- records based on business group id/security group id
1187: -- Not added outer join for per_people_f because we are expecting existence of person_id
1188: -- in ghr_pa_requests for the actions with status in ('UPDATE_HR_COMPLETE','FUTURE_ACTION')
1189:
1190: -- 24-OCT-2002 JH truncated sf50_approval_date because it does contain time on the db.
1191: -- which causes some rows to not be included on last day.
1192:

Line 1195: FROM ghr_pa_requests par,

1191: -- which causes some rows to not be included on last day.
1192:
1193: CURSOR cur_get_pars IS
1194: SELECT par.*
1195: FROM ghr_pa_requests par,
1196: per_people_f per
1197: WHERE NVL(par.agency_code,par.from_agency_code) LIKE p_agency
1198: AND par.person_id = per.person_id
1199: AND trunc(par.sf50_approval_date) BETWEEN per.effective_start_date

Line 1212: FROM ghr_pa_requests par,

1208: AND exclude_noac(par.first_noa_code,par.second_noa_code,par.noa_family_code) <> 'TRUE'
1209: --Bug # 10158391 added the union condition to consider the records approved in last month and effective in the reporting period
1210: UNION
1211: SELECT par.*
1212: FROM ghr_pa_requests par,
1213: per_people_f per
1214: WHERE NVL(par.agency_code,par.from_agency_code) LIKE p_agency
1215: AND par.person_id = per.person_id
1216: AND trunc(par.sf50_approval_date) BETWEEN per.effective_start_date

Line 1242: l_ghr_pa_requests_rec ghr_pa_requests%ROWTYPE;

1238: -- 3) ordering of the records will be done in the report, by agency code then ssn
1239:
1240: l_ghr_cpdf_temp_rec ghr_cpdf_temp%ROWTYPE;
1241: l_ghr_empty_cpdf_temp ghr_cpdf_temp%ROWTYPE;
1242: l_ghr_pa_requests_rec ghr_pa_requests%ROWTYPE;
1243: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
1244: l_retained_pay_plan ghr_pa_requests.to_pay_plan%type;
1245: l_retained_grade_or_level ghr_pa_requests.to_grade_or_level%type;
1246: l_retained_step_or_rate ghr_pa_requests.to_step_or_rate%type;

Line 1244: l_retained_pay_plan ghr_pa_requests.to_pay_plan%type;

1240: l_ghr_cpdf_temp_rec ghr_cpdf_temp%ROWTYPE;
1241: l_ghr_empty_cpdf_temp ghr_cpdf_temp%ROWTYPE;
1242: l_ghr_pa_requests_rec ghr_pa_requests%ROWTYPE;
1243: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
1244: l_retained_pay_plan ghr_pa_requests.to_pay_plan%type;
1245: l_retained_grade_or_level ghr_pa_requests.to_grade_or_level%type;
1246: l_retained_step_or_rate ghr_pa_requests.to_step_or_rate%type;
1247: l_sf52_rec1 ghr_pa_requests%ROWTYPE;
1248: l_sf52_rec2 ghr_pa_requests%ROWTYPE;

Line 1245: l_retained_grade_or_level ghr_pa_requests.to_grade_or_level%type;

1241: l_ghr_empty_cpdf_temp ghr_cpdf_temp%ROWTYPE;
1242: l_ghr_pa_requests_rec ghr_pa_requests%ROWTYPE;
1243: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
1244: l_retained_pay_plan ghr_pa_requests.to_pay_plan%type;
1245: l_retained_grade_or_level ghr_pa_requests.to_grade_or_level%type;
1246: l_retained_step_or_rate ghr_pa_requests.to_step_or_rate%type;
1247: l_sf52_rec1 ghr_pa_requests%ROWTYPE;
1248: l_sf52_rec2 ghr_pa_requests%ROWTYPE;
1249: l_dual_flg BOOLEAN:=FALSE;

Line 1246: l_retained_step_or_rate ghr_pa_requests.to_step_or_rate%type;

1242: l_ghr_pa_requests_rec ghr_pa_requests%ROWTYPE;
1243: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
1244: l_retained_pay_plan ghr_pa_requests.to_pay_plan%type;
1245: l_retained_grade_or_level ghr_pa_requests.to_grade_or_level%type;
1246: l_retained_step_or_rate ghr_pa_requests.to_step_or_rate%type;
1247: l_sf52_rec1 ghr_pa_requests%ROWTYPE;
1248: l_sf52_rec2 ghr_pa_requests%ROWTYPE;
1249: l_dual_flg BOOLEAN:=FALSE;
1250: l_single_flg BOOLEAN:=TRUE;

Line 1247: l_sf52_rec1 ghr_pa_requests%ROWTYPE;

1243: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
1244: l_retained_pay_plan ghr_pa_requests.to_pay_plan%type;
1245: l_retained_grade_or_level ghr_pa_requests.to_grade_or_level%type;
1246: l_retained_step_or_rate ghr_pa_requests.to_step_or_rate%type;
1247: l_sf52_rec1 ghr_pa_requests%ROWTYPE;
1248: l_sf52_rec2 ghr_pa_requests%ROWTYPE;
1249: l_dual_flg BOOLEAN:=FALSE;
1250: l_single_flg BOOLEAN:=TRUE;
1251: l_loop NUMBER :=1;

Line 1248: l_sf52_rec2 ghr_pa_requests%ROWTYPE;

1244: l_retained_pay_plan ghr_pa_requests.to_pay_plan%type;
1245: l_retained_grade_or_level ghr_pa_requests.to_grade_or_level%type;
1246: l_retained_step_or_rate ghr_pa_requests.to_step_or_rate%type;
1247: l_sf52_rec1 ghr_pa_requests%ROWTYPE;
1248: l_sf52_rec2 ghr_pa_requests%ROWTYPE;
1249: l_dual_flg BOOLEAN:=FALSE;
1250: l_single_flg BOOLEAN:=TRUE;
1251: l_loop NUMBER :=1;
1252: l_index NUMBER :=1;

Line 1271: CURSOR cur_scd_dates(p_pa_request_id ghr_pa_requests.pa_request_id%type)

1267: SELECT title,last_name
1268: FROM per_all_people_f
1269: WHERE person_id = p_person_id;
1270:
1271: CURSOR cur_scd_dates(p_pa_request_id ghr_pa_requests.pa_request_id%type)
1272: IS
1273: SELECT REI_INFORMATION3 rif ,REI_INFORMATION8 ret
1274: FROM ghr_pa_request_extra_info parei
1275: WHERE parei.pa_request_id=p_pa_request_id

Line 1304: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;

1300: l_last_name per_all_people_f.last_name%type;
1301: l_suffix per_all_people_f.title%type;
1302:
1303: -- For Dual Actions PRD is becoming null so preserving it using a local variable.
1304: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
1305:
1306: --Bug # 9329643
1307: l_employee_number per_people_f.employee_number%TYPE;
1308:

Line 1323: l_ghr_pa_requests_rec := cur_get_pars_rec;

1319: FOR cur_get_pars_rec IN cur_get_pars
1320: LOOP
1321: hr_utility.set_location(l_proc||' Get PA Request data', 20);
1322: -- 1) Get PA Request data
1323: l_ghr_pa_requests_rec := cur_get_pars_rec;
1324:
1325: l_sf52_rec1 := l_ghr_pa_requests_rec;
1326: l_sf52_rec2 := l_ghr_pa_requests_rec;
1327:

Line 1325: l_sf52_rec1 := l_ghr_pa_requests_rec;

1321: hr_utility.set_location(l_proc||' Get PA Request data', 20);
1322: -- 1) Get PA Request data
1323: l_ghr_pa_requests_rec := cur_get_pars_rec;
1324:
1325: l_sf52_rec1 := l_ghr_pa_requests_rec;
1326: l_sf52_rec2 := l_ghr_pa_requests_rec;
1327:
1328: -- Begin Bug# 5109841
1329: IF l_ghr_pa_requests_rec.second_noa_code IS NOT NULL

Line 1326: l_sf52_rec2 := l_ghr_pa_requests_rec;

1322: -- 1) Get PA Request data
1323: l_ghr_pa_requests_rec := cur_get_pars_rec;
1324:
1325: l_sf52_rec1 := l_ghr_pa_requests_rec;
1326: l_sf52_rec2 := l_ghr_pa_requests_rec;
1327:
1328: -- Begin Bug# 5109841
1329: IF l_ghr_pa_requests_rec.second_noa_code IS NOT NULL
1330: AND l_ghr_pa_requests_rec.first_noa_code NOT IN ('001','002') THEN

Line 1329: IF l_ghr_pa_requests_rec.second_noa_code IS NOT NULL

1325: l_sf52_rec1 := l_ghr_pa_requests_rec;
1326: l_sf52_rec2 := l_ghr_pa_requests_rec;
1327:
1328: -- Begin Bug# 5109841
1329: IF l_ghr_pa_requests_rec.second_noa_code IS NOT NULL
1330: AND l_ghr_pa_requests_rec.first_noa_code NOT IN ('001','002') THEN
1331: l_loop := 2;
1332: l_dual_flg := TRUE;
1333: l_single_flg := FALSE;

Line 1330: AND l_ghr_pa_requests_rec.first_noa_code NOT IN ('001','002') THEN

1326: l_sf52_rec2 := l_ghr_pa_requests_rec;
1327:
1328: -- Begin Bug# 5109841
1329: IF l_ghr_pa_requests_rec.second_noa_code IS NOT NULL
1330: AND l_ghr_pa_requests_rec.first_noa_code NOT IN ('001','002') THEN
1331: l_loop := 2;
1332: l_dual_flg := TRUE;
1333: l_single_flg := FALSE;
1334: ELSE

Line 1341: If ( l_ghr_pa_requests_rec.first_noa_code like '3%'and

1337: l_dual_flg := FALSE;
1338: END IF;
1339:
1340: /*
1341: If ( l_ghr_pa_requests_rec.first_noa_code like '3%'and
1342: l_ghr_pa_requests_rec.second_noa_code ='825' ) THEN
1343: l_loop := 2;
1344: l_dual_flg := TRUE;
1345: l_single_flg := FALSE;

Line 1342: l_ghr_pa_requests_rec.second_noa_code ='825' ) THEN

1338: END IF;
1339:
1340: /*
1341: If ( l_ghr_pa_requests_rec.first_noa_code like '3%'and
1342: l_ghr_pa_requests_rec.second_noa_code ='825' ) THEN
1343: l_loop := 2;
1344: l_dual_flg := TRUE;
1345: l_single_flg := FALSE;
1346: ELSE

Line 1359: ghr_pa_requests table. So no need to call build_corrected_sf52

1355: -- For Correction record need to build the whole lot up!
1356: -- OK it appears this function creates the whole 52 again! i.e switches the
1357: -- second noa details into the first no details
1358: Bug # 2884948 With New Correction NPA changes, we are saving the all the to side pay data in
1359: ghr_pa_requests table. So no need to call build_corrected_sf52
1360: IF l_ghr_pa_requests_rec.noa_family_code = 'CORRECT' THEN
1361: l_first_noa_id := l_ghr_pa_requests_rec.first_noa_id;
1362: l_first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
1363: l_first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;

Line 1360: IF l_ghr_pa_requests_rec.noa_family_code = 'CORRECT' THEN

1356: -- OK it appears this function creates the whole 52 again! i.e switches the
1357: -- second noa details into the first no details
1358: Bug # 2884948 With New Correction NPA changes, we are saving the all the to side pay data in
1359: ghr_pa_requests table. So no need to call build_corrected_sf52
1360: IF l_ghr_pa_requests_rec.noa_family_code = 'CORRECT' THEN
1361: l_first_noa_id := l_ghr_pa_requests_rec.first_noa_id;
1362: l_first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
1363: l_first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
1364: l_first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;

Line 1361: l_first_noa_id := l_ghr_pa_requests_rec.first_noa_id;

1357: -- second noa details into the first no details
1358: Bug # 2884948 With New Correction NPA changes, we are saving the all the to side pay data in
1359: ghr_pa_requests table. So no need to call build_corrected_sf52
1360: IF l_ghr_pa_requests_rec.noa_family_code = 'CORRECT' THEN
1361: l_first_noa_id := l_ghr_pa_requests_rec.first_noa_id;
1362: l_first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
1363: l_first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
1364: l_first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
1365: --

Line 1362: l_first_noa_code := l_ghr_pa_requests_rec.first_noa_code;

1358: Bug # 2884948 With New Correction NPA changes, we are saving the all the to side pay data in
1359: ghr_pa_requests table. So no need to call build_corrected_sf52
1360: IF l_ghr_pa_requests_rec.noa_family_code = 'CORRECT' THEN
1361: l_first_noa_id := l_ghr_pa_requests_rec.first_noa_id;
1362: l_first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
1363: l_first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
1364: l_first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
1365: --
1366:

Line 1363: l_first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;

1359: ghr_pa_requests table. So no need to call build_corrected_sf52
1360: IF l_ghr_pa_requests_rec.noa_family_code = 'CORRECT' THEN
1361: l_first_noa_id := l_ghr_pa_requests_rec.first_noa_id;
1362: l_first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
1363: l_first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
1364: l_first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
1365: --
1366:
1367: ghr_corr_canc_sf52.build_corrected_sf52

Line 1364: l_first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;

1360: IF l_ghr_pa_requests_rec.noa_family_code = 'CORRECT' THEN
1361: l_first_noa_id := l_ghr_pa_requests_rec.first_noa_id;
1362: l_first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
1363: l_first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
1364: l_first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
1365: --
1366:
1367: ghr_corr_canc_sf52.build_corrected_sf52
1368: (p_pa_request_id => l_ghr_pa_requests_rec.pa_request_id

Line 1368: (p_pa_request_id => l_ghr_pa_requests_rec.pa_request_id

1364: l_first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
1365: --
1366:
1367: ghr_corr_canc_sf52.build_corrected_sf52
1368: (p_pa_request_id => l_ghr_pa_requests_rec.pa_request_id
1369: ,p_noa_code_correct => l_ghr_pa_requests_rec.second_noa_code
1370: ,p_sf52_data_result => l_ghr_pa_requests_rec);
1371:
1372: --

Line 1369: ,p_noa_code_correct => l_ghr_pa_requests_rec.second_noa_code

1365: --
1366:
1367: ghr_corr_canc_sf52.build_corrected_sf52
1368: (p_pa_request_id => l_ghr_pa_requests_rec.pa_request_id
1369: ,p_noa_code_correct => l_ghr_pa_requests_rec.second_noa_code
1370: ,p_sf52_data_result => l_ghr_pa_requests_rec);
1371:
1372: --
1373: l_ghr_pa_requests_rec.second_noa_id := l_ghr_pa_requests_rec.first_noa_id;

Line 1370: ,p_sf52_data_result => l_ghr_pa_requests_rec);

1366:
1367: ghr_corr_canc_sf52.build_corrected_sf52
1368: (p_pa_request_id => l_ghr_pa_requests_rec.pa_request_id
1369: ,p_noa_code_correct => l_ghr_pa_requests_rec.second_noa_code
1370: ,p_sf52_data_result => l_ghr_pa_requests_rec);
1371:
1372: --
1373: l_ghr_pa_requests_rec.second_noa_id := l_ghr_pa_requests_rec.first_noa_id;
1374: l_ghr_pa_requests_rec.second_noa_code := l_ghr_pa_requests_rec.first_noa_code;

Line 1373: l_ghr_pa_requests_rec.second_noa_id := l_ghr_pa_requests_rec.first_noa_id;

1369: ,p_noa_code_correct => l_ghr_pa_requests_rec.second_noa_code
1370: ,p_sf52_data_result => l_ghr_pa_requests_rec);
1371:
1372: --
1373: l_ghr_pa_requests_rec.second_noa_id := l_ghr_pa_requests_rec.first_noa_id;
1374: l_ghr_pa_requests_rec.second_noa_code := l_ghr_pa_requests_rec.first_noa_code;
1375: l_ghr_pa_requests_rec.second_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
1376: l_ghr_pa_requests_rec.second_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
1377:

Line 1374: l_ghr_pa_requests_rec.second_noa_code := l_ghr_pa_requests_rec.first_noa_code;

1370: ,p_sf52_data_result => l_ghr_pa_requests_rec);
1371:
1372: --
1373: l_ghr_pa_requests_rec.second_noa_id := l_ghr_pa_requests_rec.first_noa_id;
1374: l_ghr_pa_requests_rec.second_noa_code := l_ghr_pa_requests_rec.first_noa_code;
1375: l_ghr_pa_requests_rec.second_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
1376: l_ghr_pa_requests_rec.second_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
1377:
1378: l_ghr_pa_requests_rec.first_noa_id := l_first_noa_id;

Line 1375: l_ghr_pa_requests_rec.second_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;

1371:
1372: --
1373: l_ghr_pa_requests_rec.second_noa_id := l_ghr_pa_requests_rec.first_noa_id;
1374: l_ghr_pa_requests_rec.second_noa_code := l_ghr_pa_requests_rec.first_noa_code;
1375: l_ghr_pa_requests_rec.second_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
1376: l_ghr_pa_requests_rec.second_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
1377:
1378: l_ghr_pa_requests_rec.first_noa_id := l_first_noa_id;
1379: l_ghr_pa_requests_rec.first_noa_code := l_first_noa_code;

Line 1376: l_ghr_pa_requests_rec.second_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;

1372: --
1373: l_ghr_pa_requests_rec.second_noa_id := l_ghr_pa_requests_rec.first_noa_id;
1374: l_ghr_pa_requests_rec.second_noa_code := l_ghr_pa_requests_rec.first_noa_code;
1375: l_ghr_pa_requests_rec.second_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
1376: l_ghr_pa_requests_rec.second_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
1377:
1378: l_ghr_pa_requests_rec.first_noa_id := l_first_noa_id;
1379: l_ghr_pa_requests_rec.first_noa_code := l_first_noa_code;
1380: l_ghr_pa_requests_rec.first_action_la_code1 := l_first_action_la_code1;

Line 1378: l_ghr_pa_requests_rec.first_noa_id := l_first_noa_id;

1374: l_ghr_pa_requests_rec.second_noa_code := l_ghr_pa_requests_rec.first_noa_code;
1375: l_ghr_pa_requests_rec.second_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
1376: l_ghr_pa_requests_rec.second_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
1377:
1378: l_ghr_pa_requests_rec.first_noa_id := l_first_noa_id;
1379: l_ghr_pa_requests_rec.first_noa_code := l_first_noa_code;
1380: l_ghr_pa_requests_rec.first_action_la_code1 := l_first_action_la_code1;
1381: l_ghr_pa_requests_rec.first_action_la_code2 := l_first_action_la_code2;
1382: l_ghr_pa_requests_rec.noa_family_code := 'CORRECT';

Line 1379: l_ghr_pa_requests_rec.first_noa_code := l_first_noa_code;

1375: l_ghr_pa_requests_rec.second_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
1376: l_ghr_pa_requests_rec.second_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
1377:
1378: l_ghr_pa_requests_rec.first_noa_id := l_first_noa_id;
1379: l_ghr_pa_requests_rec.first_noa_code := l_first_noa_code;
1380: l_ghr_pa_requests_rec.first_action_la_code1 := l_first_action_la_code1;
1381: l_ghr_pa_requests_rec.first_action_la_code2 := l_first_action_la_code2;
1382: l_ghr_pa_requests_rec.noa_family_code := 'CORRECT';
1383:

Line 1380: l_ghr_pa_requests_rec.first_action_la_code1 := l_first_action_la_code1;

1376: l_ghr_pa_requests_rec.second_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
1377:
1378: l_ghr_pa_requests_rec.first_noa_id := l_first_noa_id;
1379: l_ghr_pa_requests_rec.first_noa_code := l_first_noa_code;
1380: l_ghr_pa_requests_rec.first_action_la_code1 := l_first_action_la_code1;
1381: l_ghr_pa_requests_rec.first_action_la_code2 := l_first_action_la_code2;
1382: l_ghr_pa_requests_rec.noa_family_code := 'CORRECT';
1383:
1384: END IF;

Line 1381: l_ghr_pa_requests_rec.first_action_la_code2 := l_first_action_la_code2;

1377:
1378: l_ghr_pa_requests_rec.first_noa_id := l_first_noa_id;
1379: l_ghr_pa_requests_rec.first_noa_code := l_first_noa_code;
1380: l_ghr_pa_requests_rec.first_action_la_code1 := l_first_action_la_code1;
1381: l_ghr_pa_requests_rec.first_action_la_code2 := l_first_action_la_code2;
1382: l_ghr_pa_requests_rec.noa_family_code := 'CORRECT';
1383:
1384: END IF;
1385: */

Line 1382: l_ghr_pa_requests_rec.noa_family_code := 'CORRECT';

1378: l_ghr_pa_requests_rec.first_noa_id := l_first_noa_id;
1379: l_ghr_pa_requests_rec.first_noa_code := l_first_noa_code;
1380: l_ghr_pa_requests_rec.first_action_la_code1 := l_first_action_la_code1;
1381: l_ghr_pa_requests_rec.first_action_la_code2 := l_first_action_la_code2;
1382: l_ghr_pa_requests_rec.noa_family_code := 'CORRECT';
1383:
1384: END IF;
1385: */
1386: --

Line 1395: /* l_pay_rate_determinant := l_ghr_pa_requests_rec.pay_rate_determinant;

1391: BEGIN
1392: -- Loop twice for dual action
1393: IF ( l_dual_flg = TRUE and l_index = 1 ) then
1394: --6850492 modified for dual action to assign pay rate determinant
1395: /* l_pay_rate_determinant := l_ghr_pa_requests_rec.pay_rate_determinant;
1396: ghr_process_sf52.assign_new_rg( p_action_num => 1,
1397: p_pa_req => l_sf52_rec1);
1398:
1399: l_ghr_pa_requests_rec := l_sf52_rec1;

Line 1399: l_ghr_pa_requests_rec := l_sf52_rec1;

1395: /* l_pay_rate_determinant := l_ghr_pa_requests_rec.pay_rate_determinant;
1396: ghr_process_sf52.assign_new_rg( p_action_num => 1,
1397: p_pa_req => l_sf52_rec1);
1398:
1399: l_ghr_pa_requests_rec := l_sf52_rec1;
1400: if l_sf52_rec1.pay_rate_determinant is null then
1401: l_ghr_pa_requests_rec.pay_rate_determinant := l_pay_rate_determinant;
1402: end if; */
1403: --8275231

Line 1401: l_ghr_pa_requests_rec.pay_rate_determinant := l_pay_rate_determinant;

1397: p_pa_req => l_sf52_rec1);
1398:
1399: l_ghr_pa_requests_rec := l_sf52_rec1;
1400: if l_sf52_rec1.pay_rate_determinant is null then
1401: l_ghr_pa_requests_rec.pay_rate_determinant := l_pay_rate_determinant;
1402: end if; */
1403: --8275231
1404: ghr_process_sf52.null_2ndNoa_cols(l_sf52_rec1);
1405: l_ghr_pa_requests_rec := l_sf52_rec1;

Line 1405: l_ghr_pa_requests_rec := l_sf52_rec1;

1401: l_ghr_pa_requests_rec.pay_rate_determinant := l_pay_rate_determinant;
1402: end if; */
1403: --8275231
1404: ghr_process_sf52.null_2ndNoa_cols(l_sf52_rec1);
1405: l_ghr_pa_requests_rec := l_sf52_rec1;
1406: ELSIF ( l_dual_flg = TRUE and l_index = 2 ) then
1407: -- In case of Dual Actin assign_new_rg is nulling out the PRD.
1408: /*l_pay_rate_determinant := l_ghr_pa_requests_rec.pay_rate_determinant;
1409: ghr_process_sf52.assign_new_rg( p_action_num => 2,

Line 1408: /*l_pay_rate_determinant := l_ghr_pa_requests_rec.pay_rate_determinant;

1404: ghr_process_sf52.null_2ndNoa_cols(l_sf52_rec1);
1405: l_ghr_pa_requests_rec := l_sf52_rec1;
1406: ELSIF ( l_dual_flg = TRUE and l_index = 2 ) then
1407: -- In case of Dual Actin assign_new_rg is nulling out the PRD.
1408: /*l_pay_rate_determinant := l_ghr_pa_requests_rec.pay_rate_determinant;
1409: ghr_process_sf52.assign_new_rg( p_action_num => 2,
1410: p_pa_req => l_sf52_rec2);
1411:
1412: l_ghr_pa_requests_rec := l_sf52_rec2;

Line 1412: l_ghr_pa_requests_rec := l_sf52_rec2;

1408: /*l_pay_rate_determinant := l_ghr_pa_requests_rec.pay_rate_determinant;
1409: ghr_process_sf52.assign_new_rg( p_action_num => 2,
1410: p_pa_req => l_sf52_rec2);
1411:
1412: l_ghr_pa_requests_rec := l_sf52_rec2;
1413: if l_sf52_rec2.pay_rate_determinant is null then
1414: l_ghr_pa_requests_rec.pay_rate_determinant := l_pay_rate_determinant;
1415: end if; */
1416: --8275231

Line 1414: l_ghr_pa_requests_rec.pay_rate_determinant := l_pay_rate_determinant;

1410: p_pa_req => l_sf52_rec2);
1411:
1412: l_ghr_pa_requests_rec := l_sf52_rec2;
1413: if l_sf52_rec2.pay_rate_determinant is null then
1414: l_ghr_pa_requests_rec.pay_rate_determinant := l_pay_rate_determinant;
1415: end if; */
1416: --8275231
1417: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_rec2);
1418: ghr_process_sf52.null_2ndNoa_cols(l_sf52_rec2);

Line 1423: l_ghr_pa_requests_rec := l_sf52_rec2;

1419: for noa_family_rec in c_noa_family(l_sf52_rec2.first_noa_id,l_sf52_rec2.effective_date) loop --Bug# 8275231
1420: l_sf52_rec2.noa_family_code := noa_family_rec.noa_family_code;
1421: end loop;
1422: --8275231
1423: l_ghr_pa_requests_rec := l_sf52_rec2;
1424: l_dual_flg := FALSE;
1425: ELSIF (l_single_flg = TRUE and l_dual_flg <> TRUE ) THEN
1426: l_ghr_pa_requests_rec := cur_get_pars_rec;
1427: END IF;

Line 1426: l_ghr_pa_requests_rec := cur_get_pars_rec;

1422: --8275231
1423: l_ghr_pa_requests_rec := l_sf52_rec2;
1424: l_dual_flg := FALSE;
1425: ELSIF (l_single_flg = TRUE and l_dual_flg <> TRUE ) THEN
1426: l_ghr_pa_requests_rec := cur_get_pars_rec;
1427: END IF;
1428:
1429: --- 8490723/8490327 formating the noac before doing any comparison
1430: --- 9184710 Modified the parameter of passing as second NOAC should be NULl for DUal Actions

Line 1431: l_ghr_pa_requests_rec.first_noa_code := format_noac(l_ghr_pa_requests_rec.first_noa_code);

1427: END IF;
1428:
1429: --- 8490723/8490327 formating the noac before doing any comparison
1430: --- 9184710 Modified the parameter of passing as second NOAC should be NULl for DUal Actions
1431: l_ghr_pa_requests_rec.first_noa_code := format_noac(l_ghr_pa_requests_rec.first_noa_code);
1432: l_ghr_pa_requests_rec.second_noa_code := format_noac(l_ghr_pa_requests_rec.second_noa_code);
1433:
1434: -- Bug# 4648811getting the suffix from the Employee lastname and also removing suffix from lastname
1435: get_suffix_lname(l_ghr_pa_requests_rec.employee_last_name,

Line 1432: l_ghr_pa_requests_rec.second_noa_code := format_noac(l_ghr_pa_requests_rec.second_noa_code);

1428:
1429: --- 8490723/8490327 formating the noac before doing any comparison
1430: --- 9184710 Modified the parameter of passing as second NOAC should be NULl for DUal Actions
1431: l_ghr_pa_requests_rec.first_noa_code := format_noac(l_ghr_pa_requests_rec.first_noa_code);
1432: l_ghr_pa_requests_rec.second_noa_code := format_noac(l_ghr_pa_requests_rec.second_noa_code);
1433:
1434: -- Bug# 4648811getting the suffix from the Employee lastname and also removing suffix from lastname
1435: get_suffix_lname(l_ghr_pa_requests_rec.employee_last_name,
1436: l_ghr_pa_requests_rec.effective_date,

Line 1435: get_suffix_lname(l_ghr_pa_requests_rec.employee_last_name,

1431: l_ghr_pa_requests_rec.first_noa_code := format_noac(l_ghr_pa_requests_rec.first_noa_code);
1432: l_ghr_pa_requests_rec.second_noa_code := format_noac(l_ghr_pa_requests_rec.second_noa_code);
1433:
1434: -- Bug# 4648811getting the suffix from the Employee lastname and also removing suffix from lastname
1435: get_suffix_lname(l_ghr_pa_requests_rec.employee_last_name,
1436: l_ghr_pa_requests_rec.effective_date,
1437: l_suffix,
1438: l_last_name);
1439: --End Bug# 4648811

Line 1436: l_ghr_pa_requests_rec.effective_date,

1432: l_ghr_pa_requests_rec.second_noa_code := format_noac(l_ghr_pa_requests_rec.second_noa_code);
1433:
1434: -- Bug# 4648811getting the suffix from the Employee lastname and also removing suffix from lastname
1435: get_suffix_lname(l_ghr_pa_requests_rec.employee_last_name,
1436: l_ghr_pa_requests_rec.effective_date,
1437: l_suffix,
1438: l_last_name);
1439: --End Bug# 4648811
1440:

Line 1442: If l_ghr_pa_requests_rec.person_id is not null then

1438: l_last_name);
1439: --End Bug# 4648811
1440:
1441: --Bug # 9329643
1442: If l_ghr_pa_requests_rec.person_id is not null then
1443: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
1444: (p_person_id => l_ghr_pa_requests_rec.person_id,
1445: p_effective_date => l_ghr_pa_requests_rec.effective_date);
1446: End if;

Line 1443: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

1439: --End Bug# 4648811
1440:
1441: --Bug # 9329643
1442: If l_ghr_pa_requests_rec.person_id is not null then
1443: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
1444: (p_person_id => l_ghr_pa_requests_rec.person_id,
1445: p_effective_date => l_ghr_pa_requests_rec.effective_date);
1446: End if;
1447:

Line 1444: (p_person_id => l_ghr_pa_requests_rec.person_id,

1440:
1441: --Bug # 9329643
1442: If l_ghr_pa_requests_rec.person_id is not null then
1443: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
1444: (p_person_id => l_ghr_pa_requests_rec.person_id,
1445: p_effective_date => l_ghr_pa_requests_rec.effective_date);
1446: End if;
1447:
1448: l_ghr_pa_requests_rec.employee_last_name := l_last_name;

Line 1445: p_effective_date => l_ghr_pa_requests_rec.effective_date);

1441: --Bug # 9329643
1442: If l_ghr_pa_requests_rec.person_id is not null then
1443: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
1444: (p_person_id => l_ghr_pa_requests_rec.person_id,
1445: p_effective_date => l_ghr_pa_requests_rec.effective_date);
1446: End if;
1447:
1448: l_ghr_pa_requests_rec.employee_last_name := l_last_name;
1449:

Line 1448: l_ghr_pa_requests_rec.employee_last_name := l_last_name;

1444: (p_person_id => l_ghr_pa_requests_rec.person_id,
1445: p_effective_date => l_ghr_pa_requests_rec.effective_date);
1446: End if;
1447:
1448: l_ghr_pa_requests_rec.employee_last_name := l_last_name;
1449:
1450: hr_utility.set_location(l_proc||' Check non_us_citizen_and_foreign_ds' ,30);
1451: --
1452: -- 2.1) Do not include PAR's for a non US Citizen in a foreign country

Line 1453: IF non_us_citizen_and_foreign_ds (p_citizenship => l_ghr_pa_requests_rec.citizenship

1449:
1450: hr_utility.set_location(l_proc||' Check non_us_citizen_and_foreign_ds' ,30);
1451: --
1452: -- 2.1) Do not include PAR's for a non US Citizen in a foreign country
1453: IF non_us_citizen_and_foreign_ds (p_citizenship => l_ghr_pa_requests_rec.citizenship
1454: ,p_duty_station_code => l_ghr_pa_requests_rec.duty_station_code) THEN
1455: GOTO end_par_loop; -- loop for the next one!
1456: END IF;
1457: --

Line 1454: ,p_duty_station_code => l_ghr_pa_requests_rec.duty_station_code) THEN

1450: hr_utility.set_location(l_proc||' Check non_us_citizen_and_foreign_ds' ,30);
1451: --
1452: -- 2.1) Do not include PAR's for a non US Citizen in a foreign country
1453: IF non_us_citizen_and_foreign_ds (p_citizenship => l_ghr_pa_requests_rec.citizenship
1454: ,p_duty_station_code => l_ghr_pa_requests_rec.duty_station_code) THEN
1455: GOTO end_par_loop; -- loop for the next one!
1456: END IF;
1457: --
1458: hr_utility.set_location(l_proc||' Customer exclusion hook' ,40);

Line 1461: IF exclude_position (p_position_id => NVL(l_ghr_pa_requests_rec.to_position_id

1457: --
1458: hr_utility.set_location(l_proc||' Customer exclusion hook' ,40);
1459: --
1460: -- Bug 714944 -- Added exclusion of NAF:
1461: IF exclude_position (p_position_id => NVL(l_ghr_pa_requests_rec.to_position_id
1462: ,l_ghr_pa_requests_rec.from_position_id)
1463: ,p_effective_date => l_ghr_pa_requests_rec.effective_date) THEN
1464: GOTO end_par_loop; -- loop for the next one!
1465: END IF;

Line 1462: ,l_ghr_pa_requests_rec.from_position_id)

1458: hr_utility.set_location(l_proc||' Customer exclusion hook' ,40);
1459: --
1460: -- Bug 714944 -- Added exclusion of NAF:
1461: IF exclude_position (p_position_id => NVL(l_ghr_pa_requests_rec.to_position_id
1462: ,l_ghr_pa_requests_rec.from_position_id)
1463: ,p_effective_date => l_ghr_pa_requests_rec.effective_date) THEN
1464: GOTO end_par_loop; -- loop for the next one!
1465: END IF;
1466:

Line 1463: ,p_effective_date => l_ghr_pa_requests_rec.effective_date) THEN

1459: --
1460: -- Bug 714944 -- Added exclusion of NAF:
1461: IF exclude_position (p_position_id => NVL(l_ghr_pa_requests_rec.to_position_id
1462: ,l_ghr_pa_requests_rec.from_position_id)
1463: ,p_effective_date => l_ghr_pa_requests_rec.effective_date) THEN
1464: GOTO end_par_loop; -- loop for the next one!
1465: END IF;
1466:
1467: -- Obtain Retained Grade information

Line 1474: p_person_id => l_ghr_pa_requests_rec.person_id,

1470: l_retained_pay_plan := NULL;
1471: l_retained_grade_or_level := NULL;
1472: l_retained_step_or_rate := NULL;
1473: l_retained_grade_rec := ghr_pc_basic_pay.get_retained_grade_details (
1474: p_person_id => l_ghr_pa_requests_rec.person_id,
1475: p_effective_date => l_ghr_pa_requests_rec.effective_date
1476: );
1477:
1478: l_retained_pay_plan := l_retained_grade_rec.pay_plan;

Line 1475: p_effective_date => l_ghr_pa_requests_rec.effective_date

1471: l_retained_grade_or_level := NULL;
1472: l_retained_step_or_rate := NULL;
1473: l_retained_grade_rec := ghr_pc_basic_pay.get_retained_grade_details (
1474: p_person_id => l_ghr_pa_requests_rec.person_id,
1475: p_effective_date => l_ghr_pa_requests_rec.effective_date
1476: );
1477:
1478: l_retained_pay_plan := l_retained_grade_rec.pay_plan;
1479: l_retained_grade_or_level := l_retained_grade_rec.grade_or_level;

Line 1505: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);

1501: -- 3.1) Get all info from PAR table itself
1502: --
1503: hr_utility.set_location(l_proc||' populate cpdf temp from par' ,50);
1504: --
1505: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
1506: l_ghr_cpdf_temp_rec.to_national_identifier := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
1507:
1508: IF (l_ghr_pa_requests_rec.first_noa_code = '001' AND
1509: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '350') OR

Line 1506: l_ghr_cpdf_temp_rec.to_national_identifier := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);

1502: --
1503: hr_utility.set_location(l_proc||' populate cpdf temp from par' ,50);
1504: --
1505: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
1506: l_ghr_cpdf_temp_rec.to_national_identifier := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
1507:
1508: IF (l_ghr_pa_requests_rec.first_noa_code = '001' AND
1509: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '350') OR
1510: (l_ghr_pa_requests_rec.first_noa_code = '002' AND

Line 1508: IF (l_ghr_pa_requests_rec.first_noa_code = '001' AND

1504: --
1505: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
1506: l_ghr_cpdf_temp_rec.to_national_identifier := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
1507:
1508: IF (l_ghr_pa_requests_rec.first_noa_code = '001' AND
1509: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '350') OR
1510: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1511: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '355') OR
1512: (l_ghr_pa_requests_rec.first_noa_code NOT IN ('001', '002', '350', '355')) THEN

Line 1509: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '350') OR

1505: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
1506: l_ghr_cpdf_temp_rec.to_national_identifier := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
1507:
1508: IF (l_ghr_pa_requests_rec.first_noa_code = '001' AND
1509: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '350') OR
1510: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1511: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '355') OR
1512: (l_ghr_pa_requests_rec.first_noa_code NOT IN ('001', '002', '350', '355')) THEN
1513: IF l_ghr_pa_requests_rec.first_noa_code = '002' THEN

Line 1510: (l_ghr_pa_requests_rec.first_noa_code = '002' AND

1506: l_ghr_cpdf_temp_rec.to_national_identifier := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
1507:
1508: IF (l_ghr_pa_requests_rec.first_noa_code = '001' AND
1509: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '350') OR
1510: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1511: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '355') OR
1512: (l_ghr_pa_requests_rec.first_noa_code NOT IN ('001', '002', '350', '355')) THEN
1513: IF l_ghr_pa_requests_rec.first_noa_code = '002' THEN
1514: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.second_action_la_code1;

Line 1511: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '355') OR

1507:
1508: IF (l_ghr_pa_requests_rec.first_noa_code = '001' AND
1509: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '350') OR
1510: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1511: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '355') OR
1512: (l_ghr_pa_requests_rec.first_noa_code NOT IN ('001', '002', '350', '355')) THEN
1513: IF l_ghr_pa_requests_rec.first_noa_code = '002' THEN
1514: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.second_action_la_code1;
1515: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.second_action_la_code2;

Line 1512: (l_ghr_pa_requests_rec.first_noa_code NOT IN ('001', '002', '350', '355')) THEN

1508: IF (l_ghr_pa_requests_rec.first_noa_code = '001' AND
1509: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '350') OR
1510: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1511: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '355') OR
1512: (l_ghr_pa_requests_rec.first_noa_code NOT IN ('001', '002', '350', '355')) THEN
1513: IF l_ghr_pa_requests_rec.first_noa_code = '002' THEN
1514: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.second_action_la_code1;
1515: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.second_action_la_code2;
1516: ELSE

Line 1513: IF l_ghr_pa_requests_rec.first_noa_code = '002' THEN

1509: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '350') OR
1510: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1511: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '355') OR
1512: (l_ghr_pa_requests_rec.first_noa_code NOT IN ('001', '002', '350', '355')) THEN
1513: IF l_ghr_pa_requests_rec.first_noa_code = '002' THEN
1514: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.second_action_la_code1;
1515: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.second_action_la_code2;
1516: ELSE
1517: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;

Line 1514: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.second_action_la_code1;

1510: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1511: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '355') OR
1512: (l_ghr_pa_requests_rec.first_noa_code NOT IN ('001', '002', '350', '355')) THEN
1513: IF l_ghr_pa_requests_rec.first_noa_code = '002' THEN
1514: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.second_action_la_code1;
1515: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.second_action_la_code2;
1516: ELSE
1517: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
1518: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;

Line 1515: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.second_action_la_code2;

1511: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '355') OR
1512: (l_ghr_pa_requests_rec.first_noa_code NOT IN ('001', '002', '350', '355')) THEN
1513: IF l_ghr_pa_requests_rec.first_noa_code = '002' THEN
1514: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.second_action_la_code1;
1515: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.second_action_la_code2;
1516: ELSE
1517: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
1518: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
1519: END IF;

Line 1517: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;

1513: IF l_ghr_pa_requests_rec.first_noa_code = '002' THEN
1514: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.second_action_la_code1;
1515: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.second_action_la_code2;
1516: ELSE
1517: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
1518: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
1519: END IF;
1520: END IF;
1521:

Line 1518: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;

1514: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.second_action_la_code1;
1515: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.second_action_la_code2;
1516: ELSE
1517: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
1518: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
1519: END IF;
1520: END IF;
1521:
1522: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date; -- format in report

Line 1522: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date; -- format in report

1518: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
1519: END IF;
1520: END IF;
1521:
1522: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date; -- format in report
1523: l_ghr_cpdf_temp_rec.first_noa_code := format_noac(l_ghr_pa_requests_rec.first_noa_code);
1524: l_ghr_cpdf_temp_rec.second_noa_code := format_noac(l_ghr_pa_requests_rec.second_noa_code);-- Moved here for bug# 1399854
1525:
1526: -- IF Cancellation THEN no more data elements are needed. Bug# 1375323

Line 1523: l_ghr_cpdf_temp_rec.first_noa_code := format_noac(l_ghr_pa_requests_rec.first_noa_code);

1519: END IF;
1520: END IF;
1521:
1522: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date; -- format in report
1523: l_ghr_cpdf_temp_rec.first_noa_code := format_noac(l_ghr_pa_requests_rec.first_noa_code);
1524: l_ghr_cpdf_temp_rec.second_noa_code := format_noac(l_ghr_pa_requests_rec.second_noa_code);-- Moved here for bug# 1399854
1525:
1526: -- IF Cancellation THEN no more data elements are needed. Bug# 1375323
1527: -- Insert_row in GHR_CPDF_TEMP, and continue in the LOOP for the next PAR row.

Line 1524: l_ghr_cpdf_temp_rec.second_noa_code := format_noac(l_ghr_pa_requests_rec.second_noa_code);-- Moved here for bug# 1399854

1520: END IF;
1521:
1522: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date; -- format in report
1523: l_ghr_cpdf_temp_rec.first_noa_code := format_noac(l_ghr_pa_requests_rec.first_noa_code);
1524: l_ghr_cpdf_temp_rec.second_noa_code := format_noac(l_ghr_pa_requests_rec.second_noa_code);-- Moved here for bug# 1399854
1525:
1526: -- IF Cancellation THEN no more data elements are needed. Bug# 1375323
1527: -- Insert_row in GHR_CPDF_TEMP, and continue in the LOOP for the next PAR row.
1528: IF l_ghr_pa_requests_rec.first_noa_code = '001' THEN

Line 1528: IF l_ghr_pa_requests_rec.first_noa_code = '001' THEN

1524: l_ghr_cpdf_temp_rec.second_noa_code := format_noac(l_ghr_pa_requests_rec.second_noa_code);-- Moved here for bug# 1399854
1525:
1526: -- IF Cancellation THEN no more data elements are needed. Bug# 1375323
1527: -- Insert_row in GHR_CPDF_TEMP, and continue in the LOOP for the next PAR row.
1528: IF l_ghr_pa_requests_rec.first_noa_code = '001' THEN
1529: insert_row(l_ghr_cpdf_temp_rec);
1530: l_records_found:=TRUE;
1531: GOTO end_par_loop; -- loop for the next one!
1532: END IF;

Line 1535: l_noa_family_code := l_ghr_pa_requests_rec.noa_family_code;

1531: GOTO end_par_loop; -- loop for the next one!
1532: END IF;
1533:
1534: -- Obtain Family Code
1535: l_noa_family_code := l_ghr_pa_requests_rec.noa_family_code;
1536: IF l_noa_family_code = 'CORRECT' THEN
1537: -- Bug#2789704 Added Exception Handling
1538: BEGIN
1539: /*GHR_PROCESS_SF52.get_family_code(l_ghr_pa_requests_rec.second_noa_id,

Line 1539: /*GHR_PROCESS_SF52.get_family_code(l_ghr_pa_requests_rec.second_noa_id,

1535: l_noa_family_code := l_ghr_pa_requests_rec.noa_family_code;
1536: IF l_noa_family_code = 'CORRECT' THEN
1537: -- Bug#2789704 Added Exception Handling
1538: BEGIN
1539: /*GHR_PROCESS_SF52.get_family_code(l_ghr_pa_requests_rec.second_noa_id,
1540: l_noa_family_code);*/
1541:
1542: --Bug # 7507154 added this call to get the family code based on Effective date
1543: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family

Line 1543: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family

1539: /*GHR_PROCESS_SF52.get_family_code(l_ghr_pa_requests_rec.second_noa_id,
1540: l_noa_family_code);*/
1541:
1542: --Bug # 7507154 added this call to get the family code based on Effective date
1543: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family
1544: (l_ghr_pa_requests_rec.second_noa_id,
1545: l_ghr_pa_requests_rec.effective_date);
1546: EXCEPTION
1547: WHEN OTHERS THEN

Line 1544: (l_ghr_pa_requests_rec.second_noa_id,

1540: l_noa_family_code);*/
1541:
1542: --Bug # 7507154 added this call to get the family code based on Effective date
1543: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family
1544: (l_ghr_pa_requests_rec.second_noa_id,
1545: l_ghr_pa_requests_rec.effective_date);
1546: EXCEPTION
1547: WHEN OTHERS THEN
1548: --Bug # 9329643 Modified SSN to Emp No

Line 1545: l_ghr_pa_requests_rec.effective_date);

1541:
1542: --Bug # 7507154 added this call to get the family code based on Effective date
1543: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family
1544: (l_ghr_pa_requests_rec.second_noa_id,
1545: l_ghr_pa_requests_rec.effective_date);
1546: EXCEPTION
1547: WHEN OTHERS THEN
1548: --Bug # 9329643 Modified SSN to Emp No
1549: l_message_name := 'get_family_code';

Line 1551: l_ghr_pa_requests_rec.pa_request_id ||

1547: WHEN OTHERS THEN
1548: --Bug # 9329643 Modified SSN to Emp No
1549: l_message_name := 'get_family_code';
1550: l_log_text := 'Error in getting family code for pa_request_id: '||
1551: l_ghr_pa_requests_rec.pa_request_id ||
1552: ' ; Emp No/employee last name' ||
1553: l_employee_number ||' / '||
1554: l_ghr_pa_Requests_rec.employee_last_name ||
1555: ' ; first NOAC/Second NOAC: '||

Line 1554: l_ghr_pa_Requests_rec.employee_last_name ||

1550: l_log_text := 'Error in getting family code for pa_request_id: '||
1551: l_ghr_pa_requests_rec.pa_request_id ||
1552: ' ; Emp No/employee last name' ||
1553: l_employee_number ||' / '||
1554: l_ghr_pa_Requests_rec.employee_last_name ||
1555: ' ; first NOAC/Second NOAC: '||
1556: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1557: l_ghr_pa_requests_rec.second_noa_code ||
1558: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 1556: l_ghr_pa_requests_rec.first_noa_code || ' / '||

1552: ' ; Emp No/employee last name' ||
1553: l_employee_number ||' / '||
1554: l_ghr_pa_Requests_rec.employee_last_name ||
1555: ' ; first NOAC/Second NOAC: '||
1556: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1557: l_ghr_pa_requests_rec.second_noa_code ||
1558: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1559:
1560: Raise CPDF_DYNRPT_ERROR;

Line 1557: l_ghr_pa_requests_rec.second_noa_code ||

1553: l_employee_number ||' / '||
1554: l_ghr_pa_Requests_rec.employee_last_name ||
1555: ' ; first NOAC/Second NOAC: '||
1556: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1557: l_ghr_pa_requests_rec.second_noa_code ||
1558: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1559:
1560: Raise CPDF_DYNRPT_ERROR;
1561: END;

Line 1566: l_ghr_cpdf_temp_rec.personnel_office_id := l_ghr_pa_requests_rec.personnel_office_id;

1562: -- Bug#2789704 Added Exception Handling
1563: END IF;
1564:
1565: -- Moved POI to this place for bug# 1402287 to not print for Cancellations.
1566: l_ghr_cpdf_temp_rec.personnel_office_id := l_ghr_pa_requests_rec.personnel_office_id;
1567: l_ghr_cpdf_temp_rec.employee_date_of_birth := l_ghr_pa_requests_rec.employee_date_of_birth; -- format in report
1568: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
1569: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
1570: l_ghr_cpdf_temp_rec.tenure := l_ghr_pa_requests_rec.tenure;

Line 1567: l_ghr_cpdf_temp_rec.employee_date_of_birth := l_ghr_pa_requests_rec.employee_date_of_birth; -- format in report

1563: END IF;
1564:
1565: -- Moved POI to this place for bug# 1402287 to not print for Cancellations.
1566: l_ghr_cpdf_temp_rec.personnel_office_id := l_ghr_pa_requests_rec.personnel_office_id;
1567: l_ghr_cpdf_temp_rec.employee_date_of_birth := l_ghr_pa_requests_rec.employee_date_of_birth; -- format in report
1568: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
1569: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
1570: l_ghr_cpdf_temp_rec.tenure := l_ghr_pa_requests_rec.tenure;
1571: l_ghr_cpdf_temp_rec.service_comp_date := l_ghr_pa_requests_rec.service_comp_date; -- format in report

Line 1568: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;

1564:
1565: -- Moved POI to this place for bug# 1402287 to not print for Cancellations.
1566: l_ghr_cpdf_temp_rec.personnel_office_id := l_ghr_pa_requests_rec.personnel_office_id;
1567: l_ghr_cpdf_temp_rec.employee_date_of_birth := l_ghr_pa_requests_rec.employee_date_of_birth; -- format in report
1568: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
1569: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
1570: l_ghr_cpdf_temp_rec.tenure := l_ghr_pa_requests_rec.tenure;
1571: l_ghr_cpdf_temp_rec.service_comp_date := l_ghr_pa_requests_rec.service_comp_date; -- format in report
1572: l_ghr_cpdf_temp_rec.retirement_plan := l_ghr_pa_requests_rec.retirement_plan;

Line 1569: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;

1565: -- Moved POI to this place for bug# 1402287 to not print for Cancellations.
1566: l_ghr_cpdf_temp_rec.personnel_office_id := l_ghr_pa_requests_rec.personnel_office_id;
1567: l_ghr_cpdf_temp_rec.employee_date_of_birth := l_ghr_pa_requests_rec.employee_date_of_birth; -- format in report
1568: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
1569: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
1570: l_ghr_cpdf_temp_rec.tenure := l_ghr_pa_requests_rec.tenure;
1571: l_ghr_cpdf_temp_rec.service_comp_date := l_ghr_pa_requests_rec.service_comp_date; -- format in report
1572: l_ghr_cpdf_temp_rec.retirement_plan := l_ghr_pa_requests_rec.retirement_plan;
1573: l_ghr_cpdf_temp_rec.veterans_status := l_ghr_pa_requests_rec.veterans_status;

Line 1570: l_ghr_cpdf_temp_rec.tenure := l_ghr_pa_requests_rec.tenure;

1566: l_ghr_cpdf_temp_rec.personnel_office_id := l_ghr_pa_requests_rec.personnel_office_id;
1567: l_ghr_cpdf_temp_rec.employee_date_of_birth := l_ghr_pa_requests_rec.employee_date_of_birth; -- format in report
1568: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
1569: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
1570: l_ghr_cpdf_temp_rec.tenure := l_ghr_pa_requests_rec.tenure;
1571: l_ghr_cpdf_temp_rec.service_comp_date := l_ghr_pa_requests_rec.service_comp_date; -- format in report
1572: l_ghr_cpdf_temp_rec.retirement_plan := l_ghr_pa_requests_rec.retirement_plan;
1573: l_ghr_cpdf_temp_rec.veterans_status := l_ghr_pa_requests_rec.veterans_status;
1574:

Line 1571: l_ghr_cpdf_temp_rec.service_comp_date := l_ghr_pa_requests_rec.service_comp_date; -- format in report

1567: l_ghr_cpdf_temp_rec.employee_date_of_birth := l_ghr_pa_requests_rec.employee_date_of_birth; -- format in report
1568: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
1569: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
1570: l_ghr_cpdf_temp_rec.tenure := l_ghr_pa_requests_rec.tenure;
1571: l_ghr_cpdf_temp_rec.service_comp_date := l_ghr_pa_requests_rec.service_comp_date; -- format in report
1572: l_ghr_cpdf_temp_rec.retirement_plan := l_ghr_pa_requests_rec.retirement_plan;
1573: l_ghr_cpdf_temp_rec.veterans_status := l_ghr_pa_requests_rec.veterans_status;
1574:
1575: -- IF l_noa_family_code = 'AWARD' THEN bug#5328177

Line 1572: l_ghr_cpdf_temp_rec.retirement_plan := l_ghr_pa_requests_rec.retirement_plan;

1568: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
1569: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
1570: l_ghr_cpdf_temp_rec.tenure := l_ghr_pa_requests_rec.tenure;
1571: l_ghr_cpdf_temp_rec.service_comp_date := l_ghr_pa_requests_rec.service_comp_date; -- format in report
1572: l_ghr_cpdf_temp_rec.retirement_plan := l_ghr_pa_requests_rec.retirement_plan;
1573: l_ghr_cpdf_temp_rec.veterans_status := l_ghr_pa_requests_rec.veterans_status;
1574:
1575: -- IF l_noa_family_code = 'AWARD' THEN bug#5328177
1576: IF l_noa_family_code IN ('AWARD','GHR_INCENTIVE') THEN

Line 1573: l_ghr_cpdf_temp_rec.veterans_status := l_ghr_pa_requests_rec.veterans_status;

1569: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
1570: l_ghr_cpdf_temp_rec.tenure := l_ghr_pa_requests_rec.tenure;
1571: l_ghr_cpdf_temp_rec.service_comp_date := l_ghr_pa_requests_rec.service_comp_date; -- format in report
1572: l_ghr_cpdf_temp_rec.retirement_plan := l_ghr_pa_requests_rec.retirement_plan;
1573: l_ghr_cpdf_temp_rec.veterans_status := l_ghr_pa_requests_rec.veterans_status;
1574:
1575: -- IF l_noa_family_code = 'AWARD' THEN bug#5328177
1576: IF l_noa_family_code IN ('AWARD','GHR_INCENTIVE') THEN
1577: l_ghr_pa_requests_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;

Line 1577: l_ghr_pa_requests_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;

1573: l_ghr_cpdf_temp_rec.veterans_status := l_ghr_pa_requests_rec.veterans_status;
1574:
1575: -- IF l_noa_family_code = 'AWARD' THEN bug#5328177
1576: IF l_noa_family_code IN ('AWARD','GHR_INCENTIVE') THEN
1577: l_ghr_pa_requests_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
1578: l_ghr_pa_requests_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
1579: l_ghr_pa_requests_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
1580: l_ghr_pa_requests_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
1581: l_ghr_pa_requests_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay;

Line 1578: l_ghr_pa_requests_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;

1574:
1575: -- IF l_noa_family_code = 'AWARD' THEN bug#5328177
1576: IF l_noa_family_code IN ('AWARD','GHR_INCENTIVE') THEN
1577: l_ghr_pa_requests_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
1578: l_ghr_pa_requests_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
1579: l_ghr_pa_requests_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
1580: l_ghr_pa_requests_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
1581: l_ghr_pa_requests_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay;
1582: l_ghr_pa_requests_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;

Line 1579: l_ghr_pa_requests_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;

1575: -- IF l_noa_family_code = 'AWARD' THEN bug#5328177
1576: IF l_noa_family_code IN ('AWARD','GHR_INCENTIVE') THEN
1577: l_ghr_pa_requests_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
1578: l_ghr_pa_requests_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
1579: l_ghr_pa_requests_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
1580: l_ghr_pa_requests_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
1581: l_ghr_pa_requests_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay;
1582: l_ghr_pa_requests_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
1583: l_ghr_pa_requests_rec.to_locality_adj := l_ghr_pa_requests_rec.from_locality_adj;

Line 1580: l_ghr_pa_requests_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;

1576: IF l_noa_family_code IN ('AWARD','GHR_INCENTIVE') THEN
1577: l_ghr_pa_requests_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
1578: l_ghr_pa_requests_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
1579: l_ghr_pa_requests_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
1580: l_ghr_pa_requests_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
1581: l_ghr_pa_requests_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay;
1582: l_ghr_pa_requests_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
1583: l_ghr_pa_requests_rec.to_locality_adj := l_ghr_pa_requests_rec.from_locality_adj;
1584: END IF;

Line 1581: l_ghr_pa_requests_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay;

1577: l_ghr_pa_requests_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
1578: l_ghr_pa_requests_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
1579: l_ghr_pa_requests_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
1580: l_ghr_pa_requests_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
1581: l_ghr_pa_requests_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay;
1582: l_ghr_pa_requests_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
1583: l_ghr_pa_requests_rec.to_locality_adj := l_ghr_pa_requests_rec.from_locality_adj;
1584: END IF;
1585:

Line 1582: l_ghr_pa_requests_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;

1578: l_ghr_pa_requests_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
1579: l_ghr_pa_requests_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
1580: l_ghr_pa_requests_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
1581: l_ghr_pa_requests_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay;
1582: l_ghr_pa_requests_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
1583: l_ghr_pa_requests_rec.to_locality_adj := l_ghr_pa_requests_rec.from_locality_adj;
1584: END IF;
1585:
1586: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.to_pay_plan;

Line 1583: l_ghr_pa_requests_rec.to_locality_adj := l_ghr_pa_requests_rec.from_locality_adj;

1579: l_ghr_pa_requests_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
1580: l_ghr_pa_requests_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
1581: l_ghr_pa_requests_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay;
1582: l_ghr_pa_requests_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
1583: l_ghr_pa_requests_rec.to_locality_adj := l_ghr_pa_requests_rec.from_locality_adj;
1584: END IF;
1585:
1586: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.to_pay_plan;
1587: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;

Line 1586: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.to_pay_plan;

1582: l_ghr_pa_requests_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
1583: l_ghr_pa_requests_rec.to_locality_adj := l_ghr_pa_requests_rec.from_locality_adj;
1584: END IF;
1585:
1586: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.to_pay_plan;
1587: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;
1588: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.to_grade_or_level;
1589: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.to_step_or_rate;
1590: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.to_basic_pay; -- format in report

Line 1587: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;

1583: l_ghr_pa_requests_rec.to_locality_adj := l_ghr_pa_requests_rec.from_locality_adj;
1584: END IF;
1585:
1586: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.to_pay_plan;
1587: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;
1588: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.to_grade_or_level;
1589: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.to_step_or_rate;
1590: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.to_basic_pay; -- format in report
1591: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.to_pay_basis;

Line 1588: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.to_grade_or_level;

1584: END IF;
1585:
1586: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.to_pay_plan;
1587: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;
1588: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.to_grade_or_level;
1589: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.to_step_or_rate;
1590: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.to_basic_pay; -- format in report
1591: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.to_pay_basis;
1592:

Line 1589: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.to_step_or_rate;

1585:
1586: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.to_pay_plan;
1587: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;
1588: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.to_grade_or_level;
1589: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.to_step_or_rate;
1590: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.to_basic_pay; -- format in report
1591: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.to_pay_basis;
1592:
1593: IF l_noa_family_code <> 'AWARD' THEN

Line 1590: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.to_basic_pay; -- format in report

1586: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.to_pay_plan;
1587: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;
1588: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.to_grade_or_level;
1589: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.to_step_or_rate;
1590: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.to_basic_pay; -- format in report
1591: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.to_pay_basis;
1592:
1593: IF l_noa_family_code <> 'AWARD' THEN
1594: -- Added following 'IF' according to bug# 1375333

Line 1591: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.to_pay_basis;

1587: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;
1588: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.to_grade_or_level;
1589: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.to_step_or_rate;
1590: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.to_basic_pay; -- format in report
1591: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.to_pay_basis;
1592:
1593: IF l_noa_family_code <> 'AWARD' THEN
1594: -- Added following 'IF' according to bug# 1375333
1595: IF NOT (l_ghr_pa_requests_rec.first_noa_code LIKE '3%' OR

Line 1595: IF NOT (l_ghr_pa_requests_rec.first_noa_code LIKE '3%' OR

1591: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.to_pay_basis;
1592:
1593: IF l_noa_family_code <> 'AWARD' THEN
1594: -- Added following 'IF' according to bug# 1375333
1595: IF NOT (l_ghr_pa_requests_rec.first_noa_code LIKE '3%' OR
1596: l_ghr_pa_requests_rec.first_noa_code LIKE '4%' OR
1597: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1598: (NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '3%' OR
1599: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%')

Line 1596: l_ghr_pa_requests_rec.first_noa_code LIKE '4%' OR

1592:
1593: IF l_noa_family_code <> 'AWARD' THEN
1594: -- Added following 'IF' according to bug# 1375333
1595: IF NOT (l_ghr_pa_requests_rec.first_noa_code LIKE '3%' OR
1596: l_ghr_pa_requests_rec.first_noa_code LIKE '4%' OR
1597: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1598: (NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '3%' OR
1599: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%')
1600: )

Line 1597: (l_ghr_pa_requests_rec.first_noa_code = '002' AND

1593: IF l_noa_family_code <> 'AWARD' THEN
1594: -- Added following 'IF' according to bug# 1375333
1595: IF NOT (l_ghr_pa_requests_rec.first_noa_code LIKE '3%' OR
1596: l_ghr_pa_requests_rec.first_noa_code LIKE '4%' OR
1597: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1598: (NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '3%' OR
1599: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%')
1600: )
1601: ) THEN

Line 1598: (NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '3%' OR

1594: -- Added following 'IF' according to bug# 1375333
1595: IF NOT (l_ghr_pa_requests_rec.first_noa_code LIKE '3%' OR
1596: l_ghr_pa_requests_rec.first_noa_code LIKE '4%' OR
1597: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1598: (NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '3%' OR
1599: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%')
1600: )
1601: ) THEN
1602: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;

Line 1599: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%')

1595: IF NOT (l_ghr_pa_requests_rec.first_noa_code LIKE '3%' OR
1596: l_ghr_pa_requests_rec.first_noa_code LIKE '4%' OR
1597: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1598: (NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '3%' OR
1599: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%')
1600: )
1601: ) THEN
1602: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;
1603: ELSE

Line 1602: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;

1598: (NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '3%' OR
1599: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%')
1600: )
1601: ) THEN
1602: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;
1603: ELSE
1604: l_ghr_cpdf_temp_rec.to_pay_rate_determinant := NULL;
1605: END IF;
1606: END IF;

Line 1609: IF NOT (l_ghr_pa_requests_rec.first_noa_code LIKE '3%' OR

1605: END IF;
1606: END IF;
1607:
1608: -- Added following 'IF' according to bug# 1375333
1609: IF NOT (l_ghr_pa_requests_rec.first_noa_code LIKE '3%' OR
1610: l_ghr_pa_requests_rec.first_noa_code LIKE '4%' OR
1611: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1612: (NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '3%' OR
1613: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%')

Line 1610: l_ghr_pa_requests_rec.first_noa_code LIKE '4%' OR

1606: END IF;
1607:
1608: -- Added following 'IF' according to bug# 1375333
1609: IF NOT (l_ghr_pa_requests_rec.first_noa_code LIKE '3%' OR
1610: l_ghr_pa_requests_rec.first_noa_code LIKE '4%' OR
1611: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1612: (NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '3%' OR
1613: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%')
1614: )

Line 1611: (l_ghr_pa_requests_rec.first_noa_code = '002' AND

1607:
1608: -- Added following 'IF' according to bug# 1375333
1609: IF NOT (l_ghr_pa_requests_rec.first_noa_code LIKE '3%' OR
1610: l_ghr_pa_requests_rec.first_noa_code LIKE '4%' OR
1611: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1612: (NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '3%' OR
1613: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%')
1614: )
1615: ) THEN

Line 1612: (NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '3%' OR

1608: -- Added following 'IF' according to bug# 1375333
1609: IF NOT (l_ghr_pa_requests_rec.first_noa_code LIKE '3%' OR
1610: l_ghr_pa_requests_rec.first_noa_code LIKE '4%' OR
1611: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1612: (NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '3%' OR
1613: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%')
1614: )
1615: ) THEN
1616: l_ghr_cpdf_temp_rec.to_work_schedule := l_ghr_pa_requests_rec.work_schedule;

Line 1613: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%')

1609: IF NOT (l_ghr_pa_requests_rec.first_noa_code LIKE '3%' OR
1610: l_ghr_pa_requests_rec.first_noa_code LIKE '4%' OR
1611: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1612: (NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '3%' OR
1613: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%')
1614: )
1615: ) THEN
1616: l_ghr_cpdf_temp_rec.to_work_schedule := l_ghr_pa_requests_rec.work_schedule;
1617: --- commented for bug# 2257630 as duty station code required for all NOA codes except for cancellation action

Line 1616: l_ghr_cpdf_temp_rec.to_work_schedule := l_ghr_pa_requests_rec.work_schedule;

1612: (NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '3%' OR
1613: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%')
1614: )
1615: ) THEN
1616: l_ghr_cpdf_temp_rec.to_work_schedule := l_ghr_pa_requests_rec.work_schedule;
1617: --- commented for bug# 2257630 as duty station code required for all NOA codes except for cancellation action
1618: -- l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);
1619: ELSE
1620: l_ghr_cpdf_temp_rec.to_work_schedule := NULL;

Line 1618: -- l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);

1614: )
1615: ) THEN
1616: l_ghr_cpdf_temp_rec.to_work_schedule := l_ghr_pa_requests_rec.work_schedule;
1617: --- commented for bug# 2257630 as duty station code required for all NOA codes except for cancellation action
1618: -- l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);
1619: ELSE
1620: l_ghr_cpdf_temp_rec.to_work_schedule := NULL;
1621: END IF;
1622: l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);

Line 1622: l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);

1618: -- l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);
1619: ELSE
1620: l_ghr_cpdf_temp_rec.to_work_schedule := NULL;
1621: END IF;
1622: l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);
1623: l_ghr_cpdf_temp_rec.position_occupied := l_ghr_pa_requests_rec.position_occupied;
1624: l_ghr_cpdf_temp_rec.supervisory_status := l_ghr_pa_requests_rec.supervisory_status;
1625: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount; -- format in report
1626: -- Do the formating here and put the 'whole' name to be reported in just last name column!

Line 1623: l_ghr_cpdf_temp_rec.position_occupied := l_ghr_pa_requests_rec.position_occupied;

1619: ELSE
1620: l_ghr_cpdf_temp_rec.to_work_schedule := NULL;
1621: END IF;
1622: l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);
1623: l_ghr_cpdf_temp_rec.position_occupied := l_ghr_pa_requests_rec.position_occupied;
1624: l_ghr_cpdf_temp_rec.supervisory_status := l_ghr_pa_requests_rec.supervisory_status;
1625: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount; -- format in report
1626: -- Do the formating here and put the 'whole' name to be reported in just last name column!
1627: l_ghr_cpdf_temp_rec.employee_last_name := format_name(l_ghr_pa_requests_rec.employee_first_name

Line 1624: l_ghr_cpdf_temp_rec.supervisory_status := l_ghr_pa_requests_rec.supervisory_status;

1620: l_ghr_cpdf_temp_rec.to_work_schedule := NULL;
1621: END IF;
1622: l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);
1623: l_ghr_cpdf_temp_rec.position_occupied := l_ghr_pa_requests_rec.position_occupied;
1624: l_ghr_cpdf_temp_rec.supervisory_status := l_ghr_pa_requests_rec.supervisory_status;
1625: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount; -- format in report
1626: -- Do the formating here and put the 'whole' name to be reported in just last name column!
1627: l_ghr_cpdf_temp_rec.employee_last_name := format_name(l_ghr_pa_requests_rec.employee_first_name
1628: ,l_ghr_pa_requests_rec.employee_last_name

Line 1625: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount; -- format in report

1621: END IF;
1622: l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);
1623: l_ghr_cpdf_temp_rec.position_occupied := l_ghr_pa_requests_rec.position_occupied;
1624: l_ghr_cpdf_temp_rec.supervisory_status := l_ghr_pa_requests_rec.supervisory_status;
1625: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount; -- format in report
1626: -- Do the formating here and put the 'whole' name to be reported in just last name column!
1627: l_ghr_cpdf_temp_rec.employee_last_name := format_name(l_ghr_pa_requests_rec.employee_first_name
1628: ,l_ghr_pa_requests_rec.employee_last_name
1629: ,l_ghr_pa_requests_rec.employee_middle_names);

Line 1627: l_ghr_cpdf_temp_rec.employee_last_name := format_name(l_ghr_pa_requests_rec.employee_first_name

1623: l_ghr_cpdf_temp_rec.position_occupied := l_ghr_pa_requests_rec.position_occupied;
1624: l_ghr_cpdf_temp_rec.supervisory_status := l_ghr_pa_requests_rec.supervisory_status;
1625: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount; -- format in report
1626: -- Do the formating here and put the 'whole' name to be reported in just last name column!
1627: l_ghr_cpdf_temp_rec.employee_last_name := format_name(l_ghr_pa_requests_rec.employee_first_name
1628: ,l_ghr_pa_requests_rec.employee_last_name
1629: ,l_ghr_pa_requests_rec.employee_middle_names);
1630:
1631: -- Added IF for bug# 1375342

Line 1628: ,l_ghr_pa_requests_rec.employee_last_name

1624: l_ghr_cpdf_temp_rec.supervisory_status := l_ghr_pa_requests_rec.supervisory_status;
1625: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount; -- format in report
1626: -- Do the formating here and put the 'whole' name to be reported in just last name column!
1627: l_ghr_cpdf_temp_rec.employee_last_name := format_name(l_ghr_pa_requests_rec.employee_first_name
1628: ,l_ghr_pa_requests_rec.employee_last_name
1629: ,l_ghr_pa_requests_rec.employee_middle_names);
1630:
1631: -- Added IF for bug# 1375342
1632: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND

Line 1629: ,l_ghr_pa_requests_rec.employee_middle_names);

1625: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount; -- format in report
1626: -- Do the formating here and put the 'whole' name to be reported in just last name column!
1627: l_ghr_cpdf_temp_rec.employee_last_name := format_name(l_ghr_pa_requests_rec.employee_first_name
1628: ,l_ghr_pa_requests_rec.employee_last_name
1629: ,l_ghr_pa_requests_rec.employee_middle_names);
1630:
1631: -- Added IF for bug# 1375342
1632: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
1633: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND

Line 1632: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND

1628: ,l_ghr_pa_requests_rec.employee_last_name
1629: ,l_ghr_pa_requests_rec.employee_middle_names);
1630:
1631: -- Added IF for bug# 1375342
1632: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
1633: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND
1634: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
1635: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '2%'
1636: )

Line 1633: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND

1629: ,l_ghr_pa_requests_rec.employee_middle_names);
1630:
1631: -- Added IF for bug# 1375342
1632: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
1633: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND
1634: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
1635: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '2%'
1636: )
1637: ) THEN

Line 1634: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR

1630:
1631: -- Added IF for bug# 1375342
1632: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
1633: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND
1634: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
1635: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '2%'
1636: )
1637: ) THEN
1638: l_ghr_cpdf_temp_rec.from_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;

Line 1635: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '2%'

1631: -- Added IF for bug# 1375342
1632: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
1633: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND
1634: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
1635: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '2%'
1636: )
1637: ) THEN
1638: l_ghr_cpdf_temp_rec.from_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
1639: l_ghr_cpdf_temp_rec.from_occ_code := l_ghr_pa_requests_rec.from_occ_code;

Line 1638: l_ghr_cpdf_temp_rec.from_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;

1634: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
1635: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '2%'
1636: )
1637: ) THEN
1638: l_ghr_cpdf_temp_rec.from_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
1639: l_ghr_cpdf_temp_rec.from_occ_code := l_ghr_pa_requests_rec.from_occ_code;
1640: l_ghr_cpdf_temp_rec.from_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
1641: l_ghr_cpdf_temp_rec.from_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
1642: l_ghr_cpdf_temp_rec.from_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report

Line 1639: l_ghr_cpdf_temp_rec.from_occ_code := l_ghr_pa_requests_rec.from_occ_code;

1635: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '2%'
1636: )
1637: ) THEN
1638: l_ghr_cpdf_temp_rec.from_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
1639: l_ghr_cpdf_temp_rec.from_occ_code := l_ghr_pa_requests_rec.from_occ_code;
1640: l_ghr_cpdf_temp_rec.from_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
1641: l_ghr_cpdf_temp_rec.from_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
1642: l_ghr_cpdf_temp_rec.from_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
1643: l_ghr_cpdf_temp_rec.from_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;

Line 1640: l_ghr_cpdf_temp_rec.from_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;

1636: )
1637: ) THEN
1638: l_ghr_cpdf_temp_rec.from_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
1639: l_ghr_cpdf_temp_rec.from_occ_code := l_ghr_pa_requests_rec.from_occ_code;
1640: l_ghr_cpdf_temp_rec.from_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
1641: l_ghr_cpdf_temp_rec.from_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
1642: l_ghr_cpdf_temp_rec.from_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
1643: l_ghr_cpdf_temp_rec.from_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
1644: END IF;

Line 1641: l_ghr_cpdf_temp_rec.from_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;

1637: ) THEN
1638: l_ghr_cpdf_temp_rec.from_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
1639: l_ghr_cpdf_temp_rec.from_occ_code := l_ghr_pa_requests_rec.from_occ_code;
1640: l_ghr_cpdf_temp_rec.from_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
1641: l_ghr_cpdf_temp_rec.from_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
1642: l_ghr_cpdf_temp_rec.from_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
1643: l_ghr_cpdf_temp_rec.from_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
1644: END IF;
1645:

Line 1642: l_ghr_cpdf_temp_rec.from_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report

1638: l_ghr_cpdf_temp_rec.from_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
1639: l_ghr_cpdf_temp_rec.from_occ_code := l_ghr_pa_requests_rec.from_occ_code;
1640: l_ghr_cpdf_temp_rec.from_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
1641: l_ghr_cpdf_temp_rec.from_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
1642: l_ghr_cpdf_temp_rec.from_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
1643: l_ghr_cpdf_temp_rec.from_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
1644: END IF;
1645:
1646: IF get_loc_pay_area_code(p_duty_station_id => l_ghr_pa_requests_rec.duty_station_id,

Line 1643: l_ghr_cpdf_temp_rec.from_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;

1639: l_ghr_cpdf_temp_rec.from_occ_code := l_ghr_pa_requests_rec.from_occ_code;
1640: l_ghr_cpdf_temp_rec.from_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
1641: l_ghr_cpdf_temp_rec.from_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
1642: l_ghr_cpdf_temp_rec.from_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
1643: l_ghr_cpdf_temp_rec.from_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
1644: END IF;
1645:
1646: IF get_loc_pay_area_code(p_duty_station_id => l_ghr_pa_requests_rec.duty_station_id,
1647: p_effective_date => l_ghr_pa_requests_rec.effective_date) <> '99' THEN

Line 1646: IF get_loc_pay_area_code(p_duty_station_id => l_ghr_pa_requests_rec.duty_station_id,

1642: l_ghr_cpdf_temp_rec.from_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
1643: l_ghr_cpdf_temp_rec.from_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
1644: END IF;
1645:
1646: IF get_loc_pay_area_code(p_duty_station_id => l_ghr_pa_requests_rec.duty_station_id,
1647: p_effective_date => l_ghr_pa_requests_rec.effective_date) <> '99' THEN
1648:
1649: --7507154 ADDED incentive family
1650: IF l_noa_family_code <> 'GHR_INCENTIVE' then

Line 1647: p_effective_date => l_ghr_pa_requests_rec.effective_date) <> '99' THEN

1643: l_ghr_cpdf_temp_rec.from_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
1644: END IF;
1645:
1646: IF get_loc_pay_area_code(p_duty_station_id => l_ghr_pa_requests_rec.duty_station_id,
1647: p_effective_date => l_ghr_pa_requests_rec.effective_date) <> '99' THEN
1648:
1649: --7507154 ADDED incentive family
1650: IF l_noa_family_code <> 'GHR_INCENTIVE' then
1651: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND

Line 1651: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND

1647: p_effective_date => l_ghr_pa_requests_rec.effective_date) <> '99' THEN
1648:
1649: --7507154 ADDED incentive family
1650: IF l_noa_family_code <> 'GHR_INCENTIVE' then
1651: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
1652: l_ghr_pa_requests_rec.first_noa_code NOT LIKE '1%' AND
1653: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND
1654: (NVL(l_ghr_pa_requests_rec.first_noa_code,'@#') <> '002' OR
1655: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') NOT LIKE '2%'

Line 1652: l_ghr_pa_requests_rec.first_noa_code NOT LIKE '1%' AND

1648:
1649: --7507154 ADDED incentive family
1650: IF l_noa_family_code <> 'GHR_INCENTIVE' then
1651: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
1652: l_ghr_pa_requests_rec.first_noa_code NOT LIKE '1%' AND
1653: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND
1654: (NVL(l_ghr_pa_requests_rec.first_noa_code,'@#') <> '002' OR
1655: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') NOT LIKE '2%'
1656: )

Line 1653: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND

1649: --7507154 ADDED incentive family
1650: IF l_noa_family_code <> 'GHR_INCENTIVE' then
1651: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
1652: l_ghr_pa_requests_rec.first_noa_code NOT LIKE '1%' AND
1653: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND
1654: (NVL(l_ghr_pa_requests_rec.first_noa_code,'@#') <> '002' OR
1655: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') NOT LIKE '2%'
1656: )
1657: ) THEN

Line 1654: (NVL(l_ghr_pa_requests_rec.first_noa_code,'@#') <> '002' OR

1650: IF l_noa_family_code <> 'GHR_INCENTIVE' then
1651: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
1652: l_ghr_pa_requests_rec.first_noa_code NOT LIKE '1%' AND
1653: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND
1654: (NVL(l_ghr_pa_requests_rec.first_noa_code,'@#') <> '002' OR
1655: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') NOT LIKE '2%'
1656: )
1657: ) THEN
1658: IF (get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.from_pay_plan)) <> 'FW' OR

Line 1655: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') NOT LIKE '2%'

1651: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
1652: l_ghr_pa_requests_rec.first_noa_code NOT LIKE '1%' AND
1653: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND
1654: (NVL(l_ghr_pa_requests_rec.first_noa_code,'@#') <> '002' OR
1655: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') NOT LIKE '2%'
1656: )
1657: ) THEN
1658: IF (get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.from_pay_plan)) <> 'FW' OR
1659: --9862674 pay plans starting with N or D need to have locality adjustment.

Line 1658: IF (get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.from_pay_plan)) <> 'FW' OR

1654: (NVL(l_ghr_pa_requests_rec.first_noa_code,'@#') <> '002' OR
1655: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') NOT LIKE '2%'
1656: )
1657: ) THEN
1658: IF (get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.from_pay_plan)) <> 'FW' OR
1659: --9862674 pay plans starting with N or D need to have locality adjustment.
1660: (substr(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.from_pay_plan),1,1) IN ('N','D'))) THEN
1661: l_ghr_cpdf_temp_rec.from_locality_adj := NVL(l_ghr_pa_requests_rec.from_locality_adj, 0);
1662: ELSE

Line 1660: (substr(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.from_pay_plan),1,1) IN ('N','D'))) THEN

1656: )
1657: ) THEN
1658: IF (get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.from_pay_plan)) <> 'FW' OR
1659: --9862674 pay plans starting with N or D need to have locality adjustment.
1660: (substr(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.from_pay_plan),1,1) IN ('N','D'))) THEN
1661: l_ghr_cpdf_temp_rec.from_locality_adj := NVL(l_ghr_pa_requests_rec.from_locality_adj, 0);
1662: ELSE
1663: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
1664: END IF;

Line 1661: l_ghr_cpdf_temp_rec.from_locality_adj := NVL(l_ghr_pa_requests_rec.from_locality_adj, 0);

1657: ) THEN
1658: IF (get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.from_pay_plan)) <> 'FW' OR
1659: --9862674 pay plans starting with N or D need to have locality adjustment.
1660: (substr(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.from_pay_plan),1,1) IN ('N','D'))) THEN
1661: l_ghr_cpdf_temp_rec.from_locality_adj := NVL(l_ghr_pa_requests_rec.from_locality_adj, 0);
1662: ELSE
1663: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
1664: END IF;
1665: ELSE

Line 1672: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND

1668: END IF;
1669:
1670:
1671:
1672: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
1673: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '3%' AND
1674: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
1675: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '3%'
1676: )

Line 1673: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '3%' AND

1669:
1670:
1671:
1672: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
1673: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '3%' AND
1674: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
1675: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '3%'
1676: )
1677: ) AND

Line 1674: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR

1670:
1671:
1672: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
1673: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '3%' AND
1674: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
1675: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '3%'
1676: )
1677: ) AND
1678: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '4%' AND

Line 1675: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '3%'

1671:
1672: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
1673: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '3%' AND
1674: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
1675: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '3%'
1676: )
1677: ) AND
1678: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '4%' AND
1679: (l_ghr_pa_requests_rec.first_noa_code = '002' OR

Line 1678: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '4%' AND

1674: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
1675: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '3%'
1676: )
1677: ) AND
1678: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '4%' AND
1679: (l_ghr_pa_requests_rec.first_noa_code = '002' OR
1680: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '4%'
1681: )
1682: ) THEN

Line 1679: (l_ghr_pa_requests_rec.first_noa_code = '002' OR

1675: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '3%'
1676: )
1677: ) AND
1678: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '4%' AND
1679: (l_ghr_pa_requests_rec.first_noa_code = '002' OR
1680: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '4%'
1681: )
1682: ) THEN
1683: IF get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.to_pay_plan)) <> 'FW' THEN

Line 1680: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '4%'

1676: )
1677: ) AND
1678: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '4%' AND
1679: (l_ghr_pa_requests_rec.first_noa_code = '002' OR
1680: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '4%'
1681: )
1682: ) THEN
1683: IF get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.to_pay_plan)) <> 'FW' THEN
1684: l_ghr_cpdf_temp_rec.to_locality_adj := NVL(l_ghr_pa_requests_rec.to_locality_adj, 0);

Line 1683: IF get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.to_pay_plan)) <> 'FW' THEN

1679: (l_ghr_pa_requests_rec.first_noa_code = '002' OR
1680: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '4%'
1681: )
1682: ) THEN
1683: IF get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.to_pay_plan)) <> 'FW' THEN
1684: l_ghr_cpdf_temp_rec.to_locality_adj := NVL(l_ghr_pa_requests_rec.to_locality_adj, 0);
1685: ELSE
1686: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
1687: END IF;

Line 1684: l_ghr_cpdf_temp_rec.to_locality_adj := NVL(l_ghr_pa_requests_rec.to_locality_adj, 0);

1680: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '4%'
1681: )
1682: ) THEN
1683: IF get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.to_pay_plan)) <> 'FW' THEN
1684: l_ghr_cpdf_temp_rec.to_locality_adj := NVL(l_ghr_pa_requests_rec.to_locality_adj, 0);
1685: ELSE
1686: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
1687: END IF;
1688: ELSE

Line 1697: l_ghr_cpdf_temp_rec.to_staffing_differential := l_ghr_pa_requests_rec.to_staffing_differential; -- format in report

1693: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
1694: END IF;
1695:
1696:
1697: l_ghr_cpdf_temp_rec.to_staffing_differential := l_ghr_pa_requests_rec.to_staffing_differential; -- format in report
1698: l_ghr_cpdf_temp_rec.to_supervisory_differential:= l_ghr_pa_requests_rec.to_supervisory_differential;-- format in report
1699: l_ghr_cpdf_temp_rec.to_retention_allowance := l_ghr_pa_requests_rec.to_retention_allowance; -- format in report
1700:
1701: IF l_noa_family_code IN ('AWARD', 'OTHER_PAY','GHR_INCENTIVE') THEN -- Bug# 1400486 --GHR_INCENTIVE added for bug #5328177

Line 1698: l_ghr_cpdf_temp_rec.to_supervisory_differential:= l_ghr_pa_requests_rec.to_supervisory_differential;-- format in report

1694: END IF;
1695:
1696:
1697: l_ghr_cpdf_temp_rec.to_staffing_differential := l_ghr_pa_requests_rec.to_staffing_differential; -- format in report
1698: l_ghr_cpdf_temp_rec.to_supervisory_differential:= l_ghr_pa_requests_rec.to_supervisory_differential;-- format in report
1699: l_ghr_cpdf_temp_rec.to_retention_allowance := l_ghr_pa_requests_rec.to_retention_allowance; -- format in report
1700:
1701: IF l_noa_family_code IN ('AWARD', 'OTHER_PAY','GHR_INCENTIVE') THEN -- Bug# 1400486 --GHR_INCENTIVE added for bug #5328177
1702: IF l_ghr_pa_requests_rec.first_noa_code IN ('818', '819') OR

Line 1699: l_ghr_cpdf_temp_rec.to_retention_allowance := l_ghr_pa_requests_rec.to_retention_allowance; -- format in report

1695:
1696:
1697: l_ghr_cpdf_temp_rec.to_staffing_differential := l_ghr_pa_requests_rec.to_staffing_differential; -- format in report
1698: l_ghr_cpdf_temp_rec.to_supervisory_differential:= l_ghr_pa_requests_rec.to_supervisory_differential;-- format in report
1699: l_ghr_cpdf_temp_rec.to_retention_allowance := l_ghr_pa_requests_rec.to_retention_allowance; -- format in report
1700:
1701: IF l_noa_family_code IN ('AWARD', 'OTHER_PAY','GHR_INCENTIVE') THEN -- Bug# 1400486 --GHR_INCENTIVE added for bug #5328177
1702: IF l_ghr_pa_requests_rec.first_noa_code IN ('818', '819') OR
1703: (l_ghr_pa_requests_rec.first_noa_code = '002' AND

Line 1702: IF l_ghr_pa_requests_rec.first_noa_code IN ('818', '819') OR

1698: l_ghr_cpdf_temp_rec.to_supervisory_differential:= l_ghr_pa_requests_rec.to_supervisory_differential;-- format in report
1699: l_ghr_cpdf_temp_rec.to_retention_allowance := l_ghr_pa_requests_rec.to_retention_allowance; -- format in report
1700:
1701: IF l_noa_family_code IN ('AWARD', 'OTHER_PAY','GHR_INCENTIVE') THEN -- Bug# 1400486 --GHR_INCENTIVE added for bug #5328177
1702: IF l_ghr_pa_requests_rec.first_noa_code IN ('818', '819') OR
1703: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1704: l_ghr_pa_requests_rec.second_noa_code IN ('818', '819')) THEN
1705: IF l_ghr_cpdf_temp_rec.award_amount IS NULL THEN
1706: -- Bug# 1494916. By ENUNEZ. From 10.7 Dec2000 Patch release

Line 1703: (l_ghr_pa_requests_rec.first_noa_code = '002' AND

1699: l_ghr_cpdf_temp_rec.to_retention_allowance := l_ghr_pa_requests_rec.to_retention_allowance; -- format in report
1700:
1701: IF l_noa_family_code IN ('AWARD', 'OTHER_PAY','GHR_INCENTIVE') THEN -- Bug# 1400486 --GHR_INCENTIVE added for bug #5328177
1702: IF l_ghr_pa_requests_rec.first_noa_code IN ('818', '819') OR
1703: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1704: l_ghr_pa_requests_rec.second_noa_code IN ('818', '819')) THEN
1705: IF l_ghr_cpdf_temp_rec.award_amount IS NULL THEN
1706: -- Bug# 1494916. By ENUNEZ. From 10.7 Dec2000 Patch release
1707: IF l_ghr_pa_requests_rec.first_noa_code = '818' OR

Line 1704: l_ghr_pa_requests_rec.second_noa_code IN ('818', '819')) THEN

1700:
1701: IF l_noa_family_code IN ('AWARD', 'OTHER_PAY','GHR_INCENTIVE') THEN -- Bug# 1400486 --GHR_INCENTIVE added for bug #5328177
1702: IF l_ghr_pa_requests_rec.first_noa_code IN ('818', '819') OR
1703: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1704: l_ghr_pa_requests_rec.second_noa_code IN ('818', '819')) THEN
1705: IF l_ghr_cpdf_temp_rec.award_amount IS NULL THEN
1706: -- Bug# 1494916. By ENUNEZ. From 10.7 Dec2000 Patch release
1707: IF l_ghr_pa_requests_rec.first_noa_code = '818' OR
1708: (l_ghr_pa_requests_rec.first_noa_code = '002' AND

Line 1707: IF l_ghr_pa_requests_rec.first_noa_code = '818' OR

1703: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1704: l_ghr_pa_requests_rec.second_noa_code IN ('818', '819')) THEN
1705: IF l_ghr_cpdf_temp_rec.award_amount IS NULL THEN
1706: -- Bug# 1494916. By ENUNEZ. From 10.7 Dec2000 Patch release
1707: IF l_ghr_pa_requests_rec.first_noa_code = '818' OR
1708: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1709: l_ghr_pa_requests_rec.second_noa_code = '818') THEN
1710: -- Bug#2789704 Added Exception Handling
1711:

Line 1708: (l_ghr_pa_requests_rec.first_noa_code = '002' AND

1704: l_ghr_pa_requests_rec.second_noa_code IN ('818', '819')) THEN
1705: IF l_ghr_cpdf_temp_rec.award_amount IS NULL THEN
1706: -- Bug# 1494916. By ENUNEZ. From 10.7 Dec2000 Patch release
1707: IF l_ghr_pa_requests_rec.first_noa_code = '818' OR
1708: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1709: l_ghr_pa_requests_rec.second_noa_code = '818') THEN
1710: -- Bug#2789704 Added Exception Handling
1711:
1712: BEGIN

Line 1709: l_ghr_pa_requests_rec.second_noa_code = '818') THEN

1705: IF l_ghr_cpdf_temp_rec.award_amount IS NULL THEN
1706: -- Bug# 1494916. By ENUNEZ. From 10.7 Dec2000 Patch release
1707: IF l_ghr_pa_requests_rec.first_noa_code = '818' OR
1708: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1709: l_ghr_pa_requests_rec.second_noa_code = '818') THEN
1710: -- Bug#2789704 Added Exception Handling
1711:
1712: BEGIN
1713: ghr_api.retrieve_element_entry_value (p_element_name => 'AUO'

Line 1715: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id

1711:
1712: BEGIN
1713: ghr_api.retrieve_element_entry_value (p_element_name => 'AUO'
1714: ,p_input_value_name => 'Amount'
1715: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1716: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1717: ,p_value => l_ghr_cpdf_temp_rec.award_amount
1718: ,p_multiple_error_flag => l_multi_error_flag);
1719:

Line 1716: ,p_effective_date => l_ghr_pa_requests_rec.effective_date

1712: BEGIN
1713: ghr_api.retrieve_element_entry_value (p_element_name => 'AUO'
1714: ,p_input_value_name => 'Amount'
1715: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1716: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1717: ,p_value => l_ghr_cpdf_temp_rec.award_amount
1718: ,p_multiple_error_flag => l_multi_error_flag);
1719:
1720: -- Added the if condition for Bug#5564750

Line 1730: l_ghr_pa_requests_rec.pa_request_id ||

1726: WHEN OTHERS THEN
1727: --Bug # 9329643 Modified SSN to Emp No
1728: l_message_name := 'retrieve_element_entry_value';
1729: l_log_text := 'Error in fetching AUO Amount for pa_request_id: '||
1730: l_ghr_pa_requests_rec.pa_request_id ||
1731: ' ; Emp No/employee last name' ||
1732: l_employee_number ||' / '||
1733: l_ghr_pa_Requests_rec.employee_last_name ||
1734: ' ; first NOAC/Second NOAC: '||

Line 1733: l_ghr_pa_Requests_rec.employee_last_name ||

1729: l_log_text := 'Error in fetching AUO Amount for pa_request_id: '||
1730: l_ghr_pa_requests_rec.pa_request_id ||
1731: ' ; Emp No/employee last name' ||
1732: l_employee_number ||' / '||
1733: l_ghr_pa_Requests_rec.employee_last_name ||
1734: ' ; first NOAC/Second NOAC: '||
1735: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1736: l_ghr_pa_requests_rec.second_noa_code ||
1737: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 1735: l_ghr_pa_requests_rec.first_noa_code || ' / '||

1731: ' ; Emp No/employee last name' ||
1732: l_employee_number ||' / '||
1733: l_ghr_pa_Requests_rec.employee_last_name ||
1734: ' ; first NOAC/Second NOAC: '||
1735: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1736: l_ghr_pa_requests_rec.second_noa_code ||
1737: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1738:
1739: Raise CPDF_DYNRPT_ERROR;

Line 1736: l_ghr_pa_requests_rec.second_noa_code ||

1732: l_employee_number ||' / '||
1733: l_ghr_pa_Requests_rec.employee_last_name ||
1734: ' ; first NOAC/Second NOAC: '||
1735: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1736: l_ghr_pa_requests_rec.second_noa_code ||
1737: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1738:
1739: Raise CPDF_DYNRPT_ERROR;
1740: END;

Line 1748: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id

1744: -- Bug#2789704 Added Exception Handling
1745: BEGIN
1746: ghr_api.retrieve_element_entry_value (p_element_name => 'Availability Pay'
1747: ,p_input_value_name => 'Amount'
1748: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1749: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1750: ,p_value => l_ghr_cpdf_temp_rec.award_amount
1751: ,p_multiple_error_flag => l_multi_error_flag);
1752:

Line 1749: ,p_effective_date => l_ghr_pa_requests_rec.effective_date

1745: BEGIN
1746: ghr_api.retrieve_element_entry_value (p_element_name => 'Availability Pay'
1747: ,p_input_value_name => 'Amount'
1748: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1749: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1750: ,p_value => l_ghr_cpdf_temp_rec.award_amount
1751: ,p_multiple_error_flag => l_multi_error_flag);
1752:
1753: -- Added the if condition for Bug#5564750

Line 1763: l_ghr_pa_requests_rec.pa_request_id ||

1759: WHEN OTHERS THEN
1760: --Bug # 9329643 Modified SSN to Emp No
1761: l_message_name := 'retrieve_element_entry_value';
1762: l_log_text := 'Error in fetching Availability Pay Amount for pa_request_id: '||
1763: l_ghr_pa_requests_rec.pa_request_id ||
1764: ' ; Emp No/employee last name' ||
1765: l_employee_number ||' / '||
1766: l_ghr_pa_Requests_rec.employee_last_name ||
1767: ' ; first NOAC/Second NOAC: '||

Line 1766: l_ghr_pa_Requests_rec.employee_last_name ||

1762: l_log_text := 'Error in fetching Availability Pay Amount for pa_request_id: '||
1763: l_ghr_pa_requests_rec.pa_request_id ||
1764: ' ; Emp No/employee last name' ||
1765: l_employee_number ||' / '||
1766: l_ghr_pa_Requests_rec.employee_last_name ||
1767: ' ; first NOAC/Second NOAC: '||
1768: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1769: l_ghr_pa_requests_rec.second_noa_code ||
1770: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 1768: l_ghr_pa_requests_rec.first_noa_code || ' / '||

1764: ' ; Emp No/employee last name' ||
1765: l_employee_number ||' / '||
1766: l_ghr_pa_Requests_rec.employee_last_name ||
1767: ' ; first NOAC/Second NOAC: '||
1768: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1769: l_ghr_pa_requests_rec.second_noa_code ||
1770: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1771:
1772: Raise CPDF_DYNRPT_ERROR;

Line 1769: l_ghr_pa_requests_rec.second_noa_code ||

1765: l_employee_number ||' / '||
1766: l_ghr_pa_Requests_rec.employee_last_name ||
1767: ' ; first NOAC/Second NOAC: '||
1768: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1769: l_ghr_pa_requests_rec.second_noa_code ||
1770: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1771:
1772: Raise CPDF_DYNRPT_ERROR;
1773: END;

Line 1783: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id

1779: -- Bug#2789704 Added Exception Handling
1780: BEGIN
1781: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
1782: ,p_input_value_name => 'Amount'
1783: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1784: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1785: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential
1786: ,p_multiple_error_flag => l_multi_error_flag);
1787: EXCEPTION

Line 1784: ,p_effective_date => l_ghr_pa_requests_rec.effective_date

1780: BEGIN
1781: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
1782: ,p_input_value_name => 'Amount'
1783: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1784: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1785: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential
1786: ,p_multiple_error_flag => l_multi_error_flag);
1787: EXCEPTION
1788: WHEN OTHERS THEN

Line 1792: l_ghr_pa_requests_rec.pa_request_id ||

1788: WHEN OTHERS THEN
1789: --Bug # 9329643 Modified SSN to Emp No
1790: l_message_name := 'retrieve_element_entry_value';
1791: l_log_text := 'Error in fetching Supervisory Differential Amount for pa_request_id: '||
1792: l_ghr_pa_requests_rec.pa_request_id ||
1793: ' ; Emp No/employee last name' ||
1794: l_employee_number ||' / '||
1795: l_ghr_pa_Requests_rec.employee_last_name ||
1796: ' ; first NOAC/Second NOAC: '||

Line 1795: l_ghr_pa_Requests_rec.employee_last_name ||

1791: l_log_text := 'Error in fetching Supervisory Differential Amount for pa_request_id: '||
1792: l_ghr_pa_requests_rec.pa_request_id ||
1793: ' ; Emp No/employee last name' ||
1794: l_employee_number ||' / '||
1795: l_ghr_pa_Requests_rec.employee_last_name ||
1796: ' ; first NOAC/Second NOAC: '||
1797: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1798: l_ghr_pa_requests_rec.second_noa_code ||
1799: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 1797: l_ghr_pa_requests_rec.first_noa_code || ' / '||

1793: ' ; Emp No/employee last name' ||
1794: l_employee_number ||' / '||
1795: l_ghr_pa_Requests_rec.employee_last_name ||
1796: ' ; first NOAC/Second NOAC: '||
1797: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1798: l_ghr_pa_requests_rec.second_noa_code ||
1799: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1800:
1801: Raise CPDF_DYNRPT_ERROR;

Line 1798: l_ghr_pa_requests_rec.second_noa_code ||

1794: l_employee_number ||' / '||
1795: l_ghr_pa_Requests_rec.employee_last_name ||
1796: ' ; first NOAC/Second NOAC: '||
1797: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1798: l_ghr_pa_requests_rec.second_noa_code ||
1799: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1800:
1801: Raise CPDF_DYNRPT_ERROR;
1802: END;

Line 1811: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id

1807: -- Bug#2789704 Added Exception Handling
1808: BEGIN
1809: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
1810: ,p_input_value_name => 'Amount'
1811: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1812: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1813: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance
1814: ,p_multiple_error_flag => l_multi_error_flag);
1815: EXCEPTION

Line 1812: ,p_effective_date => l_ghr_pa_requests_rec.effective_date

1808: BEGIN
1809: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
1810: ,p_input_value_name => 'Amount'
1811: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1812: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1813: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance
1814: ,p_multiple_error_flag => l_multi_error_flag);
1815: EXCEPTION
1816: WHEN OTHERS THEN

Line 1820: l_ghr_pa_requests_rec.pa_request_id ||

1816: WHEN OTHERS THEN
1817: --Bug # 9329643 Modified SSN to Emp No
1818: l_message_name := 'retrieve_element_entry_value';
1819: l_log_text := 'Error in fetching Retention Allowance Amount for pa_request_id: '||
1820: l_ghr_pa_requests_rec.pa_request_id ||
1821: ' ; Emp No/employee last name' ||
1822: l_employee_number ||' / '||
1823: l_ghr_pa_Requests_rec.employee_last_name ||
1824: ' ; first NOAC/Second NOAC: '||

Line 1823: l_ghr_pa_Requests_rec.employee_last_name ||

1819: l_log_text := 'Error in fetching Retention Allowance Amount for pa_request_id: '||
1820: l_ghr_pa_requests_rec.pa_request_id ||
1821: ' ; Emp No/employee last name' ||
1822: l_employee_number ||' / '||
1823: l_ghr_pa_Requests_rec.employee_last_name ||
1824: ' ; first NOAC/Second NOAC: '||
1825: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1826: l_ghr_pa_requests_rec.second_noa_code ||
1827: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 1825: l_ghr_pa_requests_rec.first_noa_code || ' / '||

1821: ' ; Emp No/employee last name' ||
1822: l_employee_number ||' / '||
1823: l_ghr_pa_Requests_rec.employee_last_name ||
1824: ' ; first NOAC/Second NOAC: '||
1825: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1826: l_ghr_pa_requests_rec.second_noa_code ||
1827: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1828:
1829: Raise CPDF_DYNRPT_ERROR;

Line 1826: l_ghr_pa_requests_rec.second_noa_code ||

1822: l_employee_number ||' / '||
1823: l_ghr_pa_Requests_rec.employee_last_name ||
1824: ' ; first NOAC/Second NOAC: '||
1825: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1826: l_ghr_pa_requests_rec.second_noa_code ||
1827: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1828:
1829: Raise CPDF_DYNRPT_ERROR;
1830: END;

Line 1838: ghr_api.return_education_details(p_person_id => l_ghr_pa_requests_rec.person_id,

1834: END IF;
1835:
1836: -- Changes for education
1837: -- Fix for 3958881 Madhuri
1838: ghr_api.return_education_details(p_person_id => l_ghr_pa_requests_rec.person_id,
1839: p_effective_date => l_ghr_pa_requests_rec.effective_date,
1840: p_education_level => l_ghr_cpdf_temp_rec.education_level,
1841: p_academic_discipline => l_ghr_cpdf_temp_rec.academic_discipline,
1842: p_year_degree_attained => l_ghr_cpdf_temp_rec.year_degree_attained);

Line 1839: p_effective_date => l_ghr_pa_requests_rec.effective_date,

1835:
1836: -- Changes for education
1837: -- Fix for 3958881 Madhuri
1838: ghr_api.return_education_details(p_person_id => l_ghr_pa_requests_rec.person_id,
1839: p_effective_date => l_ghr_pa_requests_rec.effective_date,
1840: p_education_level => l_ghr_cpdf_temp_rec.education_level,
1841: p_academic_discipline => l_ghr_cpdf_temp_rec.academic_discipline,
1842: p_year_degree_attained => l_ghr_cpdf_temp_rec.year_degree_attained);
1843: -- End changes for education Commented below code

Line 1845: /* l_ghr_cpdf_temp_rec.education_level := l_ghr_pa_requests_rec.education_level;

1841: p_academic_discipline => l_ghr_cpdf_temp_rec.academic_discipline,
1842: p_year_degree_attained => l_ghr_cpdf_temp_rec.year_degree_attained);
1843: -- End changes for education Commented below code
1844:
1845: /* l_ghr_cpdf_temp_rec.education_level := l_ghr_pa_requests_rec.education_level;
1846: -- academic_discipline is refered to as 'Instructional Program' in the dynamics report
1847: l_ghr_cpdf_temp_rec.academic_discipline := l_ghr_pa_requests_rec.academic_discipline;
1848: l_ghr_cpdf_temp_rec.year_degree_attained := l_ghr_pa_requests_rec.year_degree_attained;
1849: -- */

Line 1847: l_ghr_cpdf_temp_rec.academic_discipline := l_ghr_pa_requests_rec.academic_discipline;

1843: -- End changes for education Commented below code
1844:
1845: /* l_ghr_cpdf_temp_rec.education_level := l_ghr_pa_requests_rec.education_level;
1846: -- academic_discipline is refered to as 'Instructional Program' in the dynamics report
1847: l_ghr_cpdf_temp_rec.academic_discipline := l_ghr_pa_requests_rec.academic_discipline;
1848: l_ghr_cpdf_temp_rec.year_degree_attained := l_ghr_pa_requests_rec.year_degree_attained;
1849: -- */
1850:
1851: -- Not worth getting any more detials if only counting!

Line 1848: l_ghr_cpdf_temp_rec.year_degree_attained := l_ghr_pa_requests_rec.year_degree_attained;

1844:
1845: /* l_ghr_cpdf_temp_rec.education_level := l_ghr_pa_requests_rec.education_level;
1846: -- academic_discipline is refered to as 'Instructional Program' in the dynamics report
1847: l_ghr_cpdf_temp_rec.academic_discipline := l_ghr_pa_requests_rec.academic_discipline;
1848: l_ghr_cpdf_temp_rec.year_degree_attained := l_ghr_pa_requests_rec.year_degree_attained;
1849: -- */
1850:
1851: -- Not worth getting any more detials if only counting!
1852: IF not p_count_only THEN

Line 1860: get_org_comp (NVL(l_ghr_pa_requests_rec.to_position_id

1856: -- it must come from to_position if there, if not from the from_position
1857: --
1858: -- Bug#2789704 Added Exception Handling
1859: BEGIN
1860: get_org_comp (NVL(l_ghr_pa_requests_rec.to_position_id
1861: ,l_ghr_pa_requests_rec.from_position_id)
1862: ,l_ghr_pa_requests_rec.effective_date
1863: ,l_ghr_cpdf_temp_rec.organizational_component);
1864: EXCEPTION

Line 1861: ,l_ghr_pa_requests_rec.from_position_id)

1857: --
1858: -- Bug#2789704 Added Exception Handling
1859: BEGIN
1860: get_org_comp (NVL(l_ghr_pa_requests_rec.to_position_id
1861: ,l_ghr_pa_requests_rec.from_position_id)
1862: ,l_ghr_pa_requests_rec.effective_date
1863: ,l_ghr_cpdf_temp_rec.organizational_component);
1864: EXCEPTION
1865: WHEN OTHERS THEN

Line 1862: ,l_ghr_pa_requests_rec.effective_date

1858: -- Bug#2789704 Added Exception Handling
1859: BEGIN
1860: get_org_comp (NVL(l_ghr_pa_requests_rec.to_position_id
1861: ,l_ghr_pa_requests_rec.from_position_id)
1862: ,l_ghr_pa_requests_rec.effective_date
1863: ,l_ghr_cpdf_temp_rec.organizational_component);
1864: EXCEPTION
1865: WHEN OTHERS THEN
1866: --Bug # 9329643 Modified SSN to Emp No

Line 1869: l_ghr_pa_requests_rec.pa_request_id ||

1865: WHEN OTHERS THEN
1866: --Bug # 9329643 Modified SSN to Emp No
1867: l_message_name := 'get_org_comp';
1868: l_log_text := 'Error in fetching OPM Organizational Component for pa_request_id: '||
1869: l_ghr_pa_requests_rec.pa_request_id ||
1870: ' ; Emp No/employee last name' ||
1871: l_employee_number ||' / '||
1872: l_ghr_pa_Requests_rec.employee_last_name ||
1873: ' ; first NOAC/Second NOAC: '||

Line 1872: l_ghr_pa_Requests_rec.employee_last_name ||

1868: l_log_text := 'Error in fetching OPM Organizational Component for pa_request_id: '||
1869: l_ghr_pa_requests_rec.pa_request_id ||
1870: ' ; Emp No/employee last name' ||
1871: l_employee_number ||' / '||
1872: l_ghr_pa_Requests_rec.employee_last_name ||
1873: ' ; first NOAC/Second NOAC: '||
1874: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1875: l_ghr_pa_requests_rec.second_noa_code ||
1876: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 1874: l_ghr_pa_requests_rec.first_noa_code || ' / '||

1870: ' ; Emp No/employee last name' ||
1871: l_employee_number ||' / '||
1872: l_ghr_pa_Requests_rec.employee_last_name ||
1873: ' ; first NOAC/Second NOAC: '||
1874: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1875: l_ghr_pa_requests_rec.second_noa_code ||
1876: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1877:
1878: Raise CPDF_DYNRPT_ERROR;

Line 1875: l_ghr_pa_requests_rec.second_noa_code ||

1871: l_employee_number ||' / '||
1872: l_ghr_pa_Requests_rec.employee_last_name ||
1873: ' ; first NOAC/Second NOAC: '||
1874: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1875: l_ghr_pa_requests_rec.second_noa_code ||
1876: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1877:
1878: Raise CPDF_DYNRPT_ERROR;
1879: END;

Line 1885: get_sex (l_ghr_pa_requests_rec.person_id

1881: --
1882: -- 3.3) Get Sex
1883: -- Bug#2789704 Added Exception Handling
1884: BEGIN
1885: get_sex (l_ghr_pa_requests_rec.person_id
1886: ,l_ghr_pa_requests_rec.effective_date
1887: ,l_ghr_cpdf_temp_rec.sex);
1888: EXCEPTION
1889: WHEN OTHERS THEN

Line 1886: ,l_ghr_pa_requests_rec.effective_date

1882: -- 3.3) Get Sex
1883: -- Bug#2789704 Added Exception Handling
1884: BEGIN
1885: get_sex (l_ghr_pa_requests_rec.person_id
1886: ,l_ghr_pa_requests_rec.effective_date
1887: ,l_ghr_cpdf_temp_rec.sex);
1888: EXCEPTION
1889: WHEN OTHERS THEN
1890: --Bug # 9329643 Modified SSN to Emp No

Line 1893: l_ghr_pa_requests_rec.pa_request_id ||

1889: WHEN OTHERS THEN
1890: --Bug # 9329643 Modified SSN to Emp No
1891: l_message_name := 'get_sex';
1892: l_log_text := 'Error in fetching SEX for pa_request_id: '||
1893: l_ghr_pa_requests_rec.pa_request_id ||
1894: ' ; Emp No/employee last name' ||
1895: l_employee_number ||' / '||
1896: l_ghr_pa_Requests_rec.employee_last_name ||
1897: ' ; first NOAC/Second NOAC: '||

Line 1896: l_ghr_pa_Requests_rec.employee_last_name ||

1892: l_log_text := 'Error in fetching SEX for pa_request_id: '||
1893: l_ghr_pa_requests_rec.pa_request_id ||
1894: ' ; Emp No/employee last name' ||
1895: l_employee_number ||' / '||
1896: l_ghr_pa_Requests_rec.employee_last_name ||
1897: ' ; first NOAC/Second NOAC: '||
1898: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1899: l_ghr_pa_requests_rec.second_noa_code ||
1900: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 1898: l_ghr_pa_requests_rec.first_noa_code || ' / '||

1894: ' ; Emp No/employee last name' ||
1895: l_employee_number ||' / '||
1896: l_ghr_pa_Requests_rec.employee_last_name ||
1897: ' ; first NOAC/Second NOAC: '||
1898: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1899: l_ghr_pa_requests_rec.second_noa_code ||
1900: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1901:
1902: Raise CPDF_DYNRPT_ERROR;

Line 1899: l_ghr_pa_requests_rec.second_noa_code ||

1895: l_employee_number ||' / '||
1896: l_ghr_pa_Requests_rec.employee_last_name ||
1897: ' ; first NOAC/Second NOAC: '||
1898: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1899: l_ghr_pa_requests_rec.second_noa_code ||
1900: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1901:
1902: Raise CPDF_DYNRPT_ERROR;
1903: END;

Line 1910: get_per_sit_perf_appraisal(l_ghr_pa_requests_rec.person_id

1906: -- 3.4) Get person SIT - 'US Fed Perf Appraisal'
1907: --
1908: -- Bug#2789704 Added Exception Handling
1909: BEGIN
1910: get_per_sit_perf_appraisal(l_ghr_pa_requests_rec.person_id
1911: ,l_ghr_pa_requests_rec.effective_date
1912: ,l_ghr_cpdf_temp_rec.rating_of_record_level
1913: ,l_ghr_cpdf_temp_rec.rating_of_record_pattern
1914: ,l_ghr_cpdf_temp_rec.rating_of_record_period_ends); -- format in report

Line 1911: ,l_ghr_pa_requests_rec.effective_date

1907: --
1908: -- Bug#2789704 Added Exception Handling
1909: BEGIN
1910: get_per_sit_perf_appraisal(l_ghr_pa_requests_rec.person_id
1911: ,l_ghr_pa_requests_rec.effective_date
1912: ,l_ghr_cpdf_temp_rec.rating_of_record_level
1913: ,l_ghr_cpdf_temp_rec.rating_of_record_pattern
1914: ,l_ghr_cpdf_temp_rec.rating_of_record_period_ends); -- format in report
1915: EXCEPTION

Line 1920: to_char(l_ghr_pa_requests_rec.pa_request_id) ||

1916: WHEN OTHERS THEN
1917: --Bug # 9329643 Modified SSN to Emp No
1918: l_message_name := 'get_per_sit_perf_apprisal';
1919: l_log_text := 'Error in fetching Performance Apprisal details for pa_request_id: '||
1920: to_char(l_ghr_pa_requests_rec.pa_request_id) ||
1921: ' ; Emp No/employee last name' ||
1922: l_employee_number ||' / '||
1923: l_ghr_pa_Requests_rec.employee_last_name ||
1924: ' ; first NOAC/Second NOAC: '||

Line 1923: l_ghr_pa_Requests_rec.employee_last_name ||

1919: l_log_text := 'Error in fetching Performance Apprisal details for pa_request_id: '||
1920: to_char(l_ghr_pa_requests_rec.pa_request_id) ||
1921: ' ; Emp No/employee last name' ||
1922: l_employee_number ||' / '||
1923: l_ghr_pa_Requests_rec.employee_last_name ||
1924: ' ; first NOAC/Second NOAC: '||
1925: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1926: l_ghr_pa_requests_rec.second_noa_code ||
1927: ' ; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 1925: l_ghr_pa_requests_rec.first_noa_code || ' / '||

1921: ' ; Emp No/employee last name' ||
1922: l_employee_number ||' / '||
1923: l_ghr_pa_Requests_rec.employee_last_name ||
1924: ' ; first NOAC/Second NOAC: '||
1925: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1926: l_ghr_pa_requests_rec.second_noa_code ||
1927: ' ; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1928: Raise CPDF_DYNRPT_ERROR;
1929:

Line 1926: l_ghr_pa_requests_rec.second_noa_code ||

1922: l_employee_number ||' / '||
1923: l_ghr_pa_Requests_rec.employee_last_name ||
1924: ' ; first NOAC/Second NOAC: '||
1925: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1926: l_ghr_pa_requests_rec.second_noa_code ||
1927: ' ; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1928: Raise CPDF_DYNRPT_ERROR;
1929:
1930: END;

Line 1937: get_PAR_EI_noac (l_ghr_pa_requests_rec.pa_request_id

1933: -- 3.5) Get PAR Extra Info Noa specific
1934: --
1935: -- Bug#2789704 Added Exception Handling
1936: BEGIN
1937: get_PAR_EI_noac (l_ghr_pa_requests_rec.pa_request_id
1938: ,l_ghr_pa_requests_rec.first_noa_id
1939: ,l_ghr_pa_requests_rec.second_noa_id
1940: ,l_ghr_pa_requests_rec.noa_family_code
1941: ,l_ghr_pa_requests_rec.person_id

Line 1938: ,l_ghr_pa_requests_rec.first_noa_id

1934: --
1935: -- Bug#2789704 Added Exception Handling
1936: BEGIN
1937: get_PAR_EI_noac (l_ghr_pa_requests_rec.pa_request_id
1938: ,l_ghr_pa_requests_rec.first_noa_id
1939: ,l_ghr_pa_requests_rec.second_noa_id
1940: ,l_ghr_pa_requests_rec.noa_family_code
1941: ,l_ghr_pa_requests_rec.person_id
1942: ,l_ghr_pa_requests_rec.effective_date

Line 1939: ,l_ghr_pa_requests_rec.second_noa_id

1935: -- Bug#2789704 Added Exception Handling
1936: BEGIN
1937: get_PAR_EI_noac (l_ghr_pa_requests_rec.pa_request_id
1938: ,l_ghr_pa_requests_rec.first_noa_id
1939: ,l_ghr_pa_requests_rec.second_noa_id
1940: ,l_ghr_pa_requests_rec.noa_family_code
1941: ,l_ghr_pa_requests_rec.person_id
1942: ,l_ghr_pa_requests_rec.effective_date
1943: ,l_ghr_cpdf_temp_rec.creditable_military_service -- no format assumed yymm?

Line 1940: ,l_ghr_pa_requests_rec.noa_family_code

1936: BEGIN
1937: get_PAR_EI_noac (l_ghr_pa_requests_rec.pa_request_id
1938: ,l_ghr_pa_requests_rec.first_noa_id
1939: ,l_ghr_pa_requests_rec.second_noa_id
1940: ,l_ghr_pa_requests_rec.noa_family_code
1941: ,l_ghr_pa_requests_rec.person_id
1942: ,l_ghr_pa_requests_rec.effective_date
1943: ,l_ghr_cpdf_temp_rec.creditable_military_service -- no format assumed yymm?
1944: ,l_ghr_cpdf_temp_rec.frozen_service -- no format assumed yymm?

Line 1941: ,l_ghr_pa_requests_rec.person_id

1937: get_PAR_EI_noac (l_ghr_pa_requests_rec.pa_request_id
1938: ,l_ghr_pa_requests_rec.first_noa_id
1939: ,l_ghr_pa_requests_rec.second_noa_id
1940: ,l_ghr_pa_requests_rec.noa_family_code
1941: ,l_ghr_pa_requests_rec.person_id
1942: ,l_ghr_pa_requests_rec.effective_date
1943: ,l_ghr_cpdf_temp_rec.creditable_military_service -- no format assumed yymm?
1944: ,l_ghr_cpdf_temp_rec.frozen_service -- no format assumed yymm?
1945: ,l_ghr_cpdf_temp_rec.from_retirement_coverage -- previous retirement coverage

Line 1942: ,l_ghr_pa_requests_rec.effective_date

1938: ,l_ghr_pa_requests_rec.first_noa_id
1939: ,l_ghr_pa_requests_rec.second_noa_id
1940: ,l_ghr_pa_requests_rec.noa_family_code
1941: ,l_ghr_pa_requests_rec.person_id
1942: ,l_ghr_pa_requests_rec.effective_date
1943: ,l_ghr_cpdf_temp_rec.creditable_military_service -- no format assumed yymm?
1944: ,l_ghr_cpdf_temp_rec.frozen_service -- no format assumed yymm?
1945: ,l_ghr_cpdf_temp_rec.from_retirement_coverage -- previous retirement coverage
1946: ,l_ghr_cpdf_temp_rec.race_national_origin

Line 1956: l_ghr_pa_requests_rec.pa_request_id ||

1952: WHEN OTHERS THEN
1953: l_message_name := 'get_par_ei_noac';
1954: --Bug # 9329643 Modified SSN to Emp No
1955: l_log_text := 'Error in fetching PA Record Extra Information for pa_request_id: '||
1956: l_ghr_pa_requests_rec.pa_request_id ||
1957: ' ; Emp No/employee last name' ||
1958: l_employee_number ||' / '||
1959: l_ghr_pa_Requests_rec.employee_last_name ||
1960: ' ; first NOAC/Second NOAC: '||

Line 1959: l_ghr_pa_Requests_rec.employee_last_name ||

1955: l_log_text := 'Error in fetching PA Record Extra Information for pa_request_id: '||
1956: l_ghr_pa_requests_rec.pa_request_id ||
1957: ' ; Emp No/employee last name' ||
1958: l_employee_number ||' / '||
1959: l_ghr_pa_Requests_rec.employee_last_name ||
1960: ' ; first NOAC/Second NOAC: '||
1961: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1962: l_ghr_pa_requests_rec.second_noa_code ||
1963: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 1961: l_ghr_pa_requests_rec.first_noa_code || ' / '||

1957: ' ; Emp No/employee last name' ||
1958: l_employee_number ||' / '||
1959: l_ghr_pa_Requests_rec.employee_last_name ||
1960: ' ; first NOAC/Second NOAC: '||
1961: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1962: l_ghr_pa_requests_rec.second_noa_code ||
1963: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1964:
1965: Raise CPDF_DYNRPT_ERROR;

Line 1962: l_ghr_pa_requests_rec.second_noa_code ||

1958: l_employee_number ||' / '||
1959: l_ghr_pa_Requests_rec.employee_last_name ||
1960: ' ; first NOAC/Second NOAC: '||
1961: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1962: l_ghr_pa_requests_rec.second_noa_code ||
1963: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1964:
1965: Raise CPDF_DYNRPT_ERROR;
1966: END;

Line 1970: IF (l_ghr_pa_requests_rec.first_noa_code LIKE '2%' OR

1966: END;
1967: -- Bug#2789704 Added Exception Handling
1968:
1969: -- Bug# 1375342
1970: IF (l_ghr_pa_requests_rec.first_noa_code LIKE '2%' OR
1971: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1972: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '2%')) THEN
1973: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
1974: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;

Line 1971: (l_ghr_pa_requests_rec.first_noa_code = '002' AND

1967: -- Bug#2789704 Added Exception Handling
1968:
1969: -- Bug# 1375342
1970: IF (l_ghr_pa_requests_rec.first_noa_code LIKE '2%' OR
1971: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1972: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '2%')) THEN
1973: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
1974: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
1975: -- for bug 3327389

Line 1972: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '2%')) THEN

1968:
1969: -- Bug# 1375342
1970: IF (l_ghr_pa_requests_rec.first_noa_code LIKE '2%' OR
1971: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1972: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '2%')) THEN
1973: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
1974: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
1975: -- for bug 3327389
1976: END IF;

Line 1982: (p_pa_req_rec => l_ghr_pa_requests_rec

1978: -- get current appointment auth codes.
1979: -- Bug#2789704 Added Exception Handling
1980: BEGIN
1981: ghr_sf52_pre_update.get_auth_codes
1982: (p_pa_req_rec => l_ghr_pa_requests_rec
1983: ,p_auth_code1 => l_ghr_cpdf_temp_rec.current_appointment_auth1
1984: ,p_auth_code2 => l_ghr_cpdf_temp_rec.current_appointment_auth2);
1985: EXCEPTION
1986: WHEN OTHERS THEN

Line 1990: l_ghr_pa_requests_rec.pa_request_id ||

1986: WHEN OTHERS THEN
1987: l_message_name := 'get_auth_codes';
1988: --Bug # 9329643 Modified SSN to Emp No
1989: l_log_text := 'Error in fetching Current Appointment Authority Codes for pa_request_id: '||
1990: l_ghr_pa_requests_rec.pa_request_id ||
1991: ' ; Emp No/employee last name' ||
1992: l_employee_number ||' / '||
1993: l_ghr_pa_Requests_rec.employee_last_name ||
1994: ' ; first NOAC/Second NOAC: '||

Line 1993: l_ghr_pa_Requests_rec.employee_last_name ||

1989: l_log_text := 'Error in fetching Current Appointment Authority Codes for pa_request_id: '||
1990: l_ghr_pa_requests_rec.pa_request_id ||
1991: ' ; Emp No/employee last name' ||
1992: l_employee_number ||' / '||
1993: l_ghr_pa_Requests_rec.employee_last_name ||
1994: ' ; first NOAC/Second NOAC: '||
1995: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1996: l_ghr_pa_requests_rec.second_noa_code ||
1997: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 1995: l_ghr_pa_requests_rec.first_noa_code || ' / '||

1991: ' ; Emp No/employee last name' ||
1992: l_employee_number ||' / '||
1993: l_ghr_pa_Requests_rec.employee_last_name ||
1994: ' ; first NOAC/Second NOAC: '||
1995: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1996: l_ghr_pa_requests_rec.second_noa_code ||
1997: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1998:
1999: Raise CPDF_DYNRPT_ERROR;

Line 1996: l_ghr_pa_requests_rec.second_noa_code ||

1992: l_employee_number ||' / '||
1993: l_ghr_pa_Requests_rec.employee_last_name ||
1994: ' ; first NOAC/Second NOAC: '||
1995: l_ghr_pa_requests_rec.first_noa_code || ' / '||
1996: l_ghr_pa_requests_rec.second_noa_code ||
1997: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
1998:
1999: Raise CPDF_DYNRPT_ERROR;
2000: END;

Line 2005: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND

2001: -- Bug#2789704 Added Exception Handling
2002: --
2003: -- 3.6) Get PRIOR Work Schedule and Pay Rate Determinant
2004: --
2005: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
2006: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND
2007: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
2008: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '2%'))
2009: THEN

Line 2006: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND

2002: --
2003: -- 3.6) Get PRIOR Work Schedule and Pay Rate Determinant
2004: --
2005: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
2006: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND
2007: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
2008: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '2%'))
2009: THEN
2010: -- Bug#2789704 Added Exception Handling

Line 2007: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR

2003: -- 3.6) Get PRIOR Work Schedule and Pay Rate Determinant
2004: --
2005: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
2006: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND
2007: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
2008: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '2%'))
2009: THEN
2010: -- Bug#2789704 Added Exception Handling
2011: BEGIN

Line 2008: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '2%'))

2004: --
2005: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
2006: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '2%' AND
2007: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
2008: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '2%'))
2009: THEN
2010: -- Bug#2789704 Added Exception Handling
2011: BEGIN
2012: get_prior_ws_prd_ds (l_ghr_pa_requests_rec.pa_request_id

Line 2012: get_prior_ws_prd_ds (l_ghr_pa_requests_rec.pa_request_id

2008: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '2%'))
2009: THEN
2010: -- Bug#2789704 Added Exception Handling
2011: BEGIN
2012: get_prior_ws_prd_ds (l_ghr_pa_requests_rec.pa_request_id
2013: ,l_ghr_pa_requests_rec.altered_pa_request_id
2014: ,l_ghr_pa_requests_rec.first_noa_id
2015: ,l_ghr_pa_requests_rec.second_noa_id
2016: ,l_ghr_pa_requests_rec.person_id

Line 2013: ,l_ghr_pa_requests_rec.altered_pa_request_id

2009: THEN
2010: -- Bug#2789704 Added Exception Handling
2011: BEGIN
2012: get_prior_ws_prd_ds (l_ghr_pa_requests_rec.pa_request_id
2013: ,l_ghr_pa_requests_rec.altered_pa_request_id
2014: ,l_ghr_pa_requests_rec.first_noa_id
2015: ,l_ghr_pa_requests_rec.second_noa_id
2016: ,l_ghr_pa_requests_rec.person_id
2017: ,l_ghr_pa_requests_rec.employee_assignment_id

Line 2014: ,l_ghr_pa_requests_rec.first_noa_id

2010: -- Bug#2789704 Added Exception Handling
2011: BEGIN
2012: get_prior_ws_prd_ds (l_ghr_pa_requests_rec.pa_request_id
2013: ,l_ghr_pa_requests_rec.altered_pa_request_id
2014: ,l_ghr_pa_requests_rec.first_noa_id
2015: ,l_ghr_pa_requests_rec.second_noa_id
2016: ,l_ghr_pa_requests_rec.person_id
2017: ,l_ghr_pa_requests_rec.employee_assignment_id
2018: ,l_ghr_pa_requests_rec.from_position_id

Line 2015: ,l_ghr_pa_requests_rec.second_noa_id

2011: BEGIN
2012: get_prior_ws_prd_ds (l_ghr_pa_requests_rec.pa_request_id
2013: ,l_ghr_pa_requests_rec.altered_pa_request_id
2014: ,l_ghr_pa_requests_rec.first_noa_id
2015: ,l_ghr_pa_requests_rec.second_noa_id
2016: ,l_ghr_pa_requests_rec.person_id
2017: ,l_ghr_pa_requests_rec.employee_assignment_id
2018: ,l_ghr_pa_requests_rec.from_position_id
2019: ,l_ghr_pa_requests_rec.effective_date

Line 2016: ,l_ghr_pa_requests_rec.person_id

2012: get_prior_ws_prd_ds (l_ghr_pa_requests_rec.pa_request_id
2013: ,l_ghr_pa_requests_rec.altered_pa_request_id
2014: ,l_ghr_pa_requests_rec.first_noa_id
2015: ,l_ghr_pa_requests_rec.second_noa_id
2016: ,l_ghr_pa_requests_rec.person_id
2017: ,l_ghr_pa_requests_rec.employee_assignment_id
2018: ,l_ghr_pa_requests_rec.from_position_id
2019: ,l_ghr_pa_requests_rec.effective_date
2020: ,l_ghr_pa_requests_rec.status

Line 2017: ,l_ghr_pa_requests_rec.employee_assignment_id

2013: ,l_ghr_pa_requests_rec.altered_pa_request_id
2014: ,l_ghr_pa_requests_rec.first_noa_id
2015: ,l_ghr_pa_requests_rec.second_noa_id
2016: ,l_ghr_pa_requests_rec.person_id
2017: ,l_ghr_pa_requests_rec.employee_assignment_id
2018: ,l_ghr_pa_requests_rec.from_position_id
2019: ,l_ghr_pa_requests_rec.effective_date
2020: ,l_ghr_pa_requests_rec.status
2021: ,l_ghr_cpdf_temp_rec.from_work_schedule

Line 2018: ,l_ghr_pa_requests_rec.from_position_id

2014: ,l_ghr_pa_requests_rec.first_noa_id
2015: ,l_ghr_pa_requests_rec.second_noa_id
2016: ,l_ghr_pa_requests_rec.person_id
2017: ,l_ghr_pa_requests_rec.employee_assignment_id
2018: ,l_ghr_pa_requests_rec.from_position_id
2019: ,l_ghr_pa_requests_rec.effective_date
2020: ,l_ghr_pa_requests_rec.status
2021: ,l_ghr_cpdf_temp_rec.from_work_schedule
2022: ,l_ghr_cpdf_temp_rec.from_pay_rate_determinant

Line 2019: ,l_ghr_pa_requests_rec.effective_date

2015: ,l_ghr_pa_requests_rec.second_noa_id
2016: ,l_ghr_pa_requests_rec.person_id
2017: ,l_ghr_pa_requests_rec.employee_assignment_id
2018: ,l_ghr_pa_requests_rec.from_position_id
2019: ,l_ghr_pa_requests_rec.effective_date
2020: ,l_ghr_pa_requests_rec.status
2021: ,l_ghr_cpdf_temp_rec.from_work_schedule
2022: ,l_ghr_cpdf_temp_rec.from_pay_rate_determinant
2023: ,l_ghr_cpdf_temp_rec.from_duty_station_code);

Line 2020: ,l_ghr_pa_requests_rec.status

2016: ,l_ghr_pa_requests_rec.person_id
2017: ,l_ghr_pa_requests_rec.employee_assignment_id
2018: ,l_ghr_pa_requests_rec.from_position_id
2019: ,l_ghr_pa_requests_rec.effective_date
2020: ,l_ghr_pa_requests_rec.status
2021: ,l_ghr_cpdf_temp_rec.from_work_schedule
2022: ,l_ghr_cpdf_temp_rec.from_pay_rate_determinant
2023: ,l_ghr_cpdf_temp_rec.from_duty_station_code);
2024: EXCEPTION

Line 2029: l_ghr_pa_requests_rec.pa_request_id ||

2025: WHEN OTHERS THEN
2026: l_message_name := 'get_prior_ws_prd_ds';
2027: --Bug # 9329643 Modified SSN to Emp No
2028: l_log_text := 'Error in fetching prior work schedule,prg,duty station for pa_request_id: '||
2029: l_ghr_pa_requests_rec.pa_request_id ||
2030: ' ; Emp No/employee last name' ||
2031: l_employee_number ||' / '||
2032: l_ghr_pa_Requests_rec.employee_last_name ||
2033: ' ; first NOAC/Second NOAC: '||

Line 2032: l_ghr_pa_Requests_rec.employee_last_name ||

2028: l_log_text := 'Error in fetching prior work schedule,prg,duty station for pa_request_id: '||
2029: l_ghr_pa_requests_rec.pa_request_id ||
2030: ' ; Emp No/employee last name' ||
2031: l_employee_number ||' / '||
2032: l_ghr_pa_Requests_rec.employee_last_name ||
2033: ' ; first NOAC/Second NOAC: '||
2034: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2035: l_ghr_pa_requests_rec.second_noa_code ||
2036: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 2034: l_ghr_pa_requests_rec.first_noa_code || ' / '||

2030: ' ; Emp No/employee last name' ||
2031: l_employee_number ||' / '||
2032: l_ghr_pa_Requests_rec.employee_last_name ||
2033: ' ; first NOAC/Second NOAC: '||
2034: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2035: l_ghr_pa_requests_rec.second_noa_code ||
2036: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
2037:
2038: Raise CPDF_DYNRPT_ERROR;

Line 2035: l_ghr_pa_requests_rec.second_noa_code ||

2031: l_employee_number ||' / '||
2032: l_ghr_pa_Requests_rec.employee_last_name ||
2033: ' ; first NOAC/Second NOAC: '||
2034: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2035: l_ghr_pa_requests_rec.second_noa_code ||
2036: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
2037:
2038: Raise CPDF_DYNRPT_ERROR;
2039: END;

Line 2048: p_effective_date => l_ghr_pa_requests_rec.effective_date) = '99'

2044: l_ghr_cpdf_temp_rec.to_pay_rate_determinant := l_ghr_cpdf_temp_rec.from_pay_rate_determinant;
2045: END IF;
2046: -- Added IF Condition to fix bug#3231946
2047: IF get_loc_pay_area_code(p_duty_station_code => l_ghr_cpdf_temp_rec.from_duty_station_code,
2048: p_effective_date => l_ghr_pa_requests_rec.effective_date) = '99'
2049: AND l_ghr_pa_requests_rec.from_locality_adj = 0 THEN
2050: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
2051: END IF;
2052:

Line 2049: AND l_ghr_pa_requests_rec.from_locality_adj = 0 THEN

2045: END IF;
2046: -- Added IF Condition to fix bug#3231946
2047: IF get_loc_pay_area_code(p_duty_station_code => l_ghr_cpdf_temp_rec.from_duty_station_code,
2048: p_effective_date => l_ghr_pa_requests_rec.effective_date) = '99'
2049: AND l_ghr_pa_requests_rec.from_locality_adj = 0 THEN
2050: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
2051: END IF;
2052:
2053: END IF;

Line 2059: get_prev_ssn (l_ghr_pa_requests_rec.altered_pa_request_id

2055: -- 3.7) Get prior ssn if it is being corrected.
2056: --
2057: -- Bug#2789704 Added Exception Handling
2058: BEGIN
2059: get_prev_ssn (l_ghr_pa_requests_rec.altered_pa_request_id
2060: ,l_ghr_pa_requests_rec.employee_national_identifier
2061: ,l_ghr_pa_requests_rec.noa_family_code
2062: ,l_ghr_cpdf_temp_rec.from_national_identifier);
2063: EXCEPTION

Line 2060: ,l_ghr_pa_requests_rec.employee_national_identifier

2056: --
2057: -- Bug#2789704 Added Exception Handling
2058: BEGIN
2059: get_prev_ssn (l_ghr_pa_requests_rec.altered_pa_request_id
2060: ,l_ghr_pa_requests_rec.employee_national_identifier
2061: ,l_ghr_pa_requests_rec.noa_family_code
2062: ,l_ghr_cpdf_temp_rec.from_national_identifier);
2063: EXCEPTION
2064: WHEN OTHERS THEN

Line 2061: ,l_ghr_pa_requests_rec.noa_family_code

2057: -- Bug#2789704 Added Exception Handling
2058: BEGIN
2059: get_prev_ssn (l_ghr_pa_requests_rec.altered_pa_request_id
2060: ,l_ghr_pa_requests_rec.employee_national_identifier
2061: ,l_ghr_pa_requests_rec.noa_family_code
2062: ,l_ghr_cpdf_temp_rec.from_national_identifier);
2063: EXCEPTION
2064: WHEN OTHERS THEN
2065: l_message_name := 'get_prev_ssn';

Line 2068: l_ghr_pa_requests_rec.pa_request_id ||

2064: WHEN OTHERS THEN
2065: l_message_name := 'get_prev_ssn';
2066: --Bug # 9329643 Modified SSN to Emp No
2067: l_log_text := 'Error in fetching SSN for pa_request_id: '||
2068: l_ghr_pa_requests_rec.pa_request_id ||
2069: ' ; Emp No/employee last name' ||
2070: l_employee_number ||' / '||
2071: l_ghr_pa_Requests_rec.employee_last_name ||
2072: ' ; first NOAC/Second NOAC: '||

Line 2071: l_ghr_pa_Requests_rec.employee_last_name ||

2067: l_log_text := 'Error in fetching SSN for pa_request_id: '||
2068: l_ghr_pa_requests_rec.pa_request_id ||
2069: ' ; Emp No/employee last name' ||
2070: l_employee_number ||' / '||
2071: l_ghr_pa_Requests_rec.employee_last_name ||
2072: ' ; first NOAC/Second NOAC: '||
2073: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2074: l_ghr_pa_requests_rec.second_noa_code ||
2075: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 2073: l_ghr_pa_requests_rec.first_noa_code || ' / '||

2069: ' ; Emp No/employee last name' ||
2070: l_employee_number ||' / '||
2071: l_ghr_pa_Requests_rec.employee_last_name ||
2072: ' ; first NOAC/Second NOAC: '||
2073: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2074: l_ghr_pa_requests_rec.second_noa_code ||
2075: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
2076:
2077: Raise CPDF_DYNRPT_ERROR;

Line 2074: l_ghr_pa_requests_rec.second_noa_code ||

2070: l_employee_number ||' / '||
2071: l_ghr_pa_Requests_rec.employee_last_name ||
2072: ' ; first NOAC/Second NOAC: '||
2073: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2074: l_ghr_pa_requests_rec.second_noa_code ||
2075: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
2076:
2077: Raise CPDF_DYNRPT_ERROR;
2078: END;

Line 2083: IF (l_ghr_pa_requests_rec.first_noa_code='817' or l_ghr_pa_requests_rec.second_noa_code='817') THEN

2079:
2080: END IF; -- end of popluation of full record if not count_only
2081: --
2082: -- adding code for 817 NOAC
2083: IF (l_ghr_pa_requests_rec.first_noa_code='817' or l_ghr_pa_requests_rec.second_noa_code='817') THEN
2084: l_ghr_cpdf_temp_rec := l_ghr_empty_cpdf_temp;
2085: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
2086: l_ghr_cpdf_temp_rec.to_national_identifier
2087: := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);

Line 2085: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);

2081: --
2082: -- adding code for 817 NOAC
2083: IF (l_ghr_pa_requests_rec.first_noa_code='817' or l_ghr_pa_requests_rec.second_noa_code='817') THEN
2084: l_ghr_cpdf_temp_rec := l_ghr_empty_cpdf_temp;
2085: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
2086: l_ghr_cpdf_temp_rec.to_national_identifier
2087: := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
2088: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date;
2089: l_ghr_cpdf_temp_rec.first_noa_code := l_ghr_pa_requests_rec.first_noa_code;

Line 2087: := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);

2083: IF (l_ghr_pa_requests_rec.first_noa_code='817' or l_ghr_pa_requests_rec.second_noa_code='817') THEN
2084: l_ghr_cpdf_temp_rec := l_ghr_empty_cpdf_temp;
2085: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
2086: l_ghr_cpdf_temp_rec.to_national_identifier
2087: := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
2088: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date;
2089: l_ghr_cpdf_temp_rec.first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
2090: l_ghr_cpdf_temp_rec.second_noa_code := l_ghr_pa_requests_rec.second_noa_code;
2091: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;

Line 2088: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date;

2084: l_ghr_cpdf_temp_rec := l_ghr_empty_cpdf_temp;
2085: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
2086: l_ghr_cpdf_temp_rec.to_national_identifier
2087: := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
2088: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date;
2089: l_ghr_cpdf_temp_rec.first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
2090: l_ghr_cpdf_temp_rec.second_noa_code := l_ghr_pa_requests_rec.second_noa_code;
2091: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2092: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount;

Line 2089: l_ghr_cpdf_temp_rec.first_noa_code := l_ghr_pa_requests_rec.first_noa_code;

2085: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
2086: l_ghr_cpdf_temp_rec.to_national_identifier
2087: := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
2088: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date;
2089: l_ghr_cpdf_temp_rec.first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
2090: l_ghr_cpdf_temp_rec.second_noa_code := l_ghr_pa_requests_rec.second_noa_code;
2091: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2092: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount;
2093: -- GOTO end_par_loop;

Line 2090: l_ghr_cpdf_temp_rec.second_noa_code := l_ghr_pa_requests_rec.second_noa_code;

2086: l_ghr_cpdf_temp_rec.to_national_identifier
2087: := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
2088: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date;
2089: l_ghr_cpdf_temp_rec.first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
2090: l_ghr_cpdf_temp_rec.second_noa_code := l_ghr_pa_requests_rec.second_noa_code;
2091: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2092: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount;
2093: -- GOTO end_par_loop;
2094: END IF;

Line 2091: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;

2087: := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
2088: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date;
2089: l_ghr_cpdf_temp_rec.first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
2090: l_ghr_cpdf_temp_rec.second_noa_code := l_ghr_pa_requests_rec.second_noa_code;
2091: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2092: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount;
2093: -- GOTO end_par_loop;
2094: END IF;
2095:

Line 2092: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount;

2088: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date;
2089: l_ghr_cpdf_temp_rec.first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
2090: l_ghr_cpdf_temp_rec.second_noa_code := l_ghr_pa_requests_rec.second_noa_code;
2091: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2092: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount;
2093: -- GOTO end_par_loop;
2094: END IF;
2095:
2096: ---

Line 2099: IF ((l_ghr_pa_requests_rec.first_noa_code ='002'

2095:
2096: ---
2097: -- EHRI changes
2098: --
2099: IF ((l_ghr_pa_requests_rec.first_noa_code ='002'
2100: AND
2101: (NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '1%' or NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '2%' or
2102: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '3%' or NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '4%' or
2103: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '5%' OR NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '6%' or

Line 2101: (NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '1%' or NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '2%' or

2097: -- EHRI changes
2098: --
2099: IF ((l_ghr_pa_requests_rec.first_noa_code ='002'
2100: AND
2101: (NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '1%' or NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '2%' or
2102: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '3%' or NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '4%' or
2103: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '5%' OR NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '6%' or
2104: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '7%' OR NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '8%' )
2105: ) -- for 002

Line 2102: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '3%' or NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '4%' or

2098: --
2099: IF ((l_ghr_pa_requests_rec.first_noa_code ='002'
2100: AND
2101: (NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '1%' or NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '2%' or
2102: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '3%' or NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '4%' or
2103: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '5%' OR NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '6%' or
2104: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '7%' OR NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '8%' )
2105: ) -- for 002
2106: OR

Line 2103: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '5%' OR NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '6%' or

2099: IF ((l_ghr_pa_requests_rec.first_noa_code ='002'
2100: AND
2101: (NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '1%' or NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '2%' or
2102: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '3%' or NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '4%' or
2103: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '5%' OR NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '6%' or
2104: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '7%' OR NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '8%' )
2105: ) -- for 002
2106: OR
2107: (l_ghr_pa_requests_rec.first_noa_code like '1%' or l_ghr_pa_requests_rec.first_noa_code like '2%' or

Line 2104: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '7%' OR NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '8%' )

2100: AND
2101: (NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '1%' or NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '2%' or
2102: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '3%' or NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '4%' or
2103: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '5%' OR NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '6%' or
2104: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '7%' OR NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '8%' )
2105: ) -- for 002
2106: OR
2107: (l_ghr_pa_requests_rec.first_noa_code like '1%' or l_ghr_pa_requests_rec.first_noa_code like '2%' or
2108: l_ghr_pa_requests_rec.first_noa_code like '3%' or l_ghr_pa_requests_rec.first_noa_code like '4%' or

Line 2107: (l_ghr_pa_requests_rec.first_noa_code like '1%' or l_ghr_pa_requests_rec.first_noa_code like '2%' or

2103: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '5%' OR NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '6%' or
2104: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '7%' OR NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '8%' )
2105: ) -- for 002
2106: OR
2107: (l_ghr_pa_requests_rec.first_noa_code like '1%' or l_ghr_pa_requests_rec.first_noa_code like '2%' or
2108: l_ghr_pa_requests_rec.first_noa_code like '3%' or l_ghr_pa_requests_rec.first_noa_code like '4%' or
2109: l_ghr_pa_requests_rec.first_noa_code like '5%' OR l_ghr_pa_requests_rec.first_noa_code like '6%' or
2110: l_ghr_pa_requests_rec.first_noa_code like '7%' OR l_ghr_pa_requests_rec.first_noa_code like '8%'
2111: )

Line 2108: l_ghr_pa_requests_rec.first_noa_code like '3%' or l_ghr_pa_requests_rec.first_noa_code like '4%' or

2104: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '7%' OR NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') like '8%' )
2105: ) -- for 002
2106: OR
2107: (l_ghr_pa_requests_rec.first_noa_code like '1%' or l_ghr_pa_requests_rec.first_noa_code like '2%' or
2108: l_ghr_pa_requests_rec.first_noa_code like '3%' or l_ghr_pa_requests_rec.first_noa_code like '4%' or
2109: l_ghr_pa_requests_rec.first_noa_code like '5%' OR l_ghr_pa_requests_rec.first_noa_code like '6%' or
2110: l_ghr_pa_requests_rec.first_noa_code like '7%' OR l_ghr_pa_requests_rec.first_noa_code like '8%'
2111: )
2112: )

Line 2109: l_ghr_pa_requests_rec.first_noa_code like '5%' OR l_ghr_pa_requests_rec.first_noa_code like '6%' or

2105: ) -- for 002
2106: OR
2107: (l_ghr_pa_requests_rec.first_noa_code like '1%' or l_ghr_pa_requests_rec.first_noa_code like '2%' or
2108: l_ghr_pa_requests_rec.first_noa_code like '3%' or l_ghr_pa_requests_rec.first_noa_code like '4%' or
2109: l_ghr_pa_requests_rec.first_noa_code like '5%' OR l_ghr_pa_requests_rec.first_noa_code like '6%' or
2110: l_ghr_pa_requests_rec.first_noa_code like '7%' OR l_ghr_pa_requests_rec.first_noa_code like '8%'
2111: )
2112: )
2113: THEN

Line 2110: l_ghr_pa_requests_rec.first_noa_code like '7%' OR l_ghr_pa_requests_rec.first_noa_code like '8%'

2106: OR
2107: (l_ghr_pa_requests_rec.first_noa_code like '1%' or l_ghr_pa_requests_rec.first_noa_code like '2%' or
2108: l_ghr_pa_requests_rec.first_noa_code like '3%' or l_ghr_pa_requests_rec.first_noa_code like '4%' or
2109: l_ghr_pa_requests_rec.first_noa_code like '5%' OR l_ghr_pa_requests_rec.first_noa_code like '6%' or
2110: l_ghr_pa_requests_rec.first_noa_code like '7%' OR l_ghr_pa_requests_rec.first_noa_code like '8%'
2111: )
2112: )
2113: THEN
2114:

Line 2115: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND

2111: )
2112: )
2113: THEN
2114:
2115: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
2116: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '3%' AND
2117: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
2118: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '3%'
2119: )

Line 2116: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '3%' AND

2112: )
2113: THEN
2114:
2115: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
2116: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '3%' AND
2117: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
2118: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '3%'
2119: )
2120: ) AND

Line 2117: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR

2113: THEN
2114:
2115: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
2116: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '3%' AND
2117: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
2118: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '3%'
2119: )
2120: ) AND
2121: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '4%' AND

Line 2118: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '3%'

2114:
2115: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
2116: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '3%' AND
2117: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
2118: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '3%'
2119: )
2120: ) AND
2121: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '4%' AND
2122: (l_ghr_pa_requests_rec.first_noa_code = '002' OR

Line 2121: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '4%' AND

2117: (l_ghr_pa_requests_rec.first_noa_code <> '002' OR
2118: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '3%'
2119: )
2120: ) AND
2121: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '4%' AND
2122: (l_ghr_pa_requests_rec.first_noa_code = '002' OR
2123: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '4%'
2124: )
2125: ) THEN

Line 2122: (l_ghr_pa_requests_rec.first_noa_code = '002' OR

2118: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '3%'
2119: )
2120: ) AND
2121: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '4%' AND
2122: (l_ghr_pa_requests_rec.first_noa_code = '002' OR
2123: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '4%'
2124: )
2125: ) THEN
2126: l_ghr_cpdf_temp_rec.position_title := l_ghr_pa_requests_rec.to_position_title;

Line 2123: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '4%'

2119: )
2120: ) AND
2121: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '4%' AND
2122: (l_ghr_pa_requests_rec.first_noa_code = '002' OR
2123: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '4%'
2124: )
2125: ) THEN
2126: l_ghr_cpdf_temp_rec.position_title := l_ghr_pa_requests_rec.to_position_title;
2127: ELSE

Line 2126: l_ghr_cpdf_temp_rec.position_title := l_ghr_pa_requests_rec.to_position_title;

2122: (l_ghr_pa_requests_rec.first_noa_code = '002' OR
2123: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '4%'
2124: )
2125: ) THEN
2126: l_ghr_cpdf_temp_rec.position_title := l_ghr_pa_requests_rec.to_position_title;
2127: ELSE
2128: l_ghr_cpdf_temp_rec.position_title := NULL;
2129: END IF;
2130:

Line 2133: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' and

2129: END IF;
2130:
2131: -- Bug#5328177 Added NOAC 827 in the NOAC list.
2132: -- Bug # 8510442 Added 885 into the list to display award amount for 885 action
2133: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' and
2134: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('815','816','817','818','819','825','827',
2135: '840','841','842','843','844','845','846','847','848','849','878','879','885')
2136: )
2137: OR

Line 2134: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('815','816','817','818','819','825','827',

2130:
2131: -- Bug#5328177 Added NOAC 827 in the NOAC list.
2132: -- Bug # 8510442 Added 885 into the list to display award amount for 885 action
2133: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' and
2134: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('815','816','817','818','819','825','827',
2135: '840','841','842','843','844','845','846','847','848','849','878','879','885')
2136: )
2137: OR
2138: l_ghr_pa_requests_rec.first_noa_code in ('815','816','817','818','819','825','827',

Line 2138: l_ghr_pa_requests_rec.first_noa_code in ('815','816','817','818','819','825','827',

2134: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('815','816','817','818','819','825','827',
2135: '840','841','842','843','844','845','846','847','848','849','878','879','885')
2136: )
2137: OR
2138: l_ghr_pa_requests_rec.first_noa_code in ('815','816','817','818','819','825','827',
2139: '840','841','842','843','844','845','846','847','848','849','878','879','885')
2140: )
2141: THEN
2142:

Line 2146: IF ( l_ghr_pa_requests_rec.first_noa_code IN ('825','815','816') OR

2142:
2143: -- Bug#3941541,5168358 Separation Incentive Changes.
2144: -- If the Award Dollars value is NOT NULL, Assume that 825 is processed as Award.
2145: -- Otherwise, it is processed as Incentive.
2146: IF ( l_ghr_pa_requests_rec.first_noa_code IN ('825','815','816') OR
2147: l_ghr_pa_requests_rec.second_noa_code IN ('825','815','816')) AND
2148: l_ghr_pa_requests_rec.award_amount IS NULL THEN
2149: l_ghr_pa_requests_rec.award_amount := l_ghr_pa_requests_rec.to_total_salary;
2150: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.to_total_salary;

Line 2147: l_ghr_pa_requests_rec.second_noa_code IN ('825','815','816')) AND

2143: -- Bug#3941541,5168358 Separation Incentive Changes.
2144: -- If the Award Dollars value is NOT NULL, Assume that 825 is processed as Award.
2145: -- Otherwise, it is processed as Incentive.
2146: IF ( l_ghr_pa_requests_rec.first_noa_code IN ('825','815','816') OR
2147: l_ghr_pa_requests_rec.second_noa_code IN ('825','815','816')) AND
2148: l_ghr_pa_requests_rec.award_amount IS NULL THEN
2149: l_ghr_pa_requests_rec.award_amount := l_ghr_pa_requests_rec.to_total_salary;
2150: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.to_total_salary;
2151: END IF;

Line 2148: l_ghr_pa_requests_rec.award_amount IS NULL THEN

2144: -- If the Award Dollars value is NOT NULL, Assume that 825 is processed as Award.
2145: -- Otherwise, it is processed as Incentive.
2146: IF ( l_ghr_pa_requests_rec.first_noa_code IN ('825','815','816') OR
2147: l_ghr_pa_requests_rec.second_noa_code IN ('825','815','816')) AND
2148: l_ghr_pa_requests_rec.award_amount IS NULL THEN
2149: l_ghr_pa_requests_rec.award_amount := l_ghr_pa_requests_rec.to_total_salary;
2150: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.to_total_salary;
2151: END IF;
2152: -- End of Bug#3941541,5168358

Line 2149: l_ghr_pa_requests_rec.award_amount := l_ghr_pa_requests_rec.to_total_salary;

2145: -- Otherwise, it is processed as Incentive.
2146: IF ( l_ghr_pa_requests_rec.first_noa_code IN ('825','815','816') OR
2147: l_ghr_pa_requests_rec.second_noa_code IN ('825','815','816')) AND
2148: l_ghr_pa_requests_rec.award_amount IS NULL THEN
2149: l_ghr_pa_requests_rec.award_amount := l_ghr_pa_requests_rec.to_total_salary;
2150: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.to_total_salary;
2151: END IF;
2152: -- End of Bug#3941541,5168358
2153:

Line 2150: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.to_total_salary;

2146: IF ( l_ghr_pa_requests_rec.first_noa_code IN ('825','815','816') OR
2147: l_ghr_pa_requests_rec.second_noa_code IN ('825','815','816')) AND
2148: l_ghr_pa_requests_rec.award_amount IS NULL THEN
2149: l_ghr_pa_requests_rec.award_amount := l_ghr_pa_requests_rec.to_total_salary;
2150: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.to_total_salary;
2151: END IF;
2152: -- End of Bug#3941541,5168358
2153:
2154: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='M' THEN

Line 2154: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='M' THEN

2150: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.to_total_salary;
2151: END IF;
2152: -- End of Bug#3941541,5168358
2153:
2154: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='M' THEN
2155: l_ghr_cpdf_temp_rec.award_dollars := l_ghr_pa_requests_rec.award_amount;
2156: END IF;
2157: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='H' THEN
2158: l_ghr_cpdf_temp_rec.award_hours := l_ghr_pa_requests_rec.award_amount;

Line 2155: l_ghr_cpdf_temp_rec.award_dollars := l_ghr_pa_requests_rec.award_amount;

2151: END IF;
2152: -- End of Bug#3941541,5168358
2153:
2154: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='M' THEN
2155: l_ghr_cpdf_temp_rec.award_dollars := l_ghr_pa_requests_rec.award_amount;
2156: END IF;
2157: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='H' THEN
2158: l_ghr_cpdf_temp_rec.award_hours := l_ghr_pa_requests_rec.award_amount;
2159: END IF;

Line 2157: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='H' THEN

2153:
2154: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='M' THEN
2155: l_ghr_cpdf_temp_rec.award_dollars := l_ghr_pa_requests_rec.award_amount;
2156: END IF;
2157: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='H' THEN
2158: l_ghr_cpdf_temp_rec.award_hours := l_ghr_pa_requests_rec.award_amount;
2159: END IF;
2160: IF l_ghr_pa_requests_rec.award_percentage IS NOT NULL THEN
2161: l_ghr_cpdf_temp_rec.award_percentage := l_ghr_pa_requests_rec.award_percentage;

Line 2158: l_ghr_cpdf_temp_rec.award_hours := l_ghr_pa_requests_rec.award_amount;

2154: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='M' THEN
2155: l_ghr_cpdf_temp_rec.award_dollars := l_ghr_pa_requests_rec.award_amount;
2156: END IF;
2157: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='H' THEN
2158: l_ghr_cpdf_temp_rec.award_hours := l_ghr_pa_requests_rec.award_amount;
2159: END IF;
2160: IF l_ghr_pa_requests_rec.award_percentage IS NOT NULL THEN
2161: l_ghr_cpdf_temp_rec.award_percentage := l_ghr_pa_requests_rec.award_percentage;
2162: END IF;

Line 2160: IF l_ghr_pa_requests_rec.award_percentage IS NOT NULL THEN

2156: END IF;
2157: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='H' THEN
2158: l_ghr_cpdf_temp_rec.award_hours := l_ghr_pa_requests_rec.award_amount;
2159: END IF;
2160: IF l_ghr_pa_requests_rec.award_percentage IS NOT NULL THEN
2161: l_ghr_cpdf_temp_rec.award_percentage := l_ghr_pa_requests_rec.award_percentage;
2162: END IF;
2163: -- Bug#5328177 Added the following IF Condition
2164: IF l_ghr_pa_requests_rec.first_noa_code = '827' OR

Line 2161: l_ghr_cpdf_temp_rec.award_percentage := l_ghr_pa_requests_rec.award_percentage;

2157: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='H' THEN
2158: l_ghr_cpdf_temp_rec.award_hours := l_ghr_pa_requests_rec.award_amount;
2159: END IF;
2160: IF l_ghr_pa_requests_rec.award_percentage IS NOT NULL THEN
2161: l_ghr_cpdf_temp_rec.award_percentage := l_ghr_pa_requests_rec.award_percentage;
2162: END IF;
2163: -- Bug#5328177 Added the following IF Condition
2164: IF l_ghr_pa_requests_rec.first_noa_code = '827' OR
2165: l_ghr_pa_requests_rec.second_noa_code = '827' THEN

Line 2164: IF l_ghr_pa_requests_rec.first_noa_code = '827' OR

2160: IF l_ghr_pa_requests_rec.award_percentage IS NOT NULL THEN
2161: l_ghr_cpdf_temp_rec.award_percentage := l_ghr_pa_requests_rec.award_percentage;
2162: END IF;
2163: -- Bug#5328177 Added the following IF Condition
2164: IF l_ghr_pa_requests_rec.first_noa_code = '827' OR
2165: l_ghr_pa_requests_rec.second_noa_code = '827' THEN
2166: l_ghr_cpdf_temp_rec.award_percentage := l_ghr_pa_requests_rec.to_total_salary;
2167: END IF;
2168:

Line 2165: l_ghr_pa_requests_rec.second_noa_code = '827' THEN

2161: l_ghr_cpdf_temp_rec.award_percentage := l_ghr_pa_requests_rec.award_percentage;
2162: END IF;
2163: -- Bug#5328177 Added the following IF Condition
2164: IF l_ghr_pa_requests_rec.first_noa_code = '827' OR
2165: l_ghr_pa_requests_rec.second_noa_code = '827' THEN
2166: l_ghr_cpdf_temp_rec.award_percentage := l_ghr_pa_requests_rec.to_total_salary;
2167: END IF;
2168:
2169:

Line 2166: l_ghr_cpdf_temp_rec.award_percentage := l_ghr_pa_requests_rec.to_total_salary;

2162: END IF;
2163: -- Bug#5328177 Added the following IF Condition
2164: IF l_ghr_pa_requests_rec.first_noa_code = '827' OR
2165: l_ghr_pa_requests_rec.second_noa_code = '827' THEN
2166: l_ghr_cpdf_temp_rec.award_percentage := l_ghr_pa_requests_rec.to_total_salary;
2167: END IF;
2168:
2169:
2170: END IF;

Line 2172: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' AND l_ghr_pa_requests_rec.second_noa_code='817')

2168:
2169:
2170: END IF;
2171:
2172: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' AND l_ghr_pa_requests_rec.second_noa_code='817')
2173: OR
2174: l_ghr_pa_requests_rec.first_noa_code NOT IN ('817')) THEN
2175: l_ghr_cpdf_temp_rec.employee_last_name := format_name_ehri(l_ghr_pa_requests_rec.employee_last_name);
2176: l_ghr_cpdf_temp_rec.employee_first_name := format_name_ehri(l_ghr_pa_requests_rec.employee_first_name);

Line 2174: l_ghr_pa_requests_rec.first_noa_code NOT IN ('817')) THEN

2170: END IF;
2171:
2172: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' AND l_ghr_pa_requests_rec.second_noa_code='817')
2173: OR
2174: l_ghr_pa_requests_rec.first_noa_code NOT IN ('817')) THEN
2175: l_ghr_cpdf_temp_rec.employee_last_name := format_name_ehri(l_ghr_pa_requests_rec.employee_last_name);
2176: l_ghr_cpdf_temp_rec.employee_first_name := format_name_ehri(l_ghr_pa_requests_rec.employee_first_name);
2177: l_ghr_cpdf_temp_rec.employee_middle_names := format_name_ehri(l_ghr_pa_requests_rec.employee_middle_names);
2178: -- Added format_name_ehri for EHRI changes.

Line 2175: l_ghr_cpdf_temp_rec.employee_last_name := format_name_ehri(l_ghr_pa_requests_rec.employee_last_name);

2171:
2172: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' AND l_ghr_pa_requests_rec.second_noa_code='817')
2173: OR
2174: l_ghr_pa_requests_rec.first_noa_code NOT IN ('817')) THEN
2175: l_ghr_cpdf_temp_rec.employee_last_name := format_name_ehri(l_ghr_pa_requests_rec.employee_last_name);
2176: l_ghr_cpdf_temp_rec.employee_first_name := format_name_ehri(l_ghr_pa_requests_rec.employee_first_name);
2177: l_ghr_cpdf_temp_rec.employee_middle_names := format_name_ehri(l_ghr_pa_requests_rec.employee_middle_names);
2178: -- Added format_name_ehri for EHRI changes.
2179: FOR per_det IN cur_per_details(l_ghr_pa_requests_rec.person_id)

Line 2176: l_ghr_cpdf_temp_rec.employee_first_name := format_name_ehri(l_ghr_pa_requests_rec.employee_first_name);

2172: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' AND l_ghr_pa_requests_rec.second_noa_code='817')
2173: OR
2174: l_ghr_pa_requests_rec.first_noa_code NOT IN ('817')) THEN
2175: l_ghr_cpdf_temp_rec.employee_last_name := format_name_ehri(l_ghr_pa_requests_rec.employee_last_name);
2176: l_ghr_cpdf_temp_rec.employee_first_name := format_name_ehri(l_ghr_pa_requests_rec.employee_first_name);
2177: l_ghr_cpdf_temp_rec.employee_middle_names := format_name_ehri(l_ghr_pa_requests_rec.employee_middle_names);
2178: -- Added format_name_ehri for EHRI changes.
2179: FOR per_det IN cur_per_details(l_ghr_pa_requests_rec.person_id)
2180: LOOP

Line 2177: l_ghr_cpdf_temp_rec.employee_middle_names := format_name_ehri(l_ghr_pa_requests_rec.employee_middle_names);

2173: OR
2174: l_ghr_pa_requests_rec.first_noa_code NOT IN ('817')) THEN
2175: l_ghr_cpdf_temp_rec.employee_last_name := format_name_ehri(l_ghr_pa_requests_rec.employee_last_name);
2176: l_ghr_cpdf_temp_rec.employee_first_name := format_name_ehri(l_ghr_pa_requests_rec.employee_first_name);
2177: l_ghr_cpdf_temp_rec.employee_middle_names := format_name_ehri(l_ghr_pa_requests_rec.employee_middle_names);
2178: -- Added format_name_ehri for EHRI changes.
2179: FOR per_det IN cur_per_details(l_ghr_pa_requests_rec.person_id)
2180: LOOP
2181: -- Bug# 4648811getting the suffix from the Employee lastname

Line 2179: FOR per_det IN cur_per_details(l_ghr_pa_requests_rec.person_id)

2175: l_ghr_cpdf_temp_rec.employee_last_name := format_name_ehri(l_ghr_pa_requests_rec.employee_last_name);
2176: l_ghr_cpdf_temp_rec.employee_first_name := format_name_ehri(l_ghr_pa_requests_rec.employee_first_name);
2177: l_ghr_cpdf_temp_rec.employee_middle_names := format_name_ehri(l_ghr_pa_requests_rec.employee_middle_names);
2178: -- Added format_name_ehri for EHRI changes.
2179: FOR per_det IN cur_per_details(l_ghr_pa_requests_rec.person_id)
2180: LOOP
2181: -- Bug# 4648811getting the suffix from the Employee lastname
2182: get_suffix_lname(per_det.last_name,
2183: l_ghr_pa_requests_rec.effective_date,

Line 2183: l_ghr_pa_requests_rec.effective_date,

2179: FOR per_det IN cur_per_details(l_ghr_pa_requests_rec.person_id)
2180: LOOP
2181: -- Bug# 4648811getting the suffix from the Employee lastname
2182: get_suffix_lname(per_det.last_name,
2183: l_ghr_pa_requests_rec.effective_date,
2184: l_suffix,
2185: l_last_name);
2186: --End Bug# 4648811
2187: l_ghr_cpdf_temp_rec.name_title := l_suffix;

Line 2190: FOR scd_dates IN cur_scd_dates(l_ghr_pa_requests_rec.pa_request_id)

2186: --End Bug# 4648811
2187: l_ghr_cpdf_temp_rec.name_title := l_suffix;
2188: END LOOP;
2189:
2190: FOR scd_dates IN cur_scd_dates(l_ghr_pa_requests_rec.pa_request_id)
2191: LOOP
2192: l_ghr_cpdf_temp_rec.SCD_rif := fnd_date.canonical_to_date(scd_dates.rif);
2193: l_ghr_cpdf_temp_rec.SCD_retirement := fnd_date.canonical_to_date(scd_dates.ret);
2194: -- Added date conversion for bug#3808473-EHRI reports

Line 2202: (p_person_id => l_ghr_pa_requests_rec.person_id,

2198: and l_ghr_cpdf_temp_rec.SCD_retirement IS NULL) THEN
2199:
2200: BEGIN
2201: ghr_history_fetch.fetch_peopleei
2202: (p_person_id => l_ghr_pa_requests_rec.person_id,
2203: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
2204: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2205: p_per_ei_data => ll_per_ei_data
2206: );

Line 2204: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),

2200: BEGIN
2201: ghr_history_fetch.fetch_peopleei
2202: (p_person_id => l_ghr_pa_requests_rec.person_id,
2203: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
2204: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2205: p_per_ei_data => ll_per_ei_data
2206: );
2207:
2208: l_ghr_cpdf_temp_rec.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);

Line 2216: l_ghr_pa_requests_rec.pa_request_id ||

2212: WHEN OTHERS THEN
2213: l_message_name := 'fetch_peopleei';
2214: --Bug # 9329643 Modified SSN to Emp No
2215: l_log_text := 'Error in fetching SCD Information for pa_request_id: '||
2216: l_ghr_pa_requests_rec.pa_request_id ||
2217: ' ; Emp No/employee last name' ||
2218: l_employee_number ||' / '||
2219: l_ghr_pa_Requests_rec.employee_last_name ||
2220: ' ; first NOAC/Second NOAC: '||

Line 2219: l_ghr_pa_Requests_rec.employee_last_name ||

2215: l_log_text := 'Error in fetching SCD Information for pa_request_id: '||
2216: l_ghr_pa_requests_rec.pa_request_id ||
2217: ' ; Emp No/employee last name' ||
2218: l_employee_number ||' / '||
2219: l_ghr_pa_Requests_rec.employee_last_name ||
2220: ' ; first NOAC/Second NOAC: '||
2221: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2222: l_ghr_pa_requests_rec.second_noa_code ||
2223: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 2221: l_ghr_pa_requests_rec.first_noa_code || ' / '||

2217: ' ; Emp No/employee last name' ||
2218: l_employee_number ||' / '||
2219: l_ghr_pa_Requests_rec.employee_last_name ||
2220: ' ; first NOAC/Second NOAC: '||
2221: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2222: l_ghr_pa_requests_rec.second_noa_code ||
2223: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
2224:
2225: Raise CPDF_DYNRPT_ERROR;

Line 2222: l_ghr_pa_requests_rec.second_noa_code ||

2218: l_employee_number ||' / '||
2219: l_ghr_pa_Requests_rec.employee_last_name ||
2220: ' ; first NOAC/Second NOAC: '||
2221: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2222: l_ghr_pa_requests_rec.second_noa_code ||
2223: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
2224:
2225: Raise CPDF_DYNRPT_ERROR;
2226: END;

Line 2246: IF l_ghr_pa_requests_rec.first_noa_code = '825'

2242: /* In case of 825 instead of taking TO side values From side values are taken as
2243: to side values are not populated.
2244: in future in case to side values are populated consider only the toside values.
2245: */
2246: IF l_ghr_pa_requests_rec.first_noa_code = '825'
2247: OR ( l_ghr_pa_requests_rec.first_noa_code = '002' and
2248: l_ghr_pa_requests_rec.first_noa_code = '825' ) THEN
2249: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
2250: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;

Line 2247: OR ( l_ghr_pa_requests_rec.first_noa_code = '002' and

2243: to side values are not populated.
2244: in future in case to side values are populated consider only the toside values.
2245: */
2246: IF l_ghr_pa_requests_rec.first_noa_code = '825'
2247: OR ( l_ghr_pa_requests_rec.first_noa_code = '002' and
2248: l_ghr_pa_requests_rec.first_noa_code = '825' ) THEN
2249: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
2250: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2251: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;

Line 2248: l_ghr_pa_requests_rec.first_noa_code = '825' ) THEN

2244: in future in case to side values are populated consider only the toside values.
2245: */
2246: IF l_ghr_pa_requests_rec.first_noa_code = '825'
2247: OR ( l_ghr_pa_requests_rec.first_noa_code = '002' and
2248: l_ghr_pa_requests_rec.first_noa_code = '825' ) THEN
2249: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
2250: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2251: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
2252: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;

Line 2249: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;

2245: */
2246: IF l_ghr_pa_requests_rec.first_noa_code = '825'
2247: OR ( l_ghr_pa_requests_rec.first_noa_code = '002' and
2248: l_ghr_pa_requests_rec.first_noa_code = '825' ) THEN
2249: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
2250: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2251: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
2252: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
2253: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report

Line 2250: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;

2246: IF l_ghr_pa_requests_rec.first_noa_code = '825'
2247: OR ( l_ghr_pa_requests_rec.first_noa_code = '002' and
2248: l_ghr_pa_requests_rec.first_noa_code = '825' ) THEN
2249: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
2250: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2251: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
2252: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
2253: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
2254: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;

Line 2251: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;

2247: OR ( l_ghr_pa_requests_rec.first_noa_code = '002' and
2248: l_ghr_pa_requests_rec.first_noa_code = '825' ) THEN
2249: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
2250: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2251: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
2252: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
2253: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
2254: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
2255:

Line 2252: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;

2248: l_ghr_pa_requests_rec.first_noa_code = '825' ) THEN
2249: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
2250: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2251: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
2252: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
2253: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
2254: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
2255:
2256: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;

Line 2253: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report

2249: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
2250: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2251: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
2252: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
2253: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
2254: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
2255:
2256: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;
2257: l_ghr_cpdf_temp_rec.position_title := l_ghr_pa_requests_rec.from_position_title;

Line 2254: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;

2250: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2251: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
2252: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
2253: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
2254: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
2255:
2256: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;
2257: l_ghr_cpdf_temp_rec.position_title := l_ghr_pa_requests_rec.from_position_title;
2258: END IF;

Line 2256: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;

2252: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
2253: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
2254: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
2255:
2256: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;
2257: l_ghr_cpdf_temp_rec.position_title := l_ghr_pa_requests_rec.from_position_title;
2258: END IF;
2259:
2260: IF l_ghr_cpdf_temp_rec.to_supervisory_differential IS NULL THEN

Line 2257: l_ghr_cpdf_temp_rec.position_title := l_ghr_pa_requests_rec.from_position_title;

2253: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
2254: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
2255:
2256: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;
2257: l_ghr_cpdf_temp_rec.position_title := l_ghr_pa_requests_rec.from_position_title;
2258: END IF;
2259:
2260: IF l_ghr_cpdf_temp_rec.to_supervisory_differential IS NULL THEN
2261:

Line 2265: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id

2261:
2262: BEGIN
2263: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
2264: ,p_input_value_name => 'Amount'
2265: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
2266: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
2267: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential
2268: ,p_multiple_error_flag => l_multi_error_flag);
2269: EXCEPTION

Line 2266: ,p_effective_date => l_ghr_pa_requests_rec.effective_date

2262: BEGIN
2263: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
2264: ,p_input_value_name => 'Amount'
2265: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
2266: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
2267: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential
2268: ,p_multiple_error_flag => l_multi_error_flag);
2269: EXCEPTION
2270: WHEN OTHERS THEN

Line 2274: l_ghr_pa_requests_rec.pa_request_id ||

2270: WHEN OTHERS THEN
2271: --Bug # 9329643 Modified SSN to Emp No
2272: l_message_name := 'retrieve_element_entry_value';
2273: l_log_text := 'Error in fetching Supervisory Differential Amount for pa_request_id: '||
2274: l_ghr_pa_requests_rec.pa_request_id ||
2275: ' ; Emp No/employee last name' ||
2276: l_employee_number ||' / '||
2277: l_ghr_pa_Requests_rec.employee_last_name ||
2278: ' ; first NOAC/Second NOAC: '||

Line 2277: l_ghr_pa_Requests_rec.employee_last_name ||

2273: l_log_text := 'Error in fetching Supervisory Differential Amount for pa_request_id: '||
2274: l_ghr_pa_requests_rec.pa_request_id ||
2275: ' ; Emp No/employee last name' ||
2276: l_employee_number ||' / '||
2277: l_ghr_pa_Requests_rec.employee_last_name ||
2278: ' ; first NOAC/Second NOAC: '||
2279: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2280: l_ghr_pa_requests_rec.second_noa_code ||
2281: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 2279: l_ghr_pa_requests_rec.first_noa_code || ' / '||

2275: ' ; Emp No/employee last name' ||
2276: l_employee_number ||' / '||
2277: l_ghr_pa_Requests_rec.employee_last_name ||
2278: ' ; first NOAC/Second NOAC: '||
2279: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2280: l_ghr_pa_requests_rec.second_noa_code ||
2281: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
2282:
2283: Raise CPDF_DYNRPT_ERROR;

Line 2280: l_ghr_pa_requests_rec.second_noa_code ||

2276: l_employee_number ||' / '||
2277: l_ghr_pa_Requests_rec.employee_last_name ||
2278: ' ; first NOAC/Second NOAC: '||
2279: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2280: l_ghr_pa_requests_rec.second_noa_code ||
2281: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
2282:
2283: Raise CPDF_DYNRPT_ERROR;
2284: END;

Line 2292: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id

2288:
2289: BEGIN
2290: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
2291: ,p_input_value_name => 'Amount'
2292: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
2293: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
2294: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance
2295: ,p_multiple_error_flag => l_multi_error_flag);
2296: EXCEPTION

Line 2293: ,p_effective_date => l_ghr_pa_requests_rec.effective_date

2289: BEGIN
2290: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
2291: ,p_input_value_name => 'Amount'
2292: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
2293: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
2294: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance
2295: ,p_multiple_error_flag => l_multi_error_flag);
2296: EXCEPTION
2297: WHEN OTHERS THEN

Line 2301: l_ghr_pa_requests_rec.pa_request_id ||

2297: WHEN OTHERS THEN
2298: --Bug # 9329643 Modified SSN to Emp No
2299: l_message_name := 'retrieve_element_entry_value';
2300: l_log_text := 'Error in fetching Retention Allowance Amount for pa_request_id: '||
2301: l_ghr_pa_requests_rec.pa_request_id ||
2302: ' ; Emp No/employee last name' ||
2303: l_employee_number ||' / '||
2304: l_ghr_pa_Requests_rec.employee_last_name ||
2305: ' ; first NOAC/Second NOAC: '||

Line 2304: l_ghr_pa_Requests_rec.employee_last_name ||

2300: l_log_text := 'Error in fetching Retention Allowance Amount for pa_request_id: '||
2301: l_ghr_pa_requests_rec.pa_request_id ||
2302: ' ; Emp No/employee last name' ||
2303: l_employee_number ||' / '||
2304: l_ghr_pa_Requests_rec.employee_last_name ||
2305: ' ; first NOAC/Second NOAC: '||
2306: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2307: l_ghr_pa_requests_rec.second_noa_code ||
2308: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 2306: l_ghr_pa_requests_rec.first_noa_code || ' / '||

2302: ' ; Emp No/employee last name' ||
2303: l_employee_number ||' / '||
2304: l_ghr_pa_Requests_rec.employee_last_name ||
2305: ' ; first NOAC/Second NOAC: '||
2306: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2307: l_ghr_pa_requests_rec.second_noa_code ||
2308: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
2309:
2310: Raise CPDF_DYNRPT_ERROR;

Line 2307: l_ghr_pa_requests_rec.second_noa_code ||

2303: l_employee_number ||' / '||
2304: l_ghr_pa_Requests_rec.employee_last_name ||
2305: ' ; first NOAC/Second NOAC: '||
2306: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2307: l_ghr_pa_requests_rec.second_noa_code ||
2308: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
2309:
2310: Raise CPDF_DYNRPT_ERROR;
2311: END;

Line 2321: /* IF ( (l_ghr_pa_requests_rec.first_noa_code='002' and

2317: -- CPDF Reporting changes to include Creditable Military Service, Frozen Service and Prev Retirement Coverage
2318: -- including the NOACS 800 and 782 inspite they are optional for reporting
2319: -- as they will be anyways filtered under exclude_noacs
2320: BEGIN
2321: /* IF ( (l_ghr_pa_requests_rec.first_noa_code='002' and
2322: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('280','292','293'))
2323: OR l_ghr_pa_requests_rec.first_noa_code in ('280','292','293')
2324: ) THEN
2325: ghr_history_fetch.fetch_peopleei

Line 2322: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('280','292','293'))

2318: -- including the NOACS 800 and 782 inspite they are optional for reporting
2319: -- as they will be anyways filtered under exclude_noacs
2320: BEGIN
2321: /* IF ( (l_ghr_pa_requests_rec.first_noa_code='002' and
2322: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('280','292','293'))
2323: OR l_ghr_pa_requests_rec.first_noa_code in ('280','292','293')
2324: ) THEN
2325: ghr_history_fetch.fetch_peopleei
2326: (p_person_id => l_ghr_pa_requests_rec.person_id,

Line 2323: OR l_ghr_pa_requests_rec.first_noa_code in ('280','292','293')

2319: -- as they will be anyways filtered under exclude_noacs
2320: BEGIN
2321: /* IF ( (l_ghr_pa_requests_rec.first_noa_code='002' and
2322: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('280','292','293'))
2323: OR l_ghr_pa_requests_rec.first_noa_code in ('280','292','293')
2324: ) THEN
2325: ghr_history_fetch.fetch_peopleei
2326: (p_person_id => l_ghr_pa_requests_rec.person_id,
2327: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',

Line 2326: (p_person_id => l_ghr_pa_requests_rec.person_id,

2322: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('280','292','293'))
2323: OR l_ghr_pa_requests_rec.first_noa_code in ('280','292','293')
2324: ) THEN
2325: ghr_history_fetch.fetch_peopleei
2326: (p_person_id => l_ghr_pa_requests_rec.person_id,
2327: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2328: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2329: p_per_ei_data => ll_per_ei_data
2330: );

Line 2328: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),

2324: ) THEN
2325: ghr_history_fetch.fetch_peopleei
2326: (p_person_id => l_ghr_pa_requests_rec.person_id,
2327: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2328: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2329: p_per_ei_data => ll_per_ei_data
2330: );
2331: l_ghr_cpdf_temp_rec.from_retirement_coverage := ll_per_ei_data.pei_information4;
2332: -- Cerditable mil serv, frozen serv are already picked up from get_PAR_EI_noac procedure

Line 2337: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' and

2333: -- information5 for Frozen service
2334: ll_per_ei_data:=NULL;
2335:
2336: END IF; */
2337: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' and
2338: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('702','703','713','721','781','782','790','800',
2339: '850','855','867','868','891','892','893','895','899'))
2340: OR l_ghr_pa_requests_rec.first_noa_code in ('702','703','713','721','781','782','790','800',
2341: '850','855','867','868','891','892','893','895','899')

Line 2338: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('702','703','713','721','781','782','790','800',

2334: ll_per_ei_data:=NULL;
2335:
2336: END IF; */
2337: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' and
2338: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('702','703','713','721','781','782','790','800',
2339: '850','855','867','868','891','892','893','895','899'))
2340: OR l_ghr_pa_requests_rec.first_noa_code in ('702','703','713','721','781','782','790','800',
2341: '850','855','867','868','891','892','893','895','899')
2342: ) THEN

Line 2340: OR l_ghr_pa_requests_rec.first_noa_code in ('702','703','713','721','781','782','790','800',

2336: END IF; */
2337: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' and
2338: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('702','703','713','721','781','782','790','800',
2339: '850','855','867','868','891','892','893','895','899'))
2340: OR l_ghr_pa_requests_rec.first_noa_code in ('702','703','713','721','781','782','790','800',
2341: '850','855','867','868','891','892','893','895','899')
2342: ) THEN
2343:
2344: ghr_history_fetch.fetch_peopleei

Line 2345: (p_person_id => l_ghr_pa_requests_rec.person_id,

2341: '850','855','867','868','891','892','893','895','899')
2342: ) THEN
2343:
2344: ghr_history_fetch.fetch_peopleei
2345: (p_person_id => l_ghr_pa_requests_rec.person_id,
2346: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
2347: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2348: p_per_ei_data => ll_per_ei_data
2349: );

Line 2347: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),

2343:
2344: ghr_history_fetch.fetch_peopleei
2345: (p_person_id => l_ghr_pa_requests_rec.person_id,
2346: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
2347: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2348: p_per_ei_data => ll_per_ei_data
2349: );
2350:
2351: l_ghr_cpdf_temp_rec.creditable_military_service:= SUBSTR(ll_per_ei_data.pei_information5,1,4);

Line 2355: (p_person_id => l_ghr_pa_requests_rec.person_id,

2351: l_ghr_cpdf_temp_rec.creditable_military_service:= SUBSTR(ll_per_ei_data.pei_information5,1,4);
2352: ll_per_ei_data :=NULL;
2353:
2354: ghr_history_fetch.fetch_peopleei
2355: (p_person_id => l_ghr_pa_requests_rec.person_id,
2356: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2357: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2358: p_per_ei_data => ll_per_ei_data
2359: );

Line 2357: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),

2353:
2354: ghr_history_fetch.fetch_peopleei
2355: (p_person_id => l_ghr_pa_requests_rec.person_id,
2356: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2357: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2358: p_per_ei_data => ll_per_ei_data
2359: );
2360: l_ghr_cpdf_temp_rec.from_retirement_coverage := ll_per_ei_data.pei_information4;
2361: l_ghr_cpdf_temp_rec.Frozen_service:= SUBSTR(ll_per_ei_data.pei_information5,1,4);

Line 2373: l_locality_pay_area_code := get_loc_pay_area_code(p_duty_station_id => l_ghr_pa_requests_rec.duty_station_id,

2369: END IF;
2370:
2371:
2372: -- Bug 4542476
2373: l_locality_pay_area_code := get_loc_pay_area_code(p_duty_station_id => l_ghr_pa_requests_rec.duty_station_id,
2374: p_effective_date => l_ghr_pa_requests_rec.effective_date);
2375: l_equiv_plan := get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.to_pay_plan));
2376:
2377: -- Bug# 8939586 added the bug fix 5011003 which is fixed for EHRI Dynamics report

Line 2374: p_effective_date => l_ghr_pa_requests_rec.effective_date);

2370:
2371:
2372: -- Bug 4542476
2373: l_locality_pay_area_code := get_loc_pay_area_code(p_duty_station_id => l_ghr_pa_requests_rec.duty_station_id,
2374: p_effective_date => l_ghr_pa_requests_rec.effective_date);
2375: l_equiv_plan := get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.to_pay_plan));
2376:
2377: -- Bug# 8939586 added the bug fix 5011003 which is fixed for EHRI Dynamics report
2378: IF l_ghr_cpdf_temp_rec.to_pay_rate_determinant IN ('3', 'J', 'K', 'U', 'V', '6', 'E', 'F') THEN

Line 2375: l_equiv_plan := get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.to_pay_plan));

2371:
2372: -- Bug 4542476
2373: l_locality_pay_area_code := get_loc_pay_area_code(p_duty_station_id => l_ghr_pa_requests_rec.duty_station_id,
2374: p_effective_date => l_ghr_pa_requests_rec.effective_date);
2375: l_equiv_plan := get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.to_pay_plan));
2376:
2377: -- Bug# 8939586 added the bug fix 5011003 which is fixed for EHRI Dynamics report
2378: IF l_ghr_cpdf_temp_rec.to_pay_rate_determinant IN ('3', 'J', 'K', 'U', 'V', '6', 'E', 'F') THEN
2379: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;

Line 2417: l_ghr_pa_requests_rec.pa_request_id ||

2413: WHEN OTHERS THEN
2414: --Bug # 9329643 Modified SSN to Emp No
2415: l_message_name := 'fetch_peopleei';
2416: l_log_text := 'Error in fetching SCD Information for pa_request_id: '||
2417: l_ghr_pa_requests_rec.pa_request_id ||
2418: ' ; Emp No/employee last name' ||
2419: l_employee_number ||' / '||
2420: l_ghr_pa_Requests_rec.employee_last_name ||
2421: ' ; first NOAC/Second NOAC: '||

Line 2420: l_ghr_pa_Requests_rec.employee_last_name ||

2416: l_log_text := 'Error in fetching SCD Information for pa_request_id: '||
2417: l_ghr_pa_requests_rec.pa_request_id ||
2418: ' ; Emp No/employee last name' ||
2419: l_employee_number ||' / '||
2420: l_ghr_pa_Requests_rec.employee_last_name ||
2421: ' ; first NOAC/Second NOAC: '||
2422: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2423: l_ghr_pa_requests_rec.second_noa_code ||
2424: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 2422: l_ghr_pa_requests_rec.first_noa_code || ' / '||

2418: ' ; Emp No/employee last name' ||
2419: l_employee_number ||' / '||
2420: l_ghr_pa_Requests_rec.employee_last_name ||
2421: ' ; first NOAC/Second NOAC: '||
2422: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2423: l_ghr_pa_requests_rec.second_noa_code ||
2424: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
2425: END;
2426: -- End of changes for CPDF reports picking creditable mil serv, frozen serv and prev retirement coverage

Line 2423: l_ghr_pa_requests_rec.second_noa_code ||

2419: l_employee_number ||' / '||
2420: l_ghr_pa_Requests_rec.employee_last_name ||
2421: ' ; first NOAC/Second NOAC: '||
2422: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2423: l_ghr_pa_requests_rec.second_noa_code ||
2424: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
2425: END;
2426: -- End of changes for CPDF reports picking creditable mil serv, frozen serv and prev retirement coverage
2427: -- 3327389 Bug fix end

Line 2445: l_ghr_pa_requests_rec.pa_request_id ||

2441: hr_utility.set_location('Inside WHEN_OTHERS exception ',40);
2442: --Bug # 9329643 Modified SSN to Emp No
2443: l_message_name := 'Unhandled Error';
2444: l_log_text := 'Unhandled Error for pa_request_id: '||
2445: l_ghr_pa_requests_rec.pa_request_id ||
2446: ' ; Emp No/employee last name' ||
2447: l_employee_number ||' / '||
2448: l_ghr_pa_Requests_rec.employee_last_name ||
2449: ' ; first NOAC/Second NOAC: '||

Line 2448: l_ghr_pa_Requests_rec.employee_last_name ||

2444: l_log_text := 'Unhandled Error for pa_request_id: '||
2445: l_ghr_pa_requests_rec.pa_request_id ||
2446: ' ; Emp No/employee last name' ||
2447: l_employee_number ||' / '||
2448: l_ghr_pa_Requests_rec.employee_last_name ||
2449: ' ; first NOAC/Second NOAC: '||
2450: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2451: l_ghr_pa_requests_rec.second_noa_code ||
2452: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);

Line 2450: l_ghr_pa_requests_rec.first_noa_code || ' / '||

2446: ' ; Emp No/employee last name' ||
2447: l_employee_number ||' / '||
2448: l_ghr_pa_Requests_rec.employee_last_name ||
2449: ' ; first NOAC/Second NOAC: '||
2450: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2451: l_ghr_pa_requests_rec.second_noa_code ||
2452: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
2453: ghr_mto_int.log_message(p_procedure => l_message_name,
2454: p_message => l_log_text

Line 2451: l_ghr_pa_requests_rec.second_noa_code ||

2447: l_employee_number ||' / '||
2448: l_ghr_pa_Requests_rec.employee_last_name ||
2449: ' ; first NOAC/Second NOAC: '||
2450: l_ghr_pa_requests_rec.first_noa_code || ' / '||
2451: l_ghr_pa_requests_rec.second_noa_code ||
2452: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
2453: ghr_mto_int.log_message(p_procedure => l_message_name,
2454: p_message => l_log_text
2455: );