[Home] [Help]
15: -- 'DYNAMICS'
16: ---------------------------------------------------------------------------------------------
17: PROCEDURE cleanup_table IS
18: BEGIN
19: DELETE FROM ghr_cpdf_temp
20: WHERE report_type ='DYNAMICS'
21: AND session_id = USERENV('SESSIONID');
22: COMMIT;
23: END;
446: -- Added for new EHRI changes Madhuri 21-Jan-2005
447: ,p_leave_scd OUT NOCOPY DATE
448: ,p_scd_ses OUT NOCOPY DATE
449: ,p_scd_spcl_retire OUT NOCOPY DATE
450: ,p_ehri_employee_id OUT NOCOPY ghr_cpdf_temp.ehri_employee_id%TYPE --NUMBER
451: ,p_tsp_scd OUT NOCOPY DATE
452: ,p_scd_rif OUT NOCOPY DATE
453: ,p_scd_retirement OUT NOCOPY DATE
454: ,p_agency_use_code_field OUT NOCOPY VARCHAR2
505: l_per_ei_grp1_data per_people_extra_info%rowtype;
506:
507: l_leave_scd DATE;
508: l_tsp_scd DATE;
509: l_ehri_employee_id ghr_cpdf_temp.ehri_employee_id%TYPE;
510: --- Data records retrieval bug 4284244
511: -- EHRI ID type problem
512: --
513:
1179: --
1180: END format_amount;
1181: --
1182: ---------------------------------------------------------------------------------------------
1183: -- This will insert one record into the GHR_CPDF_TEMP
1184: ---------------------------------------------------------------------------------------------
1185: --
1186: PROCEDURE insert_row (p_ghr_cpdf_temp_rec IN ghr_cpdf_temp%rowtype) IS
1187: BEGIN
1182: ---------------------------------------------------------------------------------------------
1183: -- This will insert one record into the GHR_CPDF_TEMP
1184: ---------------------------------------------------------------------------------------------
1185: --
1186: PROCEDURE insert_row (p_ghr_cpdf_temp_rec IN ghr_cpdf_temp%rowtype) IS
1187: BEGIN
1188:
1189: INSERT INTO ghr_cpdf_temp(
1190: report_type,
1185: --
1186: PROCEDURE insert_row (p_ghr_cpdf_temp_rec IN ghr_cpdf_temp%rowtype) IS
1187: BEGIN
1188:
1189: INSERT INTO ghr_cpdf_temp(
1190: report_type,
1191: session_id,
1192: to_national_identifier,
1193: employee_date_of_birth,
1318: )
1319: VALUES(
1320: 'DYNAMICS',
1321: USERENV('SESSIONID'),
1322: p_ghr_cpdf_temp_rec.to_national_identifier,
1323: p_ghr_cpdf_temp_rec.employee_date_of_birth,
1324: p_ghr_cpdf_temp_rec.ehri_employee_id, -- new
1325: p_ghr_cpdf_temp_rec.agency_code,
1326: p_ghr_cpdf_temp_rec.effective_date,
1319: VALUES(
1320: 'DYNAMICS',
1321: USERENV('SESSIONID'),
1322: p_ghr_cpdf_temp_rec.to_national_identifier,
1323: p_ghr_cpdf_temp_rec.employee_date_of_birth,
1324: p_ghr_cpdf_temp_rec.ehri_employee_id, -- new
1325: p_ghr_cpdf_temp_rec.agency_code,
1326: p_ghr_cpdf_temp_rec.effective_date,
1327: p_ghr_cpdf_temp_rec.first_noa_code,
1320: 'DYNAMICS',
1321: USERENV('SESSIONID'),
1322: p_ghr_cpdf_temp_rec.to_national_identifier,
1323: p_ghr_cpdf_temp_rec.employee_date_of_birth,
1324: p_ghr_cpdf_temp_rec.ehri_employee_id, -- new
1325: p_ghr_cpdf_temp_rec.agency_code,
1326: p_ghr_cpdf_temp_rec.effective_date,
1327: p_ghr_cpdf_temp_rec.first_noa_code,
1328: p_ghr_cpdf_temp_rec.first_action_la_code1,
1321: USERENV('SESSIONID'),
1322: p_ghr_cpdf_temp_rec.to_national_identifier,
1323: p_ghr_cpdf_temp_rec.employee_date_of_birth,
1324: p_ghr_cpdf_temp_rec.ehri_employee_id, -- new
1325: p_ghr_cpdf_temp_rec.agency_code,
1326: p_ghr_cpdf_temp_rec.effective_date,
1327: p_ghr_cpdf_temp_rec.first_noa_code,
1328: p_ghr_cpdf_temp_rec.first_action_la_code1,
1329: p_ghr_cpdf_temp_rec.first_action_la_code2,
1322: p_ghr_cpdf_temp_rec.to_national_identifier,
1323: p_ghr_cpdf_temp_rec.employee_date_of_birth,
1324: p_ghr_cpdf_temp_rec.ehri_employee_id, -- new
1325: p_ghr_cpdf_temp_rec.agency_code,
1326: p_ghr_cpdf_temp_rec.effective_date,
1327: p_ghr_cpdf_temp_rec.first_noa_code,
1328: p_ghr_cpdf_temp_rec.first_action_la_code1,
1329: p_ghr_cpdf_temp_rec.first_action_la_code2,
1330: p_ghr_cpdf_temp_rec.second_noa_code,
1323: p_ghr_cpdf_temp_rec.employee_date_of_birth,
1324: p_ghr_cpdf_temp_rec.ehri_employee_id, -- new
1325: p_ghr_cpdf_temp_rec.agency_code,
1326: p_ghr_cpdf_temp_rec.effective_date,
1327: p_ghr_cpdf_temp_rec.first_noa_code,
1328: p_ghr_cpdf_temp_rec.first_action_la_code1,
1329: p_ghr_cpdf_temp_rec.first_action_la_code2,
1330: p_ghr_cpdf_temp_rec.second_noa_code,
1331: p_ghr_cpdf_temp_rec.NOA_CORRECTED, -- new
1324: p_ghr_cpdf_temp_rec.ehri_employee_id, -- new
1325: p_ghr_cpdf_temp_rec.agency_code,
1326: p_ghr_cpdf_temp_rec.effective_date,
1327: p_ghr_cpdf_temp_rec.first_noa_code,
1328: p_ghr_cpdf_temp_rec.first_action_la_code1,
1329: p_ghr_cpdf_temp_rec.first_action_la_code2,
1330: p_ghr_cpdf_temp_rec.second_noa_code,
1331: p_ghr_cpdf_temp_rec.NOA_CORRECTED, -- new
1332: p_ghr_cpdf_temp_rec.EFFECTIVE_DATE_CORRECTED, --new
1325: p_ghr_cpdf_temp_rec.agency_code,
1326: p_ghr_cpdf_temp_rec.effective_date,
1327: p_ghr_cpdf_temp_rec.first_noa_code,
1328: p_ghr_cpdf_temp_rec.first_action_la_code1,
1329: p_ghr_cpdf_temp_rec.first_action_la_code2,
1330: p_ghr_cpdf_temp_rec.second_noa_code,
1331: p_ghr_cpdf_temp_rec.NOA_CORRECTED, -- new
1332: p_ghr_cpdf_temp_rec.EFFECTIVE_DATE_CORRECTED, --new
1333: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1326: p_ghr_cpdf_temp_rec.effective_date,
1327: p_ghr_cpdf_temp_rec.first_noa_code,
1328: p_ghr_cpdf_temp_rec.first_action_la_code1,
1329: p_ghr_cpdf_temp_rec.first_action_la_code2,
1330: p_ghr_cpdf_temp_rec.second_noa_code,
1331: p_ghr_cpdf_temp_rec.NOA_CORRECTED, -- new
1332: p_ghr_cpdf_temp_rec.EFFECTIVE_DATE_CORRECTED, --new
1333: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1334: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1327: p_ghr_cpdf_temp_rec.first_noa_code,
1328: p_ghr_cpdf_temp_rec.first_action_la_code1,
1329: p_ghr_cpdf_temp_rec.first_action_la_code2,
1330: p_ghr_cpdf_temp_rec.second_noa_code,
1331: p_ghr_cpdf_temp_rec.NOA_CORRECTED, -- new
1332: p_ghr_cpdf_temp_rec.EFFECTIVE_DATE_CORRECTED, --new
1333: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1334: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1335: p_ghr_cpdf_temp_rec.APPOINTMENT_NTE_DATE, -- New
1328: p_ghr_cpdf_temp_rec.first_action_la_code1,
1329: p_ghr_cpdf_temp_rec.first_action_la_code2,
1330: p_ghr_cpdf_temp_rec.second_noa_code,
1331: p_ghr_cpdf_temp_rec.NOA_CORRECTED, -- new
1332: p_ghr_cpdf_temp_rec.EFFECTIVE_DATE_CORRECTED, --new
1333: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1334: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1335: p_ghr_cpdf_temp_rec.APPOINTMENT_NTE_DATE, -- New
1336: p_ghr_cpdf_temp_rec.personnel_office_id,
1329: p_ghr_cpdf_temp_rec.first_action_la_code2,
1330: p_ghr_cpdf_temp_rec.second_noa_code,
1331: p_ghr_cpdf_temp_rec.NOA_CORRECTED, -- new
1332: p_ghr_cpdf_temp_rec.EFFECTIVE_DATE_CORRECTED, --new
1333: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1334: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1335: p_ghr_cpdf_temp_rec.APPOINTMENT_NTE_DATE, -- New
1336: p_ghr_cpdf_temp_rec.personnel_office_id,
1337: p_ghr_cpdf_temp_rec.organizational_component,
1330: p_ghr_cpdf_temp_rec.second_noa_code,
1331: p_ghr_cpdf_temp_rec.NOA_CORRECTED, -- new
1332: p_ghr_cpdf_temp_rec.EFFECTIVE_DATE_CORRECTED, --new
1333: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1334: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1335: p_ghr_cpdf_temp_rec.APPOINTMENT_NTE_DATE, -- New
1336: p_ghr_cpdf_temp_rec.personnel_office_id,
1337: p_ghr_cpdf_temp_rec.organizational_component,
1338: p_ghr_cpdf_temp_rec.sex,
1331: p_ghr_cpdf_temp_rec.NOA_CORRECTED, -- new
1332: p_ghr_cpdf_temp_rec.EFFECTIVE_DATE_CORRECTED, --new
1333: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1334: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1335: p_ghr_cpdf_temp_rec.APPOINTMENT_NTE_DATE, -- New
1336: p_ghr_cpdf_temp_rec.personnel_office_id,
1337: p_ghr_cpdf_temp_rec.organizational_component,
1338: p_ghr_cpdf_temp_rec.sex,
1339: p_ghr_cpdf_temp_rec.race_national_origin,
1332: p_ghr_cpdf_temp_rec.EFFECTIVE_DATE_CORRECTED, --new
1333: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1334: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1335: p_ghr_cpdf_temp_rec.APPOINTMENT_NTE_DATE, -- New
1336: p_ghr_cpdf_temp_rec.personnel_office_id,
1337: p_ghr_cpdf_temp_rec.organizational_component,
1338: p_ghr_cpdf_temp_rec.sex,
1339: p_ghr_cpdf_temp_rec.race_national_origin,
1340: p_ghr_cpdf_temp_rec.handicap_code,
1333: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1334: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1335: p_ghr_cpdf_temp_rec.APPOINTMENT_NTE_DATE, -- New
1336: p_ghr_cpdf_temp_rec.personnel_office_id,
1337: p_ghr_cpdf_temp_rec.organizational_component,
1338: p_ghr_cpdf_temp_rec.sex,
1339: p_ghr_cpdf_temp_rec.race_national_origin,
1340: p_ghr_cpdf_temp_rec.handicap_code,
1341: p_ghr_cpdf_temp_rec.SSN_CORRECTED, --new
1334: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1335: p_ghr_cpdf_temp_rec.APPOINTMENT_NTE_DATE, -- New
1336: p_ghr_cpdf_temp_rec.personnel_office_id,
1337: p_ghr_cpdf_temp_rec.organizational_component,
1338: p_ghr_cpdf_temp_rec.sex,
1339: p_ghr_cpdf_temp_rec.race_national_origin,
1340: p_ghr_cpdf_temp_rec.handicap_code,
1341: p_ghr_cpdf_temp_rec.SSN_CORRECTED, --new
1342: p_ghr_cpdf_temp_rec.veterans_preference,
1335: p_ghr_cpdf_temp_rec.APPOINTMENT_NTE_DATE, -- New
1336: p_ghr_cpdf_temp_rec.personnel_office_id,
1337: p_ghr_cpdf_temp_rec.organizational_component,
1338: p_ghr_cpdf_temp_rec.sex,
1339: p_ghr_cpdf_temp_rec.race_national_origin,
1340: p_ghr_cpdf_temp_rec.handicap_code,
1341: p_ghr_cpdf_temp_rec.SSN_CORRECTED, --new
1342: p_ghr_cpdf_temp_rec.veterans_preference,
1343: p_ghr_cpdf_temp_rec.tenure,
1336: p_ghr_cpdf_temp_rec.personnel_office_id,
1337: p_ghr_cpdf_temp_rec.organizational_component,
1338: p_ghr_cpdf_temp_rec.sex,
1339: p_ghr_cpdf_temp_rec.race_national_origin,
1340: p_ghr_cpdf_temp_rec.handicap_code,
1341: p_ghr_cpdf_temp_rec.SSN_CORRECTED, --new
1342: p_ghr_cpdf_temp_rec.veterans_preference,
1343: p_ghr_cpdf_temp_rec.tenure,
1344: p_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD,
1337: p_ghr_cpdf_temp_rec.organizational_component,
1338: p_ghr_cpdf_temp_rec.sex,
1339: p_ghr_cpdf_temp_rec.race_national_origin,
1340: p_ghr_cpdf_temp_rec.handicap_code,
1341: p_ghr_cpdf_temp_rec.SSN_CORRECTED, --new
1342: p_ghr_cpdf_temp_rec.veterans_preference,
1343: p_ghr_cpdf_temp_rec.tenure,
1344: p_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD,
1345: p_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD,
1338: p_ghr_cpdf_temp_rec.sex,
1339: p_ghr_cpdf_temp_rec.race_national_origin,
1340: p_ghr_cpdf_temp_rec.handicap_code,
1341: p_ghr_cpdf_temp_rec.SSN_CORRECTED, --new
1342: p_ghr_cpdf_temp_rec.veterans_preference,
1343: p_ghr_cpdf_temp_rec.tenure,
1344: p_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD,
1345: p_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD,
1346: p_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF,
1339: p_ghr_cpdf_temp_rec.race_national_origin,
1340: p_ghr_cpdf_temp_rec.handicap_code,
1341: p_ghr_cpdf_temp_rec.SSN_CORRECTED, --new
1342: p_ghr_cpdf_temp_rec.veterans_preference,
1343: p_ghr_cpdf_temp_rec.tenure,
1344: p_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD,
1345: p_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD,
1346: p_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF,
1347: p_ghr_cpdf_temp_rec.FEGLI, -- existing but not coded
1340: p_ghr_cpdf_temp_rec.handicap_code,
1341: p_ghr_cpdf_temp_rec.SSN_CORRECTED, --new
1342: p_ghr_cpdf_temp_rec.veterans_preference,
1343: p_ghr_cpdf_temp_rec.tenure,
1344: p_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD,
1345: p_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD,
1346: p_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF,
1347: p_ghr_cpdf_temp_rec.FEGLI, -- existing but not coded
1348: p_ghr_cpdf_temp_rec.annuitant_indicator, -- existing but nt coded
1341: p_ghr_cpdf_temp_rec.SSN_CORRECTED, --new
1342: p_ghr_cpdf_temp_rec.veterans_preference,
1343: p_ghr_cpdf_temp_rec.tenure,
1344: p_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD,
1345: p_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD,
1346: p_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF,
1347: p_ghr_cpdf_temp_rec.FEGLI, -- existing but not coded
1348: p_ghr_cpdf_temp_rec.annuitant_indicator, -- existing but nt coded
1349: p_ghr_cpdf_temp_rec.retirement_plan,
1342: p_ghr_cpdf_temp_rec.veterans_preference,
1343: p_ghr_cpdf_temp_rec.tenure,
1344: p_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD,
1345: p_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD,
1346: p_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF,
1347: p_ghr_cpdf_temp_rec.FEGLI, -- existing but not coded
1348: p_ghr_cpdf_temp_rec.annuitant_indicator, -- existing but nt coded
1349: p_ghr_cpdf_temp_rec.retirement_plan,
1350: p_ghr_cpdf_temp_rec.LEAVE_SCD, --new
1343: p_ghr_cpdf_temp_rec.tenure,
1344: p_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD,
1345: p_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD,
1346: p_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF,
1347: p_ghr_cpdf_temp_rec.FEGLI, -- existing but not coded
1348: p_ghr_cpdf_temp_rec.annuitant_indicator, -- existing but nt coded
1349: p_ghr_cpdf_temp_rec.retirement_plan,
1350: p_ghr_cpdf_temp_rec.LEAVE_SCD, --new
1351: p_ghr_cpdf_temp_rec.SCD_retirement,
1344: p_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD,
1345: p_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD,
1346: p_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF,
1347: p_ghr_cpdf_temp_rec.FEGLI, -- existing but not coded
1348: p_ghr_cpdf_temp_rec.annuitant_indicator, -- existing but nt coded
1349: p_ghr_cpdf_temp_rec.retirement_plan,
1350: p_ghr_cpdf_temp_rec.LEAVE_SCD, --new
1351: p_ghr_cpdf_temp_rec.SCD_retirement,
1352: p_ghr_cpdf_temp_rec.SCD_RIF,
1345: p_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD,
1346: p_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF,
1347: p_ghr_cpdf_temp_rec.FEGLI, -- existing but not coded
1348: p_ghr_cpdf_temp_rec.annuitant_indicator, -- existing but nt coded
1349: p_ghr_cpdf_temp_rec.retirement_plan,
1350: p_ghr_cpdf_temp_rec.LEAVE_SCD, --new
1351: p_ghr_cpdf_temp_rec.SCD_retirement,
1352: p_ghr_cpdf_temp_rec.SCD_RIF,
1353: p_ghr_cpdf_temp_rec.SCD_SES, -- NEW
1346: p_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF,
1347: p_ghr_cpdf_temp_rec.FEGLI, -- existing but not coded
1348: p_ghr_cpdf_temp_rec.annuitant_indicator, -- existing but nt coded
1349: p_ghr_cpdf_temp_rec.retirement_plan,
1350: p_ghr_cpdf_temp_rec.LEAVE_SCD, --new
1351: p_ghr_cpdf_temp_rec.SCD_retirement,
1352: p_ghr_cpdf_temp_rec.SCD_RIF,
1353: p_ghr_cpdf_temp_rec.SCD_SES, -- NEW
1354: p_ghr_cpdf_temp_rec.SCD_spcl_retire, -- NEW
1347: p_ghr_cpdf_temp_rec.FEGLI, -- existing but not coded
1348: p_ghr_cpdf_temp_rec.annuitant_indicator, -- existing but nt coded
1349: p_ghr_cpdf_temp_rec.retirement_plan,
1350: p_ghr_cpdf_temp_rec.LEAVE_SCD, --new
1351: p_ghr_cpdf_temp_rec.SCD_retirement,
1352: p_ghr_cpdf_temp_rec.SCD_RIF,
1353: p_ghr_cpdf_temp_rec.SCD_SES, -- NEW
1354: p_ghr_cpdf_temp_rec.SCD_spcl_retire, -- NEW
1355: p_ghr_cpdf_temp_rec.TSP_SCD, -- NEW
1348: p_ghr_cpdf_temp_rec.annuitant_indicator, -- existing but nt coded
1349: p_ghr_cpdf_temp_rec.retirement_plan,
1350: p_ghr_cpdf_temp_rec.LEAVE_SCD, --new
1351: p_ghr_cpdf_temp_rec.SCD_retirement,
1352: p_ghr_cpdf_temp_rec.SCD_RIF,
1353: p_ghr_cpdf_temp_rec.SCD_SES, -- NEW
1354: p_ghr_cpdf_temp_rec.SCD_spcl_retire, -- NEW
1355: p_ghr_cpdf_temp_rec.TSP_SCD, -- NEW
1356: p_ghr_cpdf_temp_rec.position_occupied,
1349: p_ghr_cpdf_temp_rec.retirement_plan,
1350: p_ghr_cpdf_temp_rec.LEAVE_SCD, --new
1351: p_ghr_cpdf_temp_rec.SCD_retirement,
1352: p_ghr_cpdf_temp_rec.SCD_RIF,
1353: p_ghr_cpdf_temp_rec.SCD_SES, -- NEW
1354: p_ghr_cpdf_temp_rec.SCD_spcl_retire, -- NEW
1355: p_ghr_cpdf_temp_rec.TSP_SCD, -- NEW
1356: p_ghr_cpdf_temp_rec.position_occupied,
1357: p_ghr_cpdf_temp_rec.FLSA_category, -- existing but not coded
1350: p_ghr_cpdf_temp_rec.LEAVE_SCD, --new
1351: p_ghr_cpdf_temp_rec.SCD_retirement,
1352: p_ghr_cpdf_temp_rec.SCD_RIF,
1353: p_ghr_cpdf_temp_rec.SCD_SES, -- NEW
1354: p_ghr_cpdf_temp_rec.SCD_spcl_retire, -- NEW
1355: p_ghr_cpdf_temp_rec.TSP_SCD, -- NEW
1356: p_ghr_cpdf_temp_rec.position_occupied,
1357: p_ghr_cpdf_temp_rec.FLSA_category, -- existing but not coded
1358: p_ghr_cpdf_temp_rec.appropriation_code, -- NEW
1351: p_ghr_cpdf_temp_rec.SCD_retirement,
1352: p_ghr_cpdf_temp_rec.SCD_RIF,
1353: p_ghr_cpdf_temp_rec.SCD_SES, -- NEW
1354: p_ghr_cpdf_temp_rec.SCD_spcl_retire, -- NEW
1355: p_ghr_cpdf_temp_rec.TSP_SCD, -- NEW
1356: p_ghr_cpdf_temp_rec.position_occupied,
1357: p_ghr_cpdf_temp_rec.FLSA_category, -- existing but not coded
1358: p_ghr_cpdf_temp_rec.appropriation_code, -- NEW
1359: p_ghr_cpdf_temp_rec.bargaining_unit_status, -- existing but not coded
1352: p_ghr_cpdf_temp_rec.SCD_RIF,
1353: p_ghr_cpdf_temp_rec.SCD_SES, -- NEW
1354: p_ghr_cpdf_temp_rec.SCD_spcl_retire, -- NEW
1355: p_ghr_cpdf_temp_rec.TSP_SCD, -- NEW
1356: p_ghr_cpdf_temp_rec.position_occupied,
1357: p_ghr_cpdf_temp_rec.FLSA_category, -- existing but not coded
1358: p_ghr_cpdf_temp_rec.appropriation_code, -- NEW
1359: p_ghr_cpdf_temp_rec.bargaining_unit_status, -- existing but not coded
1360: p_ghr_cpdf_temp_rec.supervisory_status,
1353: p_ghr_cpdf_temp_rec.SCD_SES, -- NEW
1354: p_ghr_cpdf_temp_rec.SCD_spcl_retire, -- NEW
1355: p_ghr_cpdf_temp_rec.TSP_SCD, -- NEW
1356: p_ghr_cpdf_temp_rec.position_occupied,
1357: p_ghr_cpdf_temp_rec.FLSA_category, -- existing but not coded
1358: p_ghr_cpdf_temp_rec.appropriation_code, -- NEW
1359: p_ghr_cpdf_temp_rec.bargaining_unit_status, -- existing but not coded
1360: p_ghr_cpdf_temp_rec.supervisory_status,
1361: p_ghr_cpdf_temp_rec.creditable_military_service,
1354: p_ghr_cpdf_temp_rec.SCD_spcl_retire, -- NEW
1355: p_ghr_cpdf_temp_rec.TSP_SCD, -- NEW
1356: p_ghr_cpdf_temp_rec.position_occupied,
1357: p_ghr_cpdf_temp_rec.FLSA_category, -- existing but not coded
1358: p_ghr_cpdf_temp_rec.appropriation_code, -- NEW
1359: p_ghr_cpdf_temp_rec.bargaining_unit_status, -- existing but not coded
1360: p_ghr_cpdf_temp_rec.supervisory_status,
1361: p_ghr_cpdf_temp_rec.creditable_military_service,
1362: p_ghr_cpdf_temp_rec.frozen_service,
1355: p_ghr_cpdf_temp_rec.TSP_SCD, -- NEW
1356: p_ghr_cpdf_temp_rec.position_occupied,
1357: p_ghr_cpdf_temp_rec.FLSA_category, -- existing but not coded
1358: p_ghr_cpdf_temp_rec.appropriation_code, -- NEW
1359: p_ghr_cpdf_temp_rec.bargaining_unit_status, -- existing but not coded
1360: p_ghr_cpdf_temp_rec.supervisory_status,
1361: p_ghr_cpdf_temp_rec.creditable_military_service,
1362: p_ghr_cpdf_temp_rec.frozen_service,
1363: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1356: p_ghr_cpdf_temp_rec.position_occupied,
1357: p_ghr_cpdf_temp_rec.FLSA_category, -- existing but not coded
1358: p_ghr_cpdf_temp_rec.appropriation_code, -- NEW
1359: p_ghr_cpdf_temp_rec.bargaining_unit_status, -- existing but not coded
1360: p_ghr_cpdf_temp_rec.supervisory_status,
1361: p_ghr_cpdf_temp_rec.creditable_military_service,
1362: p_ghr_cpdf_temp_rec.frozen_service,
1363: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1364: p_ghr_cpdf_temp_rec.veterans_status,
1357: p_ghr_cpdf_temp_rec.FLSA_category, -- existing but not coded
1358: p_ghr_cpdf_temp_rec.appropriation_code, -- NEW
1359: p_ghr_cpdf_temp_rec.bargaining_unit_status, -- existing but not coded
1360: p_ghr_cpdf_temp_rec.supervisory_status,
1361: p_ghr_cpdf_temp_rec.creditable_military_service,
1362: p_ghr_cpdf_temp_rec.frozen_service,
1363: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1364: p_ghr_cpdf_temp_rec.veterans_status,
1365: p_ghr_cpdf_temp_rec.education_level,
1358: p_ghr_cpdf_temp_rec.appropriation_code, -- NEW
1359: p_ghr_cpdf_temp_rec.bargaining_unit_status, -- existing but not coded
1360: p_ghr_cpdf_temp_rec.supervisory_status,
1361: p_ghr_cpdf_temp_rec.creditable_military_service,
1362: p_ghr_cpdf_temp_rec.frozen_service,
1363: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1364: p_ghr_cpdf_temp_rec.veterans_status,
1365: p_ghr_cpdf_temp_rec.education_level,
1366: p_ghr_cpdf_temp_rec.academic_discipline,
1359: p_ghr_cpdf_temp_rec.bargaining_unit_status, -- existing but not coded
1360: p_ghr_cpdf_temp_rec.supervisory_status,
1361: p_ghr_cpdf_temp_rec.creditable_military_service,
1362: p_ghr_cpdf_temp_rec.frozen_service,
1363: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1364: p_ghr_cpdf_temp_rec.veterans_status,
1365: p_ghr_cpdf_temp_rec.education_level,
1366: p_ghr_cpdf_temp_rec.academic_discipline,
1367: p_ghr_cpdf_temp_rec.year_degree_attained,
1360: p_ghr_cpdf_temp_rec.supervisory_status,
1361: p_ghr_cpdf_temp_rec.creditable_military_service,
1362: p_ghr_cpdf_temp_rec.frozen_service,
1363: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1364: p_ghr_cpdf_temp_rec.veterans_status,
1365: p_ghr_cpdf_temp_rec.education_level,
1366: p_ghr_cpdf_temp_rec.academic_discipline,
1367: p_ghr_cpdf_temp_rec.year_degree_attained,
1368: p_ghr_cpdf_temp_rec.rating_of_record_level,
1361: p_ghr_cpdf_temp_rec.creditable_military_service,
1362: p_ghr_cpdf_temp_rec.frozen_service,
1363: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1364: p_ghr_cpdf_temp_rec.veterans_status,
1365: p_ghr_cpdf_temp_rec.education_level,
1366: p_ghr_cpdf_temp_rec.academic_discipline,
1367: p_ghr_cpdf_temp_rec.year_degree_attained,
1368: p_ghr_cpdf_temp_rec.rating_of_record_level,
1369: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1362: p_ghr_cpdf_temp_rec.frozen_service,
1363: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1364: p_ghr_cpdf_temp_rec.veterans_status,
1365: p_ghr_cpdf_temp_rec.education_level,
1366: p_ghr_cpdf_temp_rec.academic_discipline,
1367: p_ghr_cpdf_temp_rec.year_degree_attained,
1368: p_ghr_cpdf_temp_rec.rating_of_record_level,
1369: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1370: p_ghr_cpdf_temp_rec.rating_of_record_period_starts, -- NEW
1363: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1364: p_ghr_cpdf_temp_rec.veterans_status,
1365: p_ghr_cpdf_temp_rec.education_level,
1366: p_ghr_cpdf_temp_rec.academic_discipline,
1367: p_ghr_cpdf_temp_rec.year_degree_attained,
1368: p_ghr_cpdf_temp_rec.rating_of_record_level,
1369: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1370: p_ghr_cpdf_temp_rec.rating_of_record_period_starts, -- NEW
1371: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1364: p_ghr_cpdf_temp_rec.veterans_status,
1365: p_ghr_cpdf_temp_rec.education_level,
1366: p_ghr_cpdf_temp_rec.academic_discipline,
1367: p_ghr_cpdf_temp_rec.year_degree_attained,
1368: p_ghr_cpdf_temp_rec.rating_of_record_level,
1369: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1370: p_ghr_cpdf_temp_rec.rating_of_record_period_starts, -- NEW
1371: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1372: p_ghr_cpdf_temp_rec.PRIOR_FAMILY_NAME, --
1365: p_ghr_cpdf_temp_rec.education_level,
1366: p_ghr_cpdf_temp_rec.academic_discipline,
1367: p_ghr_cpdf_temp_rec.year_degree_attained,
1368: p_ghr_cpdf_temp_rec.rating_of_record_level,
1369: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1370: p_ghr_cpdf_temp_rec.rating_of_record_period_starts, -- NEW
1371: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1372: p_ghr_cpdf_temp_rec.PRIOR_FAMILY_NAME, --
1373: p_ghr_cpdf_temp_rec.PRIOR_GIVEN_NAME, --
1366: p_ghr_cpdf_temp_rec.academic_discipline,
1367: p_ghr_cpdf_temp_rec.year_degree_attained,
1368: p_ghr_cpdf_temp_rec.rating_of_record_level,
1369: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1370: p_ghr_cpdf_temp_rec.rating_of_record_period_starts, -- NEW
1371: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1372: p_ghr_cpdf_temp_rec.PRIOR_FAMILY_NAME, --
1373: p_ghr_cpdf_temp_rec.PRIOR_GIVEN_NAME, --
1374: p_ghr_cpdf_temp_rec.PRIOR_MIDDLE_NAME, --
1367: p_ghr_cpdf_temp_rec.year_degree_attained,
1368: p_ghr_cpdf_temp_rec.rating_of_record_level,
1369: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1370: p_ghr_cpdf_temp_rec.rating_of_record_period_starts, -- NEW
1371: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1372: p_ghr_cpdf_temp_rec.PRIOR_FAMILY_NAME, --
1373: p_ghr_cpdf_temp_rec.PRIOR_GIVEN_NAME, --
1374: p_ghr_cpdf_temp_rec.PRIOR_MIDDLE_NAME, --
1375: p_ghr_cpdf_temp_rec.PRIOR_NAME_SUFFIX, -- New
1368: p_ghr_cpdf_temp_rec.rating_of_record_level,
1369: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1370: p_ghr_cpdf_temp_rec.rating_of_record_period_starts, -- NEW
1371: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1372: p_ghr_cpdf_temp_rec.PRIOR_FAMILY_NAME, --
1373: p_ghr_cpdf_temp_rec.PRIOR_GIVEN_NAME, --
1374: p_ghr_cpdf_temp_rec.PRIOR_MIDDLE_NAME, --
1375: p_ghr_cpdf_temp_rec.PRIOR_NAME_SUFFIX, -- New
1376: p_ghr_cpdf_temp_rec.PRIOR_POSITION_TITLE, --
1369: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1370: p_ghr_cpdf_temp_rec.rating_of_record_period_starts, -- NEW
1371: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1372: p_ghr_cpdf_temp_rec.PRIOR_FAMILY_NAME, --
1373: p_ghr_cpdf_temp_rec.PRIOR_GIVEN_NAME, --
1374: p_ghr_cpdf_temp_rec.PRIOR_MIDDLE_NAME, --
1375: p_ghr_cpdf_temp_rec.PRIOR_NAME_SUFFIX, -- New
1376: p_ghr_cpdf_temp_rec.PRIOR_POSITION_TITLE, --
1377: p_ghr_cpdf_temp_rec.PRIOR_POSITION_NUMBER, --
1370: p_ghr_cpdf_temp_rec.rating_of_record_period_starts, -- NEW
1371: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1372: p_ghr_cpdf_temp_rec.PRIOR_FAMILY_NAME, --
1373: p_ghr_cpdf_temp_rec.PRIOR_GIVEN_NAME, --
1374: p_ghr_cpdf_temp_rec.PRIOR_MIDDLE_NAME, --
1375: p_ghr_cpdf_temp_rec.PRIOR_NAME_SUFFIX, -- New
1376: p_ghr_cpdf_temp_rec.PRIOR_POSITION_TITLE, --
1377: p_ghr_cpdf_temp_rec.PRIOR_POSITION_NUMBER, --
1378: p_ghr_cpdf_temp_rec.PRIOR_POSITION_ORG, --
1371: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1372: p_ghr_cpdf_temp_rec.PRIOR_FAMILY_NAME, --
1373: p_ghr_cpdf_temp_rec.PRIOR_GIVEN_NAME, --
1374: p_ghr_cpdf_temp_rec.PRIOR_MIDDLE_NAME, --
1375: p_ghr_cpdf_temp_rec.PRIOR_NAME_SUFFIX, -- New
1376: p_ghr_cpdf_temp_rec.PRIOR_POSITION_TITLE, --
1377: p_ghr_cpdf_temp_rec.PRIOR_POSITION_NUMBER, --
1378: p_ghr_cpdf_temp_rec.PRIOR_POSITION_ORG, --
1379: p_ghr_cpdf_temp_rec.from_pay_plan,
1372: p_ghr_cpdf_temp_rec.PRIOR_FAMILY_NAME, --
1373: p_ghr_cpdf_temp_rec.PRIOR_GIVEN_NAME, --
1374: p_ghr_cpdf_temp_rec.PRIOR_MIDDLE_NAME, --
1375: p_ghr_cpdf_temp_rec.PRIOR_NAME_SUFFIX, -- New
1376: p_ghr_cpdf_temp_rec.PRIOR_POSITION_TITLE, --
1377: p_ghr_cpdf_temp_rec.PRIOR_POSITION_NUMBER, --
1378: p_ghr_cpdf_temp_rec.PRIOR_POSITION_ORG, --
1379: p_ghr_cpdf_temp_rec.from_pay_plan,
1380: p_ghr_cpdf_temp_rec.from_occ_code,
1373: p_ghr_cpdf_temp_rec.PRIOR_GIVEN_NAME, --
1374: p_ghr_cpdf_temp_rec.PRIOR_MIDDLE_NAME, --
1375: p_ghr_cpdf_temp_rec.PRIOR_NAME_SUFFIX, -- New
1376: p_ghr_cpdf_temp_rec.PRIOR_POSITION_TITLE, --
1377: p_ghr_cpdf_temp_rec.PRIOR_POSITION_NUMBER, --
1378: p_ghr_cpdf_temp_rec.PRIOR_POSITION_ORG, --
1379: p_ghr_cpdf_temp_rec.from_pay_plan,
1380: p_ghr_cpdf_temp_rec.from_occ_code,
1381: p_ghr_cpdf_temp_rec.from_grade_or_level,
1374: p_ghr_cpdf_temp_rec.PRIOR_MIDDLE_NAME, --
1375: p_ghr_cpdf_temp_rec.PRIOR_NAME_SUFFIX, -- New
1376: p_ghr_cpdf_temp_rec.PRIOR_POSITION_TITLE, --
1377: p_ghr_cpdf_temp_rec.PRIOR_POSITION_NUMBER, --
1378: p_ghr_cpdf_temp_rec.PRIOR_POSITION_ORG, --
1379: p_ghr_cpdf_temp_rec.from_pay_plan,
1380: p_ghr_cpdf_temp_rec.from_occ_code,
1381: p_ghr_cpdf_temp_rec.from_grade_or_level,
1382: p_ghr_cpdf_temp_rec.from_step_or_rate,
1375: p_ghr_cpdf_temp_rec.PRIOR_NAME_SUFFIX, -- New
1376: p_ghr_cpdf_temp_rec.PRIOR_POSITION_TITLE, --
1377: p_ghr_cpdf_temp_rec.PRIOR_POSITION_NUMBER, --
1378: p_ghr_cpdf_temp_rec.PRIOR_POSITION_ORG, --
1379: p_ghr_cpdf_temp_rec.from_pay_plan,
1380: p_ghr_cpdf_temp_rec.from_occ_code,
1381: p_ghr_cpdf_temp_rec.from_grade_or_level,
1382: p_ghr_cpdf_temp_rec.from_step_or_rate,
1383: p_ghr_cpdf_temp_rec.from_pay_basis,
1376: p_ghr_cpdf_temp_rec.PRIOR_POSITION_TITLE, --
1377: p_ghr_cpdf_temp_rec.PRIOR_POSITION_NUMBER, --
1378: p_ghr_cpdf_temp_rec.PRIOR_POSITION_ORG, --
1379: p_ghr_cpdf_temp_rec.from_pay_plan,
1380: p_ghr_cpdf_temp_rec.from_occ_code,
1381: p_ghr_cpdf_temp_rec.from_grade_or_level,
1382: p_ghr_cpdf_temp_rec.from_step_or_rate,
1383: p_ghr_cpdf_temp_rec.from_pay_basis,
1384: p_ghr_cpdf_temp_rec.from_total_salary, -- existing but not coded
1377: p_ghr_cpdf_temp_rec.PRIOR_POSITION_NUMBER, --
1378: p_ghr_cpdf_temp_rec.PRIOR_POSITION_ORG, --
1379: p_ghr_cpdf_temp_rec.from_pay_plan,
1380: p_ghr_cpdf_temp_rec.from_occ_code,
1381: p_ghr_cpdf_temp_rec.from_grade_or_level,
1382: p_ghr_cpdf_temp_rec.from_step_or_rate,
1383: p_ghr_cpdf_temp_rec.from_pay_basis,
1384: p_ghr_cpdf_temp_rec.from_total_salary, -- existing but not coded
1385: p_ghr_cpdf_temp_rec.from_basic_pay,
1378: p_ghr_cpdf_temp_rec.PRIOR_POSITION_ORG, --
1379: p_ghr_cpdf_temp_rec.from_pay_plan,
1380: p_ghr_cpdf_temp_rec.from_occ_code,
1381: p_ghr_cpdf_temp_rec.from_grade_or_level,
1382: p_ghr_cpdf_temp_rec.from_step_or_rate,
1383: p_ghr_cpdf_temp_rec.from_pay_basis,
1384: p_ghr_cpdf_temp_rec.from_total_salary, -- existing but not coded
1385: p_ghr_cpdf_temp_rec.from_basic_pay,
1386: p_ghr_cpdf_temp_rec.from_adj_basic_pay,
1379: p_ghr_cpdf_temp_rec.from_pay_plan,
1380: p_ghr_cpdf_temp_rec.from_occ_code,
1381: p_ghr_cpdf_temp_rec.from_grade_or_level,
1382: p_ghr_cpdf_temp_rec.from_step_or_rate,
1383: p_ghr_cpdf_temp_rec.from_pay_basis,
1384: p_ghr_cpdf_temp_rec.from_total_salary, -- existing but not coded
1385: p_ghr_cpdf_temp_rec.from_basic_pay,
1386: p_ghr_cpdf_temp_rec.from_adj_basic_pay,
1387: p_ghr_cpdf_temp_rec.from_locality_adj,
1380: p_ghr_cpdf_temp_rec.from_occ_code,
1381: p_ghr_cpdf_temp_rec.from_grade_or_level,
1382: p_ghr_cpdf_temp_rec.from_step_or_rate,
1383: p_ghr_cpdf_temp_rec.from_pay_basis,
1384: p_ghr_cpdf_temp_rec.from_total_salary, -- existing but not coded
1385: p_ghr_cpdf_temp_rec.from_basic_pay,
1386: p_ghr_cpdf_temp_rec.from_adj_basic_pay,
1387: p_ghr_cpdf_temp_rec.from_locality_adj,
1388: p_ghr_cpdf_temp_rec.from_work_schedule,
1381: p_ghr_cpdf_temp_rec.from_grade_or_level,
1382: p_ghr_cpdf_temp_rec.from_step_or_rate,
1383: p_ghr_cpdf_temp_rec.from_pay_basis,
1384: p_ghr_cpdf_temp_rec.from_total_salary, -- existing but not coded
1385: p_ghr_cpdf_temp_rec.from_basic_pay,
1386: p_ghr_cpdf_temp_rec.from_adj_basic_pay,
1387: p_ghr_cpdf_temp_rec.from_locality_adj,
1388: p_ghr_cpdf_temp_rec.from_work_schedule,
1389: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1382: p_ghr_cpdf_temp_rec.from_step_or_rate,
1383: p_ghr_cpdf_temp_rec.from_pay_basis,
1384: p_ghr_cpdf_temp_rec.from_total_salary, -- existing but not coded
1385: p_ghr_cpdf_temp_rec.from_basic_pay,
1386: p_ghr_cpdf_temp_rec.from_adj_basic_pay,
1387: p_ghr_cpdf_temp_rec.from_locality_adj,
1388: p_ghr_cpdf_temp_rec.from_work_schedule,
1389: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1390: p_ghr_cpdf_temp_rec.from_duty_station_code,
1383: p_ghr_cpdf_temp_rec.from_pay_basis,
1384: p_ghr_cpdf_temp_rec.from_total_salary, -- existing but not coded
1385: p_ghr_cpdf_temp_rec.from_basic_pay,
1386: p_ghr_cpdf_temp_rec.from_adj_basic_pay,
1387: p_ghr_cpdf_temp_rec.from_locality_adj,
1388: p_ghr_cpdf_temp_rec.from_work_schedule,
1389: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1390: p_ghr_cpdf_temp_rec.from_duty_station_code,
1391: p_ghr_cpdf_temp_rec.employee_last_name,
1384: p_ghr_cpdf_temp_rec.from_total_salary, -- existing but not coded
1385: p_ghr_cpdf_temp_rec.from_basic_pay,
1386: p_ghr_cpdf_temp_rec.from_adj_basic_pay,
1387: p_ghr_cpdf_temp_rec.from_locality_adj,
1388: p_ghr_cpdf_temp_rec.from_work_schedule,
1389: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1390: p_ghr_cpdf_temp_rec.from_duty_station_code,
1391: p_ghr_cpdf_temp_rec.employee_last_name,
1392: p_ghr_cpdf_temp_rec.employee_first_name,
1385: p_ghr_cpdf_temp_rec.from_basic_pay,
1386: p_ghr_cpdf_temp_rec.from_adj_basic_pay,
1387: p_ghr_cpdf_temp_rec.from_locality_adj,
1388: p_ghr_cpdf_temp_rec.from_work_schedule,
1389: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1390: p_ghr_cpdf_temp_rec.from_duty_station_code,
1391: p_ghr_cpdf_temp_rec.employee_last_name,
1392: p_ghr_cpdf_temp_rec.employee_first_name,
1393: p_ghr_cpdf_temp_rec.employee_middle_names,
1386: p_ghr_cpdf_temp_rec.from_adj_basic_pay,
1387: p_ghr_cpdf_temp_rec.from_locality_adj,
1388: p_ghr_cpdf_temp_rec.from_work_schedule,
1389: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1390: p_ghr_cpdf_temp_rec.from_duty_station_code,
1391: p_ghr_cpdf_temp_rec.employee_last_name,
1392: p_ghr_cpdf_temp_rec.employee_first_name,
1393: p_ghr_cpdf_temp_rec.employee_middle_names,
1394: p_ghr_cpdf_temp_rec.name_title,
1387: p_ghr_cpdf_temp_rec.from_locality_adj,
1388: p_ghr_cpdf_temp_rec.from_work_schedule,
1389: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1390: p_ghr_cpdf_temp_rec.from_duty_station_code,
1391: p_ghr_cpdf_temp_rec.employee_last_name,
1392: p_ghr_cpdf_temp_rec.employee_first_name,
1393: p_ghr_cpdf_temp_rec.employee_middle_names,
1394: p_ghr_cpdf_temp_rec.name_title,
1395: p_ghr_cpdf_temp_rec.position_title,
1388: p_ghr_cpdf_temp_rec.from_work_schedule,
1389: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1390: p_ghr_cpdf_temp_rec.from_duty_station_code,
1391: p_ghr_cpdf_temp_rec.employee_last_name,
1392: p_ghr_cpdf_temp_rec.employee_first_name,
1393: p_ghr_cpdf_temp_rec.employee_middle_names,
1394: p_ghr_cpdf_temp_rec.name_title,
1395: p_ghr_cpdf_temp_rec.position_title,
1396: p_ghr_cpdf_temp_rec.POSITION_NUMBER, -- NEW
1389: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1390: p_ghr_cpdf_temp_rec.from_duty_station_code,
1391: p_ghr_cpdf_temp_rec.employee_last_name,
1392: p_ghr_cpdf_temp_rec.employee_first_name,
1393: p_ghr_cpdf_temp_rec.employee_middle_names,
1394: p_ghr_cpdf_temp_rec.name_title,
1395: p_ghr_cpdf_temp_rec.position_title,
1396: p_ghr_cpdf_temp_rec.POSITION_NUMBER, -- NEW
1397: p_ghr_cpdf_temp_rec.POSITION_ORG, -- NEW
1390: p_ghr_cpdf_temp_rec.from_duty_station_code,
1391: p_ghr_cpdf_temp_rec.employee_last_name,
1392: p_ghr_cpdf_temp_rec.employee_first_name,
1393: p_ghr_cpdf_temp_rec.employee_middle_names,
1394: p_ghr_cpdf_temp_rec.name_title,
1395: p_ghr_cpdf_temp_rec.position_title,
1396: p_ghr_cpdf_temp_rec.POSITION_NUMBER, -- NEW
1397: p_ghr_cpdf_temp_rec.POSITION_ORG, -- NEW
1398: p_ghr_cpdf_temp_rec.to_pay_plan,
1391: p_ghr_cpdf_temp_rec.employee_last_name,
1392: p_ghr_cpdf_temp_rec.employee_first_name,
1393: p_ghr_cpdf_temp_rec.employee_middle_names,
1394: p_ghr_cpdf_temp_rec.name_title,
1395: p_ghr_cpdf_temp_rec.position_title,
1396: p_ghr_cpdf_temp_rec.POSITION_NUMBER, -- NEW
1397: p_ghr_cpdf_temp_rec.POSITION_ORG, -- NEW
1398: p_ghr_cpdf_temp_rec.to_pay_plan,
1399: p_ghr_cpdf_temp_rec.to_occ_code,
1392: p_ghr_cpdf_temp_rec.employee_first_name,
1393: p_ghr_cpdf_temp_rec.employee_middle_names,
1394: p_ghr_cpdf_temp_rec.name_title,
1395: p_ghr_cpdf_temp_rec.position_title,
1396: p_ghr_cpdf_temp_rec.POSITION_NUMBER, -- NEW
1397: p_ghr_cpdf_temp_rec.POSITION_ORG, -- NEW
1398: p_ghr_cpdf_temp_rec.to_pay_plan,
1399: p_ghr_cpdf_temp_rec.to_occ_code,
1400: p_ghr_cpdf_temp_rec.to_grade_or_level,
1393: p_ghr_cpdf_temp_rec.employee_middle_names,
1394: p_ghr_cpdf_temp_rec.name_title,
1395: p_ghr_cpdf_temp_rec.position_title,
1396: p_ghr_cpdf_temp_rec.POSITION_NUMBER, -- NEW
1397: p_ghr_cpdf_temp_rec.POSITION_ORG, -- NEW
1398: p_ghr_cpdf_temp_rec.to_pay_plan,
1399: p_ghr_cpdf_temp_rec.to_occ_code,
1400: p_ghr_cpdf_temp_rec.to_grade_or_level,
1401: p_ghr_cpdf_temp_rec.to_step_or_rate,
1394: p_ghr_cpdf_temp_rec.name_title,
1395: p_ghr_cpdf_temp_rec.position_title,
1396: p_ghr_cpdf_temp_rec.POSITION_NUMBER, -- NEW
1397: p_ghr_cpdf_temp_rec.POSITION_ORG, -- NEW
1398: p_ghr_cpdf_temp_rec.to_pay_plan,
1399: p_ghr_cpdf_temp_rec.to_occ_code,
1400: p_ghr_cpdf_temp_rec.to_grade_or_level,
1401: p_ghr_cpdf_temp_rec.to_step_or_rate,
1402: p_ghr_cpdf_temp_rec.to_pay_basis,
1395: p_ghr_cpdf_temp_rec.position_title,
1396: p_ghr_cpdf_temp_rec.POSITION_NUMBER, -- NEW
1397: p_ghr_cpdf_temp_rec.POSITION_ORG, -- NEW
1398: p_ghr_cpdf_temp_rec.to_pay_plan,
1399: p_ghr_cpdf_temp_rec.to_occ_code,
1400: p_ghr_cpdf_temp_rec.to_grade_or_level,
1401: p_ghr_cpdf_temp_rec.to_step_or_rate,
1402: p_ghr_cpdf_temp_rec.to_pay_basis,
1403: p_ghr_cpdf_temp_rec.to_total_salary, -- existing but not coded
1396: p_ghr_cpdf_temp_rec.POSITION_NUMBER, -- NEW
1397: p_ghr_cpdf_temp_rec.POSITION_ORG, -- NEW
1398: p_ghr_cpdf_temp_rec.to_pay_plan,
1399: p_ghr_cpdf_temp_rec.to_occ_code,
1400: p_ghr_cpdf_temp_rec.to_grade_or_level,
1401: p_ghr_cpdf_temp_rec.to_step_or_rate,
1402: p_ghr_cpdf_temp_rec.to_pay_basis,
1403: p_ghr_cpdf_temp_rec.to_total_salary, -- existing but not coded
1404: p_ghr_cpdf_temp_rec.to_basic_pay,
1397: p_ghr_cpdf_temp_rec.POSITION_ORG, -- NEW
1398: p_ghr_cpdf_temp_rec.to_pay_plan,
1399: p_ghr_cpdf_temp_rec.to_occ_code,
1400: p_ghr_cpdf_temp_rec.to_grade_or_level,
1401: p_ghr_cpdf_temp_rec.to_step_or_rate,
1402: p_ghr_cpdf_temp_rec.to_pay_basis,
1403: p_ghr_cpdf_temp_rec.to_total_salary, -- existing but not coded
1404: p_ghr_cpdf_temp_rec.to_basic_pay,
1405: p_ghr_cpdf_temp_rec.TO_ADJ_BASIC_PAY, -- NEW
1398: p_ghr_cpdf_temp_rec.to_pay_plan,
1399: p_ghr_cpdf_temp_rec.to_occ_code,
1400: p_ghr_cpdf_temp_rec.to_grade_or_level,
1401: p_ghr_cpdf_temp_rec.to_step_or_rate,
1402: p_ghr_cpdf_temp_rec.to_pay_basis,
1403: p_ghr_cpdf_temp_rec.to_total_salary, -- existing but not coded
1404: p_ghr_cpdf_temp_rec.to_basic_pay,
1405: p_ghr_cpdf_temp_rec.TO_ADJ_BASIC_PAY, -- NEW
1406: p_ghr_cpdf_temp_rec.to_locality_adj,
1399: p_ghr_cpdf_temp_rec.to_occ_code,
1400: p_ghr_cpdf_temp_rec.to_grade_or_level,
1401: p_ghr_cpdf_temp_rec.to_step_or_rate,
1402: p_ghr_cpdf_temp_rec.to_pay_basis,
1403: p_ghr_cpdf_temp_rec.to_total_salary, -- existing but not coded
1404: p_ghr_cpdf_temp_rec.to_basic_pay,
1405: p_ghr_cpdf_temp_rec.TO_ADJ_BASIC_PAY, -- NEW
1406: p_ghr_cpdf_temp_rec.to_locality_adj,
1407: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1400: p_ghr_cpdf_temp_rec.to_grade_or_level,
1401: p_ghr_cpdf_temp_rec.to_step_or_rate,
1402: p_ghr_cpdf_temp_rec.to_pay_basis,
1403: p_ghr_cpdf_temp_rec.to_total_salary, -- existing but not coded
1404: p_ghr_cpdf_temp_rec.to_basic_pay,
1405: p_ghr_cpdf_temp_rec.TO_ADJ_BASIC_PAY, -- NEW
1406: p_ghr_cpdf_temp_rec.to_locality_adj,
1407: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1408: p_ghr_cpdf_temp_rec.to_retention_allowance,
1401: p_ghr_cpdf_temp_rec.to_step_or_rate,
1402: p_ghr_cpdf_temp_rec.to_pay_basis,
1403: p_ghr_cpdf_temp_rec.to_total_salary, -- existing but not coded
1404: p_ghr_cpdf_temp_rec.to_basic_pay,
1405: p_ghr_cpdf_temp_rec.TO_ADJ_BASIC_PAY, -- NEW
1406: p_ghr_cpdf_temp_rec.to_locality_adj,
1407: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1408: p_ghr_cpdf_temp_rec.to_retention_allowance,
1409: p_ghr_cpdf_temp_rec.award_dollars,
1402: p_ghr_cpdf_temp_rec.to_pay_basis,
1403: p_ghr_cpdf_temp_rec.to_total_salary, -- existing but not coded
1404: p_ghr_cpdf_temp_rec.to_basic_pay,
1405: p_ghr_cpdf_temp_rec.TO_ADJ_BASIC_PAY, -- NEW
1406: p_ghr_cpdf_temp_rec.to_locality_adj,
1407: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1408: p_ghr_cpdf_temp_rec.to_retention_allowance,
1409: p_ghr_cpdf_temp_rec.award_dollars,
1410: p_ghr_cpdf_temp_rec.award_hours,
1403: p_ghr_cpdf_temp_rec.to_total_salary, -- existing but not coded
1404: p_ghr_cpdf_temp_rec.to_basic_pay,
1405: p_ghr_cpdf_temp_rec.TO_ADJ_BASIC_PAY, -- NEW
1406: p_ghr_cpdf_temp_rec.to_locality_adj,
1407: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1408: p_ghr_cpdf_temp_rec.to_retention_allowance,
1409: p_ghr_cpdf_temp_rec.award_dollars,
1410: p_ghr_cpdf_temp_rec.award_hours,
1411: p_ghr_cpdf_temp_rec.award_percentage,
1404: p_ghr_cpdf_temp_rec.to_basic_pay,
1405: p_ghr_cpdf_temp_rec.TO_ADJ_BASIC_PAY, -- NEW
1406: p_ghr_cpdf_temp_rec.to_locality_adj,
1407: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1408: p_ghr_cpdf_temp_rec.to_retention_allowance,
1409: p_ghr_cpdf_temp_rec.award_dollars,
1410: p_ghr_cpdf_temp_rec.award_hours,
1411: p_ghr_cpdf_temp_rec.award_percentage,
1412: p_ghr_cpdf_temp_rec.to_work_schedule,
1405: p_ghr_cpdf_temp_rec.TO_ADJ_BASIC_PAY, -- NEW
1406: p_ghr_cpdf_temp_rec.to_locality_adj,
1407: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1408: p_ghr_cpdf_temp_rec.to_retention_allowance,
1409: p_ghr_cpdf_temp_rec.award_dollars,
1410: p_ghr_cpdf_temp_rec.award_hours,
1411: p_ghr_cpdf_temp_rec.award_percentage,
1412: p_ghr_cpdf_temp_rec.to_work_schedule,
1413: p_ghr_cpdf_temp_rec.PART_TIME_HOURS, --NEW
1406: p_ghr_cpdf_temp_rec.to_locality_adj,
1407: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1408: p_ghr_cpdf_temp_rec.to_retention_allowance,
1409: p_ghr_cpdf_temp_rec.award_dollars,
1410: p_ghr_cpdf_temp_rec.award_hours,
1411: p_ghr_cpdf_temp_rec.award_percentage,
1412: p_ghr_cpdf_temp_rec.to_work_schedule,
1413: p_ghr_cpdf_temp_rec.PART_TIME_HOURS, --NEW
1414: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1407: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1408: p_ghr_cpdf_temp_rec.to_retention_allowance,
1409: p_ghr_cpdf_temp_rec.award_dollars,
1410: p_ghr_cpdf_temp_rec.award_hours,
1411: p_ghr_cpdf_temp_rec.award_percentage,
1412: p_ghr_cpdf_temp_rec.to_work_schedule,
1413: p_ghr_cpdf_temp_rec.PART_TIME_HOURS, --NEW
1414: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1415: p_ghr_cpdf_temp_rec.to_duty_station_code,
1408: p_ghr_cpdf_temp_rec.to_retention_allowance,
1409: p_ghr_cpdf_temp_rec.award_dollars,
1410: p_ghr_cpdf_temp_rec.award_hours,
1411: p_ghr_cpdf_temp_rec.award_percentage,
1412: p_ghr_cpdf_temp_rec.to_work_schedule,
1413: p_ghr_cpdf_temp_rec.PART_TIME_HOURS, --NEW
1414: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1415: p_ghr_cpdf_temp_rec.to_duty_station_code,
1416: p_ghr_cpdf_temp_rec.AGENCY_DATA1, -- NEW
1409: p_ghr_cpdf_temp_rec.award_dollars,
1410: p_ghr_cpdf_temp_rec.award_hours,
1411: p_ghr_cpdf_temp_rec.award_percentage,
1412: p_ghr_cpdf_temp_rec.to_work_schedule,
1413: p_ghr_cpdf_temp_rec.PART_TIME_HOURS, --NEW
1414: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1415: p_ghr_cpdf_temp_rec.to_duty_station_code,
1416: p_ghr_cpdf_temp_rec.AGENCY_DATA1, -- NEW
1417: p_ghr_cpdf_temp_rec.AGENCY_DATA2, -- NEW
1410: p_ghr_cpdf_temp_rec.award_hours,
1411: p_ghr_cpdf_temp_rec.award_percentage,
1412: p_ghr_cpdf_temp_rec.to_work_schedule,
1413: p_ghr_cpdf_temp_rec.PART_TIME_HOURS, --NEW
1414: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1415: p_ghr_cpdf_temp_rec.to_duty_station_code,
1416: p_ghr_cpdf_temp_rec.AGENCY_DATA1, -- NEW
1417: p_ghr_cpdf_temp_rec.AGENCY_DATA2, -- NEW
1418: p_ghr_cpdf_temp_rec.AGENCY_DATA3, --NEW
1411: p_ghr_cpdf_temp_rec.award_percentage,
1412: p_ghr_cpdf_temp_rec.to_work_schedule,
1413: p_ghr_cpdf_temp_rec.PART_TIME_HOURS, --NEW
1414: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1415: p_ghr_cpdf_temp_rec.to_duty_station_code,
1416: p_ghr_cpdf_temp_rec.AGENCY_DATA1, -- NEW
1417: p_ghr_cpdf_temp_rec.AGENCY_DATA2, -- NEW
1418: p_ghr_cpdf_temp_rec.AGENCY_DATA3, --NEW
1419: p_ghr_cpdf_temp_rec.AGENCY_DATA4, -- NEW
1412: p_ghr_cpdf_temp_rec.to_work_schedule,
1413: p_ghr_cpdf_temp_rec.PART_TIME_HOURS, --NEW
1414: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1415: p_ghr_cpdf_temp_rec.to_duty_station_code,
1416: p_ghr_cpdf_temp_rec.AGENCY_DATA1, -- NEW
1417: p_ghr_cpdf_temp_rec.AGENCY_DATA2, -- NEW
1418: p_ghr_cpdf_temp_rec.AGENCY_DATA3, --NEW
1419: p_ghr_cpdf_temp_rec.AGENCY_DATA4, -- NEW
1420: p_ghr_cpdf_temp_rec.AGENCY_DATA5, --NEW
1413: p_ghr_cpdf_temp_rec.PART_TIME_HOURS, --NEW
1414: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1415: p_ghr_cpdf_temp_rec.to_duty_station_code,
1416: p_ghr_cpdf_temp_rec.AGENCY_DATA1, -- NEW
1417: p_ghr_cpdf_temp_rec.AGENCY_DATA2, -- NEW
1418: p_ghr_cpdf_temp_rec.AGENCY_DATA3, --NEW
1419: p_ghr_cpdf_temp_rec.AGENCY_DATA4, -- NEW
1420: p_ghr_cpdf_temp_rec.AGENCY_DATA5, --NEW
1421: p_ghr_cpdf_temp_rec.ACTION_APPROVAL_DATE, --NEW
1414: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1415: p_ghr_cpdf_temp_rec.to_duty_station_code,
1416: p_ghr_cpdf_temp_rec.AGENCY_DATA1, -- NEW
1417: p_ghr_cpdf_temp_rec.AGENCY_DATA2, -- NEW
1418: p_ghr_cpdf_temp_rec.AGENCY_DATA3, --NEW
1419: p_ghr_cpdf_temp_rec.AGENCY_DATA4, -- NEW
1420: p_ghr_cpdf_temp_rec.AGENCY_DATA5, --NEW
1421: p_ghr_cpdf_temp_rec.ACTION_APPROVAL_DATE, --NEW
1422: p_ghr_cpdf_temp_rec.ACTION_AUTHR_FAMILY_NAME, --NEW
1415: p_ghr_cpdf_temp_rec.to_duty_station_code,
1416: p_ghr_cpdf_temp_rec.AGENCY_DATA1, -- NEW
1417: p_ghr_cpdf_temp_rec.AGENCY_DATA2, -- NEW
1418: p_ghr_cpdf_temp_rec.AGENCY_DATA3, --NEW
1419: p_ghr_cpdf_temp_rec.AGENCY_DATA4, -- NEW
1420: p_ghr_cpdf_temp_rec.AGENCY_DATA5, --NEW
1421: p_ghr_cpdf_temp_rec.ACTION_APPROVAL_DATE, --NEW
1422: p_ghr_cpdf_temp_rec.ACTION_AUTHR_FAMILY_NAME, --NEW
1423: p_ghr_cpdf_temp_rec.ACTION_AUTHR_GIVEN_NAME, --NEW
1416: p_ghr_cpdf_temp_rec.AGENCY_DATA1, -- NEW
1417: p_ghr_cpdf_temp_rec.AGENCY_DATA2, -- NEW
1418: p_ghr_cpdf_temp_rec.AGENCY_DATA3, --NEW
1419: p_ghr_cpdf_temp_rec.AGENCY_DATA4, -- NEW
1420: p_ghr_cpdf_temp_rec.AGENCY_DATA5, --NEW
1421: p_ghr_cpdf_temp_rec.ACTION_APPROVAL_DATE, --NEW
1422: p_ghr_cpdf_temp_rec.ACTION_AUTHR_FAMILY_NAME, --NEW
1423: p_ghr_cpdf_temp_rec.ACTION_AUTHR_GIVEN_NAME, --NEW
1424: p_ghr_cpdf_temp_rec.ACTION_AUTHR_MIDDLE_NAME, --NEW
1417: p_ghr_cpdf_temp_rec.AGENCY_DATA2, -- NEW
1418: p_ghr_cpdf_temp_rec.AGENCY_DATA3, --NEW
1419: p_ghr_cpdf_temp_rec.AGENCY_DATA4, -- NEW
1420: p_ghr_cpdf_temp_rec.AGENCY_DATA5, --NEW
1421: p_ghr_cpdf_temp_rec.ACTION_APPROVAL_DATE, --NEW
1422: p_ghr_cpdf_temp_rec.ACTION_AUTHR_FAMILY_NAME, --NEW
1423: p_ghr_cpdf_temp_rec.ACTION_AUTHR_GIVEN_NAME, --NEW
1424: p_ghr_cpdf_temp_rec.ACTION_AUTHR_MIDDLE_NAME, --NEW
1425: p_ghr_cpdf_temp_rec.ACTION_AUTHR_NAME_SUFFIX, --NEW
1418: p_ghr_cpdf_temp_rec.AGENCY_DATA3, --NEW
1419: p_ghr_cpdf_temp_rec.AGENCY_DATA4, -- NEW
1420: p_ghr_cpdf_temp_rec.AGENCY_DATA5, --NEW
1421: p_ghr_cpdf_temp_rec.ACTION_APPROVAL_DATE, --NEW
1422: p_ghr_cpdf_temp_rec.ACTION_AUTHR_FAMILY_NAME, --NEW
1423: p_ghr_cpdf_temp_rec.ACTION_AUTHR_GIVEN_NAME, --NEW
1424: p_ghr_cpdf_temp_rec.ACTION_AUTHR_MIDDLE_NAME, --NEW
1425: p_ghr_cpdf_temp_rec.ACTION_AUTHR_NAME_SUFFIX, --NEW
1426: p_ghr_cpdf_temp_rec.ACTION_AUTHR_TITLE, --NEW
1419: p_ghr_cpdf_temp_rec.AGENCY_DATA4, -- NEW
1420: p_ghr_cpdf_temp_rec.AGENCY_DATA5, --NEW
1421: p_ghr_cpdf_temp_rec.ACTION_APPROVAL_DATE, --NEW
1422: p_ghr_cpdf_temp_rec.ACTION_AUTHR_FAMILY_NAME, --NEW
1423: p_ghr_cpdf_temp_rec.ACTION_AUTHR_GIVEN_NAME, --NEW
1424: p_ghr_cpdf_temp_rec.ACTION_AUTHR_MIDDLE_NAME, --NEW
1425: p_ghr_cpdf_temp_rec.ACTION_AUTHR_NAME_SUFFIX, --NEW
1426: p_ghr_cpdf_temp_rec.ACTION_AUTHR_TITLE, --NEW
1427: p_ghr_cpdf_temp_rec.REMARKS_TEXT, --NEW
1420: p_ghr_cpdf_temp_rec.AGENCY_DATA5, --NEW
1421: p_ghr_cpdf_temp_rec.ACTION_APPROVAL_DATE, --NEW
1422: p_ghr_cpdf_temp_rec.ACTION_AUTHR_FAMILY_NAME, --NEW
1423: p_ghr_cpdf_temp_rec.ACTION_AUTHR_GIVEN_NAME, --NEW
1424: p_ghr_cpdf_temp_rec.ACTION_AUTHR_MIDDLE_NAME, --NEW
1425: p_ghr_cpdf_temp_rec.ACTION_AUTHR_NAME_SUFFIX, --NEW
1426: p_ghr_cpdf_temp_rec.ACTION_AUTHR_TITLE, --NEW
1427: p_ghr_cpdf_temp_rec.REMARKS_TEXT, --NEW
1428: p_ghr_cpdf_temp_rec.race_ethnic_info,
1421: p_ghr_cpdf_temp_rec.ACTION_APPROVAL_DATE, --NEW
1422: p_ghr_cpdf_temp_rec.ACTION_AUTHR_FAMILY_NAME, --NEW
1423: p_ghr_cpdf_temp_rec.ACTION_AUTHR_GIVEN_NAME, --NEW
1424: p_ghr_cpdf_temp_rec.ACTION_AUTHR_MIDDLE_NAME, --NEW
1425: p_ghr_cpdf_temp_rec.ACTION_AUTHR_NAME_SUFFIX, --NEW
1426: p_ghr_cpdf_temp_rec.ACTION_AUTHR_TITLE, --NEW
1427: p_ghr_cpdf_temp_rec.REMARKS_TEXT, --NEW
1428: p_ghr_cpdf_temp_rec.race_ethnic_info,
1429: p_ghr_cpdf_temp_rec.from_spl_rate_supplement,
1422: p_ghr_cpdf_temp_rec.ACTION_AUTHR_FAMILY_NAME, --NEW
1423: p_ghr_cpdf_temp_rec.ACTION_AUTHR_GIVEN_NAME, --NEW
1424: p_ghr_cpdf_temp_rec.ACTION_AUTHR_MIDDLE_NAME, --NEW
1425: p_ghr_cpdf_temp_rec.ACTION_AUTHR_NAME_SUFFIX, --NEW
1426: p_ghr_cpdf_temp_rec.ACTION_AUTHR_TITLE, --NEW
1427: p_ghr_cpdf_temp_rec.REMARKS_TEXT, --NEW
1428: p_ghr_cpdf_temp_rec.race_ethnic_info,
1429: p_ghr_cpdf_temp_rec.from_spl_rate_supplement,
1430: p_ghr_cpdf_temp_rec.to_spl_rate_supplement,
1423: p_ghr_cpdf_temp_rec.ACTION_AUTHR_GIVEN_NAME, --NEW
1424: p_ghr_cpdf_temp_rec.ACTION_AUTHR_MIDDLE_NAME, --NEW
1425: p_ghr_cpdf_temp_rec.ACTION_AUTHR_NAME_SUFFIX, --NEW
1426: p_ghr_cpdf_temp_rec.ACTION_AUTHR_TITLE, --NEW
1427: p_ghr_cpdf_temp_rec.REMARKS_TEXT, --NEW
1428: p_ghr_cpdf_temp_rec.race_ethnic_info,
1429: p_ghr_cpdf_temp_rec.from_spl_rate_supplement,
1430: p_ghr_cpdf_temp_rec.to_spl_rate_supplement,
1431: --Bug# 6158983
1424: p_ghr_cpdf_temp_rec.ACTION_AUTHR_MIDDLE_NAME, --NEW
1425: p_ghr_cpdf_temp_rec.ACTION_AUTHR_NAME_SUFFIX, --NEW
1426: p_ghr_cpdf_temp_rec.ACTION_AUTHR_TITLE, --NEW
1427: p_ghr_cpdf_temp_rec.REMARKS_TEXT, --NEW
1428: p_ghr_cpdf_temp_rec.race_ethnic_info,
1429: p_ghr_cpdf_temp_rec.from_spl_rate_supplement,
1430: p_ghr_cpdf_temp_rec.to_spl_rate_supplement,
1431: --Bug# 6158983
1432: p_ghr_cpdf_temp_rec.world_citizenship,
1425: p_ghr_cpdf_temp_rec.ACTION_AUTHR_NAME_SUFFIX, --NEW
1426: p_ghr_cpdf_temp_rec.ACTION_AUTHR_TITLE, --NEW
1427: p_ghr_cpdf_temp_rec.REMARKS_TEXT, --NEW
1428: p_ghr_cpdf_temp_rec.race_ethnic_info,
1429: p_ghr_cpdf_temp_rec.from_spl_rate_supplement,
1430: p_ghr_cpdf_temp_rec.to_spl_rate_supplement,
1431: --Bug# 6158983
1432: p_ghr_cpdf_temp_rec.world_citizenship,
1433: p_ghr_cpdf_temp_rec.health_plan,
1426: p_ghr_cpdf_temp_rec.ACTION_AUTHR_TITLE, --NEW
1427: p_ghr_cpdf_temp_rec.REMARKS_TEXT, --NEW
1428: p_ghr_cpdf_temp_rec.race_ethnic_info,
1429: p_ghr_cpdf_temp_rec.from_spl_rate_supplement,
1430: p_ghr_cpdf_temp_rec.to_spl_rate_supplement,
1431: --Bug# 6158983
1432: p_ghr_cpdf_temp_rec.world_citizenship,
1433: p_ghr_cpdf_temp_rec.health_plan,
1434: p_ghr_cpdf_temp_rec.special_population_code,
1428: p_ghr_cpdf_temp_rec.race_ethnic_info,
1429: p_ghr_cpdf_temp_rec.from_spl_rate_supplement,
1430: p_ghr_cpdf_temp_rec.to_spl_rate_supplement,
1431: --Bug# 6158983
1432: p_ghr_cpdf_temp_rec.world_citizenship,
1433: p_ghr_cpdf_temp_rec.health_plan,
1434: p_ghr_cpdf_temp_rec.special_population_code,
1435: p_ghr_cpdf_temp_rec.csrs_exc_appts,
1436: p_ghr_cpdf_temp_rec.fers_exc_appts,
1429: p_ghr_cpdf_temp_rec.from_spl_rate_supplement,
1430: p_ghr_cpdf_temp_rec.to_spl_rate_supplement,
1431: --Bug# 6158983
1432: p_ghr_cpdf_temp_rec.world_citizenship,
1433: p_ghr_cpdf_temp_rec.health_plan,
1434: p_ghr_cpdf_temp_rec.special_population_code,
1435: p_ghr_cpdf_temp_rec.csrs_exc_appts,
1436: p_ghr_cpdf_temp_rec.fers_exc_appts,
1437: p_ghr_cpdf_temp_rec.fica_coverage_ind1,
1430: p_ghr_cpdf_temp_rec.to_spl_rate_supplement,
1431: --Bug# 6158983
1432: p_ghr_cpdf_temp_rec.world_citizenship,
1433: p_ghr_cpdf_temp_rec.health_plan,
1434: p_ghr_cpdf_temp_rec.special_population_code,
1435: p_ghr_cpdf_temp_rec.csrs_exc_appts,
1436: p_ghr_cpdf_temp_rec.fers_exc_appts,
1437: p_ghr_cpdf_temp_rec.fica_coverage_ind1,
1438: p_ghr_cpdf_temp_rec.fica_coverage_ind2,
1431: --Bug# 6158983
1432: p_ghr_cpdf_temp_rec.world_citizenship,
1433: p_ghr_cpdf_temp_rec.health_plan,
1434: p_ghr_cpdf_temp_rec.special_population_code,
1435: p_ghr_cpdf_temp_rec.csrs_exc_appts,
1436: p_ghr_cpdf_temp_rec.fers_exc_appts,
1437: p_ghr_cpdf_temp_rec.fica_coverage_ind1,
1438: p_ghr_cpdf_temp_rec.fica_coverage_ind2,
1439: p_ghr_cpdf_temp_rec.hyp_full_reg_duty_part_emp,
1432: p_ghr_cpdf_temp_rec.world_citizenship,
1433: p_ghr_cpdf_temp_rec.health_plan,
1434: p_ghr_cpdf_temp_rec.special_population_code,
1435: p_ghr_cpdf_temp_rec.csrs_exc_appts,
1436: p_ghr_cpdf_temp_rec.fers_exc_appts,
1437: p_ghr_cpdf_temp_rec.fica_coverage_ind1,
1438: p_ghr_cpdf_temp_rec.fica_coverage_ind2,
1439: p_ghr_cpdf_temp_rec.hyp_full_reg_duty_part_emp,
1440: p_ghr_cpdf_temp_rec.fegli_assg_indicator,
1433: p_ghr_cpdf_temp_rec.health_plan,
1434: p_ghr_cpdf_temp_rec.special_population_code,
1435: p_ghr_cpdf_temp_rec.csrs_exc_appts,
1436: p_ghr_cpdf_temp_rec.fers_exc_appts,
1437: p_ghr_cpdf_temp_rec.fica_coverage_ind1,
1438: p_ghr_cpdf_temp_rec.fica_coverage_ind2,
1439: p_ghr_cpdf_temp_rec.hyp_full_reg_duty_part_emp,
1440: p_ghr_cpdf_temp_rec.fegli_assg_indicator,
1441: p_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt,
1434: p_ghr_cpdf_temp_rec.special_population_code,
1435: p_ghr_cpdf_temp_rec.csrs_exc_appts,
1436: p_ghr_cpdf_temp_rec.fers_exc_appts,
1437: p_ghr_cpdf_temp_rec.fica_coverage_ind1,
1438: p_ghr_cpdf_temp_rec.fica_coverage_ind2,
1439: p_ghr_cpdf_temp_rec.hyp_full_reg_duty_part_emp,
1440: p_ghr_cpdf_temp_rec.fegli_assg_indicator,
1441: p_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt,
1442: p_ghr_cpdf_temp_rec.fegli_court_ord_ind,
1435: p_ghr_cpdf_temp_rec.csrs_exc_appts,
1436: p_ghr_cpdf_temp_rec.fers_exc_appts,
1437: p_ghr_cpdf_temp_rec.fica_coverage_ind1,
1438: p_ghr_cpdf_temp_rec.fica_coverage_ind2,
1439: p_ghr_cpdf_temp_rec.hyp_full_reg_duty_part_emp,
1440: p_ghr_cpdf_temp_rec.fegli_assg_indicator,
1441: p_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt,
1442: p_ghr_cpdf_temp_rec.fegli_court_ord_ind,
1443: p_ghr_cpdf_temp_rec.fegli_benf_desg_ind,
1436: p_ghr_cpdf_temp_rec.fers_exc_appts,
1437: p_ghr_cpdf_temp_rec.fica_coverage_ind1,
1438: p_ghr_cpdf_temp_rec.fica_coverage_ind2,
1439: p_ghr_cpdf_temp_rec.hyp_full_reg_duty_part_emp,
1440: p_ghr_cpdf_temp_rec.fegli_assg_indicator,
1441: p_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt,
1442: p_ghr_cpdf_temp_rec.fegli_court_ord_ind,
1443: p_ghr_cpdf_temp_rec.fegli_benf_desg_ind,
1444: p_ghr_cpdf_temp_rec.fehb_event_code,
1437: p_ghr_cpdf_temp_rec.fica_coverage_ind1,
1438: p_ghr_cpdf_temp_rec.fica_coverage_ind2,
1439: p_ghr_cpdf_temp_rec.hyp_full_reg_duty_part_emp,
1440: p_ghr_cpdf_temp_rec.fegli_assg_indicator,
1441: p_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt,
1442: p_ghr_cpdf_temp_rec.fegli_court_ord_ind,
1443: p_ghr_cpdf_temp_rec.fegli_benf_desg_ind,
1444: p_ghr_cpdf_temp_rec.fehb_event_code,
1445: p_ghr_cpdf_temp_rec.pareq_last_updated_date,
1438: p_ghr_cpdf_temp_rec.fica_coverage_ind2,
1439: p_ghr_cpdf_temp_rec.hyp_full_reg_duty_part_emp,
1440: p_ghr_cpdf_temp_rec.fegli_assg_indicator,
1441: p_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt,
1442: p_ghr_cpdf_temp_rec.fegli_court_ord_ind,
1443: p_ghr_cpdf_temp_rec.fegli_benf_desg_ind,
1444: p_ghr_cpdf_temp_rec.fehb_event_code,
1445: p_ghr_cpdf_temp_rec.pareq_last_updated_date,
1446: p_ghr_cpdf_temp_rec.fehb_elect_eff_date
1439: p_ghr_cpdf_temp_rec.hyp_full_reg_duty_part_emp,
1440: p_ghr_cpdf_temp_rec.fegli_assg_indicator,
1441: p_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt,
1442: p_ghr_cpdf_temp_rec.fegli_court_ord_ind,
1443: p_ghr_cpdf_temp_rec.fegli_benf_desg_ind,
1444: p_ghr_cpdf_temp_rec.fehb_event_code,
1445: p_ghr_cpdf_temp_rec.pareq_last_updated_date,
1446: p_ghr_cpdf_temp_rec.fehb_elect_eff_date
1447: --Bug# 6158983
1440: p_ghr_cpdf_temp_rec.fegli_assg_indicator,
1441: p_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt,
1442: p_ghr_cpdf_temp_rec.fegli_court_ord_ind,
1443: p_ghr_cpdf_temp_rec.fegli_benf_desg_ind,
1444: p_ghr_cpdf_temp_rec.fehb_event_code,
1445: p_ghr_cpdf_temp_rec.pareq_last_updated_date,
1446: p_ghr_cpdf_temp_rec.fehb_elect_eff_date
1447: --Bug# 6158983
1448: );
1441: p_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt,
1442: p_ghr_cpdf_temp_rec.fegli_court_ord_ind,
1443: p_ghr_cpdf_temp_rec.fegli_benf_desg_ind,
1444: p_ghr_cpdf_temp_rec.fehb_event_code,
1445: p_ghr_cpdf_temp_rec.pareq_last_updated_date,
1446: p_ghr_cpdf_temp_rec.fehb_elect_eff_date
1447: --Bug# 6158983
1448: );
1449:
1442: p_ghr_cpdf_temp_rec.fegli_court_ord_ind,
1443: p_ghr_cpdf_temp_rec.fegli_benf_desg_ind,
1444: p_ghr_cpdf_temp_rec.fehb_event_code,
1445: p_ghr_cpdf_temp_rec.pareq_last_updated_date,
1446: p_ghr_cpdf_temp_rec.fehb_elect_eff_date
1447: --Bug# 6158983
1448: );
1449:
1450: COMMIT;
1474: l_temp VARCHAR2(500);
1475:
1476:
1477: --6158983
1478: prev_national_identifier GHR_CPDF_TEMP.to_national_identifier%type := null;
1479: prev_effective_date GHR_CPDF_TEMP.effective_date%type := null;
1480: prev_agency_code GHR_CPDF_TEMP.agency_code%type := null;
1481: eff_seq_no number;
1482: --6158983
1475:
1476:
1477: --6158983
1478: prev_national_identifier GHR_CPDF_TEMP.to_national_identifier%type := null;
1479: prev_effective_date GHR_CPDF_TEMP.effective_date%type := null;
1480: prev_agency_code GHR_CPDF_TEMP.agency_code%type := null;
1481: eff_seq_no number;
1482: --6158983
1483:
1476:
1477: --6158983
1478: prev_national_identifier GHR_CPDF_TEMP.to_national_identifier%type := null;
1479: prev_effective_date GHR_CPDF_TEMP.effective_date%type := null;
1480: prev_agency_code GHR_CPDF_TEMP.agency_code%type := null;
1481: eff_seq_no number;
1482: --6158983
1483:
1484: CURSOR c_cpdf_dynamic(c_session_id NUMBER) IS
1482: --6158983
1483:
1484: CURSOR c_cpdf_dynamic(c_session_id NUMBER) IS
1485: SELECT *
1486: FROM GHR_CPDF_TEMP
1487: WHERE SESSION_ID = c_session_id
1488: AND report_type='DYNAMICS'
1489: ORDER BY agency_code,to_national_identifier,effective_date,pareq_last_updated_date;
1490: --
1604:
1605: END WritetoFile;
1606:
1607: ---------------------------------------------------------------------------------------------
1608: -- This Procedure writes one record from the temporary table GHR_CPDF_TEMP
1609: -- to a PL/SQL table p_tags at a time. This PL/SQL table p_tags is used to write to file.
1610: ---------------------------------------------------------------------------------------------
1611:
1612: PROCEDURE WriteTagValues(p_cpdf_dynamic GHR_CPDF_TEMP%rowtype,p_tags OUT NOCOPY t_tags)
1608: -- This Procedure writes one record from the temporary table GHR_CPDF_TEMP
1609: -- to a PL/SQL table p_tags at a time. This PL/SQL table p_tags is used to write to file.
1610: ---------------------------------------------------------------------------------------------
1611:
1612: PROCEDURE WriteTagValues(p_cpdf_dynamic GHR_CPDF_TEMP%rowtype,p_tags OUT NOCOPY t_tags)
1613: IS
1614: l_count NUMBER;
1615:
1616:
2280: END get_suffix_lname;
2281:
2282:
2283: ---------------------------------------------------------------------------------------------
2284: -- This is the procedure to populate values into the temporary table GHR_CPDF_TEMP
2285: ---------------------------------------------------------------------------------------------
2286: PROCEDURE populate_ghr_cpdf_temp(p_agency IN VARCHAR2
2287: ,p_start_date IN DATE
2288: ,p_end_date IN DATE
2282:
2283: ---------------------------------------------------------------------------------------------
2284: -- This is the procedure to populate values into the temporary table GHR_CPDF_TEMP
2285: ---------------------------------------------------------------------------------------------
2286: PROCEDURE populate_ghr_cpdf_temp(p_agency IN VARCHAR2
2287: ,p_start_date IN DATE
2288: ,p_end_date IN DATE
2289: ,p_count_only IN BOOLEAN ) IS
2290: --
2287: ,p_start_date IN DATE
2288: ,p_end_date IN DATE
2289: ,p_count_only IN BOOLEAN ) IS
2290: --
2291: l_proc VARCHAR2(72) := g_package||'populate_ghr_cpdf_temp';
2292: --
2293: l_info_type VARCHAR2(200) := NULL;
2294: l_api_assignment_id per_assignments.assignment_id%TYPE;
2295: --
2343: -- Bug 706585 has been raised to make sure it gets populated on UPDATE_HR and not UPDATE_HR_COMPLETE
2344: -- otherwise this will not be available to FUTURE_ACTIONS
2345: -- 3) ordering of the records will be done in the report, by agency code then ssn
2346:
2347: l_ghr_cpdf_temp_rec ghr_cpdf_temp%ROWTYPE;
2348: l_ghr_empty_cpdf_temp ghr_cpdf_temp%ROWTYPE;
2349: -- l_ghr_cpdf_cancel_rec ghr_cpdf_temp%ROWTYPE;
2350:
2351: l_ghr_pa_requests_rec ghr_pa_requests%ROWTYPE;
2344: -- otherwise this will not be available to FUTURE_ACTIONS
2345: -- 3) ordering of the records will be done in the report, by agency code then ssn
2346:
2347: l_ghr_cpdf_temp_rec ghr_cpdf_temp%ROWTYPE;
2348: l_ghr_empty_cpdf_temp ghr_cpdf_temp%ROWTYPE;
2349: -- l_ghr_cpdf_cancel_rec ghr_cpdf_temp%ROWTYPE;
2350:
2351: l_ghr_pa_requests_rec ghr_pa_requests%ROWTYPE;
2352: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2345: -- 3) ordering of the records will be done in the report, by agency code then ssn
2346:
2347: l_ghr_cpdf_temp_rec ghr_cpdf_temp%ROWTYPE;
2348: l_ghr_empty_cpdf_temp ghr_cpdf_temp%ROWTYPE;
2349: -- l_ghr_cpdf_cancel_rec ghr_cpdf_temp%ROWTYPE;
2350:
2351: l_ghr_pa_requests_rec ghr_pa_requests%ROWTYPE;
2352: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
2353: l_retained_pay_plan ghr_pa_requests.to_pay_plan%type;
2443: l_scd_rif ghr_pa_request_extra_info.rei_information3%type;
2444: l_scd_retirement ghr_pa_request_extra_info.rei_information8%type;
2445: l_scd_tsp ghr_pa_request_extra_info.rei_information8%type;
2446: l_scd_leave ghr_pa_request_extra_info.rei_information8%type;
2447: l_ehri_id ghr_cpdf_temp.ehri_employee_id%TYPE;
2448: ll_per_ei_data per_people_extra_info%rowtype;
2449: l_last_name per_all_people.last_name%type;
2450: l_suffix ghr_cpdf_temp.prior_name_suffix%type;
2451:
2446: l_scd_leave ghr_pa_request_extra_info.rei_information8%type;
2447: l_ehri_id ghr_cpdf_temp.ehri_employee_id%TYPE;
2448: ll_per_ei_data per_people_extra_info%rowtype;
2449: l_last_name per_all_people.last_name%type;
2450: l_suffix ghr_cpdf_temp.prior_name_suffix%type;
2451:
2452: -- For Dual Actions PRD is becoming null so preserving it using a local variable.
2453: l_pay_rate_determinant ghr_pa_requests.pay_rate_determinant%TYPE;
2454: --
2577: WHEN ghr_pay_calc.pay_calc_message THEN
2578: NULL;
2579: END;
2580:
2581: -- Emptying GHR_CPDF_TEMP_REC... Added for bug# 1375342
2582: l_ghr_cpdf_temp_rec := l_ghr_empty_cpdf_temp;
2583:
2584: --
2585: -- 2.2) Add a cutomer hook to determine whether or not to include in report or not!!!!
2578: NULL;
2579: END;
2580:
2581: -- Emptying GHR_CPDF_TEMP_REC... Added for bug# 1375342
2582: l_ghr_cpdf_temp_rec := l_ghr_empty_cpdf_temp;
2583:
2584: --
2585: -- 2.2) Add a cutomer hook to determine whether or not to include in report or not!!!!
2586: -- This maybe particuarly useful for excluding Non appropriated fund personnel (NAF) as currently
2587: -- we do not hold this infoamtion about a person or position, but apparently DoD hold it
2588: -- in the position kff
2589: --
2590: --
2591: -- 3) Now we have decided to keep this populate the ghr_cpdf_temp record group:
2592: -- First with all the information the PAR table itself and then go and get any more information needed
2593: -- If we are just doing a count, we do not need to do the second bit!
2594: --
2595: -- 3.1) Get all info from PAR table itself
2595: -- 3.1) Get all info from PAR table itself
2596: --
2597: hr_utility.set_location(l_proc||' populate cpdf temp from par' ,50);
2598: --
2599: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
2600: -- Agency Subelement Code
2601: l_ghr_cpdf_temp_rec.to_national_identifier := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
2602: -- SSN
2603: -- SSN corrected
2597: hr_utility.set_location(l_proc||' populate cpdf temp from par' ,50);
2598: --
2599: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
2600: -- Agency Subelement Code
2601: l_ghr_cpdf_temp_rec.to_national_identifier := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
2602: -- SSN
2603: -- SSN corrected
2604: IF (l_ghr_pa_requests_rec.first_noa_code = '002' AND
2605: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '1%') THEN
2607: --Bug# 6458070 added the below cursor to check whether ssn is corrected
2608: for cur_ssn_corr_rec in cur_ssn_corr(l_ghr_pa_requests_rec.altered_pa_request_id,
2609: l_ghr_pa_requests_rec.employee_national_identifier)
2610: loop
2611: l_ghr_cpdf_temp_rec.SSN_CORRECTED := format_ni(cur_ssn_corr_rec.employee_national_identifier);
2612: end loop;
2613: END IF;
2614: --
2615:
2618: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
2619: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '355') OR
2620: (l_ghr_pa_requests_rec.first_noa_code NOT IN ('001', '002', '350', '355')) THEN
2621: IF l_ghr_pa_requests_rec.first_noa_code = '002' THEN
2622: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.second_action_la_code1;
2623: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.second_action_la_code2;
2624: ELSE
2625: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
2626: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
2619: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') <> '355') OR
2620: (l_ghr_pa_requests_rec.first_noa_code NOT IN ('001', '002', '350', '355')) THEN
2621: IF l_ghr_pa_requests_rec.first_noa_code = '002' THEN
2622: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.second_action_la_code1;
2623: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.second_action_la_code2;
2624: ELSE
2625: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
2626: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
2627: END IF;
2621: IF l_ghr_pa_requests_rec.first_noa_code = '002' THEN
2622: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.second_action_la_code1;
2623: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.second_action_la_code2;
2624: ELSE
2625: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
2626: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
2627: END IF;
2628: END IF;
2629:
2622: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.second_action_la_code1;
2623: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.second_action_la_code2;
2624: ELSE
2625: l_ghr_cpdf_temp_rec.first_action_la_code1 := l_ghr_pa_requests_rec.first_action_la_code1;
2626: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
2627: END IF;
2628: END IF;
2629:
2630: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date; -- format in report
2626: l_ghr_cpdf_temp_rec.first_action_la_code2 := l_ghr_pa_requests_rec.first_action_la_code2;
2627: END IF;
2628: END IF;
2629:
2630: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date; -- format in report
2631: l_ghr_cpdf_temp_rec.first_noa_code := format_noac(l_ghr_pa_requests_rec.first_noa_code);
2632: l_ghr_cpdf_temp_rec.second_noa_code := format_noac(l_ghr_pa_requests_rec.second_noa_code);-- Moved here for bug# 1399854
2633:
2634: -- All NOACS need to report details regarding the approval date, authorizer details etc.
2627: END IF;
2628: END IF;
2629:
2630: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date; -- format in report
2631: l_ghr_cpdf_temp_rec.first_noa_code := format_noac(l_ghr_pa_requests_rec.first_noa_code);
2632: l_ghr_cpdf_temp_rec.second_noa_code := format_noac(l_ghr_pa_requests_rec.second_noa_code);-- Moved here for bug# 1399854
2633:
2634: -- All NOACS need to report details regarding the approval date, authorizer details etc.
2635: l_ghr_cpdf_temp_rec.ACTION_APPROVAL_DATE := l_ghr_pa_requests_rec.APPROVAL_DATE;
2628: END IF;
2629:
2630: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date; -- format in report
2631: l_ghr_cpdf_temp_rec.first_noa_code := format_noac(l_ghr_pa_requests_rec.first_noa_code);
2632: l_ghr_cpdf_temp_rec.second_noa_code := format_noac(l_ghr_pa_requests_rec.second_noa_code);-- Moved here for bug# 1399854
2633:
2634: -- All NOACS need to report details regarding the approval date, authorizer details etc.
2635: l_ghr_cpdf_temp_rec.ACTION_APPROVAL_DATE := l_ghr_pa_requests_rec.APPROVAL_DATE;
2636:
2631: l_ghr_cpdf_temp_rec.first_noa_code := format_noac(l_ghr_pa_requests_rec.first_noa_code);
2632: l_ghr_cpdf_temp_rec.second_noa_code := format_noac(l_ghr_pa_requests_rec.second_noa_code);-- Moved here for bug# 1399854
2633:
2634: -- All NOACS need to report details regarding the approval date, authorizer details etc.
2635: l_ghr_cpdf_temp_rec.ACTION_APPROVAL_DATE := l_ghr_pa_requests_rec.APPROVAL_DATE;
2636:
2637: -- 5010844
2638: -- Setting l_approver_id to NULL to find the proper approver's name.
2639: l_approver_id := NULL;
2657: get_suffix_lname(auth_det.last_name,
2658: l_ghr_pa_requests_rec.effective_date,
2659: l_suffix,
2660: l_last_name);
2661: l_ghr_cpdf_temp_rec.ACTION_AUTHR_FAMILY_NAME := l_last_name;
2662: l_ghr_cpdf_temp_rec.ACTION_AUTHR_GIVEN_NAME := auth_det.first_name;
2663: l_ghr_cpdf_temp_rec.ACTION_AUTHR_MIDDLE_NAME := auth_det.middle_names;
2664: l_ghr_cpdf_temp_rec.ACTION_AUTHR_NAME_SUFFIX := l_suffix;
2665: -- End Bug 4648811
2658: l_ghr_pa_requests_rec.effective_date,
2659: l_suffix,
2660: l_last_name);
2661: l_ghr_cpdf_temp_rec.ACTION_AUTHR_FAMILY_NAME := l_last_name;
2662: l_ghr_cpdf_temp_rec.ACTION_AUTHR_GIVEN_NAME := auth_det.first_name;
2663: l_ghr_cpdf_temp_rec.ACTION_AUTHR_MIDDLE_NAME := auth_det.middle_names;
2664: l_ghr_cpdf_temp_rec.ACTION_AUTHR_NAME_SUFFIX := l_suffix;
2665: -- End Bug 4648811
2666:
2659: l_suffix,
2660: l_last_name);
2661: l_ghr_cpdf_temp_rec.ACTION_AUTHR_FAMILY_NAME := l_last_name;
2662: l_ghr_cpdf_temp_rec.ACTION_AUTHR_GIVEN_NAME := auth_det.first_name;
2663: l_ghr_cpdf_temp_rec.ACTION_AUTHR_MIDDLE_NAME := auth_det.middle_names;
2664: l_ghr_cpdf_temp_rec.ACTION_AUTHR_NAME_SUFFIX := l_suffix;
2665: -- End Bug 4648811
2666:
2667:
2660: l_last_name);
2661: l_ghr_cpdf_temp_rec.ACTION_AUTHR_FAMILY_NAME := l_last_name;
2662: l_ghr_cpdf_temp_rec.ACTION_AUTHR_GIVEN_NAME := auth_det.first_name;
2663: l_ghr_cpdf_temp_rec.ACTION_AUTHR_MIDDLE_NAME := auth_det.middle_names;
2664: l_ghr_cpdf_temp_rec.ACTION_AUTHR_NAME_SUFFIX := l_suffix;
2665: -- End Bug 4648811
2666:
2667:
2668: END LOOP;
2666:
2667:
2668: END LOOP;
2669:
2670: l_ghr_cpdf_temp_rec.ACTION_AUTHR_TITLE := l_ghr_pa_requests_rec.sf50_approving_ofcl_work_title;
2671:
2672: -- Restricting Remarks to 2000 characters.
2673: FOR rem_rec IN cur_rem(l_ghr_pa_requests_rec.pa_request_id) LOOP
2674: l_ghr_cpdf_temp_rec.remarks_text := SUBSTR(l_ghr_cpdf_temp_rec.remarks_text||rem_rec.description,1,2000);
2670: l_ghr_cpdf_temp_rec.ACTION_AUTHR_TITLE := l_ghr_pa_requests_rec.sf50_approving_ofcl_work_title;
2671:
2672: -- Restricting Remarks to 2000 characters.
2673: FOR rem_rec IN cur_rem(l_ghr_pa_requests_rec.pa_request_id) LOOP
2674: l_ghr_cpdf_temp_rec.remarks_text := SUBSTR(l_ghr_cpdf_temp_rec.remarks_text||rem_rec.description,1,2000);
2675: IF LENGTH(l_ghr_cpdf_temp_rec.remarks_text) = 2000 THEN
2676: EXIT;
2677: END IF;
2678: END LOOP;
2671:
2672: -- Restricting Remarks to 2000 characters.
2673: FOR rem_rec IN cur_rem(l_ghr_pa_requests_rec.pa_request_id) LOOP
2674: l_ghr_cpdf_temp_rec.remarks_text := SUBSTR(l_ghr_cpdf_temp_rec.remarks_text||rem_rec.description,1,2000);
2675: IF LENGTH(l_ghr_cpdf_temp_rec.remarks_text) = 2000 THEN
2676: EXIT;
2677: END IF;
2678: END LOOP;
2679: --Begin Bug# 5444553
2676: EXIT;
2677: END IF;
2678: END LOOP;
2679: --Begin Bug# 5444553
2680: l_ghr_cpdf_temp_rec.remarks_text := REPLACE(l_ghr_cpdf_temp_rec.remarks_text,fnd_global.local_chr(10),' ');
2681: --End Bug# 5444553
2682:
2683: ---
2684:
2684:
2685: --- EHRI_EMPLOYEE_ID IS TO BE REPORTED FOR ALL THE EMPLOYEES AND FOR ALL RPA's
2686: ---
2687: -- IF Cancellation THEN no more data elements are needed. Bug# 1375323
2688: -- Insert_row in GHR_CPDF_TEMP, and continue in the LOOP for the next PAR row.
2689: --- EHRI_EMPLOYEE_ID IS TO BE REPORTED FOR ALL THE EMPLOYEES AND FOR ALL RPA's
2690: --- esp for 001 action
2691: BEGIN
2692: get_PAR_EI_noac (l_ghr_pa_requests_rec.pa_request_id
2705: -- Added for new EHRI changes Madhuri 21-Jan-2005
2706: ,l_dummy
2707: ,l_dummy
2708: ,l_dummy
2709: ,l_ghr_cpdf_temp_rec.ehri_employee_id
2710: ,l_dummy
2711: ,l_dummy
2712: ,l_dummy
2713: ,l_dummy
2747: END;
2748:
2749: -- Bug 5063301
2750: --Birth Date
2751: l_ghr_cpdf_temp_rec.employee_date_of_birth := l_ghr_pa_requests_rec.employee_date_of_birth; -- format in report
2752: -- End Bug 5063301
2753:
2754: IF l_ghr_pa_requests_rec.first_noa_code = '001' THEN
2755: insert_row(l_ghr_cpdf_temp_rec);
2751: l_ghr_cpdf_temp_rec.employee_date_of_birth := l_ghr_pa_requests_rec.employee_date_of_birth; -- format in report
2752: -- End Bug 5063301
2753:
2754: IF l_ghr_pa_requests_rec.first_noa_code = '001' THEN
2755: insert_row(l_ghr_cpdf_temp_rec);
2756: l_records_found:=TRUE;
2757: GOTO end_par_loop; -- loop for the next one!
2758: END IF;
2759:
2784: -- Bug#2789704 Added Exception Handling
2785: END IF;
2786:
2787: -- Moved POI to this place for bug# 1402287 to not print for Cancellations.
2788: l_ghr_cpdf_temp_rec.personnel_office_id := l_ghr_pa_requests_rec.personnel_office_id;
2789: -- Personnel Office Identifier Code
2790: l_ghr_cpdf_temp_rec.employee_date_of_birth := l_ghr_pa_requests_rec.employee_date_of_birth; -- format in report
2791: --Birth Date
2792: l_ghr_cpdf_temp_rec.FEGLI := l_ghr_pa_requests_rec.FEGLI;
2786:
2787: -- Moved POI to this place for bug# 1402287 to not print for Cancellations.
2788: l_ghr_cpdf_temp_rec.personnel_office_id := l_ghr_pa_requests_rec.personnel_office_id;
2789: -- Personnel Office Identifier Code
2790: l_ghr_cpdf_temp_rec.employee_date_of_birth := l_ghr_pa_requests_rec.employee_date_of_birth; -- format in report
2791: --Birth Date
2792: l_ghr_cpdf_temp_rec.FEGLI := l_ghr_pa_requests_rec.FEGLI;
2793: l_ghr_cpdf_temp_rec.annuitant_indicator := l_ghr_pa_requests_rec.annuitant_indicator;
2794: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
2788: l_ghr_cpdf_temp_rec.personnel_office_id := l_ghr_pa_requests_rec.personnel_office_id;
2789: -- Personnel Office Identifier Code
2790: l_ghr_cpdf_temp_rec.employee_date_of_birth := l_ghr_pa_requests_rec.employee_date_of_birth; -- format in report
2791: --Birth Date
2792: l_ghr_cpdf_temp_rec.FEGLI := l_ghr_pa_requests_rec.FEGLI;
2793: l_ghr_cpdf_temp_rec.annuitant_indicator := l_ghr_pa_requests_rec.annuitant_indicator;
2794: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
2795: l_ghr_cpdf_temp_rec.tenure := l_ghr_pa_requests_rec.tenure;
2796: l_ghr_cpdf_temp_rec.service_comp_date := l_ghr_pa_requests_rec.service_comp_date; -- format in report
2789: -- Personnel Office Identifier Code
2790: l_ghr_cpdf_temp_rec.employee_date_of_birth := l_ghr_pa_requests_rec.employee_date_of_birth; -- format in report
2791: --Birth Date
2792: l_ghr_cpdf_temp_rec.FEGLI := l_ghr_pa_requests_rec.FEGLI;
2793: l_ghr_cpdf_temp_rec.annuitant_indicator := l_ghr_pa_requests_rec.annuitant_indicator;
2794: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
2795: l_ghr_cpdf_temp_rec.tenure := l_ghr_pa_requests_rec.tenure;
2796: l_ghr_cpdf_temp_rec.service_comp_date := l_ghr_pa_requests_rec.service_comp_date; -- format in report
2797: l_ghr_cpdf_temp_rec.retirement_plan := l_ghr_pa_requests_rec.retirement_plan;
2790: l_ghr_cpdf_temp_rec.employee_date_of_birth := l_ghr_pa_requests_rec.employee_date_of_birth; -- format in report
2791: --Birth Date
2792: l_ghr_cpdf_temp_rec.FEGLI := l_ghr_pa_requests_rec.FEGLI;
2793: l_ghr_cpdf_temp_rec.annuitant_indicator := l_ghr_pa_requests_rec.annuitant_indicator;
2794: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
2795: l_ghr_cpdf_temp_rec.tenure := l_ghr_pa_requests_rec.tenure;
2796: l_ghr_cpdf_temp_rec.service_comp_date := l_ghr_pa_requests_rec.service_comp_date; -- format in report
2797: l_ghr_cpdf_temp_rec.retirement_plan := l_ghr_pa_requests_rec.retirement_plan;
2798: -- Retirement System Type Code (retierment plan)
2791: --Birth Date
2792: l_ghr_cpdf_temp_rec.FEGLI := l_ghr_pa_requests_rec.FEGLI;
2793: l_ghr_cpdf_temp_rec.annuitant_indicator := l_ghr_pa_requests_rec.annuitant_indicator;
2794: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
2795: l_ghr_cpdf_temp_rec.tenure := l_ghr_pa_requests_rec.tenure;
2796: l_ghr_cpdf_temp_rec.service_comp_date := l_ghr_pa_requests_rec.service_comp_date; -- format in report
2797: l_ghr_cpdf_temp_rec.retirement_plan := l_ghr_pa_requests_rec.retirement_plan;
2798: -- Retirement System Type Code (retierment plan)
2799:
2792: l_ghr_cpdf_temp_rec.FEGLI := l_ghr_pa_requests_rec.FEGLI;
2793: l_ghr_cpdf_temp_rec.annuitant_indicator := l_ghr_pa_requests_rec.annuitant_indicator;
2794: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
2795: l_ghr_cpdf_temp_rec.tenure := l_ghr_pa_requests_rec.tenure;
2796: l_ghr_cpdf_temp_rec.service_comp_date := l_ghr_pa_requests_rec.service_comp_date; -- format in report
2797: l_ghr_cpdf_temp_rec.retirement_plan := l_ghr_pa_requests_rec.retirement_plan;
2798: -- Retirement System Type Code (retierment plan)
2799:
2800:
2793: l_ghr_cpdf_temp_rec.annuitant_indicator := l_ghr_pa_requests_rec.annuitant_indicator;
2794: l_ghr_cpdf_temp_rec.veterans_preference := l_ghr_pa_requests_rec.veterans_preference;
2795: l_ghr_cpdf_temp_rec.tenure := l_ghr_pa_requests_rec.tenure;
2796: l_ghr_cpdf_temp_rec.service_comp_date := l_ghr_pa_requests_rec.service_comp_date; -- format in report
2797: l_ghr_cpdf_temp_rec.retirement_plan := l_ghr_pa_requests_rec.retirement_plan;
2798: -- Retirement System Type Code (retierment plan)
2799:
2800:
2801: --Start of Bug #6158983
2801: --Start of Bug #6158983
2802: --start of Bug #6522440 adding one more validation of showing the hyp_full_reg_duty_part_emp
2803: -- only for part time employees
2804: if l_ghr_pa_requests_rec.part_time_hours is not null then
2805: if l_ghr_cpdf_temp_rec.retirement_plan in ('E','M','T') then
2806: l_ghr_cpdf_temp_rec.hyp_full_reg_duty_part_emp := 72.00;
2807: else
2808: l_ghr_cpdf_temp_rec.hyp_full_reg_duty_part_emp := 80.00;
2809: end if;
2802: --start of Bug #6522440 adding one more validation of showing the hyp_full_reg_duty_part_emp
2803: -- only for part time employees
2804: if l_ghr_pa_requests_rec.part_time_hours is not null then
2805: if l_ghr_cpdf_temp_rec.retirement_plan in ('E','M','T') then
2806: l_ghr_cpdf_temp_rec.hyp_full_reg_duty_part_emp := 72.00;
2807: else
2808: l_ghr_cpdf_temp_rec.hyp_full_reg_duty_part_emp := 80.00;
2809: end if;
2810: end if;
2804: if l_ghr_pa_requests_rec.part_time_hours is not null then
2805: if l_ghr_cpdf_temp_rec.retirement_plan in ('E','M','T') then
2806: l_ghr_cpdf_temp_rec.hyp_full_reg_duty_part_emp := 72.00;
2807: else
2808: l_ghr_cpdf_temp_rec.hyp_full_reg_duty_part_emp := 80.00;
2809: end if;
2810: end if;
2811:
2812: -- End of Bug #6158983
2813:
2814:
2815:
2816:
2817: l_ghr_cpdf_temp_rec.veterans_status := l_ghr_pa_requests_rec.veterans_status;
2818: l_ghr_cpdf_temp_rec.FLSA_category := l_ghr_pa_requests_rec.FLSA_category;
2819:
2820: IF (l_ghr_pa_requests_rec.VETERANS_PREF_FOR_RIF in ('P','R') ) THEN
2821: l_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF := 'Y';
2814:
2815:
2816:
2817: l_ghr_cpdf_temp_rec.veterans_status := l_ghr_pa_requests_rec.veterans_status;
2818: l_ghr_cpdf_temp_rec.FLSA_category := l_ghr_pa_requests_rec.FLSA_category;
2819:
2820: IF (l_ghr_pa_requests_rec.VETERANS_PREF_FOR_RIF in ('P','R') ) THEN
2821: l_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF := 'Y';
2822: ELSIF (l_ghr_pa_requests_rec.VETERANS_PREF_FOR_RIF = 'N') THEN
2817: l_ghr_cpdf_temp_rec.veterans_status := l_ghr_pa_requests_rec.veterans_status;
2818: l_ghr_cpdf_temp_rec.FLSA_category := l_ghr_pa_requests_rec.FLSA_category;
2819:
2820: IF (l_ghr_pa_requests_rec.VETERANS_PREF_FOR_RIF in ('P','R') ) THEN
2821: l_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF := 'Y';
2822: ELSIF (l_ghr_pa_requests_rec.VETERANS_PREF_FOR_RIF = 'N') THEN
2823: l_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF := 'N';
2824: ELSE
2825: l_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF := 'NA';
2819:
2820: IF (l_ghr_pa_requests_rec.VETERANS_PREF_FOR_RIF in ('P','R') ) THEN
2821: l_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF := 'Y';
2822: ELSIF (l_ghr_pa_requests_rec.VETERANS_PREF_FOR_RIF = 'N') THEN
2823: l_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF := 'N';
2824: ELSE
2825: l_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF := 'NA';
2826: END IF;
2827:
2821: l_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF := 'Y';
2822: ELSIF (l_ghr_pa_requests_rec.VETERANS_PREF_FOR_RIF = 'N') THEN
2823: l_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF := 'N';
2824: ELSE
2825: l_ghr_cpdf_temp_rec.VETERANS_PREF_FOR_RIF := 'NA';
2826: END IF;
2827:
2828: -- APPOINTMENT_NTE_DATE
2829: BEGIN
2830:
2831: get_asg_details( l_ghr_pa_requests_rec.pa_request_id,
2832: l_ghr_pa_requests_rec.person_id,
2833: l_ghr_pa_requests_rec.effective_date,
2834: l_ghr_cpdf_temp_rec.appointment_nte_date);
2835:
2836: EXCEPTION
2837: WHEN OTHERS THEN
2838: l_message_name := 'get_asg_details';
2853: --Bug#5328177 Added the following conditions to report the incentive percentage, amount
2854: -- in the Award percentage(for noac 827) and award amount(for noacs 815,816,825) fields.
2855: IF l_ghr_pa_requests_rec.first_noa_code = '827' OR
2856: l_ghr_pa_requests_rec.second_noa_code = '827' THEN
2857: l_ghr_cpdf_temp_rec.award_percentage := l_ghr_pa_requests_rec.to_total_salary;
2858: ELSIF (l_ghr_pa_requests_rec.first_noa_code IN ('815','816','825') OR
2859: l_ghr_pa_requests_rec.second_noa_code IN ('815','816','825')) AND
2860: l_ghr_pa_requests_rec.award_amount IS NULL THEN
2861: l_ghr_pa_requests_rec.award_amount := l_ghr_pa_requests_rec.to_total_salary;
2876: l_ghr_pa_requests_rec.to_adj_basic_pay := l_ghr_pa_requests_rec.from_adj_basic_pay;
2877:
2878: END IF;
2879:
2880: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.to_pay_plan;
2881: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;
2882: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.to_grade_or_level;
2883: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.to_step_or_rate;
2884: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.to_basic_pay; -- format in report
2877:
2878: END IF;
2879:
2880: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.to_pay_plan;
2881: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;
2882: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.to_grade_or_level;
2883: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.to_step_or_rate;
2884: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.to_basic_pay; -- format in report
2885: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.to_pay_basis;
2878: END IF;
2879:
2880: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.to_pay_plan;
2881: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;
2882: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.to_grade_or_level;
2883: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.to_step_or_rate;
2884: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.to_basic_pay; -- format in report
2885: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.to_pay_basis;
2886: l_ghr_cpdf_temp_rec.to_locality_adj := l_ghr_pa_requests_rec.to_locality_adj;
2879:
2880: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.to_pay_plan;
2881: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;
2882: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.to_grade_or_level;
2883: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.to_step_or_rate;
2884: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.to_basic_pay; -- format in report
2885: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.to_pay_basis;
2886: l_ghr_cpdf_temp_rec.to_locality_adj := l_ghr_pa_requests_rec.to_locality_adj;
2887: l_ghr_cpdf_temp_rec.to_total_salary := l_ghr_pa_requests_rec.to_total_salary; -- format in report
2880: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.to_pay_plan;
2881: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;
2882: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.to_grade_or_level;
2883: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.to_step_or_rate;
2884: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.to_basic_pay; -- format in report
2885: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.to_pay_basis;
2886: l_ghr_cpdf_temp_rec.to_locality_adj := l_ghr_pa_requests_rec.to_locality_adj;
2887: l_ghr_cpdf_temp_rec.to_total_salary := l_ghr_pa_requests_rec.to_total_salary; -- format in report
2888: l_ghr_cpdf_temp_rec.to_adj_basic_pay := l_ghr_pa_requests_rec.to_adj_basic_pay;
2881: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;
2882: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.to_grade_or_level;
2883: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.to_step_or_rate;
2884: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.to_basic_pay; -- format in report
2885: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.to_pay_basis;
2886: l_ghr_cpdf_temp_rec.to_locality_adj := l_ghr_pa_requests_rec.to_locality_adj;
2887: l_ghr_cpdf_temp_rec.to_total_salary := l_ghr_pa_requests_rec.to_total_salary; -- format in report
2888: l_ghr_cpdf_temp_rec.to_adj_basic_pay := l_ghr_pa_requests_rec.to_adj_basic_pay;
2889:
2882: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.to_grade_or_level;
2883: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.to_step_or_rate;
2884: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.to_basic_pay; -- format in report
2885: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.to_pay_basis;
2886: l_ghr_cpdf_temp_rec.to_locality_adj := l_ghr_pa_requests_rec.to_locality_adj;
2887: l_ghr_cpdf_temp_rec.to_total_salary := l_ghr_pa_requests_rec.to_total_salary; -- format in report
2888: l_ghr_cpdf_temp_rec.to_adj_basic_pay := l_ghr_pa_requests_rec.to_adj_basic_pay;
2889:
2890:
2883: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.to_step_or_rate;
2884: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.to_basic_pay; -- format in report
2885: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.to_pay_basis;
2886: l_ghr_cpdf_temp_rec.to_locality_adj := l_ghr_pa_requests_rec.to_locality_adj;
2887: l_ghr_cpdf_temp_rec.to_total_salary := l_ghr_pa_requests_rec.to_total_salary; -- format in report
2888: l_ghr_cpdf_temp_rec.to_adj_basic_pay := l_ghr_pa_requests_rec.to_adj_basic_pay;
2889:
2890:
2891: IF l_noa_family_code <> 'AWARD' THEN
2884: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.to_basic_pay; -- format in report
2885: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.to_pay_basis;
2886: l_ghr_cpdf_temp_rec.to_locality_adj := l_ghr_pa_requests_rec.to_locality_adj;
2887: l_ghr_cpdf_temp_rec.to_total_salary := l_ghr_pa_requests_rec.to_total_salary; -- format in report
2888: l_ghr_cpdf_temp_rec.to_adj_basic_pay := l_ghr_pa_requests_rec.to_adj_basic_pay;
2889:
2890:
2891: IF l_noa_family_code <> 'AWARD' THEN
2892: -- Added following 'IF' according to bug# 1375333
2896: (NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '3%' OR
2897: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%')
2898: )
2899: ) THEN
2900: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;
2901: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;
2902: ELSE
2903: l_ghr_cpdf_temp_rec.to_pay_rate_determinant := NULL;
2904: l_ghr_cpdf_temp_rec.to_occ_code := NULL;
2897: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%')
2898: )
2899: ) THEN
2900: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;
2901: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;
2902: ELSE
2903: l_ghr_cpdf_temp_rec.to_pay_rate_determinant := NULL;
2904: l_ghr_cpdf_temp_rec.to_occ_code := NULL;
2905: --
2899: ) THEN
2900: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;
2901: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;
2902: ELSE
2903: l_ghr_cpdf_temp_rec.to_pay_rate_determinant := NULL;
2904: l_ghr_cpdf_temp_rec.to_occ_code := NULL;
2905: --
2906: l_ghr_cpdf_temp_rec.to_pay_plan := NULL;
2907: l_ghr_cpdf_temp_rec.to_occ_code := NULL;
2900: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;
2901: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.to_occ_code;
2902: ELSE
2903: l_ghr_cpdf_temp_rec.to_pay_rate_determinant := NULL;
2904: l_ghr_cpdf_temp_rec.to_occ_code := NULL;
2905: --
2906: l_ghr_cpdf_temp_rec.to_pay_plan := NULL;
2907: l_ghr_cpdf_temp_rec.to_occ_code := NULL;
2908: l_ghr_cpdf_temp_rec.to_grade_or_level := NULL;
2902: ELSE
2903: l_ghr_cpdf_temp_rec.to_pay_rate_determinant := NULL;
2904: l_ghr_cpdf_temp_rec.to_occ_code := NULL;
2905: --
2906: l_ghr_cpdf_temp_rec.to_pay_plan := NULL;
2907: l_ghr_cpdf_temp_rec.to_occ_code := NULL;
2908: l_ghr_cpdf_temp_rec.to_grade_or_level := NULL;
2909: l_ghr_cpdf_temp_rec.to_step_or_rate := NULL;
2910: l_ghr_cpdf_temp_rec.to_basic_pay := NULL;
2903: l_ghr_cpdf_temp_rec.to_pay_rate_determinant := NULL;
2904: l_ghr_cpdf_temp_rec.to_occ_code := NULL;
2905: --
2906: l_ghr_cpdf_temp_rec.to_pay_plan := NULL;
2907: l_ghr_cpdf_temp_rec.to_occ_code := NULL;
2908: l_ghr_cpdf_temp_rec.to_grade_or_level := NULL;
2909: l_ghr_cpdf_temp_rec.to_step_or_rate := NULL;
2910: l_ghr_cpdf_temp_rec.to_basic_pay := NULL;
2911: l_ghr_cpdf_temp_rec.to_pay_basis := NULL;
2904: l_ghr_cpdf_temp_rec.to_occ_code := NULL;
2905: --
2906: l_ghr_cpdf_temp_rec.to_pay_plan := NULL;
2907: l_ghr_cpdf_temp_rec.to_occ_code := NULL;
2908: l_ghr_cpdf_temp_rec.to_grade_or_level := NULL;
2909: l_ghr_cpdf_temp_rec.to_step_or_rate := NULL;
2910: l_ghr_cpdf_temp_rec.to_basic_pay := NULL;
2911: l_ghr_cpdf_temp_rec.to_pay_basis := NULL;
2912: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2905: --
2906: l_ghr_cpdf_temp_rec.to_pay_plan := NULL;
2907: l_ghr_cpdf_temp_rec.to_occ_code := NULL;
2908: l_ghr_cpdf_temp_rec.to_grade_or_level := NULL;
2909: l_ghr_cpdf_temp_rec.to_step_or_rate := NULL;
2910: l_ghr_cpdf_temp_rec.to_basic_pay := NULL;
2911: l_ghr_cpdf_temp_rec.to_pay_basis := NULL;
2912: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2913: l_ghr_cpdf_temp_rec.to_total_salary := NULL;
2906: l_ghr_cpdf_temp_rec.to_pay_plan := NULL;
2907: l_ghr_cpdf_temp_rec.to_occ_code := NULL;
2908: l_ghr_cpdf_temp_rec.to_grade_or_level := NULL;
2909: l_ghr_cpdf_temp_rec.to_step_or_rate := NULL;
2910: l_ghr_cpdf_temp_rec.to_basic_pay := NULL;
2911: l_ghr_cpdf_temp_rec.to_pay_basis := NULL;
2912: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2913: l_ghr_cpdf_temp_rec.to_total_salary := NULL;
2914: l_ghr_cpdf_temp_rec.to_adj_basic_pay := NULL;
2907: l_ghr_cpdf_temp_rec.to_occ_code := NULL;
2908: l_ghr_cpdf_temp_rec.to_grade_or_level := NULL;
2909: l_ghr_cpdf_temp_rec.to_step_or_rate := NULL;
2910: l_ghr_cpdf_temp_rec.to_basic_pay := NULL;
2911: l_ghr_cpdf_temp_rec.to_pay_basis := NULL;
2912: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2913: l_ghr_cpdf_temp_rec.to_total_salary := NULL;
2914: l_ghr_cpdf_temp_rec.to_adj_basic_pay := NULL;
2915: END IF;
2908: l_ghr_cpdf_temp_rec.to_grade_or_level := NULL;
2909: l_ghr_cpdf_temp_rec.to_step_or_rate := NULL;
2910: l_ghr_cpdf_temp_rec.to_basic_pay := NULL;
2911: l_ghr_cpdf_temp_rec.to_pay_basis := NULL;
2912: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2913: l_ghr_cpdf_temp_rec.to_total_salary := NULL;
2914: l_ghr_cpdf_temp_rec.to_adj_basic_pay := NULL;
2915: END IF;
2916: END IF;
2909: l_ghr_cpdf_temp_rec.to_step_or_rate := NULL;
2910: l_ghr_cpdf_temp_rec.to_basic_pay := NULL;
2911: l_ghr_cpdf_temp_rec.to_pay_basis := NULL;
2912: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2913: l_ghr_cpdf_temp_rec.to_total_salary := NULL;
2914: l_ghr_cpdf_temp_rec.to_adj_basic_pay := NULL;
2915: END IF;
2916: END IF;
2917:
2910: l_ghr_cpdf_temp_rec.to_basic_pay := NULL;
2911: l_ghr_cpdf_temp_rec.to_pay_basis := NULL;
2912: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2913: l_ghr_cpdf_temp_rec.to_total_salary := NULL;
2914: l_ghr_cpdf_temp_rec.to_adj_basic_pay := NULL;
2915: END IF;
2916: END IF;
2917:
2918: -- Added following 'IF' according to bug# 1375333
2924: )
2925: ) THEN
2926:
2927:
2928: l_ghr_cpdf_temp_rec.to_work_schedule := l_ghr_pa_requests_rec.work_schedule;
2929: l_ghr_cpdf_temp_rec.part_time_hours := l_ghr_pa_requests_rec.part_time_hours;
2930: --- commented for bug# 2257630 as duty station code required for all NOA codes except for cancellation action
2931: -- l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);
2932:
2925: ) THEN
2926:
2927:
2928: l_ghr_cpdf_temp_rec.to_work_schedule := l_ghr_pa_requests_rec.work_schedule;
2929: l_ghr_cpdf_temp_rec.part_time_hours := l_ghr_pa_requests_rec.part_time_hours;
2930: --- commented for bug# 2257630 as duty station code required for all NOA codes except for cancellation action
2931: -- l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);
2932:
2933: ELSE
2927:
2928: l_ghr_cpdf_temp_rec.to_work_schedule := l_ghr_pa_requests_rec.work_schedule;
2929: l_ghr_cpdf_temp_rec.part_time_hours := l_ghr_pa_requests_rec.part_time_hours;
2930: --- commented for bug# 2257630 as duty station code required for all NOA codes except for cancellation action
2931: -- l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);
2932:
2933: ELSE
2934: l_ghr_cpdf_temp_rec.to_work_schedule := NULL;
2935: l_ghr_cpdf_temp_rec.part_time_hours := NULL;
2930: --- commented for bug# 2257630 as duty station code required for all NOA codes except for cancellation action
2931: -- l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);
2932:
2933: ELSE
2934: l_ghr_cpdf_temp_rec.to_work_schedule := NULL;
2935: l_ghr_cpdf_temp_rec.part_time_hours := NULL;
2936: END IF;
2937:
2938: --Start of BUG# 6631879
2931: -- l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);
2932:
2933: ELSE
2934: l_ghr_cpdf_temp_rec.to_work_schedule := NULL;
2935: l_ghr_cpdf_temp_rec.part_time_hours := NULL;
2936: END IF;
2937:
2938: --Start of BUG# 6631879
2939:
2936: END IF;
2937:
2938: --Start of BUG# 6631879
2939:
2940: IF l_ghr_cpdf_temp_rec.to_work_schedule in ('I','J') then
2941: l_ghr_cpdf_temp_rec.part_time_hours := NULL;
2942: ELSIF l_ghr_cpdf_temp_rec.to_work_schedule in ('F','G','B') then
2943: IF l_ghr_cpdf_temp_rec.retirement_plan in ('E','M','T') then
2944: l_ghr_cpdf_temp_rec.part_time_hours := 144;
2937:
2938: --Start of BUG# 6631879
2939:
2940: IF l_ghr_cpdf_temp_rec.to_work_schedule in ('I','J') then
2941: l_ghr_cpdf_temp_rec.part_time_hours := NULL;
2942: ELSIF l_ghr_cpdf_temp_rec.to_work_schedule in ('F','G','B') then
2943: IF l_ghr_cpdf_temp_rec.retirement_plan in ('E','M','T') then
2944: l_ghr_cpdf_temp_rec.part_time_hours := 144;
2945: ELSE
2938: --Start of BUG# 6631879
2939:
2940: IF l_ghr_cpdf_temp_rec.to_work_schedule in ('I','J') then
2941: l_ghr_cpdf_temp_rec.part_time_hours := NULL;
2942: ELSIF l_ghr_cpdf_temp_rec.to_work_schedule in ('F','G','B') then
2943: IF l_ghr_cpdf_temp_rec.retirement_plan in ('E','M','T') then
2944: l_ghr_cpdf_temp_rec.part_time_hours := 144;
2945: ELSE
2946: l_ghr_cpdf_temp_rec.part_time_hours := 80;
2939:
2940: IF l_ghr_cpdf_temp_rec.to_work_schedule in ('I','J') then
2941: l_ghr_cpdf_temp_rec.part_time_hours := NULL;
2942: ELSIF l_ghr_cpdf_temp_rec.to_work_schedule in ('F','G','B') then
2943: IF l_ghr_cpdf_temp_rec.retirement_plan in ('E','M','T') then
2944: l_ghr_cpdf_temp_rec.part_time_hours := 144;
2945: ELSE
2946: l_ghr_cpdf_temp_rec.part_time_hours := 80;
2947: END IF;
2940: IF l_ghr_cpdf_temp_rec.to_work_schedule in ('I','J') then
2941: l_ghr_cpdf_temp_rec.part_time_hours := NULL;
2942: ELSIF l_ghr_cpdf_temp_rec.to_work_schedule in ('F','G','B') then
2943: IF l_ghr_cpdf_temp_rec.retirement_plan in ('E','M','T') then
2944: l_ghr_cpdf_temp_rec.part_time_hours := 144;
2945: ELSE
2946: l_ghr_cpdf_temp_rec.part_time_hours := 80;
2947: END IF;
2948: END IF;
2942: ELSIF l_ghr_cpdf_temp_rec.to_work_schedule in ('F','G','B') then
2943: IF l_ghr_cpdf_temp_rec.retirement_plan in ('E','M','T') then
2944: l_ghr_cpdf_temp_rec.part_time_hours := 144;
2945: ELSE
2946: l_ghr_cpdf_temp_rec.part_time_hours := 80;
2947: END IF;
2948: END IF;
2949: --End of BUG# 6631879
2950:
2947: END IF;
2948: END IF;
2949: --End of BUG# 6631879
2950:
2951: l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);
2952: l_ghr_cpdf_temp_rec.position_occupied := l_ghr_pa_requests_rec.position_occupied;
2953: l_ghr_cpdf_temp_rec.supervisory_status := l_ghr_pa_requests_rec.supervisory_status;
2954: -- Supervisory Status
2955: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount; -- format in report
2948: END IF;
2949: --End of BUG# 6631879
2950:
2951: l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);
2952: l_ghr_cpdf_temp_rec.position_occupied := l_ghr_pa_requests_rec.position_occupied;
2953: l_ghr_cpdf_temp_rec.supervisory_status := l_ghr_pa_requests_rec.supervisory_status;
2954: -- Supervisory Status
2955: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount; -- format in report
2956:
2949: --End of BUG# 6631879
2950:
2951: l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);
2952: l_ghr_cpdf_temp_rec.position_occupied := l_ghr_pa_requests_rec.position_occupied;
2953: l_ghr_cpdf_temp_rec.supervisory_status := l_ghr_pa_requests_rec.supervisory_status;
2954: -- Supervisory Status
2955: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount; -- format in report
2956:
2957: -- Added IF for bug# 1375342
2951: l_ghr_cpdf_temp_rec.to_duty_station_code := format_ds(l_ghr_pa_requests_rec.duty_station_code);
2952: l_ghr_cpdf_temp_rec.position_occupied := l_ghr_pa_requests_rec.position_occupied;
2953: l_ghr_cpdf_temp_rec.supervisory_status := l_ghr_pa_requests_rec.supervisory_status;
2954: -- Supervisory Status
2955: l_ghr_cpdf_temp_rec.award_amount := l_ghr_pa_requests_rec.award_amount; -- format in report
2956:
2957: -- Added IF for bug# 1375342
2958: IF NOT ( (l_ghr_pa_requests_rec.first_noa_code='002' and
2959: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('815','816','817','825','826','827',
2970: )
2971: )
2972: THEN
2973:
2974: l_ghr_cpdf_temp_rec.from_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
2975: l_ghr_cpdf_temp_rec.from_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2976: l_ghr_cpdf_temp_rec.from_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
2977: l_ghr_cpdf_temp_rec.from_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
2978: l_ghr_cpdf_temp_rec.from_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
2971: )
2972: THEN
2973:
2974: l_ghr_cpdf_temp_rec.from_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
2975: l_ghr_cpdf_temp_rec.from_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2976: l_ghr_cpdf_temp_rec.from_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
2977: l_ghr_cpdf_temp_rec.from_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
2978: l_ghr_cpdf_temp_rec.from_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
2979: l_ghr_cpdf_temp_rec.from_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
2972: THEN
2973:
2974: l_ghr_cpdf_temp_rec.from_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
2975: l_ghr_cpdf_temp_rec.from_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2976: l_ghr_cpdf_temp_rec.from_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
2977: l_ghr_cpdf_temp_rec.from_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
2978: l_ghr_cpdf_temp_rec.from_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
2979: l_ghr_cpdf_temp_rec.from_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
2980: l_ghr_cpdf_temp_rec.from_total_salary := l_ghr_pa_requests_rec.from_total_salary;
2973:
2974: l_ghr_cpdf_temp_rec.from_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
2975: l_ghr_cpdf_temp_rec.from_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2976: l_ghr_cpdf_temp_rec.from_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
2977: l_ghr_cpdf_temp_rec.from_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
2978: l_ghr_cpdf_temp_rec.from_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
2979: l_ghr_cpdf_temp_rec.from_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
2980: l_ghr_cpdf_temp_rec.from_total_salary := l_ghr_pa_requests_rec.from_total_salary;
2981: l_ghr_cpdf_temp_rec.from_adj_basic_pay := l_ghr_pa_requests_rec.from_adj_basic_pay;
2974: l_ghr_cpdf_temp_rec.from_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
2975: l_ghr_cpdf_temp_rec.from_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2976: l_ghr_cpdf_temp_rec.from_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
2977: l_ghr_cpdf_temp_rec.from_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
2978: l_ghr_cpdf_temp_rec.from_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
2979: l_ghr_cpdf_temp_rec.from_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
2980: l_ghr_cpdf_temp_rec.from_total_salary := l_ghr_pa_requests_rec.from_total_salary;
2981: l_ghr_cpdf_temp_rec.from_adj_basic_pay := l_ghr_pa_requests_rec.from_adj_basic_pay;
2982: END IF;
2975: l_ghr_cpdf_temp_rec.from_occ_code := l_ghr_pa_requests_rec.from_occ_code;
2976: l_ghr_cpdf_temp_rec.from_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
2977: l_ghr_cpdf_temp_rec.from_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
2978: l_ghr_cpdf_temp_rec.from_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
2979: l_ghr_cpdf_temp_rec.from_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
2980: l_ghr_cpdf_temp_rec.from_total_salary := l_ghr_pa_requests_rec.from_total_salary;
2981: l_ghr_cpdf_temp_rec.from_adj_basic_pay := l_ghr_pa_requests_rec.from_adj_basic_pay;
2982: END IF;
2983:
2976: l_ghr_cpdf_temp_rec.from_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
2977: l_ghr_cpdf_temp_rec.from_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
2978: l_ghr_cpdf_temp_rec.from_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
2979: l_ghr_cpdf_temp_rec.from_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
2980: l_ghr_cpdf_temp_rec.from_total_salary := l_ghr_pa_requests_rec.from_total_salary;
2981: l_ghr_cpdf_temp_rec.from_adj_basic_pay := l_ghr_pa_requests_rec.from_adj_basic_pay;
2982: END IF;
2983:
2984: -- NEW EHRI changes need these prior details
2977: l_ghr_cpdf_temp_rec.from_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
2978: l_ghr_cpdf_temp_rec.from_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
2979: l_ghr_cpdf_temp_rec.from_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
2980: l_ghr_cpdf_temp_rec.from_total_salary := l_ghr_pa_requests_rec.from_total_salary;
2981: l_ghr_cpdf_temp_rec.from_adj_basic_pay := l_ghr_pa_requests_rec.from_adj_basic_pay;
2982: END IF;
2983:
2984: -- NEW EHRI changes need these prior details
2985: -- Madhuri
3000: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#')='885') )
3001: THEN
3002: --
3003: IF get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.from_pay_plan)) <> 'FW' THEN
3004: l_ghr_cpdf_temp_rec.from_locality_adj := NVL(l_ghr_pa_requests_rec.from_locality_adj, 0);
3005: ELSE
3006: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3007: END IF;
3008: --
3002: --
3003: IF get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.from_pay_plan)) <> 'FW' THEN
3004: l_ghr_cpdf_temp_rec.from_locality_adj := NVL(l_ghr_pa_requests_rec.from_locality_adj, 0);
3005: ELSE
3006: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3007: END IF;
3008: --
3009: END IF;
3010: ELSE
3007: END IF;
3008: --
3009: END IF;
3010: ELSE
3011: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3012: END IF;
3013:
3014: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
3015: (l_ghr_pa_requests_rec.first_noa_code NOT LIKE '3%' AND
3022: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') NOT LIKE '4%'
3023: )
3024: ) THEN
3025: IF get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.to_pay_plan)) <> 'FW' THEN
3026: l_ghr_cpdf_temp_rec.to_locality_adj := NVL(l_ghr_pa_requests_rec.to_locality_adj, 0);
3027: END IF;
3028: ELSE
3029: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3030: END IF;
3025: IF get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.to_pay_plan)) <> 'FW' THEN
3026: l_ghr_cpdf_temp_rec.to_locality_adj := NVL(l_ghr_pa_requests_rec.to_locality_adj, 0);
3027: END IF;
3028: ELSE
3029: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3030: END IF;
3031: ELSE
3032: -- 4163587 Loc pay is not reported for prior loc pay
3033: -- NO NEED TO MAKE PRIOR LOC PAY ADJ NULL, as we are checking for current DS not prior DS
3030: END IF;
3031: ELSE
3032: -- 4163587 Loc pay is not reported for prior loc pay
3033: -- NO NEED TO MAKE PRIOR LOC PAY ADJ NULL, as we are checking for current DS not prior DS
3034: -- l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3035: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3036: END IF;
3037:
3038: IF NOT (l_ghr_pa_requests_rec.first_noa_code LIKE '3%' OR
3031: ELSE
3032: -- 4163587 Loc pay is not reported for prior loc pay
3033: -- NO NEED TO MAKE PRIOR LOC PAY ADJ NULL, as we are checking for current DS not prior DS
3034: -- l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3035: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3036: END IF;
3037:
3038: IF NOT (l_ghr_pa_requests_rec.first_noa_code LIKE '3%' OR
3039: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
3045: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%'
3046: )
3047: )
3048: THEN -- Issue 20 4257213
3049: l_ghr_cpdf_temp_rec.to_staffing_differential := l_ghr_pa_requests_rec.to_staffing_differential; -- format in report
3050: l_ghr_cpdf_temp_rec.to_supervisory_differential := l_ghr_pa_requests_rec.to_supervisory_differential;-- format in report
3051: l_ghr_cpdf_temp_rec.to_retention_allowance := l_ghr_pa_requests_rec.to_retention_allowance; -- format in report
3052: ELSE
3053: l_ghr_cpdf_temp_rec.to_staffing_differential := NULL;
3046: )
3047: )
3048: THEN -- Issue 20 4257213
3049: l_ghr_cpdf_temp_rec.to_staffing_differential := l_ghr_pa_requests_rec.to_staffing_differential; -- format in report
3050: l_ghr_cpdf_temp_rec.to_supervisory_differential := l_ghr_pa_requests_rec.to_supervisory_differential;-- format in report
3051: l_ghr_cpdf_temp_rec.to_retention_allowance := l_ghr_pa_requests_rec.to_retention_allowance; -- format in report
3052: ELSE
3053: l_ghr_cpdf_temp_rec.to_staffing_differential := NULL;
3054: l_ghr_cpdf_temp_rec.to_supervisory_differential := NULL;
3047: )
3048: THEN -- Issue 20 4257213
3049: l_ghr_cpdf_temp_rec.to_staffing_differential := l_ghr_pa_requests_rec.to_staffing_differential; -- format in report
3050: l_ghr_cpdf_temp_rec.to_supervisory_differential := l_ghr_pa_requests_rec.to_supervisory_differential;-- format in report
3051: l_ghr_cpdf_temp_rec.to_retention_allowance := l_ghr_pa_requests_rec.to_retention_allowance; -- format in report
3052: ELSE
3053: l_ghr_cpdf_temp_rec.to_staffing_differential := NULL;
3054: l_ghr_cpdf_temp_rec.to_supervisory_differential := NULL;
3055: l_ghr_cpdf_temp_rec.to_retention_allowance := NULL;
3049: l_ghr_cpdf_temp_rec.to_staffing_differential := l_ghr_pa_requests_rec.to_staffing_differential; -- format in report
3050: l_ghr_cpdf_temp_rec.to_supervisory_differential := l_ghr_pa_requests_rec.to_supervisory_differential;-- format in report
3051: l_ghr_cpdf_temp_rec.to_retention_allowance := l_ghr_pa_requests_rec.to_retention_allowance; -- format in report
3052: ELSE
3053: l_ghr_cpdf_temp_rec.to_staffing_differential := NULL;
3054: l_ghr_cpdf_temp_rec.to_supervisory_differential := NULL;
3055: l_ghr_cpdf_temp_rec.to_retention_allowance := NULL;
3056: END IF;
3057:
3050: l_ghr_cpdf_temp_rec.to_supervisory_differential := l_ghr_pa_requests_rec.to_supervisory_differential;-- format in report
3051: l_ghr_cpdf_temp_rec.to_retention_allowance := l_ghr_pa_requests_rec.to_retention_allowance; -- format in report
3052: ELSE
3053: l_ghr_cpdf_temp_rec.to_staffing_differential := NULL;
3054: l_ghr_cpdf_temp_rec.to_supervisory_differential := NULL;
3055: l_ghr_cpdf_temp_rec.to_retention_allowance := NULL;
3056: END IF;
3057:
3058: IF l_noa_family_code IN ('AWARD', 'OTHER_PAY','GHR_INCENTIVE') THEN -- Bug# 1400486 --GHR_INCENTIVE added for bug # 5328177
3051: l_ghr_cpdf_temp_rec.to_retention_allowance := l_ghr_pa_requests_rec.to_retention_allowance; -- format in report
3052: ELSE
3053: l_ghr_cpdf_temp_rec.to_staffing_differential := NULL;
3054: l_ghr_cpdf_temp_rec.to_supervisory_differential := NULL;
3055: l_ghr_cpdf_temp_rec.to_retention_allowance := NULL;
3056: END IF;
3057:
3058: IF l_noa_family_code IN ('AWARD', 'OTHER_PAY','GHR_INCENTIVE') THEN -- Bug# 1400486 --GHR_INCENTIVE added for bug # 5328177
3059: IF l_ghr_pa_requests_rec.first_noa_code IN ('818', '819') OR
3058: IF l_noa_family_code IN ('AWARD', 'OTHER_PAY','GHR_INCENTIVE') THEN -- Bug# 1400486 --GHR_INCENTIVE added for bug # 5328177
3059: IF l_ghr_pa_requests_rec.first_noa_code IN ('818', '819') OR
3060: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
3061: l_ghr_pa_requests_rec.second_noa_code IN ('818', '819')) THEN
3062: IF l_ghr_cpdf_temp_rec.award_amount IS NULL THEN
3063: -- Bug# 1494916. By ENUNEZ. From 10.7 Dec2000 Patch release
3064: IF l_ghr_pa_requests_rec.first_noa_code = '818' OR
3065: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
3066: l_ghr_pa_requests_rec.second_noa_code = '818') THEN
3069: ghr_api.retrieve_element_entry_value (p_element_name => 'AUO'
3070: ,p_input_value_name => 'Amount'
3071: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
3072: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
3073: ,p_value => l_ghr_cpdf_temp_rec.award_amount
3074: ,p_multiple_error_flag => l_multi_error_flag);
3075: EXCEPTION
3076: WHEN OTHERS THEN
3077: l_message_name := 'retrieve_element_entry_value';
3094: ghr_api.retrieve_element_entry_value (p_element_name => 'Availability Pay'
3095: ,p_input_value_name => 'Amount'
3096: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
3097: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
3098: ,p_value => l_ghr_cpdf_temp_rec.award_amount
3099: ,p_multiple_error_flag => l_multi_error_flag);
3100: EXCEPTION
3101: WHEN OTHERS THEN
3102: l_message_name := 'retrieve_element_entry_value';
3115: -- Bug#2789704 Added Exception Handling
3116: END IF;
3117: END IF;
3118: ELSE
3119: IF l_ghr_cpdf_temp_rec.to_supervisory_differential IS NULL THEN
3120: -- Bug#2789704 Added Exception Handling
3121: BEGIN
3122: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
3123: ,p_input_value_name => 'Amount'
3122: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
3123: ,p_input_value_name => 'Amount'
3124: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
3125: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
3126: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential
3127: ,p_multiple_error_flag => l_multi_error_flag);
3128: EXCEPTION
3129: WHEN OTHERS THEN
3130: l_message_name := 'retrieve_element_entry_value';
3142: END;
3143: -- Bug#2789704 Added Exception Handling
3144:
3145: END IF;
3146: IF l_ghr_cpdf_temp_rec.to_retention_allowance IS NULL THEN
3147: -- Bug#2789704 Added Exception Handling
3148: BEGIN
3149: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
3150: ,p_input_value_name => 'Amount'
3149: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
3150: ,p_input_value_name => 'Amount'
3151: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
3152: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
3153: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance
3154: ,p_multiple_error_flag => l_multi_error_flag);
3155: EXCEPTION
3156: WHEN OTHERS THEN
3157: l_message_name := 'retrieve_element_entry_value';
3174:
3175: -- Sundar Changes for education
3176: ghr_api.return_education_details(p_person_id => l_ghr_pa_requests_rec.person_id,
3177: p_effective_date => l_ghr_pa_requests_rec.effective_date,
3178: p_education_level => l_ghr_cpdf_temp_rec.education_level,
3179: p_academic_discipline => l_ghr_cpdf_temp_rec.academic_discipline,
3180: p_year_degree_attained => l_ghr_cpdf_temp_rec.year_degree_attained);
3181: -- End Sundar changes for education Commented below code
3182:
3175: -- Sundar Changes for education
3176: ghr_api.return_education_details(p_person_id => l_ghr_pa_requests_rec.person_id,
3177: p_effective_date => l_ghr_pa_requests_rec.effective_date,
3178: p_education_level => l_ghr_cpdf_temp_rec.education_level,
3179: p_academic_discipline => l_ghr_cpdf_temp_rec.academic_discipline,
3180: p_year_degree_attained => l_ghr_cpdf_temp_rec.year_degree_attained);
3181: -- End Sundar changes for education Commented below code
3182:
3183: -- Not worth getting any more detials if only counting!
3176: ghr_api.return_education_details(p_person_id => l_ghr_pa_requests_rec.person_id,
3177: p_effective_date => l_ghr_pa_requests_rec.effective_date,
3178: p_education_level => l_ghr_cpdf_temp_rec.education_level,
3179: p_academic_discipline => l_ghr_cpdf_temp_rec.academic_discipline,
3180: p_year_degree_attained => l_ghr_cpdf_temp_rec.year_degree_attained);
3181: -- End Sundar changes for education Commented below code
3182:
3183: -- Not worth getting any more detials if only counting!
3184: -- IF not p_count_only THEN
3191: BEGIN
3192: get_org_comp (NVL(l_ghr_pa_requests_rec.to_position_id
3193: ,l_ghr_pa_requests_rec.from_position_id)
3194: ,l_ghr_pa_requests_rec.effective_date
3195: ,l_ghr_cpdf_temp_rec.organizational_component);
3196: -- Organizational Component Code
3197: EXCEPTION
3198: WHEN OTHERS THEN
3199: l_message_name := 'get_org_comp';
3213: BEGIN
3214: get_appr_code(NVL(l_ghr_pa_requests_rec.to_position_id
3215: ,l_ghr_pa_requests_rec.from_position_id)
3216: ,l_ghr_pa_requests_rec.effective_date
3217: ,l_ghr_cpdf_temp_rec.APPROPRIATION_CODE);
3218: -- Organizational Component Code
3219: EXCEPTION
3220: WHEN OTHERS THEN
3221: l_message_name := 'get_appr_code';
3237: -- Bug#2789704 Added Exception Handling
3238: BEGIN
3239: get_sex (l_ghr_pa_requests_rec.person_id
3240: ,l_ghr_pa_requests_rec.effective_date
3241: ,l_ghr_cpdf_temp_rec.sex);
3242: EXCEPTION
3243: WHEN OTHERS THEN
3244: l_message_name := 'get_sex';
3245: l_log_text := 'Error in fetching SEX for pa_request_id: '||
3261: -- Bug#2789704 Added Exception Handling
3262: BEGIN
3263: get_per_sit_perf_appraisal(l_ghr_pa_requests_rec.person_id
3264: ,l_ghr_pa_requests_rec.effective_date
3265: ,l_ghr_cpdf_temp_rec.rating_of_record_level
3266: ,l_ghr_cpdf_temp_rec.rating_of_record_pattern
3267: ,l_ghr_cpdf_temp_rec.rating_of_record_period_ends
3268: ,l_ghr_cpdf_temp_rec.rating_of_record_period_starts); -- format in report
3269: EXCEPTION
3262: BEGIN
3263: get_per_sit_perf_appraisal(l_ghr_pa_requests_rec.person_id
3264: ,l_ghr_pa_requests_rec.effective_date
3265: ,l_ghr_cpdf_temp_rec.rating_of_record_level
3266: ,l_ghr_cpdf_temp_rec.rating_of_record_pattern
3267: ,l_ghr_cpdf_temp_rec.rating_of_record_period_ends
3268: ,l_ghr_cpdf_temp_rec.rating_of_record_period_starts); -- format in report
3269: EXCEPTION
3270: WHEN OTHERS THEN
3263: get_per_sit_perf_appraisal(l_ghr_pa_requests_rec.person_id
3264: ,l_ghr_pa_requests_rec.effective_date
3265: ,l_ghr_cpdf_temp_rec.rating_of_record_level
3266: ,l_ghr_cpdf_temp_rec.rating_of_record_pattern
3267: ,l_ghr_cpdf_temp_rec.rating_of_record_period_ends
3268: ,l_ghr_cpdf_temp_rec.rating_of_record_period_starts); -- format in report
3269: EXCEPTION
3270: WHEN OTHERS THEN
3271: l_message_name := 'get_per_sit_perf_apprisal';
3264: ,l_ghr_pa_requests_rec.effective_date
3265: ,l_ghr_cpdf_temp_rec.rating_of_record_level
3266: ,l_ghr_cpdf_temp_rec.rating_of_record_pattern
3267: ,l_ghr_cpdf_temp_rec.rating_of_record_period_ends
3268: ,l_ghr_cpdf_temp_rec.rating_of_record_period_starts); -- format in report
3269: EXCEPTION
3270: WHEN OTHERS THEN
3271: l_message_name := 'get_per_sit_perf_apprisal';
3272: l_log_text := 'Error in fetching Performance Apprisal details for pa_request_id: '||
3292: ,l_ghr_pa_requests_rec.second_noa_id
3293: ,l_ghr_pa_requests_rec.noa_family_code
3294: ,l_ghr_pa_requests_rec.person_id
3295: ,l_ghr_pa_requests_rec.effective_date
3296: ,l_ghr_cpdf_temp_rec.creditable_military_service -- no format assumed yymm?
3297: ,l_ghr_cpdf_temp_rec.frozen_service -- no format assumed yymm?
3298: ,l_ghr_cpdf_temp_rec.from_retirement_coverage -- previous retirement coverage
3299: ,l_ghr_cpdf_temp_rec.race_national_origin
3300: ,l_ghr_cpdf_temp_rec.handicap_code
3293: ,l_ghr_pa_requests_rec.noa_family_code
3294: ,l_ghr_pa_requests_rec.person_id
3295: ,l_ghr_pa_requests_rec.effective_date
3296: ,l_ghr_cpdf_temp_rec.creditable_military_service -- no format assumed yymm?
3297: ,l_ghr_cpdf_temp_rec.frozen_service -- no format assumed yymm?
3298: ,l_ghr_cpdf_temp_rec.from_retirement_coverage -- previous retirement coverage
3299: ,l_ghr_cpdf_temp_rec.race_national_origin
3300: ,l_ghr_cpdf_temp_rec.handicap_code
3301: ,l_ghr_cpdf_temp_rec.individual_group_award -- format in report
3294: ,l_ghr_pa_requests_rec.person_id
3295: ,l_ghr_pa_requests_rec.effective_date
3296: ,l_ghr_cpdf_temp_rec.creditable_military_service -- no format assumed yymm?
3297: ,l_ghr_cpdf_temp_rec.frozen_service -- no format assumed yymm?
3298: ,l_ghr_cpdf_temp_rec.from_retirement_coverage -- previous retirement coverage
3299: ,l_ghr_cpdf_temp_rec.race_national_origin
3300: ,l_ghr_cpdf_temp_rec.handicap_code
3301: ,l_ghr_cpdf_temp_rec.individual_group_award -- format in report
3302: ,l_ghr_cpdf_temp_rec.benefit_amount -- format in report
3295: ,l_ghr_pa_requests_rec.effective_date
3296: ,l_ghr_cpdf_temp_rec.creditable_military_service -- no format assumed yymm?
3297: ,l_ghr_cpdf_temp_rec.frozen_service -- no format assumed yymm?
3298: ,l_ghr_cpdf_temp_rec.from_retirement_coverage -- previous retirement coverage
3299: ,l_ghr_cpdf_temp_rec.race_national_origin
3300: ,l_ghr_cpdf_temp_rec.handicap_code
3301: ,l_ghr_cpdf_temp_rec.individual_group_award -- format in report
3302: ,l_ghr_cpdf_temp_rec.benefit_amount -- format in report
3303: -- Added for new EHRI changes Madhuri 21-Jan-2005
3296: ,l_ghr_cpdf_temp_rec.creditable_military_service -- no format assumed yymm?
3297: ,l_ghr_cpdf_temp_rec.frozen_service -- no format assumed yymm?
3298: ,l_ghr_cpdf_temp_rec.from_retirement_coverage -- previous retirement coverage
3299: ,l_ghr_cpdf_temp_rec.race_national_origin
3300: ,l_ghr_cpdf_temp_rec.handicap_code
3301: ,l_ghr_cpdf_temp_rec.individual_group_award -- format in report
3302: ,l_ghr_cpdf_temp_rec.benefit_amount -- format in report
3303: -- Added for new EHRI changes Madhuri 21-Jan-2005
3304: ,l_ghr_cpdf_temp_rec.leave_scd
3297: ,l_ghr_cpdf_temp_rec.frozen_service -- no format assumed yymm?
3298: ,l_ghr_cpdf_temp_rec.from_retirement_coverage -- previous retirement coverage
3299: ,l_ghr_cpdf_temp_rec.race_national_origin
3300: ,l_ghr_cpdf_temp_rec.handicap_code
3301: ,l_ghr_cpdf_temp_rec.individual_group_award -- format in report
3302: ,l_ghr_cpdf_temp_rec.benefit_amount -- format in report
3303: -- Added for new EHRI changes Madhuri 21-Jan-2005
3304: ,l_ghr_cpdf_temp_rec.leave_scd
3305: ,l_ghr_cpdf_temp_rec.scd_ses
3298: ,l_ghr_cpdf_temp_rec.from_retirement_coverage -- previous retirement coverage
3299: ,l_ghr_cpdf_temp_rec.race_national_origin
3300: ,l_ghr_cpdf_temp_rec.handicap_code
3301: ,l_ghr_cpdf_temp_rec.individual_group_award -- format in report
3302: ,l_ghr_cpdf_temp_rec.benefit_amount -- format in report
3303: -- Added for new EHRI changes Madhuri 21-Jan-2005
3304: ,l_ghr_cpdf_temp_rec.leave_scd
3305: ,l_ghr_cpdf_temp_rec.scd_ses
3306: ,l_ghr_cpdf_temp_rec.scd_spcl_retire
3300: ,l_ghr_cpdf_temp_rec.handicap_code
3301: ,l_ghr_cpdf_temp_rec.individual_group_award -- format in report
3302: ,l_ghr_cpdf_temp_rec.benefit_amount -- format in report
3303: -- Added for new EHRI changes Madhuri 21-Jan-2005
3304: ,l_ghr_cpdf_temp_rec.leave_scd
3305: ,l_ghr_cpdf_temp_rec.scd_ses
3306: ,l_ghr_cpdf_temp_rec.scd_spcl_retire
3307: ,l_ghr_cpdf_temp_rec.ehri_employee_id
3308: ,l_ghr_cpdf_temp_rec.tsp_scd
3301: ,l_ghr_cpdf_temp_rec.individual_group_award -- format in report
3302: ,l_ghr_cpdf_temp_rec.benefit_amount -- format in report
3303: -- Added for new EHRI changes Madhuri 21-Jan-2005
3304: ,l_ghr_cpdf_temp_rec.leave_scd
3305: ,l_ghr_cpdf_temp_rec.scd_ses
3306: ,l_ghr_cpdf_temp_rec.scd_spcl_retire
3307: ,l_ghr_cpdf_temp_rec.ehri_employee_id
3308: ,l_ghr_cpdf_temp_rec.tsp_scd
3309: ,l_ghr_cpdf_temp_rec.scd_rif
3302: ,l_ghr_cpdf_temp_rec.benefit_amount -- format in report
3303: -- Added for new EHRI changes Madhuri 21-Jan-2005
3304: ,l_ghr_cpdf_temp_rec.leave_scd
3305: ,l_ghr_cpdf_temp_rec.scd_ses
3306: ,l_ghr_cpdf_temp_rec.scd_spcl_retire
3307: ,l_ghr_cpdf_temp_rec.ehri_employee_id
3308: ,l_ghr_cpdf_temp_rec.tsp_scd
3309: ,l_ghr_cpdf_temp_rec.scd_rif
3310: ,l_ghr_cpdf_temp_rec.scd_retirement
3303: -- Added for new EHRI changes Madhuri 21-Jan-2005
3304: ,l_ghr_cpdf_temp_rec.leave_scd
3305: ,l_ghr_cpdf_temp_rec.scd_ses
3306: ,l_ghr_cpdf_temp_rec.scd_spcl_retire
3307: ,l_ghr_cpdf_temp_rec.ehri_employee_id
3308: ,l_ghr_cpdf_temp_rec.tsp_scd
3309: ,l_ghr_cpdf_temp_rec.scd_rif
3310: ,l_ghr_cpdf_temp_rec.scd_retirement
3311: ,l_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD
3304: ,l_ghr_cpdf_temp_rec.leave_scd
3305: ,l_ghr_cpdf_temp_rec.scd_ses
3306: ,l_ghr_cpdf_temp_rec.scd_spcl_retire
3307: ,l_ghr_cpdf_temp_rec.ehri_employee_id
3308: ,l_ghr_cpdf_temp_rec.tsp_scd
3309: ,l_ghr_cpdf_temp_rec.scd_rif
3310: ,l_ghr_cpdf_temp_rec.scd_retirement
3311: ,l_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD
3312: ,l_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD
3305: ,l_ghr_cpdf_temp_rec.scd_ses
3306: ,l_ghr_cpdf_temp_rec.scd_spcl_retire
3307: ,l_ghr_cpdf_temp_rec.ehri_employee_id
3308: ,l_ghr_cpdf_temp_rec.tsp_scd
3309: ,l_ghr_cpdf_temp_rec.scd_rif
3310: ,l_ghr_cpdf_temp_rec.scd_retirement
3311: ,l_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD
3312: ,l_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD
3313: ,l_ghr_cpdf_temp_rec.AGENCY_DATA1
3306: ,l_ghr_cpdf_temp_rec.scd_spcl_retire
3307: ,l_ghr_cpdf_temp_rec.ehri_employee_id
3308: ,l_ghr_cpdf_temp_rec.tsp_scd
3309: ,l_ghr_cpdf_temp_rec.scd_rif
3310: ,l_ghr_cpdf_temp_rec.scd_retirement
3311: ,l_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD
3312: ,l_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD
3313: ,l_ghr_cpdf_temp_rec.AGENCY_DATA1
3314: ,l_ghr_cpdf_temp_rec.AGENCY_DATA2
3307: ,l_ghr_cpdf_temp_rec.ehri_employee_id
3308: ,l_ghr_cpdf_temp_rec.tsp_scd
3309: ,l_ghr_cpdf_temp_rec.scd_rif
3310: ,l_ghr_cpdf_temp_rec.scd_retirement
3311: ,l_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD
3312: ,l_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD
3313: ,l_ghr_cpdf_temp_rec.AGENCY_DATA1
3314: ,l_ghr_cpdf_temp_rec.AGENCY_DATA2
3315: ,l_ghr_cpdf_temp_rec.AGENCY_DATA3
3308: ,l_ghr_cpdf_temp_rec.tsp_scd
3309: ,l_ghr_cpdf_temp_rec.scd_rif
3310: ,l_ghr_cpdf_temp_rec.scd_retirement
3311: ,l_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD
3312: ,l_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD
3313: ,l_ghr_cpdf_temp_rec.AGENCY_DATA1
3314: ,l_ghr_cpdf_temp_rec.AGENCY_DATA2
3315: ,l_ghr_cpdf_temp_rec.AGENCY_DATA3
3316: ,l_ghr_cpdf_temp_rec.AGENCY_DATA4
3309: ,l_ghr_cpdf_temp_rec.scd_rif
3310: ,l_ghr_cpdf_temp_rec.scd_retirement
3311: ,l_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD
3312: ,l_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD
3313: ,l_ghr_cpdf_temp_rec.AGENCY_DATA1
3314: ,l_ghr_cpdf_temp_rec.AGENCY_DATA2
3315: ,l_ghr_cpdf_temp_rec.AGENCY_DATA3
3316: ,l_ghr_cpdf_temp_rec.AGENCY_DATA4
3317: ,l_ghr_cpdf_temp_rec.AGENCY_DATA5
3310: ,l_ghr_cpdf_temp_rec.scd_retirement
3311: ,l_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD
3312: ,l_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD
3313: ,l_ghr_cpdf_temp_rec.AGENCY_DATA1
3314: ,l_ghr_cpdf_temp_rec.AGENCY_DATA2
3315: ,l_ghr_cpdf_temp_rec.AGENCY_DATA3
3316: ,l_ghr_cpdf_temp_rec.AGENCY_DATA4
3317: ,l_ghr_cpdf_temp_rec.AGENCY_DATA5
3318: ,l_ghr_cpdf_temp_rec.race_ethnic_info
3311: ,l_ghr_cpdf_temp_rec.AGENCY_USE_CODE_FIELD
3312: ,l_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD
3313: ,l_ghr_cpdf_temp_rec.AGENCY_DATA1
3314: ,l_ghr_cpdf_temp_rec.AGENCY_DATA2
3315: ,l_ghr_cpdf_temp_rec.AGENCY_DATA3
3316: ,l_ghr_cpdf_temp_rec.AGENCY_DATA4
3317: ,l_ghr_cpdf_temp_rec.AGENCY_DATA5
3318: ,l_ghr_cpdf_temp_rec.race_ethnic_info
3319: ,l_ghr_cpdf_temp_rec.world_citizenship
3312: ,l_ghr_cpdf_temp_rec.AGENCY_USE_TEXT_FIELD
3313: ,l_ghr_cpdf_temp_rec.AGENCY_DATA1
3314: ,l_ghr_cpdf_temp_rec.AGENCY_DATA2
3315: ,l_ghr_cpdf_temp_rec.AGENCY_DATA3
3316: ,l_ghr_cpdf_temp_rec.AGENCY_DATA4
3317: ,l_ghr_cpdf_temp_rec.AGENCY_DATA5
3318: ,l_ghr_cpdf_temp_rec.race_ethnic_info
3319: ,l_ghr_cpdf_temp_rec.world_citizenship
3320: ,l_ghr_cpdf_temp_rec.SPECIAL_POPULATION_CODE -- 6312144 RPA - EIT Benefits related modifications
3313: ,l_ghr_cpdf_temp_rec.AGENCY_DATA1
3314: ,l_ghr_cpdf_temp_rec.AGENCY_DATA2
3315: ,l_ghr_cpdf_temp_rec.AGENCY_DATA3
3316: ,l_ghr_cpdf_temp_rec.AGENCY_DATA4
3317: ,l_ghr_cpdf_temp_rec.AGENCY_DATA5
3318: ,l_ghr_cpdf_temp_rec.race_ethnic_info
3319: ,l_ghr_cpdf_temp_rec.world_citizenship
3320: ,l_ghr_cpdf_temp_rec.SPECIAL_POPULATION_CODE -- 6312144 RPA - EIT Benefits related modifications
3321: ,l_ghr_cpdf_temp_rec.CSRS_EXC_APPTS
3314: ,l_ghr_cpdf_temp_rec.AGENCY_DATA2
3315: ,l_ghr_cpdf_temp_rec.AGENCY_DATA3
3316: ,l_ghr_cpdf_temp_rec.AGENCY_DATA4
3317: ,l_ghr_cpdf_temp_rec.AGENCY_DATA5
3318: ,l_ghr_cpdf_temp_rec.race_ethnic_info
3319: ,l_ghr_cpdf_temp_rec.world_citizenship
3320: ,l_ghr_cpdf_temp_rec.SPECIAL_POPULATION_CODE -- 6312144 RPA - EIT Benefits related modifications
3321: ,l_ghr_cpdf_temp_rec.CSRS_EXC_APPTS
3322: ,l_ghr_cpdf_temp_rec.FERS_EXC_APPTS
3315: ,l_ghr_cpdf_temp_rec.AGENCY_DATA3
3316: ,l_ghr_cpdf_temp_rec.AGENCY_DATA4
3317: ,l_ghr_cpdf_temp_rec.AGENCY_DATA5
3318: ,l_ghr_cpdf_temp_rec.race_ethnic_info
3319: ,l_ghr_cpdf_temp_rec.world_citizenship
3320: ,l_ghr_cpdf_temp_rec.SPECIAL_POPULATION_CODE -- 6312144 RPA - EIT Benefits related modifications
3321: ,l_ghr_cpdf_temp_rec.CSRS_EXC_APPTS
3322: ,l_ghr_cpdf_temp_rec.FERS_EXC_APPTS
3323: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND1
3316: ,l_ghr_cpdf_temp_rec.AGENCY_DATA4
3317: ,l_ghr_cpdf_temp_rec.AGENCY_DATA5
3318: ,l_ghr_cpdf_temp_rec.race_ethnic_info
3319: ,l_ghr_cpdf_temp_rec.world_citizenship
3320: ,l_ghr_cpdf_temp_rec.SPECIAL_POPULATION_CODE -- 6312144 RPA - EIT Benefits related modifications
3321: ,l_ghr_cpdf_temp_rec.CSRS_EXC_APPTS
3322: ,l_ghr_cpdf_temp_rec.FERS_EXC_APPTS
3323: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND1
3324: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND2
3317: ,l_ghr_cpdf_temp_rec.AGENCY_DATA5
3318: ,l_ghr_cpdf_temp_rec.race_ethnic_info
3319: ,l_ghr_cpdf_temp_rec.world_citizenship
3320: ,l_ghr_cpdf_temp_rec.SPECIAL_POPULATION_CODE -- 6312144 RPA - EIT Benefits related modifications
3321: ,l_ghr_cpdf_temp_rec.CSRS_EXC_APPTS
3322: ,l_ghr_cpdf_temp_rec.FERS_EXC_APPTS
3323: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND1
3324: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND2
3325: ,l_ghr_cpdf_temp_rec.fegli_assg_indicator
3318: ,l_ghr_cpdf_temp_rec.race_ethnic_info
3319: ,l_ghr_cpdf_temp_rec.world_citizenship
3320: ,l_ghr_cpdf_temp_rec.SPECIAL_POPULATION_CODE -- 6312144 RPA - EIT Benefits related modifications
3321: ,l_ghr_cpdf_temp_rec.CSRS_EXC_APPTS
3322: ,l_ghr_cpdf_temp_rec.FERS_EXC_APPTS
3323: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND1
3324: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND2
3325: ,l_ghr_cpdf_temp_rec.fegli_assg_indicator
3326: ,l_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt
3319: ,l_ghr_cpdf_temp_rec.world_citizenship
3320: ,l_ghr_cpdf_temp_rec.SPECIAL_POPULATION_CODE -- 6312144 RPA - EIT Benefits related modifications
3321: ,l_ghr_cpdf_temp_rec.CSRS_EXC_APPTS
3322: ,l_ghr_cpdf_temp_rec.FERS_EXC_APPTS
3323: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND1
3324: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND2
3325: ,l_ghr_cpdf_temp_rec.fegli_assg_indicator
3326: ,l_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt
3327: ,l_ghr_cpdf_temp_rec.fegli_court_ord_ind
3320: ,l_ghr_cpdf_temp_rec.SPECIAL_POPULATION_CODE -- 6312144 RPA - EIT Benefits related modifications
3321: ,l_ghr_cpdf_temp_rec.CSRS_EXC_APPTS
3322: ,l_ghr_cpdf_temp_rec.FERS_EXC_APPTS
3323: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND1
3324: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND2
3325: ,l_ghr_cpdf_temp_rec.fegli_assg_indicator
3326: ,l_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt
3327: ,l_ghr_cpdf_temp_rec.fegli_court_ord_ind
3328: ,l_ghr_cpdf_temp_rec.fegli_benf_desg_ind
3321: ,l_ghr_cpdf_temp_rec.CSRS_EXC_APPTS
3322: ,l_ghr_cpdf_temp_rec.FERS_EXC_APPTS
3323: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND1
3324: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND2
3325: ,l_ghr_cpdf_temp_rec.fegli_assg_indicator
3326: ,l_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt
3327: ,l_ghr_cpdf_temp_rec.fegli_court_ord_ind
3328: ,l_ghr_cpdf_temp_rec.fegli_benf_desg_ind
3329: ,l_ghr_cpdf_temp_rec.fehb_event_code ); -- Bug 4724337 Race or National Origin changes
3322: ,l_ghr_cpdf_temp_rec.FERS_EXC_APPTS
3323: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND1
3324: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND2
3325: ,l_ghr_cpdf_temp_rec.fegli_assg_indicator
3326: ,l_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt
3327: ,l_ghr_cpdf_temp_rec.fegli_court_ord_ind
3328: ,l_ghr_cpdf_temp_rec.fegli_benf_desg_ind
3329: ,l_ghr_cpdf_temp_rec.fehb_event_code ); -- Bug 4724337 Race or National Origin changes
3330: --Bug#6158983 World Citizenship
3323: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND1
3324: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND2
3325: ,l_ghr_cpdf_temp_rec.fegli_assg_indicator
3326: ,l_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt
3327: ,l_ghr_cpdf_temp_rec.fegli_court_ord_ind
3328: ,l_ghr_cpdf_temp_rec.fegli_benf_desg_ind
3329: ,l_ghr_cpdf_temp_rec.fehb_event_code ); -- Bug 4724337 Race or National Origin changes
3330: --Bug#6158983 World Citizenship
3331: l_ehri_id := l_ghr_cpdf_temp_rec.ehri_employee_id;
3324: ,l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND2
3325: ,l_ghr_cpdf_temp_rec.fegli_assg_indicator
3326: ,l_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt
3327: ,l_ghr_cpdf_temp_rec.fegli_court_ord_ind
3328: ,l_ghr_cpdf_temp_rec.fegli_benf_desg_ind
3329: ,l_ghr_cpdf_temp_rec.fehb_event_code ); -- Bug 4724337 Race or National Origin changes
3330: --Bug#6158983 World Citizenship
3331: l_ehri_id := l_ghr_cpdf_temp_rec.ehri_employee_id;
3332:
3325: ,l_ghr_cpdf_temp_rec.fegli_assg_indicator
3326: ,l_ghr_cpdf_temp_rec.fegli_post_elc_basic_ins_amt
3327: ,l_ghr_cpdf_temp_rec.fegli_court_ord_ind
3328: ,l_ghr_cpdf_temp_rec.fegli_benf_desg_ind
3329: ,l_ghr_cpdf_temp_rec.fehb_event_code ); -- Bug 4724337 Race or National Origin changes
3330: --Bug#6158983 World Citizenship
3331: l_ehri_id := l_ghr_cpdf_temp_rec.ehri_employee_id;
3332:
3333:
3327: ,l_ghr_cpdf_temp_rec.fegli_court_ord_ind
3328: ,l_ghr_cpdf_temp_rec.fegli_benf_desg_ind
3329: ,l_ghr_cpdf_temp_rec.fehb_event_code ); -- Bug 4724337 Race or National Origin changes
3330: --Bug#6158983 World Citizenship
3331: l_ehri_id := l_ghr_cpdf_temp_rec.ehri_employee_id;
3332:
3333:
3334: EXCEPTION
3335: WHEN OTHERS THEN
3352: IF (l_ghr_pa_requests_rec.first_noa_code LIKE '2%' OR
3353: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
3354: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '2%')) THEN
3355:
3356: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
3357: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3358: l_ghr_cpdf_temp_rec.from_pay_plan := NULL;
3359: l_ghr_cpdf_temp_rec.from_occ_code := NULL;
3360: l_ghr_cpdf_temp_rec.from_grade_or_level := NULL;
3353: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
3354: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '2%')) THEN
3355:
3356: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
3357: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3358: l_ghr_cpdf_temp_rec.from_pay_plan := NULL;
3359: l_ghr_cpdf_temp_rec.from_occ_code := NULL;
3360: l_ghr_cpdf_temp_rec.from_grade_or_level := NULL;
3361: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3354: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '2%')) THEN
3355:
3356: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
3357: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3358: l_ghr_cpdf_temp_rec.from_pay_plan := NULL;
3359: l_ghr_cpdf_temp_rec.from_occ_code := NULL;
3360: l_ghr_cpdf_temp_rec.from_grade_or_level := NULL;
3361: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3362: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3355:
3356: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
3357: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3358: l_ghr_cpdf_temp_rec.from_pay_plan := NULL;
3359: l_ghr_cpdf_temp_rec.from_occ_code := NULL;
3360: l_ghr_cpdf_temp_rec.from_grade_or_level := NULL;
3361: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3362: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3363: l_ghr_cpdf_temp_rec.from_pay_basis := NULL;
3356: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
3357: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3358: l_ghr_cpdf_temp_rec.from_pay_plan := NULL;
3359: l_ghr_cpdf_temp_rec.from_occ_code := NULL;
3360: l_ghr_cpdf_temp_rec.from_grade_or_level := NULL;
3361: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3362: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3363: l_ghr_cpdf_temp_rec.from_pay_basis := NULL;
3364: l_ghr_cpdf_temp_rec.from_total_salary := NULL;
3357: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3358: l_ghr_cpdf_temp_rec.from_pay_plan := NULL;
3359: l_ghr_cpdf_temp_rec.from_occ_code := NULL;
3360: l_ghr_cpdf_temp_rec.from_grade_or_level := NULL;
3361: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3362: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3363: l_ghr_cpdf_temp_rec.from_pay_basis := NULL;
3364: l_ghr_cpdf_temp_rec.from_total_salary := NULL;
3365: l_ghr_cpdf_temp_rec.from_adj_basic_pay := NULL;
3358: l_ghr_cpdf_temp_rec.from_pay_plan := NULL;
3359: l_ghr_cpdf_temp_rec.from_occ_code := NULL;
3360: l_ghr_cpdf_temp_rec.from_grade_or_level := NULL;
3361: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3362: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3363: l_ghr_cpdf_temp_rec.from_pay_basis := NULL;
3364: l_ghr_cpdf_temp_rec.from_total_salary := NULL;
3365: l_ghr_cpdf_temp_rec.from_adj_basic_pay := NULL;
3366: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3359: l_ghr_cpdf_temp_rec.from_occ_code := NULL;
3360: l_ghr_cpdf_temp_rec.from_grade_or_level := NULL;
3361: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3362: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3363: l_ghr_cpdf_temp_rec.from_pay_basis := NULL;
3364: l_ghr_cpdf_temp_rec.from_total_salary := NULL;
3365: l_ghr_cpdf_temp_rec.from_adj_basic_pay := NULL;
3366: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3367:
3360: l_ghr_cpdf_temp_rec.from_grade_or_level := NULL;
3361: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3362: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3363: l_ghr_cpdf_temp_rec.from_pay_basis := NULL;
3364: l_ghr_cpdf_temp_rec.from_total_salary := NULL;
3365: l_ghr_cpdf_temp_rec.from_adj_basic_pay := NULL;
3366: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3367:
3368: -- for bug 3327389
3361: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3362: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3363: l_ghr_cpdf_temp_rec.from_pay_basis := NULL;
3364: l_ghr_cpdf_temp_rec.from_total_salary := NULL;
3365: l_ghr_cpdf_temp_rec.from_adj_basic_pay := NULL;
3366: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3367:
3368: -- for bug 3327389
3369: END IF;
3362: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3363: l_ghr_cpdf_temp_rec.from_pay_basis := NULL;
3364: l_ghr_cpdf_temp_rec.from_total_salary := NULL;
3365: l_ghr_cpdf_temp_rec.from_adj_basic_pay := NULL;
3366: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3367:
3368: -- for bug 3327389
3369: END IF;
3370:
3372: -- Bug#2789704 Added Exception Handling
3373: BEGIN
3374: ghr_sf52_pre_update.get_auth_codes
3375: (p_pa_req_rec => l_ghr_pa_requests_rec
3376: ,p_auth_code1 => l_ghr_cpdf_temp_rec.current_appointment_auth1
3377: ,p_auth_code2 => l_ghr_cpdf_temp_rec.current_appointment_auth2);
3378: EXCEPTION
3379: WHEN OTHERS THEN
3380: l_message_name := 'get_auth_codes';
3373: BEGIN
3374: ghr_sf52_pre_update.get_auth_codes
3375: (p_pa_req_rec => l_ghr_pa_requests_rec
3376: ,p_auth_code1 => l_ghr_cpdf_temp_rec.current_appointment_auth1
3377: ,p_auth_code2 => l_ghr_cpdf_temp_rec.current_appointment_auth2);
3378: EXCEPTION
3379: WHEN OTHERS THEN
3380: l_message_name := 'get_auth_codes';
3381: l_log_text := 'Error in fetching Current Appointment Authority Codes for pa_request_id: '||
3411: ,l_ghr_pa_requests_rec.employee_assignment_id
3412: ,l_ghr_pa_requests_rec.from_position_id
3413: ,l_ghr_pa_requests_rec.effective_date
3414: ,l_ghr_pa_requests_rec.status
3415: ,l_ghr_cpdf_temp_rec.from_work_schedule
3416: ,l_ghr_cpdf_temp_rec.from_pay_rate_determinant
3417: ,l_ghr_cpdf_temp_rec.from_duty_station_code);
3418:
3419: IF (l_ghr_pa_requests_rec.first_noa_code IN ('817') OR
3412: ,l_ghr_pa_requests_rec.from_position_id
3413: ,l_ghr_pa_requests_rec.effective_date
3414: ,l_ghr_pa_requests_rec.status
3415: ,l_ghr_cpdf_temp_rec.from_work_schedule
3416: ,l_ghr_cpdf_temp_rec.from_pay_rate_determinant
3417: ,l_ghr_cpdf_temp_rec.from_duty_station_code);
3418:
3419: IF (l_ghr_pa_requests_rec.first_noa_code IN ('817') OR
3420: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
3413: ,l_ghr_pa_requests_rec.effective_date
3414: ,l_ghr_pa_requests_rec.status
3415: ,l_ghr_cpdf_temp_rec.from_work_schedule
3416: ,l_ghr_cpdf_temp_rec.from_pay_rate_determinant
3417: ,l_ghr_cpdf_temp_rec.from_duty_station_code);
3418:
3419: IF (l_ghr_pa_requests_rec.first_noa_code IN ('817') OR
3420: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
3421: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#')= '817')
3420: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
3421: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#')= '817')
3422: )
3423: THEN
3424: l_ghr_cpdf_temp_rec.from_work_schedule := NULL;
3425: l_ghr_cpdf_temp_rec.from_pay_rate_determinant := NULL;
3426: l_ghr_cpdf_temp_rec.from_duty_station_code := NULL;
3427: END IF;
3428:
3421: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#')= '817')
3422: )
3423: THEN
3424: l_ghr_cpdf_temp_rec.from_work_schedule := NULL;
3425: l_ghr_cpdf_temp_rec.from_pay_rate_determinant := NULL;
3426: l_ghr_cpdf_temp_rec.from_duty_station_code := NULL;
3427: END IF;
3428:
3429: EXCEPTION
3422: )
3423: THEN
3424: l_ghr_cpdf_temp_rec.from_work_schedule := NULL;
3425: l_ghr_cpdf_temp_rec.from_pay_rate_determinant := NULL;
3426: l_ghr_cpdf_temp_rec.from_duty_station_code := NULL;
3427: END IF;
3428:
3429: EXCEPTION
3430: WHEN OTHERS THEN
3443: END;
3444:
3445: -- bug#5328177 IF l_noa_family_code = 'AWARD' THEN
3446: IF l_noa_family_code IN ('AWARD','GHR_INCENTIVE') THEN
3447: l_ghr_cpdf_temp_rec.to_pay_rate_determinant := l_ghr_cpdf_temp_rec.from_pay_rate_determinant;
3448: l_ghr_cpdf_temp_rec.from_work_schedule := NULL;
3449: l_ghr_cpdf_temp_rec.from_pay_rate_determinant := NULL;
3450: l_ghr_cpdf_temp_rec.from_duty_station_code := NULL;
3451:
3444:
3445: -- bug#5328177 IF l_noa_family_code = 'AWARD' THEN
3446: IF l_noa_family_code IN ('AWARD','GHR_INCENTIVE') THEN
3447: l_ghr_cpdf_temp_rec.to_pay_rate_determinant := l_ghr_cpdf_temp_rec.from_pay_rate_determinant;
3448: l_ghr_cpdf_temp_rec.from_work_schedule := NULL;
3449: l_ghr_cpdf_temp_rec.from_pay_rate_determinant := NULL;
3450: l_ghr_cpdf_temp_rec.from_duty_station_code := NULL;
3451:
3452: -- NULL OUT THESE FIELDS FOR AWARDS
3445: -- bug#5328177 IF l_noa_family_code = 'AWARD' THEN
3446: IF l_noa_family_code IN ('AWARD','GHR_INCENTIVE') THEN
3447: l_ghr_cpdf_temp_rec.to_pay_rate_determinant := l_ghr_cpdf_temp_rec.from_pay_rate_determinant;
3448: l_ghr_cpdf_temp_rec.from_work_schedule := NULL;
3449: l_ghr_cpdf_temp_rec.from_pay_rate_determinant := NULL;
3450: l_ghr_cpdf_temp_rec.from_duty_station_code := NULL;
3451:
3452: -- NULL OUT THESE FIELDS FOR AWARDS
3453: l_ghr_cpdf_temp_rec.from_pay_plan := NULL;
3446: IF l_noa_family_code IN ('AWARD','GHR_INCENTIVE') THEN
3447: l_ghr_cpdf_temp_rec.to_pay_rate_determinant := l_ghr_cpdf_temp_rec.from_pay_rate_determinant;
3448: l_ghr_cpdf_temp_rec.from_work_schedule := NULL;
3449: l_ghr_cpdf_temp_rec.from_pay_rate_determinant := NULL;
3450: l_ghr_cpdf_temp_rec.from_duty_station_code := NULL;
3451:
3452: -- NULL OUT THESE FIELDS FOR AWARDS
3453: l_ghr_cpdf_temp_rec.from_pay_plan := NULL;
3454: l_ghr_cpdf_temp_rec.from_occ_code := NULL;
3449: l_ghr_cpdf_temp_rec.from_pay_rate_determinant := NULL;
3450: l_ghr_cpdf_temp_rec.from_duty_station_code := NULL;
3451:
3452: -- NULL OUT THESE FIELDS FOR AWARDS
3453: l_ghr_cpdf_temp_rec.from_pay_plan := NULL;
3454: l_ghr_cpdf_temp_rec.from_occ_code := NULL;
3455: l_ghr_cpdf_temp_rec.from_grade_or_level := NULL;
3456: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3457: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3450: l_ghr_cpdf_temp_rec.from_duty_station_code := NULL;
3451:
3452: -- NULL OUT THESE FIELDS FOR AWARDS
3453: l_ghr_cpdf_temp_rec.from_pay_plan := NULL;
3454: l_ghr_cpdf_temp_rec.from_occ_code := NULL;
3455: l_ghr_cpdf_temp_rec.from_grade_or_level := NULL;
3456: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3457: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3458: l_ghr_cpdf_temp_rec.from_pay_basis := NULL;
3451:
3452: -- NULL OUT THESE FIELDS FOR AWARDS
3453: l_ghr_cpdf_temp_rec.from_pay_plan := NULL;
3454: l_ghr_cpdf_temp_rec.from_occ_code := NULL;
3455: l_ghr_cpdf_temp_rec.from_grade_or_level := NULL;
3456: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3457: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3458: l_ghr_cpdf_temp_rec.from_pay_basis := NULL;
3459: l_ghr_cpdf_temp_rec.from_total_salary := NULL;
3452: -- NULL OUT THESE FIELDS FOR AWARDS
3453: l_ghr_cpdf_temp_rec.from_pay_plan := NULL;
3454: l_ghr_cpdf_temp_rec.from_occ_code := NULL;
3455: l_ghr_cpdf_temp_rec.from_grade_or_level := NULL;
3456: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3457: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3458: l_ghr_cpdf_temp_rec.from_pay_basis := NULL;
3459: l_ghr_cpdf_temp_rec.from_total_salary := NULL;
3460: l_ghr_cpdf_temp_rec.from_adj_basic_pay := NULL;
3453: l_ghr_cpdf_temp_rec.from_pay_plan := NULL;
3454: l_ghr_cpdf_temp_rec.from_occ_code := NULL;
3455: l_ghr_cpdf_temp_rec.from_grade_or_level := NULL;
3456: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3457: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3458: l_ghr_cpdf_temp_rec.from_pay_basis := NULL;
3459: l_ghr_cpdf_temp_rec.from_total_salary := NULL;
3460: l_ghr_cpdf_temp_rec.from_adj_basic_pay := NULL;
3461:
3454: l_ghr_cpdf_temp_rec.from_occ_code := NULL;
3455: l_ghr_cpdf_temp_rec.from_grade_or_level := NULL;
3456: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3457: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3458: l_ghr_cpdf_temp_rec.from_pay_basis := NULL;
3459: l_ghr_cpdf_temp_rec.from_total_salary := NULL;
3460: l_ghr_cpdf_temp_rec.from_adj_basic_pay := NULL;
3461:
3462: END IF;
3455: l_ghr_cpdf_temp_rec.from_grade_or_level := NULL;
3456: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3457: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3458: l_ghr_cpdf_temp_rec.from_pay_basis := NULL;
3459: l_ghr_cpdf_temp_rec.from_total_salary := NULL;
3460: l_ghr_cpdf_temp_rec.from_adj_basic_pay := NULL;
3461:
3462: END IF;
3463: -- Added IF Condition to fix bug#3231946
3456: l_ghr_cpdf_temp_rec.from_step_or_rate := NULL;
3457: l_ghr_cpdf_temp_rec.from_basic_pay := NULL; -- format in report
3458: l_ghr_cpdf_temp_rec.from_pay_basis := NULL;
3459: l_ghr_cpdf_temp_rec.from_total_salary := NULL;
3460: l_ghr_cpdf_temp_rec.from_adj_basic_pay := NULL;
3461:
3462: END IF;
3463: -- Added IF Condition to fix bug#3231946
3464: IF get_loc_pay_area_code(p_duty_station_code => l_ghr_cpdf_temp_rec.from_duty_station_code,
3460: l_ghr_cpdf_temp_rec.from_adj_basic_pay := NULL;
3461:
3462: END IF;
3463: -- Added IF Condition to fix bug#3231946
3464: IF get_loc_pay_area_code(p_duty_station_code => l_ghr_cpdf_temp_rec.from_duty_station_code,
3465: p_effective_date => l_ghr_pa_requests_rec.effective_date) = '99'
3466: AND l_ghr_pa_requests_rec.from_locality_adj = 0 THEN
3467: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3468: END IF;
3463: -- Added IF Condition to fix bug#3231946
3464: IF get_loc_pay_area_code(p_duty_station_code => l_ghr_cpdf_temp_rec.from_duty_station_code,
3465: p_effective_date => l_ghr_pa_requests_rec.effective_date) = '99'
3466: AND l_ghr_pa_requests_rec.from_locality_adj = 0 THEN
3467: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3468: END IF;
3469: END IF;
3470: --
3471: -- 3.7) Get prior ssn if it is being corrected.
3474: BEGIN
3475: get_prev_ssn (l_ghr_pa_requests_rec.altered_pa_request_id
3476: ,l_ghr_pa_requests_rec.employee_national_identifier
3477: ,l_ghr_pa_requests_rec.noa_family_code
3478: ,l_ghr_cpdf_temp_rec.from_national_identifier);
3479: EXCEPTION
3480: WHEN OTHERS THEN
3481: l_message_name := 'get_prev_ssn';
3482: l_log_text := 'Error in fetching SSN for pa_request_id: '||
3512: l_ghr_pa_requests_rec.first_noa_code like '7%' OR l_ghr_pa_requests_rec.first_noa_code like '8%'
3513: )
3514: )
3515: THEN
3516: l_ghr_cpdf_temp_rec.ehri_employee_id := l_ehri_id;
3517: -- Bug 5010784
3518: -- l_ghr_cpdf_temp_rec.bargaining_unit_status := l_ghr_pa_requests_rec.bargaining_unit_status;
3519: l_ghr_cpdf_temp_rec.bargaining_unit_status := SUBSTR(l_ghr_pa_requests_rec.bargaining_unit_status,
3520: LENGTH(l_ghr_pa_requests_rec.bargaining_unit_status)-3);
3514: )
3515: THEN
3516: l_ghr_cpdf_temp_rec.ehri_employee_id := l_ehri_id;
3517: -- Bug 5010784
3518: -- l_ghr_cpdf_temp_rec.bargaining_unit_status := l_ghr_pa_requests_rec.bargaining_unit_status;
3519: l_ghr_cpdf_temp_rec.bargaining_unit_status := SUBSTR(l_ghr_pa_requests_rec.bargaining_unit_status,
3520: LENGTH(l_ghr_pa_requests_rec.bargaining_unit_status)-3);
3521: -- End Bug 5010784
3522:
3515: THEN
3516: l_ghr_cpdf_temp_rec.ehri_employee_id := l_ehri_id;
3517: -- Bug 5010784
3518: -- l_ghr_cpdf_temp_rec.bargaining_unit_status := l_ghr_pa_requests_rec.bargaining_unit_status;
3519: l_ghr_cpdf_temp_rec.bargaining_unit_status := SUBSTR(l_ghr_pa_requests_rec.bargaining_unit_status,
3520: LENGTH(l_ghr_pa_requests_rec.bargaining_unit_status)-3);
3521: -- End Bug 5010784
3522:
3523: -- adding code for 817 NOAC
3521: -- End Bug 5010784
3522:
3523: -- adding code for 817 NOAC
3524: IF (l_ghr_pa_requests_rec.first_noa_code='817' or l_ghr_pa_requests_rec.second_noa_code='817') THEN
3525: l_ghr_cpdf_temp_rec := l_ghr_empty_cpdf_temp;
3526: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
3527: l_ghr_cpdf_temp_rec.to_national_identifier
3528: := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
3529: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date;
3522:
3523: -- adding code for 817 NOAC
3524: IF (l_ghr_pa_requests_rec.first_noa_code='817' or l_ghr_pa_requests_rec.second_noa_code='817') THEN
3525: l_ghr_cpdf_temp_rec := l_ghr_empty_cpdf_temp;
3526: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
3527: l_ghr_cpdf_temp_rec.to_national_identifier
3528: := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
3529: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date;
3530: l_ghr_cpdf_temp_rec.first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
3523: -- adding code for 817 NOAC
3524: IF (l_ghr_pa_requests_rec.first_noa_code='817' or l_ghr_pa_requests_rec.second_noa_code='817') THEN
3525: l_ghr_cpdf_temp_rec := l_ghr_empty_cpdf_temp;
3526: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
3527: l_ghr_cpdf_temp_rec.to_national_identifier
3528: := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
3529: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date;
3530: l_ghr_cpdf_temp_rec.first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
3531: l_ghr_cpdf_temp_rec.second_noa_code := l_ghr_pa_requests_rec.second_noa_code;
3525: l_ghr_cpdf_temp_rec := l_ghr_empty_cpdf_temp;
3526: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
3527: l_ghr_cpdf_temp_rec.to_national_identifier
3528: := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
3529: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date;
3530: l_ghr_cpdf_temp_rec.first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
3531: l_ghr_cpdf_temp_rec.second_noa_code := l_ghr_pa_requests_rec.second_noa_code;
3532: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
3533: l_ghr_cpdf_temp_rec.ehri_employee_id := l_ehri_id;
3526: l_ghr_cpdf_temp_rec.agency_code := NVL(l_ghr_pa_requests_rec.agency_code,l_ghr_pa_requests_rec.from_agency_code);
3527: l_ghr_cpdf_temp_rec.to_national_identifier
3528: := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
3529: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date;
3530: l_ghr_cpdf_temp_rec.first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
3531: l_ghr_cpdf_temp_rec.second_noa_code := l_ghr_pa_requests_rec.second_noa_code;
3532: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
3533: l_ghr_cpdf_temp_rec.ehri_employee_id := l_ehri_id;
3534: -- l_ghr_cpdf_temp_rec.employee_date_of_birth := NULL;
3527: l_ghr_cpdf_temp_rec.to_national_identifier
3528: := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
3529: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date;
3530: l_ghr_cpdf_temp_rec.first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
3531: l_ghr_cpdf_temp_rec.second_noa_code := l_ghr_pa_requests_rec.second_noa_code;
3532: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
3533: l_ghr_cpdf_temp_rec.ehri_employee_id := l_ehri_id;
3534: -- l_ghr_cpdf_temp_rec.employee_date_of_birth := NULL;
3535: -- GOTO end_par_loop;
3528: := format_ni(l_ghr_pa_requests_rec.employee_national_identifier);
3529: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date;
3530: l_ghr_cpdf_temp_rec.first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
3531: l_ghr_cpdf_temp_rec.second_noa_code := l_ghr_pa_requests_rec.second_noa_code;
3532: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
3533: l_ghr_cpdf_temp_rec.ehri_employee_id := l_ehri_id;
3534: -- l_ghr_cpdf_temp_rec.employee_date_of_birth := NULL;
3535: -- GOTO end_par_loop;
3536: END IF;
3529: l_ghr_cpdf_temp_rec.effective_date := l_ghr_pa_requests_rec.effective_date;
3530: l_ghr_cpdf_temp_rec.first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
3531: l_ghr_cpdf_temp_rec.second_noa_code := l_ghr_pa_requests_rec.second_noa_code;
3532: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
3533: l_ghr_cpdf_temp_rec.ehri_employee_id := l_ehri_id;
3534: -- l_ghr_cpdf_temp_rec.employee_date_of_birth := NULL;
3535: -- GOTO end_par_loop;
3536: END IF;
3537:
3530: l_ghr_cpdf_temp_rec.first_noa_code := l_ghr_pa_requests_rec.first_noa_code;
3531: l_ghr_cpdf_temp_rec.second_noa_code := l_ghr_pa_requests_rec.second_noa_code;
3532: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
3533: l_ghr_cpdf_temp_rec.ehri_employee_id := l_ehri_id;
3534: -- l_ghr_cpdf_temp_rec.employee_date_of_birth := NULL;
3535: -- GOTO end_par_loop;
3536: END IF;
3537:
3538: IF l_ghr_pa_requests_rec.first_noa_code <> '001' AND
3546: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '4%'
3547: )
3548: ) THEN
3549:
3550: l_ghr_cpdf_temp_rec.position_title := l_ghr_pa_requests_rec.to_position_title;
3551: l_ghr_cpdf_temp_rec.position_number := l_ghr_pa_requests_rec.to_position_number;
3552:
3553: /* FOR pos_org IN cur_pos_org(l_ghr_pa_requests_rec.to_organization_id,
3554: l_ghr_pa_requests_rec.effective_date)
3547: )
3548: ) THEN
3549:
3550: l_ghr_cpdf_temp_rec.position_title := l_ghr_pa_requests_rec.to_position_title;
3551: l_ghr_cpdf_temp_rec.position_number := l_ghr_pa_requests_rec.to_position_number;
3552:
3553: /* FOR pos_org IN cur_pos_org(l_ghr_pa_requests_rec.to_organization_id,
3554: l_ghr_pa_requests_rec.effective_date)
3555: LOOP
3552:
3553: /* FOR pos_org IN cur_pos_org(l_ghr_pa_requests_rec.to_organization_id,
3554: l_ghr_pa_requests_rec.effective_date)
3555: LOOP
3556: l_ghr_cpdf_temp_rec.POSITION_ORG := pos_org.name;
3557: END LOOP;
3558:
3559: */
3560: l_ghr_cpdf_temp_rec.POSITION_ORG := SUBSTR(l_ghr_pa_requests_rec.to_position_org_line1 ||
3556: l_ghr_cpdf_temp_rec.POSITION_ORG := pos_org.name;
3557: END LOOP;
3558:
3559: */
3560: l_ghr_cpdf_temp_rec.POSITION_ORG := SUBSTR(l_ghr_pa_requests_rec.to_position_org_line1 ||
3561: ' ' || l_ghr_pa_requests_rec.to_position_org_line2 ||
3562: ' ' || l_ghr_pa_requests_rec.to_position_org_line3 ||
3563: ' ' || l_ghr_pa_requests_rec.to_position_org_line4 ||
3564: ' ' || l_ghr_pa_requests_rec.to_position_org_line5 ||
3563: ' ' || l_ghr_pa_requests_rec.to_position_org_line4 ||
3564: ' ' || l_ghr_pa_requests_rec.to_position_org_line5 ||
3565: ' ' || l_ghr_pa_requests_rec.to_position_org_line6,1,500);
3566: ELSE
3567: l_ghr_cpdf_temp_rec.position_title := NULL;
3568: l_ghr_cpdf_temp_rec.position_number := NULL;
3569: l_ghr_cpdf_temp_rec.POSITION_ORG := NULL;
3570: --
3571: l_ghr_cpdf_temp_rec.position_title := NULL;
3564: ' ' || l_ghr_pa_requests_rec.to_position_org_line5 ||
3565: ' ' || l_ghr_pa_requests_rec.to_position_org_line6,1,500);
3566: ELSE
3567: l_ghr_cpdf_temp_rec.position_title := NULL;
3568: l_ghr_cpdf_temp_rec.position_number := NULL;
3569: l_ghr_cpdf_temp_rec.POSITION_ORG := NULL;
3570: --
3571: l_ghr_cpdf_temp_rec.position_title := NULL;
3572: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
3565: ' ' || l_ghr_pa_requests_rec.to_position_org_line6,1,500);
3566: ELSE
3567: l_ghr_cpdf_temp_rec.position_title := NULL;
3568: l_ghr_cpdf_temp_rec.position_number := NULL;
3569: l_ghr_cpdf_temp_rec.POSITION_ORG := NULL;
3570: --
3571: l_ghr_cpdf_temp_rec.position_title := NULL;
3572: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
3573: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3567: l_ghr_cpdf_temp_rec.position_title := NULL;
3568: l_ghr_cpdf_temp_rec.position_number := NULL;
3569: l_ghr_cpdf_temp_rec.POSITION_ORG := NULL;
3570: --
3571: l_ghr_cpdf_temp_rec.position_title := NULL;
3572: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
3573: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3574: l_ghr_cpdf_temp_rec.frozen_service := NULL;
3575: END IF;
3568: l_ghr_cpdf_temp_rec.position_number := NULL;
3569: l_ghr_cpdf_temp_rec.POSITION_ORG := NULL;
3570: --
3571: l_ghr_cpdf_temp_rec.position_title := NULL;
3572: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
3573: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3574: l_ghr_cpdf_temp_rec.frozen_service := NULL;
3575: END IF;
3576:
3569: l_ghr_cpdf_temp_rec.POSITION_ORG := NULL;
3570: --
3571: l_ghr_cpdf_temp_rec.position_title := NULL;
3572: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
3573: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3574: l_ghr_cpdf_temp_rec.frozen_service := NULL;
3575: END IF;
3576:
3577: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' and
3570: --
3571: l_ghr_cpdf_temp_rec.position_title := NULL;
3572: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
3573: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3574: l_ghr_cpdf_temp_rec.frozen_service := NULL;
3575: END IF;
3576:
3577: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' and
3578: NVL(l_ghr_pa_requests_rec.second_noa_code,'@#') in ('815','816','817','818','819','825',
3584: )
3585: THEN
3586:
3587: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='M' THEN
3588: l_ghr_cpdf_temp_rec.award_dollars := l_ghr_pa_requests_rec.award_amount;
3589: END IF;
3590: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='H' THEN
3591: l_ghr_cpdf_temp_rec.award_hours := l_ghr_pa_requests_rec.award_amount;
3592: END IF;
3587: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='M' THEN
3588: l_ghr_cpdf_temp_rec.award_dollars := l_ghr_pa_requests_rec.award_amount;
3589: END IF;
3590: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='H' THEN
3591: l_ghr_cpdf_temp_rec.award_hours := l_ghr_pa_requests_rec.award_amount;
3592: END IF;
3593: IF l_ghr_pa_requests_rec.award_percentage IS NOT NULL THEN
3594: l_ghr_cpdf_temp_rec.award_percentage := l_ghr_pa_requests_rec.award_percentage;
3595: END IF;
3590: IF NVL(l_ghr_pa_requests_rec.award_uom,'M')='H' THEN
3591: l_ghr_cpdf_temp_rec.award_hours := l_ghr_pa_requests_rec.award_amount;
3592: END IF;
3593: IF l_ghr_pa_requests_rec.award_percentage IS NOT NULL THEN
3594: l_ghr_cpdf_temp_rec.award_percentage := l_ghr_pa_requests_rec.award_percentage;
3595: END IF;
3596:
3597: /* COMMENTED this code as the similar code is added at line 2545 to resolve the
3598: issue of non-printing the to total salary.
3601: -- If the Award Dollars value is NOT NULL, Assume that 825 is processed as Award.
3602: -- Otherwise, it is processed as Incentive.
3603: IF (l_ghr_pa_requests_rec.first_noa_code IN ('815','816','825') OR
3604: l_ghr_pa_requests_rec.second_noa_code IN ('815','816', '825')) AND
3605: l_ghr_cpdf_temp_rec.award_dollars IS NULL THEN
3606: l_ghr_cpdf_temp_rec.award_dollars := l_ghr_pa_requests_rec.to_total_salary;
3607: l_ghr_cpdf_temp_rec.to_total_salary := NULL;
3608: END IF;
3609: -- End of Bug#3941541,5168358
3602: -- Otherwise, it is processed as Incentive.
3603: IF (l_ghr_pa_requests_rec.first_noa_code IN ('815','816','825') OR
3604: l_ghr_pa_requests_rec.second_noa_code IN ('815','816', '825')) AND
3605: l_ghr_cpdf_temp_rec.award_dollars IS NULL THEN
3606: l_ghr_cpdf_temp_rec.award_dollars := l_ghr_pa_requests_rec.to_total_salary;
3607: l_ghr_cpdf_temp_rec.to_total_salary := NULL;
3608: END IF;
3609: -- End of Bug#3941541,5168358
3610: */
3603: IF (l_ghr_pa_requests_rec.first_noa_code IN ('815','816','825') OR
3604: l_ghr_pa_requests_rec.second_noa_code IN ('815','816', '825')) AND
3605: l_ghr_cpdf_temp_rec.award_dollars IS NULL THEN
3606: l_ghr_cpdf_temp_rec.award_dollars := l_ghr_pa_requests_rec.to_total_salary;
3607: l_ghr_cpdf_temp_rec.to_total_salary := NULL;
3608: END IF;
3609: -- End of Bug#3941541,5168358
3610: */
3611: -- DONT report if AWARD or 3xx,4xx actions
3608: END IF;
3609: -- End of Bug#3941541,5168358
3610: */
3611: -- DONT report if AWARD or 3xx,4xx actions
3612: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
3613: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3614: l_ghr_cpdf_temp_rec.frozen_service := NULL;
3615:
3616: END IF;
3609: -- End of Bug#3941541,5168358
3610: */
3611: -- DONT report if AWARD or 3xx,4xx actions
3612: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
3613: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3614: l_ghr_cpdf_temp_rec.frozen_service := NULL;
3615:
3616: END IF;
3617:
3610: */
3611: -- DONT report if AWARD or 3xx,4xx actions
3612: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
3613: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3614: l_ghr_cpdf_temp_rec.frozen_service := NULL;
3615:
3616: END IF;
3617:
3618: -- New EHRI changes MADHURI
3645: get_suffix_lname(prior_per_rec.last_name,
3646: l_ghr_pa_requests_rec.effective_date-1,
3647: l_suffix,
3648: l_last_name);
3649: l_ghr_cpdf_temp_rec.PRIOR_FAMILY_NAME := l_last_name;
3650: l_ghr_cpdf_temp_rec.PRIOR_GIVEN_NAME := prior_per_rec.first_name;
3651: l_ghr_cpdf_temp_rec.PRIOR_MIDDLE_NAME := prior_per_rec.middle_names;
3652: l_ghr_cpdf_temp_rec.PRIOR_NAME_SUFFIX := l_suffix;
3653: --End Bug# 4648811
3646: l_ghr_pa_requests_rec.effective_date-1,
3647: l_suffix,
3648: l_last_name);
3649: l_ghr_cpdf_temp_rec.PRIOR_FAMILY_NAME := l_last_name;
3650: l_ghr_cpdf_temp_rec.PRIOR_GIVEN_NAME := prior_per_rec.first_name;
3651: l_ghr_cpdf_temp_rec.PRIOR_MIDDLE_NAME := prior_per_rec.middle_names;
3652: l_ghr_cpdf_temp_rec.PRIOR_NAME_SUFFIX := l_suffix;
3653: --End Bug# 4648811
3654: END LOOP;
3647: l_suffix,
3648: l_last_name);
3649: l_ghr_cpdf_temp_rec.PRIOR_FAMILY_NAME := l_last_name;
3650: l_ghr_cpdf_temp_rec.PRIOR_GIVEN_NAME := prior_per_rec.first_name;
3651: l_ghr_cpdf_temp_rec.PRIOR_MIDDLE_NAME := prior_per_rec.middle_names;
3652: l_ghr_cpdf_temp_rec.PRIOR_NAME_SUFFIX := l_suffix;
3653: --End Bug# 4648811
3654: END LOOP;
3655:
3648: l_last_name);
3649: l_ghr_cpdf_temp_rec.PRIOR_FAMILY_NAME := l_last_name;
3650: l_ghr_cpdf_temp_rec.PRIOR_GIVEN_NAME := prior_per_rec.first_name;
3651: l_ghr_cpdf_temp_rec.PRIOR_MIDDLE_NAME := prior_per_rec.middle_names;
3652: l_ghr_cpdf_temp_rec.PRIOR_NAME_SUFFIX := l_suffix;
3653: --End Bug# 4648811
3654: END LOOP;
3655:
3656: END IF;
3661: l_ghr_pa_requests_rec.first_noa_code='817'
3662: ) THEN
3663: -- Dont report these items for 817 action
3664: --
3665: l_ghr_cpdf_temp_rec.PRIOR_POSITION_TITLE := l_ghr_pa_requests_rec.from_position_title;
3666: l_ghr_cpdf_temp_rec.PRIOR_POSITION_NUMBER := l_ghr_pa_requests_rec.from_position_number;
3667: --
3668: /* FOR prior_pos_org IN cur_prior_pos_org(l_ghr_pa_requests_rec.from_position_id,
3669: (l_ghr_pa_requests_rec.effective_date-1) )
3662: ) THEN
3663: -- Dont report these items for 817 action
3664: --
3665: l_ghr_cpdf_temp_rec.PRIOR_POSITION_TITLE := l_ghr_pa_requests_rec.from_position_title;
3666: l_ghr_cpdf_temp_rec.PRIOR_POSITION_NUMBER := l_ghr_pa_requests_rec.from_position_number;
3667: --
3668: /* FOR prior_pos_org IN cur_prior_pos_org(l_ghr_pa_requests_rec.from_position_id,
3669: (l_ghr_pa_requests_rec.effective_date-1) )
3670: LOOP
3667: --
3668: /* FOR prior_pos_org IN cur_prior_pos_org(l_ghr_pa_requests_rec.from_position_id,
3669: (l_ghr_pa_requests_rec.effective_date-1) )
3670: LOOP
3671: l_ghr_cpdf_temp_rec.PRIOR_POSITION_ORG := prior_pos_org.name;
3672: END LOOP; */
3673: l_ghr_cpdf_temp_rec.PRIOR_POSITION_ORG := SUBSTR(l_ghr_pa_requests_rec.from_position_org_line1 ||
3674: ' ' || l_ghr_pa_requests_rec.from_position_org_line2 ||
3675: ' ' || l_ghr_pa_requests_rec.from_position_org_line3 ||
3669: (l_ghr_pa_requests_rec.effective_date-1) )
3670: LOOP
3671: l_ghr_cpdf_temp_rec.PRIOR_POSITION_ORG := prior_pos_org.name;
3672: END LOOP; */
3673: l_ghr_cpdf_temp_rec.PRIOR_POSITION_ORG := SUBSTR(l_ghr_pa_requests_rec.from_position_org_line1 ||
3674: ' ' || l_ghr_pa_requests_rec.from_position_org_line2 ||
3675: ' ' || l_ghr_pa_requests_rec.from_position_org_line3 ||
3676: ' ' || l_ghr_pa_requests_rec.from_position_org_line4 ||
3677: ' ' || l_ghr_pa_requests_rec.from_position_org_line5 ||
3677: ' ' || l_ghr_pa_requests_rec.from_position_org_line5 ||
3678: ' ' || l_ghr_pa_requests_rec.from_position_org_line6,1,500);
3679:
3680: ELSE
3681: l_ghr_cpdf_temp_rec.PRIOR_POSITION_TITLE := NULL;
3682: l_ghr_cpdf_temp_rec.PRIOR_POSITION_NUMBER := NULL;
3683: l_ghr_cpdf_temp_rec.PRIOR_POSITION_ORG := NULL;
3684: END IF;
3685: --
3678: ' ' || l_ghr_pa_requests_rec.from_position_org_line6,1,500);
3679:
3680: ELSE
3681: l_ghr_cpdf_temp_rec.PRIOR_POSITION_TITLE := NULL;
3682: l_ghr_cpdf_temp_rec.PRIOR_POSITION_NUMBER := NULL;
3683: l_ghr_cpdf_temp_rec.PRIOR_POSITION_ORG := NULL;
3684: END IF;
3685: --
3686: END IF; --- NOT APPOINTMENT ACTION OR RETURN TO DUTY
3679:
3680: ELSE
3681: l_ghr_cpdf_temp_rec.PRIOR_POSITION_TITLE := NULL;
3682: l_ghr_cpdf_temp_rec.PRIOR_POSITION_NUMBER := NULL;
3683: l_ghr_cpdf_temp_rec.PRIOR_POSITION_ORG := NULL;
3684: END IF;
3685: --
3686: END IF; --- NOT APPOINTMENT ACTION OR RETURN TO DUTY
3687:
3684: END IF;
3685: --
3686: END IF; --- NOT APPOINTMENT ACTION OR RETURN TO DUTY
3687:
3688: l_ghr_cpdf_temp_rec.position_number := l_ghr_pa_requests_rec.to_position_number;
3689:
3690: -- NEW EHRI CHANGES MADHURI
3691: --
3692: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' AND l_ghr_pa_requests_rec.second_noa_code <>'817')
3691: --
3692: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' AND l_ghr_pa_requests_rec.second_noa_code <>'817')
3693: OR
3694: l_ghr_pa_requests_rec.first_noa_code NOT IN ('817')) THEN
3695: l_ghr_cpdf_temp_rec.employee_last_name := format_name_ehri(l_ghr_pa_requests_rec.employee_last_name);
3696: l_ghr_cpdf_temp_rec.employee_first_name := format_name_ehri(l_ghr_pa_requests_rec.employee_first_name);
3697: l_ghr_cpdf_temp_rec.employee_middle_names := format_name_ehri(l_ghr_pa_requests_rec.employee_middle_names);
3698: -- Added format_name_ehri for EHRI changes.
3699: FOR per_det IN cur_per_details(l_ghr_pa_requests_rec.person_id,
3692: IF ( (l_ghr_pa_requests_rec.first_noa_code='002' AND l_ghr_pa_requests_rec.second_noa_code <>'817')
3693: OR
3694: l_ghr_pa_requests_rec.first_noa_code NOT IN ('817')) THEN
3695: l_ghr_cpdf_temp_rec.employee_last_name := format_name_ehri(l_ghr_pa_requests_rec.employee_last_name);
3696: l_ghr_cpdf_temp_rec.employee_first_name := format_name_ehri(l_ghr_pa_requests_rec.employee_first_name);
3697: l_ghr_cpdf_temp_rec.employee_middle_names := format_name_ehri(l_ghr_pa_requests_rec.employee_middle_names);
3698: -- Added format_name_ehri for EHRI changes.
3699: FOR per_det IN cur_per_details(l_ghr_pa_requests_rec.person_id,
3700: l_ghr_pa_requests_rec.effective_date)
3693: OR
3694: l_ghr_pa_requests_rec.first_noa_code NOT IN ('817')) THEN
3695: l_ghr_cpdf_temp_rec.employee_last_name := format_name_ehri(l_ghr_pa_requests_rec.employee_last_name);
3696: l_ghr_cpdf_temp_rec.employee_first_name := format_name_ehri(l_ghr_pa_requests_rec.employee_first_name);
3697: l_ghr_cpdf_temp_rec.employee_middle_names := format_name_ehri(l_ghr_pa_requests_rec.employee_middle_names);
3698: -- Added format_name_ehri for EHRI changes.
3699: FOR per_det IN cur_per_details(l_ghr_pa_requests_rec.person_id,
3700: l_ghr_pa_requests_rec.effective_date)
3701: LOOP
3703: get_suffix_lname(per_det.last_name,
3704: l_ghr_pa_requests_rec.effective_date,
3705: l_suffix,
3706: l_last_name);
3707: l_ghr_cpdf_temp_rec.name_title := l_suffix;
3708: -- End Bug# 4648811
3709: END LOOP;
3710:
3711:
3711:
3712:
3713: FOR scd_dates IN cur_scd_dates(l_ghr_pa_requests_rec.pa_request_id)
3714: LOOP
3715: l_ghr_cpdf_temp_rec.SCD_rif := fnd_date.canonical_to_date(scd_dates.rif);
3716: l_ghr_cpdf_temp_rec.SCD_retirement := fnd_date.canonical_to_date(scd_dates.ret);
3717: -- Added date conversion for bug#3808473-EHRI reports
3718: END LOOP;
3719:
3712:
3713: FOR scd_dates IN cur_scd_dates(l_ghr_pa_requests_rec.pa_request_id)
3714: LOOP
3715: l_ghr_cpdf_temp_rec.SCD_rif := fnd_date.canonical_to_date(scd_dates.rif);
3716: l_ghr_cpdf_temp_rec.SCD_retirement := fnd_date.canonical_to_date(scd_dates.ret);
3717: -- Added date conversion for bug#3808473-EHRI reports
3718: END LOOP;
3719:
3720: IF (l_ghr_cpdf_temp_rec.SCD_rif IS NULL
3716: l_ghr_cpdf_temp_rec.SCD_retirement := fnd_date.canonical_to_date(scd_dates.ret);
3717: -- Added date conversion for bug#3808473-EHRI reports
3718: END LOOP;
3719:
3720: IF (l_ghr_cpdf_temp_rec.SCD_rif IS NULL
3721: and l_ghr_cpdf_temp_rec.SCD_retirement IS NULL) THEN
3722:
3723: BEGIN
3724: ghr_history_fetch.fetch_peopleei
3717: -- Added date conversion for bug#3808473-EHRI reports
3718: END LOOP;
3719:
3720: IF (l_ghr_cpdf_temp_rec.SCD_rif IS NULL
3721: and l_ghr_cpdf_temp_rec.SCD_retirement IS NULL) THEN
3722:
3723: BEGIN
3724: ghr_history_fetch.fetch_peopleei
3725: (p_person_id => l_ghr_pa_requests_rec.person_id,
3727: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
3728: p_per_ei_data => ll_per_ei_data
3729: );
3730:
3731: l_ghr_cpdf_temp_rec.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
3732: l_ghr_cpdf_temp_rec.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
3733:
3734: EXCEPTION
3735: WHEN OTHERS THEN
3728: p_per_ei_data => ll_per_ei_data
3729: );
3730:
3731: l_ghr_cpdf_temp_rec.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
3732: l_ghr_cpdf_temp_rec.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
3733:
3734: EXCEPTION
3735: WHEN OTHERS THEN
3736: l_message_name := 'fetch_peopleei';
3748: END;
3749: END IF;
3750:
3751: ELSE -- if NOAC is 817
3752: l_ghr_cpdf_temp_rec.employee_last_name := NULL;
3753: l_ghr_cpdf_temp_rec.employee_first_name := NULL;
3754: l_ghr_cpdf_temp_rec.employee_middle_names := NULL;
3755: l_ghr_cpdf_temp_rec.name_title := NULL;
3756: l_ghr_cpdf_temp_rec.SCD_rif := NULL;
3749: END IF;
3750:
3751: ELSE -- if NOAC is 817
3752: l_ghr_cpdf_temp_rec.employee_last_name := NULL;
3753: l_ghr_cpdf_temp_rec.employee_first_name := NULL;
3754: l_ghr_cpdf_temp_rec.employee_middle_names := NULL;
3755: l_ghr_cpdf_temp_rec.name_title := NULL;
3756: l_ghr_cpdf_temp_rec.SCD_rif := NULL;
3757: l_ghr_cpdf_temp_rec.SCD_retirement := NULL;
3750:
3751: ELSE -- if NOAC is 817
3752: l_ghr_cpdf_temp_rec.employee_last_name := NULL;
3753: l_ghr_cpdf_temp_rec.employee_first_name := NULL;
3754: l_ghr_cpdf_temp_rec.employee_middle_names := NULL;
3755: l_ghr_cpdf_temp_rec.name_title := NULL;
3756: l_ghr_cpdf_temp_rec.SCD_rif := NULL;
3757: l_ghr_cpdf_temp_rec.SCD_retirement := NULL;
3758: END IF; -- not in 817
3751: ELSE -- if NOAC is 817
3752: l_ghr_cpdf_temp_rec.employee_last_name := NULL;
3753: l_ghr_cpdf_temp_rec.employee_first_name := NULL;
3754: l_ghr_cpdf_temp_rec.employee_middle_names := NULL;
3755: l_ghr_cpdf_temp_rec.name_title := NULL;
3756: l_ghr_cpdf_temp_rec.SCD_rif := NULL;
3757: l_ghr_cpdf_temp_rec.SCD_retirement := NULL;
3758: END IF; -- not in 817
3759: END IF;
3752: l_ghr_cpdf_temp_rec.employee_last_name := NULL;
3753: l_ghr_cpdf_temp_rec.employee_first_name := NULL;
3754: l_ghr_cpdf_temp_rec.employee_middle_names := NULL;
3755: l_ghr_cpdf_temp_rec.name_title := NULL;
3756: l_ghr_cpdf_temp_rec.SCD_rif := NULL;
3757: l_ghr_cpdf_temp_rec.SCD_retirement := NULL;
3758: END IF; -- not in 817
3759: END IF;
3760: -- EHRI changes END
3753: l_ghr_cpdf_temp_rec.employee_first_name := NULL;
3754: l_ghr_cpdf_temp_rec.employee_middle_names := NULL;
3755: l_ghr_cpdf_temp_rec.name_title := NULL;
3756: l_ghr_cpdf_temp_rec.SCD_rif := NULL;
3757: l_ghr_cpdf_temp_rec.SCD_retirement := NULL;
3758: END IF; -- not in 817
3759: END IF;
3760: -- EHRI changes END
3761: --
3767: */
3768: IF l_ghr_pa_requests_rec.first_noa_code = '825'
3769: OR ( l_ghr_pa_requests_rec.first_noa_code = '002' and
3770: l_ghr_pa_requests_rec.second_noa_code = '825' ) THEN
3771: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
3772: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
3773: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
3774: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
3775: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
3768: IF l_ghr_pa_requests_rec.first_noa_code = '825'
3769: OR ( l_ghr_pa_requests_rec.first_noa_code = '002' and
3770: l_ghr_pa_requests_rec.second_noa_code = '825' ) THEN
3771: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
3772: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
3773: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
3774: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
3775: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
3776: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
3769: OR ( l_ghr_pa_requests_rec.first_noa_code = '002' and
3770: l_ghr_pa_requests_rec.second_noa_code = '825' ) THEN
3771: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
3772: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
3773: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
3774: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
3775: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
3776: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
3777: --
3770: l_ghr_pa_requests_rec.second_noa_code = '825' ) THEN
3771: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
3772: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
3773: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
3774: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
3775: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
3776: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
3777: --
3778: l_ghr_pa_requests_rec.to_locality_adj := l_ghr_pa_requests_rec.from_locality_adj;
3771: l_ghr_cpdf_temp_rec.to_pay_plan := l_ghr_pa_requests_rec.from_pay_plan;
3772: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
3773: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
3774: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
3775: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
3776: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
3777: --
3778: l_ghr_pa_requests_rec.to_locality_adj := l_ghr_pa_requests_rec.from_locality_adj;
3779: l_ghr_pa_requests_rec.to_total_salary := l_ghr_pa_requests_rec.from_total_salary;
3772: l_ghr_cpdf_temp_rec.to_occ_code := l_ghr_pa_requests_rec.from_occ_code;
3773: l_ghr_cpdf_temp_rec.to_grade_or_level := l_ghr_pa_requests_rec.from_grade_or_level;
3774: l_ghr_cpdf_temp_rec.to_step_or_rate := l_ghr_pa_requests_rec.from_step_or_rate;
3775: l_ghr_cpdf_temp_rec.to_basic_pay := l_ghr_pa_requests_rec.from_basic_pay; -- format in report
3776: l_ghr_cpdf_temp_rec.to_pay_basis := l_ghr_pa_requests_rec.from_pay_basis;
3777: --
3778: l_ghr_pa_requests_rec.to_locality_adj := l_ghr_pa_requests_rec.from_locality_adj;
3779: l_ghr_pa_requests_rec.to_total_salary := l_ghr_pa_requests_rec.from_total_salary;
3780: l_ghr_pa_requests_rec.to_adj_basic_pay := l_ghr_pa_requests_rec.from_adj_basic_pay;
3778: l_ghr_pa_requests_rec.to_locality_adj := l_ghr_pa_requests_rec.from_locality_adj;
3779: l_ghr_pa_requests_rec.to_total_salary := l_ghr_pa_requests_rec.from_total_salary;
3780: l_ghr_pa_requests_rec.to_adj_basic_pay := l_ghr_pa_requests_rec.from_adj_basic_pay;
3781:
3782: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;
3783: l_ghr_cpdf_temp_rec.position_title := l_ghr_pa_requests_rec.from_position_title;
3784: END IF;
3785:
3786: IF NOT (l_ghr_pa_requests_rec.first_noa_code like '3%'
3779: l_ghr_pa_requests_rec.to_total_salary := l_ghr_pa_requests_rec.from_total_salary;
3780: l_ghr_pa_requests_rec.to_adj_basic_pay := l_ghr_pa_requests_rec.from_adj_basic_pay;
3781:
3782: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;
3783: l_ghr_cpdf_temp_rec.position_title := l_ghr_pa_requests_rec.from_position_title;
3784: END IF;
3785:
3786: IF NOT (l_ghr_pa_requests_rec.first_noa_code like '3%'
3787: OR ( l_ghr_pa_requests_rec.first_noa_code = '002' and
3794: NOT (l_ghr_pa_requests_rec.first_noa_code = '817'
3795: OR ( l_ghr_pa_requests_rec.first_noa_code = '002' and
3796: l_ghr_pa_requests_rec.first_noa_code = '817' ) )
3797: THEN
3798: IF l_ghr_cpdf_temp_rec.to_supervisory_differential IS NULL THEN
3799:
3800: BEGIN
3801: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
3802: ,p_input_value_name => 'Amount'
3801: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
3802: ,p_input_value_name => 'Amount'
3803: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
3804: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
3805: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential
3806: ,p_multiple_error_flag => l_multi_error_flag);
3807: EXCEPTION
3808: WHEN OTHERS THEN
3809: l_message_name := 'retrieve_element_entry_value';
3819: Raise EHRI_DYNRPT_ERROR;
3820: END;
3821:
3822: END IF;
3823: IF l_ghr_cpdf_temp_rec.to_retention_allowance IS NULL THEN
3824:
3825: BEGIN
3826: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
3827: ,p_input_value_name => 'Amount'
3826: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
3827: ,p_input_value_name => 'Amount'
3828: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
3829: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
3830: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance
3831: ,p_multiple_error_flag => l_multi_error_flag);
3832: EXCEPTION
3833: WHEN OTHERS THEN
3834: l_message_name := 'retrieve_element_entry_value';
3867: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
3868: p_per_ei_data => ll_per_ei_data
3869: );
3870:
3871: l_ghr_cpdf_temp_rec.creditable_military_service:= ll_per_ei_data.pei_information5;
3872: ll_per_ei_data :=NULL;
3873:
3874: ghr_history_fetch.fetch_peopleei
3875: (p_person_id => l_ghr_pa_requests_rec.person_id,
3876: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
3877: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
3878: p_per_ei_data => ll_per_ei_data
3879: );
3880: l_ghr_cpdf_temp_rec.from_retirement_coverage := ll_per_ei_data.pei_information4;
3881: l_ghr_cpdf_temp_rec.Frozen_service:= ll_per_ei_data.pei_information5;
3882:
3883: ll_per_ei_data:=NULL;
3884: END IF;
3877: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
3878: p_per_ei_data => ll_per_ei_data
3879: );
3880: l_ghr_cpdf_temp_rec.from_retirement_coverage := ll_per_ei_data.pei_information4;
3881: l_ghr_cpdf_temp_rec.Frozen_service:= ll_per_ei_data.pei_information5;
3882:
3883: ll_per_ei_data:=NULL;
3884: END IF;
3885:
3883: ll_per_ei_data:=NULL;
3884: END IF;
3885:
3886: -- Bug 4714292 EHRI Reports Changes for EOY 05
3887: IF l_ghr_cpdf_temp_rec.from_pay_rate_determinant IN ('5','6','E','F') THEN
3888: l_ghr_cpdf_temp_rec.from_spl_rate_supplement := l_ghr_cpdf_temp_rec.from_locality_adj;
3889: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3890: END IF;
3891:
3884: END IF;
3885:
3886: -- Bug 4714292 EHRI Reports Changes for EOY 05
3887: IF l_ghr_cpdf_temp_rec.from_pay_rate_determinant IN ('5','6','E','F') THEN
3888: l_ghr_cpdf_temp_rec.from_spl_rate_supplement := l_ghr_cpdf_temp_rec.from_locality_adj;
3889: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3890: END IF;
3891:
3892: IF l_ghr_cpdf_temp_rec.to_pay_rate_determinant IN ('5','6','E','F') THEN
3885:
3886: -- Bug 4714292 EHRI Reports Changes for EOY 05
3887: IF l_ghr_cpdf_temp_rec.from_pay_rate_determinant IN ('5','6','E','F') THEN
3888: l_ghr_cpdf_temp_rec.from_spl_rate_supplement := l_ghr_cpdf_temp_rec.from_locality_adj;
3889: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3890: END IF;
3891:
3892: IF l_ghr_cpdf_temp_rec.to_pay_rate_determinant IN ('5','6','E','F') THEN
3893: l_ghr_cpdf_temp_rec.to_spl_rate_supplement := l_ghr_cpdf_temp_rec.to_locality_adj;
3888: l_ghr_cpdf_temp_rec.from_spl_rate_supplement := l_ghr_cpdf_temp_rec.from_locality_adj;
3889: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3890: END IF;
3891:
3892: IF l_ghr_cpdf_temp_rec.to_pay_rate_determinant IN ('5','6','E','F') THEN
3893: l_ghr_cpdf_temp_rec.to_spl_rate_supplement := l_ghr_cpdf_temp_rec.to_locality_adj;
3894: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3895: END IF;
3896:
3889: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3890: END IF;
3891:
3892: IF l_ghr_cpdf_temp_rec.to_pay_rate_determinant IN ('5','6','E','F') THEN
3893: l_ghr_cpdf_temp_rec.to_spl_rate_supplement := l_ghr_cpdf_temp_rec.to_locality_adj;
3894: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3895: END IF;
3896:
3897: -- End Bug 4714292 EHRI Reports Changes for EOY 05
3890: END IF;
3891:
3892: IF l_ghr_cpdf_temp_rec.to_pay_rate_determinant IN ('5','6','E','F') THEN
3893: l_ghr_cpdf_temp_rec.to_spl_rate_supplement := l_ghr_cpdf_temp_rec.to_locality_adj;
3894: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3895: END IF;
3896:
3897: -- End Bug 4714292 EHRI Reports Changes for EOY 05
3898:
3896:
3897: -- End Bug 4714292 EHRI Reports Changes for EOY 05
3898:
3899: -- If Ethnicity is reported, RNO should be null
3900: IF l_ghr_cpdf_temp_rec.race_ethnic_info IS NOT NULL THEN
3901: l_ghr_cpdf_temp_rec.race_national_origin := NULL;
3902: END IF;
3903:
3904: -- Bug 5011003
3897: -- End Bug 4714292 EHRI Reports Changes for EOY 05
3898:
3899: -- If Ethnicity is reported, RNO should be null
3900: IF l_ghr_cpdf_temp_rec.race_ethnic_info IS NOT NULL THEN
3901: l_ghr_cpdf_temp_rec.race_national_origin := NULL;
3902: END IF;
3903:
3904: -- Bug 5011003
3905: l_locality_pay_area_code := get_loc_pay_area_code(p_duty_station_id => l_ghr_pa_requests_rec.duty_station_id,
3905: l_locality_pay_area_code := get_loc_pay_area_code(p_duty_station_id => l_ghr_pa_requests_rec.duty_station_id,
3906: p_effective_date => l_ghr_pa_requests_rec.effective_date);
3907: l_equiv_plan := get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.to_pay_plan));
3908:
3909: IF l_ghr_cpdf_temp_rec.to_pay_rate_determinant IN ('3', 'J', 'K', 'U', 'V', '6', 'E', 'F') THEN
3910: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3911: ELSE
3912:
3913: IF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
3906: p_effective_date => l_ghr_pa_requests_rec.effective_date);
3907: l_equiv_plan := get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.to_pay_plan));
3908:
3909: IF l_ghr_cpdf_temp_rec.to_pay_rate_determinant IN ('3', 'J', 'K', 'U', 'V', '6', 'E', 'F') THEN
3910: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3911: ELSE
3912:
3913: IF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
3914: AND l_equiv_plan = 'GS' THEN
3909: IF l_ghr_cpdf_temp_rec.to_pay_rate_determinant IN ('3', 'J', 'K', 'U', 'V', '6', 'E', 'F') THEN
3910: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3911: ELSE
3912:
3913: IF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
3914: AND l_equiv_plan = 'GS' THEN
3915: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3916: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_equiv_plan = 'GS'
3917: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
3911: ELSE
3912:
3913: IF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
3914: AND l_equiv_plan = 'GS' THEN
3915: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3916: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_equiv_plan = 'GS'
3917: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
3918: l_ghr_cpdf_temp_rec.to_locality_adj := 0;
3919: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
3912:
3913: IF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
3914: AND l_equiv_plan = 'GS' THEN
3915: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3916: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_equiv_plan = 'GS'
3917: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
3918: l_ghr_cpdf_temp_rec.to_locality_adj := 0;
3919: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
3920: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3914: AND l_equiv_plan = 'GS' THEN
3915: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3916: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_equiv_plan = 'GS'
3917: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
3918: l_ghr_cpdf_temp_rec.to_locality_adj := 0;
3919: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
3920: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3921: END IF;
3922:
3915: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3916: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_equiv_plan = 'GS'
3917: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
3918: l_ghr_cpdf_temp_rec.to_locality_adj := 0;
3919: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
3920: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3921: END IF;
3922:
3923: END IF; -- IF PRD IN ('3', 'J', 'K', 'U',
3916: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_equiv_plan = 'GS'
3917: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
3918: l_ghr_cpdf_temp_rec.to_locality_adj := 0;
3919: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
3920: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
3921: END IF;
3922:
3923: END IF; -- IF PRD IN ('3', 'J', 'K', 'U',
3924:
3922:
3923: END IF; -- IF PRD IN ('3', 'J', 'K', 'U',
3924:
3925: -- For Prior locality pay
3926: IF l_ghr_cpdf_temp_rec.from_pay_rate_determinant IN ('3', 'J', 'K', 'U', 'V', '6', 'E', 'F') THEN
3927: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3928: ELSE
3929:
3930: IF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
3923: END IF; -- IF PRD IN ('3', 'J', 'K', 'U',
3924:
3925: -- For Prior locality pay
3926: IF l_ghr_cpdf_temp_rec.from_pay_rate_determinant IN ('3', 'J', 'K', 'U', 'V', '6', 'E', 'F') THEN
3927: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3928: ELSE
3929:
3930: IF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
3931: AND l_equiv_plan = 'GS' THEN
3926: IF l_ghr_cpdf_temp_rec.from_pay_rate_determinant IN ('3', 'J', 'K', 'U', 'V', '6', 'E', 'F') THEN
3927: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3928: ELSE
3929:
3930: IF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
3931: AND l_equiv_plan = 'GS' THEN
3932: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3933: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_equiv_plan = 'GS'
3934: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
3928: ELSE
3929:
3930: IF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
3931: AND l_equiv_plan = 'GS' THEN
3932: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3933: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_equiv_plan = 'GS'
3934: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
3935: l_ghr_cpdf_temp_rec.from_locality_adj := 0;
3936: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
3929:
3930: IF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
3931: AND l_equiv_plan = 'GS' THEN
3932: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3933: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_equiv_plan = 'GS'
3934: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
3935: l_ghr_cpdf_temp_rec.from_locality_adj := 0;
3936: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
3937: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3931: AND l_equiv_plan = 'GS' THEN
3932: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3933: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_equiv_plan = 'GS'
3934: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
3935: l_ghr_cpdf_temp_rec.from_locality_adj := 0;
3936: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
3937: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3938: END IF;
3939:
3932: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3933: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_equiv_plan = 'GS'
3934: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
3935: l_ghr_cpdf_temp_rec.from_locality_adj := 0;
3936: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
3937: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3938: END IF;
3939:
3940: END IF; -- IF PRD IN ('3', 'J', 'K', 'U',
3933: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_equiv_plan = 'GS'
3934: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
3935: l_ghr_cpdf_temp_rec.from_locality_adj := 0;
3936: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
3937: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
3938: END IF;
3939:
3940: END IF; -- IF PRD IN ('3', 'J', 'K', 'U',
3941:
3956: END;
3957: -- End of changes for CPDF reports picking creditable mil serv, frozen serv and prev retirement coverage
3958: -- 3327389 Bug fix end
3959: IF l_ghr_pa_requests_rec.first_noa_code <> '001' THEN
3960: IF l_ghr_cpdf_temp_rec.from_retirement_coverage IS NULL THEN
3961: l_ghr_cpdf_temp_rec.from_retirement_coverage:= 'NA';
3962: ELSIF l_ghr_cpdf_temp_rec.from_retirement_coverage IN ('P','R') THEN --bug#5184157 yogi
3963: l_ghr_cpdf_temp_rec.from_retirement_coverage:= 'Y';
3964: END IF;
3957: -- End of changes for CPDF reports picking creditable mil serv, frozen serv and prev retirement coverage
3958: -- 3327389 Bug fix end
3959: IF l_ghr_pa_requests_rec.first_noa_code <> '001' THEN
3960: IF l_ghr_cpdf_temp_rec.from_retirement_coverage IS NULL THEN
3961: l_ghr_cpdf_temp_rec.from_retirement_coverage:= 'NA';
3962: ELSIF l_ghr_cpdf_temp_rec.from_retirement_coverage IN ('P','R') THEN --bug#5184157 yogi
3963: l_ghr_cpdf_temp_rec.from_retirement_coverage:= 'Y';
3964: END IF;
3965: ELSE
3958: -- 3327389 Bug fix end
3959: IF l_ghr_pa_requests_rec.first_noa_code <> '001' THEN
3960: IF l_ghr_cpdf_temp_rec.from_retirement_coverage IS NULL THEN
3961: l_ghr_cpdf_temp_rec.from_retirement_coverage:= 'NA';
3962: ELSIF l_ghr_cpdf_temp_rec.from_retirement_coverage IN ('P','R') THEN --bug#5184157 yogi
3963: l_ghr_cpdf_temp_rec.from_retirement_coverage:= 'Y';
3964: END IF;
3965: ELSE
3966: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3959: IF l_ghr_pa_requests_rec.first_noa_code <> '001' THEN
3960: IF l_ghr_cpdf_temp_rec.from_retirement_coverage IS NULL THEN
3961: l_ghr_cpdf_temp_rec.from_retirement_coverage:= 'NA';
3962: ELSIF l_ghr_cpdf_temp_rec.from_retirement_coverage IN ('P','R') THEN --bug#5184157 yogi
3963: l_ghr_cpdf_temp_rec.from_retirement_coverage:= 'Y';
3964: END IF;
3965: ELSE
3966: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3967: END If;
3962: ELSIF l_ghr_cpdf_temp_rec.from_retirement_coverage IN ('P','R') THEN --bug#5184157 yogi
3963: l_ghr_cpdf_temp_rec.from_retirement_coverage:= 'Y';
3964: END IF;
3965: ELSE
3966: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
3967: END If;
3968:
3969:
3970: --Bug #6158983 EHRI Status and Dynamic Report Changes
3988: ,p_value => l_value
3989: ,p_effective_start_date => l_effective_start_date
3990: ,p_business_group_id => l_business_group_id);
3991:
3992: l_ghr_cpdf_temp_rec.health_plan := l_value;
3993: l_ghr_cpdf_temp_rec.fehb_elect_eff_date := l_effective_start_date;
3994: -- Reporting Plan + Enrollment as Health Plan.
3995: l_message_name := 'Fetch HB Pre Tax Enroll';
3996:
3989: ,p_effective_start_date => l_effective_start_date
3990: ,p_business_group_id => l_business_group_id);
3991:
3992: l_ghr_cpdf_temp_rec.health_plan := l_value;
3993: l_ghr_cpdf_temp_rec.fehb_elect_eff_date := l_effective_start_date;
3994: -- Reporting Plan + Enrollment as Health Plan.
3995: l_message_name := 'Fetch HB Pre Tax Enroll';
3996:
3997: l_value := null;
4005: ,p_effective_start_date => l_effective_start_date
4006: ,p_business_group_id => l_business_group_id);
4007:
4008:
4009: l_ghr_cpdf_temp_rec.health_plan := l_ghr_cpdf_temp_rec.health_plan||l_value;
4010:
4011: if l_ghr_cpdf_temp_rec.health_plan is Null then
4012:
4013: l_message_name := 'Fetch HB plan';
4007:
4008:
4009: l_ghr_cpdf_temp_rec.health_plan := l_ghr_cpdf_temp_rec.health_plan||l_value;
4010:
4011: if l_ghr_cpdf_temp_rec.health_plan is Null then
4012:
4013: l_message_name := 'Fetch HB plan';
4014: ghr_per_sum.get_element_details
4015: (p_element_name => 'Health Benefits'
4019: ,p_value => l_value
4020: ,p_effective_start_date => l_effective_start_date
4021: ,p_business_group_id => l_business_group_id);
4022:
4023: l_ghr_cpdf_temp_rec.health_plan := l_value;
4024: l_ghr_cpdf_temp_rec.fehb_elect_eff_date := l_effective_start_date;
4025: -- Reporting Plan + Enrollment as Health Plan.
4026: l_message_name := 'Fetch HB Enrollment';
4027: l_value := null;
4020: ,p_effective_start_date => l_effective_start_date
4021: ,p_business_group_id => l_business_group_id);
4022:
4023: l_ghr_cpdf_temp_rec.health_plan := l_value;
4024: l_ghr_cpdf_temp_rec.fehb_elect_eff_date := l_effective_start_date;
4025: -- Reporting Plan + Enrollment as Health Plan.
4026: l_message_name := 'Fetch HB Enrollment';
4027: l_value := null;
4028: l_effective_start_date := null;
4034: ,p_value => l_value
4035: ,p_effective_start_date => l_effective_start_date
4036: ,p_business_group_id => l_business_group_id);
4037:
4038: l_ghr_cpdf_temp_rec.health_plan := l_ghr_cpdf_temp_rec.health_plan||l_value;
4039: end if;
4040:
4041: EXCEPTION
4042: WHEN OTHERS THEN
4065: p_per_ei_data => ll_per_ei_data
4066: );
4067:
4068:
4069: l_ghr_cpdf_temp_rec.SPECIAL_POPULATION_CODE := ll_per_ei_data.pei_information1;
4070: l_ghr_cpdf_temp_rec.CSRS_EXC_APPTS := ll_per_ei_data.pei_information2;
4071: l_ghr_cpdf_temp_rec.FERS_EXC_APPTS := ll_per_ei_data.pei_information3;
4072: l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND1 := ll_per_ei_data.pei_information4;
4073: l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND2 := ll_per_ei_data.pei_information5;
4066: );
4067:
4068:
4069: l_ghr_cpdf_temp_rec.SPECIAL_POPULATION_CODE := ll_per_ei_data.pei_information1;
4070: l_ghr_cpdf_temp_rec.CSRS_EXC_APPTS := ll_per_ei_data.pei_information2;
4071: l_ghr_cpdf_temp_rec.FERS_EXC_APPTS := ll_per_ei_data.pei_information3;
4072: l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND1 := ll_per_ei_data.pei_information4;
4073: l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND2 := ll_per_ei_data.pei_information5;
4074: EXCEPTION
4067:
4068:
4069: l_ghr_cpdf_temp_rec.SPECIAL_POPULATION_CODE := ll_per_ei_data.pei_information1;
4070: l_ghr_cpdf_temp_rec.CSRS_EXC_APPTS := ll_per_ei_data.pei_information2;
4071: l_ghr_cpdf_temp_rec.FERS_EXC_APPTS := ll_per_ei_data.pei_information3;
4072: l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND1 := ll_per_ei_data.pei_information4;
4073: l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND2 := ll_per_ei_data.pei_information5;
4074: EXCEPTION
4075:
4068:
4069: l_ghr_cpdf_temp_rec.SPECIAL_POPULATION_CODE := ll_per_ei_data.pei_information1;
4070: l_ghr_cpdf_temp_rec.CSRS_EXC_APPTS := ll_per_ei_data.pei_information2;
4071: l_ghr_cpdf_temp_rec.FERS_EXC_APPTS := ll_per_ei_data.pei_information3;
4072: l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND1 := ll_per_ei_data.pei_information4;
4073: l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND2 := ll_per_ei_data.pei_information5;
4074: EXCEPTION
4075:
4076: WHEN OTHERS THEN
4069: l_ghr_cpdf_temp_rec.SPECIAL_POPULATION_CODE := ll_per_ei_data.pei_information1;
4070: l_ghr_cpdf_temp_rec.CSRS_EXC_APPTS := ll_per_ei_data.pei_information2;
4071: l_ghr_cpdf_temp_rec.FERS_EXC_APPTS := ll_per_ei_data.pei_information3;
4072: l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND1 := ll_per_ei_data.pei_information4;
4073: l_ghr_cpdf_temp_rec.FICA_COVERAGE_IND2 := ll_per_ei_data.pei_information5;
4074: EXCEPTION
4075:
4076: WHEN OTHERS THEN
4077:
4095: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
4096: p_per_ei_data => ll_per_ei_data
4097: );
4098:
4099: l_ghr_cpdf_temp_rec.FEGLI_ASSG_INDICATOR := ll_per_ei_data.pei_information16;
4100: l_ghr_cpdf_temp_rec.FEGLI_POST_ELC_BASIC_INS_AMT:= ll_per_ei_data.pei_information17;
4101: l_ghr_cpdf_temp_rec.FEGLI_COURT_ORD_IND := ll_per_ei_data.pei_information18;
4102: l_ghr_cpdf_temp_rec.FEGLI_BENF_DESG_IND := ll_per_ei_data.pei_information19;
4103: l_ghr_cpdf_temp_rec.FEHB_EVENT_CODE := ll_per_ei_data.pei_information20;
4096: p_per_ei_data => ll_per_ei_data
4097: );
4098:
4099: l_ghr_cpdf_temp_rec.FEGLI_ASSG_INDICATOR := ll_per_ei_data.pei_information16;
4100: l_ghr_cpdf_temp_rec.FEGLI_POST_ELC_BASIC_INS_AMT:= ll_per_ei_data.pei_information17;
4101: l_ghr_cpdf_temp_rec.FEGLI_COURT_ORD_IND := ll_per_ei_data.pei_information18;
4102: l_ghr_cpdf_temp_rec.FEGLI_BENF_DESG_IND := ll_per_ei_data.pei_information19;
4103: l_ghr_cpdf_temp_rec.FEHB_EVENT_CODE := ll_per_ei_data.pei_information20;
4104:
4097: );
4098:
4099: l_ghr_cpdf_temp_rec.FEGLI_ASSG_INDICATOR := ll_per_ei_data.pei_information16;
4100: l_ghr_cpdf_temp_rec.FEGLI_POST_ELC_BASIC_INS_AMT:= ll_per_ei_data.pei_information17;
4101: l_ghr_cpdf_temp_rec.FEGLI_COURT_ORD_IND := ll_per_ei_data.pei_information18;
4102: l_ghr_cpdf_temp_rec.FEGLI_BENF_DESG_IND := ll_per_ei_data.pei_information19;
4103: l_ghr_cpdf_temp_rec.FEHB_EVENT_CODE := ll_per_ei_data.pei_information20;
4104:
4105: EXCEPTION
4098:
4099: l_ghr_cpdf_temp_rec.FEGLI_ASSG_INDICATOR := ll_per_ei_data.pei_information16;
4100: l_ghr_cpdf_temp_rec.FEGLI_POST_ELC_BASIC_INS_AMT:= ll_per_ei_data.pei_information17;
4101: l_ghr_cpdf_temp_rec.FEGLI_COURT_ORD_IND := ll_per_ei_data.pei_information18;
4102: l_ghr_cpdf_temp_rec.FEGLI_BENF_DESG_IND := ll_per_ei_data.pei_information19;
4103: l_ghr_cpdf_temp_rec.FEHB_EVENT_CODE := ll_per_ei_data.pei_information20;
4104:
4105: EXCEPTION
4106:
4099: l_ghr_cpdf_temp_rec.FEGLI_ASSG_INDICATOR := ll_per_ei_data.pei_information16;
4100: l_ghr_cpdf_temp_rec.FEGLI_POST_ELC_BASIC_INS_AMT:= ll_per_ei_data.pei_information17;
4101: l_ghr_cpdf_temp_rec.FEGLI_COURT_ORD_IND := ll_per_ei_data.pei_information18;
4102: l_ghr_cpdf_temp_rec.FEGLI_BENF_DESG_IND := ll_per_ei_data.pei_information19;
4103: l_ghr_cpdf_temp_rec.FEHB_EVENT_CODE := ll_per_ei_data.pei_information20;
4104:
4105: EXCEPTION
4106:
4107: WHEN OTHERS THEN
4119: END;*/
4120: --bug #6416590 moving sf50_approval_date to pareq_last_updated_date
4121: -- as sf50_approval_date has to be considered for ordering of sequence number
4122: --with in effective date
4123: l_ghr_cpdf_temp_rec.pareq_last_updated_date := l_ghr_pa_requests_rec.sf50_approval_date;
4124: --End of Bug#6158983
4125:
4126:
4127: insert_row(l_ghr_cpdf_temp_rec);
4123: l_ghr_cpdf_temp_rec.pareq_last_updated_date := l_ghr_pa_requests_rec.sf50_approval_date;
4124: --End of Bug#6158983
4125:
4126:
4127: insert_row(l_ghr_cpdf_temp_rec);
4128: l_records_found:=TRUE;
4129: --
4130: <
4131: NULL;
4183: --
4184: hr_utility.set_location('Leaving:'||l_proc, 99);
4185: -- hr_utility.trace_off;
4186: --
4187: END populate_ghr_cpdf_temp;
4188:
4189:
4190: ---------------------------------------------------------------------------------------------
4191: -- This is the Main procedure called from the concurrent program
4223: l_start_date := fnd_date.canonical_to_date(p_start_date);
4224: l_end_date := fnd_date.canonical_to_date(p_end_date);
4225: l_ret_code := 0;
4226: --
4227: populate_ghr_cpdf_temp(p_agency_code||NVL(p_agency_subelement,'%'),l_start_date,l_end_date,FALSE);
4228: -- Generate ASCII and XML files
4229: WritetoFile(l_report_name,p_gen_xml_file,p_gen_txt_file);
4230:
4231: -- Purge the table contents after reporting