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

APPS.GHR_CPDF_DYNRPT dependencies on GHR_CPDF_TEMP

Line 19: DELETE FROM ghr_cpdf_temp

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;

Line 957: -- This will insert one record into the GHR_CPDF_TEMP

953: END format_award_perc;
954: --
955:
956: ---------------------------------------------------------------------------------------------
957: -- This will insert one record into the GHR_CPDF_TEMP
958: ---------------------------------------------------------------------------------------------
959: PROCEDURE insert_row (p_ghr_cpdf_temp_rec IN ghr_cpdf_temp%rowtype) IS
960: BEGIN
961: INSERT INTO ghr_cpdf_temp(

Line 959: PROCEDURE insert_row (p_ghr_cpdf_temp_rec IN ghr_cpdf_temp%rowtype) IS

955:
956: ---------------------------------------------------------------------------------------------
957: -- This will insert one record into the GHR_CPDF_TEMP
958: ---------------------------------------------------------------------------------------------
959: PROCEDURE insert_row (p_ghr_cpdf_temp_rec IN ghr_cpdf_temp%rowtype) IS
960: BEGIN
961: INSERT INTO ghr_cpdf_temp(
962: report_type,
963: session_id,

Line 961: INSERT INTO ghr_cpdf_temp(

957: -- This will insert one record into the GHR_CPDF_TEMP
958: ---------------------------------------------------------------------------------------------
959: PROCEDURE insert_row (p_ghr_cpdf_temp_rec IN ghr_cpdf_temp%rowtype) IS
960: BEGIN
961: INSERT INTO ghr_cpdf_temp(
962: report_type,
963: session_id,
964: agency_code,
965: organizational_component,

Line 1038: p_ghr_cpdf_temp_rec.agency_code,

1034: )
1035: VALUES(
1036: 'DYNAMICS',
1037: USERENV('SESSIONID'),
1038: p_ghr_cpdf_temp_rec.agency_code,
1039: p_ghr_cpdf_temp_rec.organizational_component,
1040: p_ghr_cpdf_temp_rec.personnel_office_id,
1041: p_ghr_cpdf_temp_rec.to_national_identifier,
1042: p_ghr_cpdf_temp_rec.employee_date_of_birth,

Line 1039: p_ghr_cpdf_temp_rec.organizational_component,

1035: VALUES(
1036: 'DYNAMICS',
1037: USERENV('SESSIONID'),
1038: p_ghr_cpdf_temp_rec.agency_code,
1039: p_ghr_cpdf_temp_rec.organizational_component,
1040: p_ghr_cpdf_temp_rec.personnel_office_id,
1041: p_ghr_cpdf_temp_rec.to_national_identifier,
1042: p_ghr_cpdf_temp_rec.employee_date_of_birth,
1043: p_ghr_cpdf_temp_rec.veterans_preference,

Line 1040: p_ghr_cpdf_temp_rec.personnel_office_id,

1036: 'DYNAMICS',
1037: USERENV('SESSIONID'),
1038: p_ghr_cpdf_temp_rec.agency_code,
1039: p_ghr_cpdf_temp_rec.organizational_component,
1040: p_ghr_cpdf_temp_rec.personnel_office_id,
1041: p_ghr_cpdf_temp_rec.to_national_identifier,
1042: p_ghr_cpdf_temp_rec.employee_date_of_birth,
1043: p_ghr_cpdf_temp_rec.veterans_preference,
1044: p_ghr_cpdf_temp_rec.tenure,

Line 1041: p_ghr_cpdf_temp_rec.to_national_identifier,

1037: USERENV('SESSIONID'),
1038: p_ghr_cpdf_temp_rec.agency_code,
1039: p_ghr_cpdf_temp_rec.organizational_component,
1040: p_ghr_cpdf_temp_rec.personnel_office_id,
1041: p_ghr_cpdf_temp_rec.to_national_identifier,
1042: p_ghr_cpdf_temp_rec.employee_date_of_birth,
1043: p_ghr_cpdf_temp_rec.veterans_preference,
1044: p_ghr_cpdf_temp_rec.tenure,
1045: p_ghr_cpdf_temp_rec.service_comp_date,

Line 1042: p_ghr_cpdf_temp_rec.employee_date_of_birth,

1038: p_ghr_cpdf_temp_rec.agency_code,
1039: p_ghr_cpdf_temp_rec.organizational_component,
1040: p_ghr_cpdf_temp_rec.personnel_office_id,
1041: p_ghr_cpdf_temp_rec.to_national_identifier,
1042: p_ghr_cpdf_temp_rec.employee_date_of_birth,
1043: p_ghr_cpdf_temp_rec.veterans_preference,
1044: p_ghr_cpdf_temp_rec.tenure,
1045: p_ghr_cpdf_temp_rec.service_comp_date,
1046: p_ghr_cpdf_temp_rec.retirement_plan,

Line 1043: p_ghr_cpdf_temp_rec.veterans_preference,

1039: p_ghr_cpdf_temp_rec.organizational_component,
1040: p_ghr_cpdf_temp_rec.personnel_office_id,
1041: p_ghr_cpdf_temp_rec.to_national_identifier,
1042: p_ghr_cpdf_temp_rec.employee_date_of_birth,
1043: p_ghr_cpdf_temp_rec.veterans_preference,
1044: p_ghr_cpdf_temp_rec.tenure,
1045: p_ghr_cpdf_temp_rec.service_comp_date,
1046: p_ghr_cpdf_temp_rec.retirement_plan,
1047: p_ghr_cpdf_temp_rec.creditable_military_service,

Line 1044: p_ghr_cpdf_temp_rec.tenure,

1040: p_ghr_cpdf_temp_rec.personnel_office_id,
1041: p_ghr_cpdf_temp_rec.to_national_identifier,
1042: p_ghr_cpdf_temp_rec.employee_date_of_birth,
1043: p_ghr_cpdf_temp_rec.veterans_preference,
1044: p_ghr_cpdf_temp_rec.tenure,
1045: p_ghr_cpdf_temp_rec.service_comp_date,
1046: p_ghr_cpdf_temp_rec.retirement_plan,
1047: p_ghr_cpdf_temp_rec.creditable_military_service,
1048: p_ghr_cpdf_temp_rec.frozen_service,

Line 1045: p_ghr_cpdf_temp_rec.service_comp_date,

1041: p_ghr_cpdf_temp_rec.to_national_identifier,
1042: p_ghr_cpdf_temp_rec.employee_date_of_birth,
1043: p_ghr_cpdf_temp_rec.veterans_preference,
1044: p_ghr_cpdf_temp_rec.tenure,
1045: p_ghr_cpdf_temp_rec.service_comp_date,
1046: p_ghr_cpdf_temp_rec.retirement_plan,
1047: p_ghr_cpdf_temp_rec.creditable_military_service,
1048: p_ghr_cpdf_temp_rec.frozen_service,
1049: p_ghr_cpdf_temp_rec.from_retirement_coverage,

Line 1046: p_ghr_cpdf_temp_rec.retirement_plan,

1042: p_ghr_cpdf_temp_rec.employee_date_of_birth,
1043: p_ghr_cpdf_temp_rec.veterans_preference,
1044: p_ghr_cpdf_temp_rec.tenure,
1045: p_ghr_cpdf_temp_rec.service_comp_date,
1046: p_ghr_cpdf_temp_rec.retirement_plan,
1047: p_ghr_cpdf_temp_rec.creditable_military_service,
1048: p_ghr_cpdf_temp_rec.frozen_service,
1049: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1050: p_ghr_cpdf_temp_rec.veterans_status,

Line 1047: p_ghr_cpdf_temp_rec.creditable_military_service,

1043: p_ghr_cpdf_temp_rec.veterans_preference,
1044: p_ghr_cpdf_temp_rec.tenure,
1045: p_ghr_cpdf_temp_rec.service_comp_date,
1046: p_ghr_cpdf_temp_rec.retirement_plan,
1047: p_ghr_cpdf_temp_rec.creditable_military_service,
1048: p_ghr_cpdf_temp_rec.frozen_service,
1049: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1050: p_ghr_cpdf_temp_rec.veterans_status,
1051: p_ghr_cpdf_temp_rec.sex,

Line 1048: p_ghr_cpdf_temp_rec.frozen_service,

1044: p_ghr_cpdf_temp_rec.tenure,
1045: p_ghr_cpdf_temp_rec.service_comp_date,
1046: p_ghr_cpdf_temp_rec.retirement_plan,
1047: p_ghr_cpdf_temp_rec.creditable_military_service,
1048: p_ghr_cpdf_temp_rec.frozen_service,
1049: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1050: p_ghr_cpdf_temp_rec.veterans_status,
1051: p_ghr_cpdf_temp_rec.sex,
1052: p_ghr_cpdf_temp_rec.race_national_origin,

Line 1049: p_ghr_cpdf_temp_rec.from_retirement_coverage,

1045: p_ghr_cpdf_temp_rec.service_comp_date,
1046: p_ghr_cpdf_temp_rec.retirement_plan,
1047: p_ghr_cpdf_temp_rec.creditable_military_service,
1048: p_ghr_cpdf_temp_rec.frozen_service,
1049: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1050: p_ghr_cpdf_temp_rec.veterans_status,
1051: p_ghr_cpdf_temp_rec.sex,
1052: p_ghr_cpdf_temp_rec.race_national_origin,
1053: p_ghr_cpdf_temp_rec.handicap_code,

Line 1050: p_ghr_cpdf_temp_rec.veterans_status,

1046: p_ghr_cpdf_temp_rec.retirement_plan,
1047: p_ghr_cpdf_temp_rec.creditable_military_service,
1048: p_ghr_cpdf_temp_rec.frozen_service,
1049: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1050: p_ghr_cpdf_temp_rec.veterans_status,
1051: p_ghr_cpdf_temp_rec.sex,
1052: p_ghr_cpdf_temp_rec.race_national_origin,
1053: p_ghr_cpdf_temp_rec.handicap_code,
1054: p_ghr_cpdf_temp_rec.first_noa_code,

Line 1051: p_ghr_cpdf_temp_rec.sex,

1047: p_ghr_cpdf_temp_rec.creditable_military_service,
1048: p_ghr_cpdf_temp_rec.frozen_service,
1049: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1050: p_ghr_cpdf_temp_rec.veterans_status,
1051: p_ghr_cpdf_temp_rec.sex,
1052: p_ghr_cpdf_temp_rec.race_national_origin,
1053: p_ghr_cpdf_temp_rec.handicap_code,
1054: p_ghr_cpdf_temp_rec.first_noa_code,
1055: p_ghr_cpdf_temp_rec.second_noa_code,

Line 1052: p_ghr_cpdf_temp_rec.race_national_origin,

1048: p_ghr_cpdf_temp_rec.frozen_service,
1049: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1050: p_ghr_cpdf_temp_rec.veterans_status,
1051: p_ghr_cpdf_temp_rec.sex,
1052: p_ghr_cpdf_temp_rec.race_national_origin,
1053: p_ghr_cpdf_temp_rec.handicap_code,
1054: p_ghr_cpdf_temp_rec.first_noa_code,
1055: p_ghr_cpdf_temp_rec.second_noa_code,
1056: p_ghr_cpdf_temp_rec.first_action_la_code1,

Line 1053: p_ghr_cpdf_temp_rec.handicap_code,

1049: p_ghr_cpdf_temp_rec.from_retirement_coverage,
1050: p_ghr_cpdf_temp_rec.veterans_status,
1051: p_ghr_cpdf_temp_rec.sex,
1052: p_ghr_cpdf_temp_rec.race_national_origin,
1053: p_ghr_cpdf_temp_rec.handicap_code,
1054: p_ghr_cpdf_temp_rec.first_noa_code,
1055: p_ghr_cpdf_temp_rec.second_noa_code,
1056: p_ghr_cpdf_temp_rec.first_action_la_code1,
1057: p_ghr_cpdf_temp_rec.first_action_la_code2,

Line 1054: p_ghr_cpdf_temp_rec.first_noa_code,

1050: p_ghr_cpdf_temp_rec.veterans_status,
1051: p_ghr_cpdf_temp_rec.sex,
1052: p_ghr_cpdf_temp_rec.race_national_origin,
1053: p_ghr_cpdf_temp_rec.handicap_code,
1054: p_ghr_cpdf_temp_rec.first_noa_code,
1055: p_ghr_cpdf_temp_rec.second_noa_code,
1056: p_ghr_cpdf_temp_rec.first_action_la_code1,
1057: p_ghr_cpdf_temp_rec.first_action_la_code2,
1058: p_ghr_cpdf_temp_rec.effective_date,

Line 1055: p_ghr_cpdf_temp_rec.second_noa_code,

1051: p_ghr_cpdf_temp_rec.sex,
1052: p_ghr_cpdf_temp_rec.race_national_origin,
1053: p_ghr_cpdf_temp_rec.handicap_code,
1054: p_ghr_cpdf_temp_rec.first_noa_code,
1055: p_ghr_cpdf_temp_rec.second_noa_code,
1056: p_ghr_cpdf_temp_rec.first_action_la_code1,
1057: p_ghr_cpdf_temp_rec.first_action_la_code2,
1058: p_ghr_cpdf_temp_rec.effective_date,
1059: p_ghr_cpdf_temp_rec.to_pay_plan,

Line 1056: p_ghr_cpdf_temp_rec.first_action_la_code1,

1052: p_ghr_cpdf_temp_rec.race_national_origin,
1053: p_ghr_cpdf_temp_rec.handicap_code,
1054: p_ghr_cpdf_temp_rec.first_noa_code,
1055: p_ghr_cpdf_temp_rec.second_noa_code,
1056: p_ghr_cpdf_temp_rec.first_action_la_code1,
1057: p_ghr_cpdf_temp_rec.first_action_la_code2,
1058: p_ghr_cpdf_temp_rec.effective_date,
1059: p_ghr_cpdf_temp_rec.to_pay_plan,
1060: p_ghr_cpdf_temp_rec.to_occ_code,

Line 1057: p_ghr_cpdf_temp_rec.first_action_la_code2,

1053: p_ghr_cpdf_temp_rec.handicap_code,
1054: p_ghr_cpdf_temp_rec.first_noa_code,
1055: p_ghr_cpdf_temp_rec.second_noa_code,
1056: p_ghr_cpdf_temp_rec.first_action_la_code1,
1057: p_ghr_cpdf_temp_rec.first_action_la_code2,
1058: p_ghr_cpdf_temp_rec.effective_date,
1059: p_ghr_cpdf_temp_rec.to_pay_plan,
1060: p_ghr_cpdf_temp_rec.to_occ_code,
1061: p_ghr_cpdf_temp_rec.to_grade_or_level,

Line 1058: p_ghr_cpdf_temp_rec.effective_date,

1054: p_ghr_cpdf_temp_rec.first_noa_code,
1055: p_ghr_cpdf_temp_rec.second_noa_code,
1056: p_ghr_cpdf_temp_rec.first_action_la_code1,
1057: p_ghr_cpdf_temp_rec.first_action_la_code2,
1058: p_ghr_cpdf_temp_rec.effective_date,
1059: p_ghr_cpdf_temp_rec.to_pay_plan,
1060: p_ghr_cpdf_temp_rec.to_occ_code,
1061: p_ghr_cpdf_temp_rec.to_grade_or_level,
1062: p_ghr_cpdf_temp_rec.to_step_or_rate,

Line 1059: p_ghr_cpdf_temp_rec.to_pay_plan,

1055: p_ghr_cpdf_temp_rec.second_noa_code,
1056: p_ghr_cpdf_temp_rec.first_action_la_code1,
1057: p_ghr_cpdf_temp_rec.first_action_la_code2,
1058: p_ghr_cpdf_temp_rec.effective_date,
1059: p_ghr_cpdf_temp_rec.to_pay_plan,
1060: p_ghr_cpdf_temp_rec.to_occ_code,
1061: p_ghr_cpdf_temp_rec.to_grade_or_level,
1062: p_ghr_cpdf_temp_rec.to_step_or_rate,
1063: p_ghr_cpdf_temp_rec.to_basic_pay,

Line 1060: p_ghr_cpdf_temp_rec.to_occ_code,

1056: p_ghr_cpdf_temp_rec.first_action_la_code1,
1057: p_ghr_cpdf_temp_rec.first_action_la_code2,
1058: p_ghr_cpdf_temp_rec.effective_date,
1059: p_ghr_cpdf_temp_rec.to_pay_plan,
1060: p_ghr_cpdf_temp_rec.to_occ_code,
1061: p_ghr_cpdf_temp_rec.to_grade_or_level,
1062: p_ghr_cpdf_temp_rec.to_step_or_rate,
1063: p_ghr_cpdf_temp_rec.to_basic_pay,
1064: p_ghr_cpdf_temp_rec.to_pay_basis,

Line 1061: p_ghr_cpdf_temp_rec.to_grade_or_level,

1057: p_ghr_cpdf_temp_rec.first_action_la_code2,
1058: p_ghr_cpdf_temp_rec.effective_date,
1059: p_ghr_cpdf_temp_rec.to_pay_plan,
1060: p_ghr_cpdf_temp_rec.to_occ_code,
1061: p_ghr_cpdf_temp_rec.to_grade_or_level,
1062: p_ghr_cpdf_temp_rec.to_step_or_rate,
1063: p_ghr_cpdf_temp_rec.to_basic_pay,
1064: p_ghr_cpdf_temp_rec.to_pay_basis,
1065: p_ghr_cpdf_temp_rec.to_work_schedule,

Line 1062: p_ghr_cpdf_temp_rec.to_step_or_rate,

1058: p_ghr_cpdf_temp_rec.effective_date,
1059: p_ghr_cpdf_temp_rec.to_pay_plan,
1060: p_ghr_cpdf_temp_rec.to_occ_code,
1061: p_ghr_cpdf_temp_rec.to_grade_or_level,
1062: p_ghr_cpdf_temp_rec.to_step_or_rate,
1063: p_ghr_cpdf_temp_rec.to_basic_pay,
1064: p_ghr_cpdf_temp_rec.to_pay_basis,
1065: p_ghr_cpdf_temp_rec.to_work_schedule,
1066: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,

Line 1063: p_ghr_cpdf_temp_rec.to_basic_pay,

1059: p_ghr_cpdf_temp_rec.to_pay_plan,
1060: p_ghr_cpdf_temp_rec.to_occ_code,
1061: p_ghr_cpdf_temp_rec.to_grade_or_level,
1062: p_ghr_cpdf_temp_rec.to_step_or_rate,
1063: p_ghr_cpdf_temp_rec.to_basic_pay,
1064: p_ghr_cpdf_temp_rec.to_pay_basis,
1065: p_ghr_cpdf_temp_rec.to_work_schedule,
1066: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1067: p_ghr_cpdf_temp_rec.position_occupied,

Line 1064: p_ghr_cpdf_temp_rec.to_pay_basis,

1060: p_ghr_cpdf_temp_rec.to_occ_code,
1061: p_ghr_cpdf_temp_rec.to_grade_or_level,
1062: p_ghr_cpdf_temp_rec.to_step_or_rate,
1063: p_ghr_cpdf_temp_rec.to_basic_pay,
1064: p_ghr_cpdf_temp_rec.to_pay_basis,
1065: p_ghr_cpdf_temp_rec.to_work_schedule,
1066: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1067: p_ghr_cpdf_temp_rec.position_occupied,
1068: p_ghr_cpdf_temp_rec.supervisory_status,

Line 1065: p_ghr_cpdf_temp_rec.to_work_schedule,

1061: p_ghr_cpdf_temp_rec.to_grade_or_level,
1062: p_ghr_cpdf_temp_rec.to_step_or_rate,
1063: p_ghr_cpdf_temp_rec.to_basic_pay,
1064: p_ghr_cpdf_temp_rec.to_pay_basis,
1065: p_ghr_cpdf_temp_rec.to_work_schedule,
1066: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1067: p_ghr_cpdf_temp_rec.position_occupied,
1068: p_ghr_cpdf_temp_rec.supervisory_status,
1069: p_ghr_cpdf_temp_rec.to_duty_station_code,

Line 1066: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,

1062: p_ghr_cpdf_temp_rec.to_step_or_rate,
1063: p_ghr_cpdf_temp_rec.to_basic_pay,
1064: p_ghr_cpdf_temp_rec.to_pay_basis,
1065: p_ghr_cpdf_temp_rec.to_work_schedule,
1066: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1067: p_ghr_cpdf_temp_rec.position_occupied,
1068: p_ghr_cpdf_temp_rec.supervisory_status,
1069: p_ghr_cpdf_temp_rec.to_duty_station_code,
1070: p_ghr_cpdf_temp_rec.current_appointment_auth1,

Line 1067: p_ghr_cpdf_temp_rec.position_occupied,

1063: p_ghr_cpdf_temp_rec.to_basic_pay,
1064: p_ghr_cpdf_temp_rec.to_pay_basis,
1065: p_ghr_cpdf_temp_rec.to_work_schedule,
1066: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1067: p_ghr_cpdf_temp_rec.position_occupied,
1068: p_ghr_cpdf_temp_rec.supervisory_status,
1069: p_ghr_cpdf_temp_rec.to_duty_station_code,
1070: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1071: p_ghr_cpdf_temp_rec.current_appointment_auth2,

Line 1068: p_ghr_cpdf_temp_rec.supervisory_status,

1064: p_ghr_cpdf_temp_rec.to_pay_basis,
1065: p_ghr_cpdf_temp_rec.to_work_schedule,
1066: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1067: p_ghr_cpdf_temp_rec.position_occupied,
1068: p_ghr_cpdf_temp_rec.supervisory_status,
1069: p_ghr_cpdf_temp_rec.to_duty_station_code,
1070: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1071: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1072: p_ghr_cpdf_temp_rec.rating_of_record_level,

Line 1069: p_ghr_cpdf_temp_rec.to_duty_station_code,

1065: p_ghr_cpdf_temp_rec.to_work_schedule,
1066: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1067: p_ghr_cpdf_temp_rec.position_occupied,
1068: p_ghr_cpdf_temp_rec.supervisory_status,
1069: p_ghr_cpdf_temp_rec.to_duty_station_code,
1070: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1071: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1072: p_ghr_cpdf_temp_rec.rating_of_record_level,
1073: p_ghr_cpdf_temp_rec.rating_of_record_pattern,

Line 1070: p_ghr_cpdf_temp_rec.current_appointment_auth1,

1066: p_ghr_cpdf_temp_rec.to_pay_rate_determinant,
1067: p_ghr_cpdf_temp_rec.position_occupied,
1068: p_ghr_cpdf_temp_rec.supervisory_status,
1069: p_ghr_cpdf_temp_rec.to_duty_station_code,
1070: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1071: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1072: p_ghr_cpdf_temp_rec.rating_of_record_level,
1073: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1074: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,

Line 1071: p_ghr_cpdf_temp_rec.current_appointment_auth2,

1067: p_ghr_cpdf_temp_rec.position_occupied,
1068: p_ghr_cpdf_temp_rec.supervisory_status,
1069: p_ghr_cpdf_temp_rec.to_duty_station_code,
1070: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1071: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1072: p_ghr_cpdf_temp_rec.rating_of_record_level,
1073: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1074: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1075: p_ghr_cpdf_temp_rec.individual_group_award,

Line 1072: p_ghr_cpdf_temp_rec.rating_of_record_level,

1068: p_ghr_cpdf_temp_rec.supervisory_status,
1069: p_ghr_cpdf_temp_rec.to_duty_station_code,
1070: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1071: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1072: p_ghr_cpdf_temp_rec.rating_of_record_level,
1073: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1074: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1075: p_ghr_cpdf_temp_rec.individual_group_award,
1076: p_ghr_cpdf_temp_rec.award_amount,

Line 1073: p_ghr_cpdf_temp_rec.rating_of_record_pattern,

1069: p_ghr_cpdf_temp_rec.to_duty_station_code,
1070: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1071: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1072: p_ghr_cpdf_temp_rec.rating_of_record_level,
1073: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1074: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1075: p_ghr_cpdf_temp_rec.individual_group_award,
1076: p_ghr_cpdf_temp_rec.award_amount,
1077: p_ghr_cpdf_temp_rec.benefit_amount,

Line 1074: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,

1070: p_ghr_cpdf_temp_rec.current_appointment_auth1,
1071: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1072: p_ghr_cpdf_temp_rec.rating_of_record_level,
1073: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1074: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1075: p_ghr_cpdf_temp_rec.individual_group_award,
1076: p_ghr_cpdf_temp_rec.award_amount,
1077: p_ghr_cpdf_temp_rec.benefit_amount,
1078: p_ghr_cpdf_temp_rec.employee_last_name,

Line 1075: p_ghr_cpdf_temp_rec.individual_group_award,

1071: p_ghr_cpdf_temp_rec.current_appointment_auth2,
1072: p_ghr_cpdf_temp_rec.rating_of_record_level,
1073: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1074: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1075: p_ghr_cpdf_temp_rec.individual_group_award,
1076: p_ghr_cpdf_temp_rec.award_amount,
1077: p_ghr_cpdf_temp_rec.benefit_amount,
1078: p_ghr_cpdf_temp_rec.employee_last_name,
1079: p_ghr_cpdf_temp_rec.from_pay_plan,

Line 1076: p_ghr_cpdf_temp_rec.award_amount,

1072: p_ghr_cpdf_temp_rec.rating_of_record_level,
1073: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1074: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1075: p_ghr_cpdf_temp_rec.individual_group_award,
1076: p_ghr_cpdf_temp_rec.award_amount,
1077: p_ghr_cpdf_temp_rec.benefit_amount,
1078: p_ghr_cpdf_temp_rec.employee_last_name,
1079: p_ghr_cpdf_temp_rec.from_pay_plan,
1080: p_ghr_cpdf_temp_rec.from_occ_code,

Line 1077: p_ghr_cpdf_temp_rec.benefit_amount,

1073: p_ghr_cpdf_temp_rec.rating_of_record_pattern,
1074: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1075: p_ghr_cpdf_temp_rec.individual_group_award,
1076: p_ghr_cpdf_temp_rec.award_amount,
1077: p_ghr_cpdf_temp_rec.benefit_amount,
1078: p_ghr_cpdf_temp_rec.employee_last_name,
1079: p_ghr_cpdf_temp_rec.from_pay_plan,
1080: p_ghr_cpdf_temp_rec.from_occ_code,
1081: p_ghr_cpdf_temp_rec.from_grade_or_level,

Line 1078: p_ghr_cpdf_temp_rec.employee_last_name,

1074: p_ghr_cpdf_temp_rec.rating_of_record_period_ends,
1075: p_ghr_cpdf_temp_rec.individual_group_award,
1076: p_ghr_cpdf_temp_rec.award_amount,
1077: p_ghr_cpdf_temp_rec.benefit_amount,
1078: p_ghr_cpdf_temp_rec.employee_last_name,
1079: p_ghr_cpdf_temp_rec.from_pay_plan,
1080: p_ghr_cpdf_temp_rec.from_occ_code,
1081: p_ghr_cpdf_temp_rec.from_grade_or_level,
1082: p_ghr_cpdf_temp_rec.from_step_or_rate,

Line 1079: p_ghr_cpdf_temp_rec.from_pay_plan,

1075: p_ghr_cpdf_temp_rec.individual_group_award,
1076: p_ghr_cpdf_temp_rec.award_amount,
1077: p_ghr_cpdf_temp_rec.benefit_amount,
1078: p_ghr_cpdf_temp_rec.employee_last_name,
1079: p_ghr_cpdf_temp_rec.from_pay_plan,
1080: p_ghr_cpdf_temp_rec.from_occ_code,
1081: p_ghr_cpdf_temp_rec.from_grade_or_level,
1082: p_ghr_cpdf_temp_rec.from_step_or_rate,
1083: p_ghr_cpdf_temp_rec.from_basic_pay,

Line 1080: p_ghr_cpdf_temp_rec.from_occ_code,

1076: p_ghr_cpdf_temp_rec.award_amount,
1077: p_ghr_cpdf_temp_rec.benefit_amount,
1078: p_ghr_cpdf_temp_rec.employee_last_name,
1079: p_ghr_cpdf_temp_rec.from_pay_plan,
1080: p_ghr_cpdf_temp_rec.from_occ_code,
1081: p_ghr_cpdf_temp_rec.from_grade_or_level,
1082: p_ghr_cpdf_temp_rec.from_step_or_rate,
1083: p_ghr_cpdf_temp_rec.from_basic_pay,
1084: p_ghr_cpdf_temp_rec.from_pay_basis,

Line 1081: p_ghr_cpdf_temp_rec.from_grade_or_level,

1077: p_ghr_cpdf_temp_rec.benefit_amount,
1078: p_ghr_cpdf_temp_rec.employee_last_name,
1079: p_ghr_cpdf_temp_rec.from_pay_plan,
1080: p_ghr_cpdf_temp_rec.from_occ_code,
1081: p_ghr_cpdf_temp_rec.from_grade_or_level,
1082: p_ghr_cpdf_temp_rec.from_step_or_rate,
1083: p_ghr_cpdf_temp_rec.from_basic_pay,
1084: p_ghr_cpdf_temp_rec.from_pay_basis,
1085: p_ghr_cpdf_temp_rec.from_work_schedule,

Line 1082: p_ghr_cpdf_temp_rec.from_step_or_rate,

1078: p_ghr_cpdf_temp_rec.employee_last_name,
1079: p_ghr_cpdf_temp_rec.from_pay_plan,
1080: p_ghr_cpdf_temp_rec.from_occ_code,
1081: p_ghr_cpdf_temp_rec.from_grade_or_level,
1082: p_ghr_cpdf_temp_rec.from_step_or_rate,
1083: p_ghr_cpdf_temp_rec.from_basic_pay,
1084: p_ghr_cpdf_temp_rec.from_pay_basis,
1085: p_ghr_cpdf_temp_rec.from_work_schedule,
1086: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,

Line 1083: p_ghr_cpdf_temp_rec.from_basic_pay,

1079: p_ghr_cpdf_temp_rec.from_pay_plan,
1080: p_ghr_cpdf_temp_rec.from_occ_code,
1081: p_ghr_cpdf_temp_rec.from_grade_or_level,
1082: p_ghr_cpdf_temp_rec.from_step_or_rate,
1083: p_ghr_cpdf_temp_rec.from_basic_pay,
1084: p_ghr_cpdf_temp_rec.from_pay_basis,
1085: p_ghr_cpdf_temp_rec.from_work_schedule,
1086: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1087: p_ghr_cpdf_temp_rec.from_national_identifier,

Line 1084: p_ghr_cpdf_temp_rec.from_pay_basis,

1080: p_ghr_cpdf_temp_rec.from_occ_code,
1081: p_ghr_cpdf_temp_rec.from_grade_or_level,
1082: p_ghr_cpdf_temp_rec.from_step_or_rate,
1083: p_ghr_cpdf_temp_rec.from_basic_pay,
1084: p_ghr_cpdf_temp_rec.from_pay_basis,
1085: p_ghr_cpdf_temp_rec.from_work_schedule,
1086: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1087: p_ghr_cpdf_temp_rec.from_national_identifier,
1088: p_ghr_cpdf_temp_rec.from_locality_adj,

Line 1085: p_ghr_cpdf_temp_rec.from_work_schedule,

1081: p_ghr_cpdf_temp_rec.from_grade_or_level,
1082: p_ghr_cpdf_temp_rec.from_step_or_rate,
1083: p_ghr_cpdf_temp_rec.from_basic_pay,
1084: p_ghr_cpdf_temp_rec.from_pay_basis,
1085: p_ghr_cpdf_temp_rec.from_work_schedule,
1086: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1087: p_ghr_cpdf_temp_rec.from_national_identifier,
1088: p_ghr_cpdf_temp_rec.from_locality_adj,
1089: p_ghr_cpdf_temp_rec.from_duty_station_code,

Line 1086: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,

1082: p_ghr_cpdf_temp_rec.from_step_or_rate,
1083: p_ghr_cpdf_temp_rec.from_basic_pay,
1084: p_ghr_cpdf_temp_rec.from_pay_basis,
1085: p_ghr_cpdf_temp_rec.from_work_schedule,
1086: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1087: p_ghr_cpdf_temp_rec.from_national_identifier,
1088: p_ghr_cpdf_temp_rec.from_locality_adj,
1089: p_ghr_cpdf_temp_rec.from_duty_station_code,
1090: p_ghr_cpdf_temp_rec.to_locality_adj,

Line 1087: p_ghr_cpdf_temp_rec.from_national_identifier,

1083: p_ghr_cpdf_temp_rec.from_basic_pay,
1084: p_ghr_cpdf_temp_rec.from_pay_basis,
1085: p_ghr_cpdf_temp_rec.from_work_schedule,
1086: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1087: p_ghr_cpdf_temp_rec.from_national_identifier,
1088: p_ghr_cpdf_temp_rec.from_locality_adj,
1089: p_ghr_cpdf_temp_rec.from_duty_station_code,
1090: p_ghr_cpdf_temp_rec.to_locality_adj,
1091: p_ghr_cpdf_temp_rec.to_staffing_differential,

Line 1088: p_ghr_cpdf_temp_rec.from_locality_adj,

1084: p_ghr_cpdf_temp_rec.from_pay_basis,
1085: p_ghr_cpdf_temp_rec.from_work_schedule,
1086: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1087: p_ghr_cpdf_temp_rec.from_national_identifier,
1088: p_ghr_cpdf_temp_rec.from_locality_adj,
1089: p_ghr_cpdf_temp_rec.from_duty_station_code,
1090: p_ghr_cpdf_temp_rec.to_locality_adj,
1091: p_ghr_cpdf_temp_rec.to_staffing_differential,
1092: p_ghr_cpdf_temp_rec.to_supervisory_differential,

Line 1089: p_ghr_cpdf_temp_rec.from_duty_station_code,

1085: p_ghr_cpdf_temp_rec.from_work_schedule,
1086: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1087: p_ghr_cpdf_temp_rec.from_national_identifier,
1088: p_ghr_cpdf_temp_rec.from_locality_adj,
1089: p_ghr_cpdf_temp_rec.from_duty_station_code,
1090: p_ghr_cpdf_temp_rec.to_locality_adj,
1091: p_ghr_cpdf_temp_rec.to_staffing_differential,
1092: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1093: p_ghr_cpdf_temp_rec.to_retention_allowance,

Line 1090: p_ghr_cpdf_temp_rec.to_locality_adj,

1086: p_ghr_cpdf_temp_rec.from_pay_rate_determinant,
1087: p_ghr_cpdf_temp_rec.from_national_identifier,
1088: p_ghr_cpdf_temp_rec.from_locality_adj,
1089: p_ghr_cpdf_temp_rec.from_duty_station_code,
1090: p_ghr_cpdf_temp_rec.to_locality_adj,
1091: p_ghr_cpdf_temp_rec.to_staffing_differential,
1092: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1093: p_ghr_cpdf_temp_rec.to_retention_allowance,
1094: p_ghr_cpdf_temp_rec.education_level,

Line 1091: p_ghr_cpdf_temp_rec.to_staffing_differential,

1087: p_ghr_cpdf_temp_rec.from_national_identifier,
1088: p_ghr_cpdf_temp_rec.from_locality_adj,
1089: p_ghr_cpdf_temp_rec.from_duty_station_code,
1090: p_ghr_cpdf_temp_rec.to_locality_adj,
1091: p_ghr_cpdf_temp_rec.to_staffing_differential,
1092: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1093: p_ghr_cpdf_temp_rec.to_retention_allowance,
1094: p_ghr_cpdf_temp_rec.education_level,
1095: p_ghr_cpdf_temp_rec.academic_discipline,

Line 1092: p_ghr_cpdf_temp_rec.to_supervisory_differential,

1088: p_ghr_cpdf_temp_rec.from_locality_adj,
1089: p_ghr_cpdf_temp_rec.from_duty_station_code,
1090: p_ghr_cpdf_temp_rec.to_locality_adj,
1091: p_ghr_cpdf_temp_rec.to_staffing_differential,
1092: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1093: p_ghr_cpdf_temp_rec.to_retention_allowance,
1094: p_ghr_cpdf_temp_rec.education_level,
1095: p_ghr_cpdf_temp_rec.academic_discipline,
1096: p_ghr_cpdf_temp_rec.year_degree_attained,

Line 1093: p_ghr_cpdf_temp_rec.to_retention_allowance,

1089: p_ghr_cpdf_temp_rec.from_duty_station_code,
1090: p_ghr_cpdf_temp_rec.to_locality_adj,
1091: p_ghr_cpdf_temp_rec.to_staffing_differential,
1092: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1093: p_ghr_cpdf_temp_rec.to_retention_allowance,
1094: p_ghr_cpdf_temp_rec.education_level,
1095: p_ghr_cpdf_temp_rec.academic_discipline,
1096: p_ghr_cpdf_temp_rec.year_degree_attained,
1097: -- p_ghr_cpdf_temp_rec.employee_last_name,

Line 1094: p_ghr_cpdf_temp_rec.education_level,

1090: p_ghr_cpdf_temp_rec.to_locality_adj,
1091: p_ghr_cpdf_temp_rec.to_staffing_differential,
1092: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1093: p_ghr_cpdf_temp_rec.to_retention_allowance,
1094: p_ghr_cpdf_temp_rec.education_level,
1095: p_ghr_cpdf_temp_rec.academic_discipline,
1096: p_ghr_cpdf_temp_rec.year_degree_attained,
1097: -- p_ghr_cpdf_temp_rec.employee_last_name,
1098: p_ghr_cpdf_temp_rec.employee_first_name,

Line 1095: p_ghr_cpdf_temp_rec.academic_discipline,

1091: p_ghr_cpdf_temp_rec.to_staffing_differential,
1092: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1093: p_ghr_cpdf_temp_rec.to_retention_allowance,
1094: p_ghr_cpdf_temp_rec.education_level,
1095: p_ghr_cpdf_temp_rec.academic_discipline,
1096: p_ghr_cpdf_temp_rec.year_degree_attained,
1097: -- p_ghr_cpdf_temp_rec.employee_last_name,
1098: p_ghr_cpdf_temp_rec.employee_first_name,
1099: p_ghr_cpdf_temp_rec.employee_middle_names,

Line 1096: p_ghr_cpdf_temp_rec.year_degree_attained,

1092: p_ghr_cpdf_temp_rec.to_supervisory_differential,
1093: p_ghr_cpdf_temp_rec.to_retention_allowance,
1094: p_ghr_cpdf_temp_rec.education_level,
1095: p_ghr_cpdf_temp_rec.academic_discipline,
1096: p_ghr_cpdf_temp_rec.year_degree_attained,
1097: -- p_ghr_cpdf_temp_rec.employee_last_name,
1098: p_ghr_cpdf_temp_rec.employee_first_name,
1099: p_ghr_cpdf_temp_rec.employee_middle_names,
1100: p_ghr_cpdf_temp_rec.name_title,

Line 1097: -- p_ghr_cpdf_temp_rec.employee_last_name,

1093: p_ghr_cpdf_temp_rec.to_retention_allowance,
1094: p_ghr_cpdf_temp_rec.education_level,
1095: p_ghr_cpdf_temp_rec.academic_discipline,
1096: p_ghr_cpdf_temp_rec.year_degree_attained,
1097: -- p_ghr_cpdf_temp_rec.employee_last_name,
1098: p_ghr_cpdf_temp_rec.employee_first_name,
1099: p_ghr_cpdf_temp_rec.employee_middle_names,
1100: p_ghr_cpdf_temp_rec.name_title,
1101: p_ghr_cpdf_temp_rec.position_title,

Line 1098: p_ghr_cpdf_temp_rec.employee_first_name,

1094: p_ghr_cpdf_temp_rec.education_level,
1095: p_ghr_cpdf_temp_rec.academic_discipline,
1096: p_ghr_cpdf_temp_rec.year_degree_attained,
1097: -- p_ghr_cpdf_temp_rec.employee_last_name,
1098: p_ghr_cpdf_temp_rec.employee_first_name,
1099: p_ghr_cpdf_temp_rec.employee_middle_names,
1100: p_ghr_cpdf_temp_rec.name_title,
1101: p_ghr_cpdf_temp_rec.position_title,
1102: p_ghr_cpdf_temp_rec.award_dollars,

Line 1099: p_ghr_cpdf_temp_rec.employee_middle_names,

1095: p_ghr_cpdf_temp_rec.academic_discipline,
1096: p_ghr_cpdf_temp_rec.year_degree_attained,
1097: -- p_ghr_cpdf_temp_rec.employee_last_name,
1098: p_ghr_cpdf_temp_rec.employee_first_name,
1099: p_ghr_cpdf_temp_rec.employee_middle_names,
1100: p_ghr_cpdf_temp_rec.name_title,
1101: p_ghr_cpdf_temp_rec.position_title,
1102: p_ghr_cpdf_temp_rec.award_dollars,
1103: p_ghr_cpdf_temp_rec.award_hours,

Line 1100: p_ghr_cpdf_temp_rec.name_title,

1096: p_ghr_cpdf_temp_rec.year_degree_attained,
1097: -- p_ghr_cpdf_temp_rec.employee_last_name,
1098: p_ghr_cpdf_temp_rec.employee_first_name,
1099: p_ghr_cpdf_temp_rec.employee_middle_names,
1100: p_ghr_cpdf_temp_rec.name_title,
1101: p_ghr_cpdf_temp_rec.position_title,
1102: p_ghr_cpdf_temp_rec.award_dollars,
1103: p_ghr_cpdf_temp_rec.award_hours,
1104: p_ghr_cpdf_temp_rec.award_percentage,

Line 1101: p_ghr_cpdf_temp_rec.position_title,

1097: -- p_ghr_cpdf_temp_rec.employee_last_name,
1098: p_ghr_cpdf_temp_rec.employee_first_name,
1099: p_ghr_cpdf_temp_rec.employee_middle_names,
1100: p_ghr_cpdf_temp_rec.name_title,
1101: p_ghr_cpdf_temp_rec.position_title,
1102: p_ghr_cpdf_temp_rec.award_dollars,
1103: p_ghr_cpdf_temp_rec.award_hours,
1104: p_ghr_cpdf_temp_rec.award_percentage,
1105: p_ghr_cpdf_temp_rec.SCD_retirement,

Line 1102: p_ghr_cpdf_temp_rec.award_dollars,

1098: p_ghr_cpdf_temp_rec.employee_first_name,
1099: p_ghr_cpdf_temp_rec.employee_middle_names,
1100: p_ghr_cpdf_temp_rec.name_title,
1101: p_ghr_cpdf_temp_rec.position_title,
1102: p_ghr_cpdf_temp_rec.award_dollars,
1103: p_ghr_cpdf_temp_rec.award_hours,
1104: p_ghr_cpdf_temp_rec.award_percentage,
1105: p_ghr_cpdf_temp_rec.SCD_retirement,
1106: p_ghr_cpdf_temp_rec.SCD_rif,

Line 1103: p_ghr_cpdf_temp_rec.award_hours,

1099: p_ghr_cpdf_temp_rec.employee_middle_names,
1100: p_ghr_cpdf_temp_rec.name_title,
1101: p_ghr_cpdf_temp_rec.position_title,
1102: p_ghr_cpdf_temp_rec.award_dollars,
1103: p_ghr_cpdf_temp_rec.award_hours,
1104: p_ghr_cpdf_temp_rec.award_percentage,
1105: p_ghr_cpdf_temp_rec.SCD_retirement,
1106: p_ghr_cpdf_temp_rec.SCD_rif,
1107: p_ghr_cpdf_temp_rec.race_ethnic_info

Line 1104: p_ghr_cpdf_temp_rec.award_percentage,

1100: p_ghr_cpdf_temp_rec.name_title,
1101: p_ghr_cpdf_temp_rec.position_title,
1102: p_ghr_cpdf_temp_rec.award_dollars,
1103: p_ghr_cpdf_temp_rec.award_hours,
1104: p_ghr_cpdf_temp_rec.award_percentage,
1105: p_ghr_cpdf_temp_rec.SCD_retirement,
1106: p_ghr_cpdf_temp_rec.SCD_rif,
1107: p_ghr_cpdf_temp_rec.race_ethnic_info
1108: );

Line 1105: p_ghr_cpdf_temp_rec.SCD_retirement,

1101: p_ghr_cpdf_temp_rec.position_title,
1102: p_ghr_cpdf_temp_rec.award_dollars,
1103: p_ghr_cpdf_temp_rec.award_hours,
1104: p_ghr_cpdf_temp_rec.award_percentage,
1105: p_ghr_cpdf_temp_rec.SCD_retirement,
1106: p_ghr_cpdf_temp_rec.SCD_rif,
1107: p_ghr_cpdf_temp_rec.race_ethnic_info
1108: );
1109:

Line 1106: p_ghr_cpdf_temp_rec.SCD_rif,

1102: p_ghr_cpdf_temp_rec.award_dollars,
1103: p_ghr_cpdf_temp_rec.award_hours,
1104: p_ghr_cpdf_temp_rec.award_percentage,
1105: p_ghr_cpdf_temp_rec.SCD_retirement,
1106: p_ghr_cpdf_temp_rec.SCD_rif,
1107: p_ghr_cpdf_temp_rec.race_ethnic_info
1108: );
1109:
1110: COMMIT;

Line 1107: p_ghr_cpdf_temp_rec.race_ethnic_info

1103: p_ghr_cpdf_temp_rec.award_hours,
1104: p_ghr_cpdf_temp_rec.award_percentage,
1105: p_ghr_cpdf_temp_rec.SCD_retirement,
1106: p_ghr_cpdf_temp_rec.SCD_rif,
1107: p_ghr_cpdf_temp_rec.race_ethnic_info
1108: );
1109:
1110: COMMIT;
1111:

Line 1164: PROCEDURE populate_ghr_cpdf_temp(p_agency IN VARCHAR2

1160: --
1161: ---------------------------------------------------------------------------------------------
1162: -- This is the main procedure
1163: ---------------------------------------------------------------------------------------------
1164: PROCEDURE populate_ghr_cpdf_temp(p_agency IN VARCHAR2
1165: ,p_start_date IN DATE
1166: ,p_end_date IN DATE
1167: ,p_count_only IN BOOLEAN ) IS
1168: --

Line 1169: l_proc VARCHAR2(72) := g_package||'populate_ghr_cpdf_temp';

1165: ,p_start_date IN DATE
1166: ,p_end_date IN DATE
1167: ,p_count_only IN BOOLEAN ) IS
1168: --
1169: l_proc VARCHAR2(72) := g_package||'populate_ghr_cpdf_temp';
1170: --
1171: l_info_type VARCHAR2(200) := NULL;
1172: l_api_assignment_id per_assignments.assignment_id%TYPE;
1173: --

Line 1240: l_ghr_cpdf_temp_rec ghr_cpdf_temp%ROWTYPE;

1236: -- Bug 706585 has been raised to make sure it gets populated on UPDATE_HR and not UPDATE_HR_COMPLETE
1237: -- otherwise this will not be available to FUTURE_ACTIONS
1238: -- 3) ordering of the records will be done in the report, by agency code then ssn
1239:
1240: l_ghr_cpdf_temp_rec ghr_cpdf_temp%ROWTYPE;
1241: l_ghr_empty_cpdf_temp ghr_cpdf_temp%ROWTYPE;
1242: l_ghr_pa_requests_rec ghr_pa_requests%ROWTYPE;
1243: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
1244: l_retained_pay_plan ghr_pa_requests.to_pay_plan%type;

Line 1241: l_ghr_empty_cpdf_temp ghr_cpdf_temp%ROWTYPE;

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

Line 1486: -- Emptying GHR_CPDF_TEMP_REC... Added for bug# 1375342

1482: WHEN ghr_pay_calc.pay_calc_message THEN
1483: NULL;
1484: END;
1485:
1486: -- Emptying GHR_CPDF_TEMP_REC... Added for bug# 1375342
1487: l_ghr_cpdf_temp_rec := l_ghr_empty_cpdf_temp;
1488:
1489:
1490: --

Line 1487: l_ghr_cpdf_temp_rec := l_ghr_empty_cpdf_temp;

1483: NULL;
1484: END;
1485:
1486: -- Emptying GHR_CPDF_TEMP_REC... Added for bug# 1375342
1487: l_ghr_cpdf_temp_rec := l_ghr_empty_cpdf_temp;
1488:
1489:
1490: --
1491: -- 2.2) Add a cutomer hook to determine whether or not to include in report or not!!!!

Line 1497: -- 3) Now we have decided to keep this populate the ghr_cpdf_temp record group:

1493: -- we do not hold this infoamtion about a person or position, but apparently DoD hold it
1494: -- in the position kff
1495: --
1496: --
1497: -- 3) Now we have decided to keep this populate the ghr_cpdf_temp record group:
1498: -- First with all the information the PAR table itself and then go and get any more information needed
1499: -- If we are just doing a count, we do not need to do the second bit!
1500: --
1501: -- 3.1) Get all info from PAR table itself

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1527: -- Insert_row in GHR_CPDF_TEMP, and continue in the LOOP for the next PAR row.

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

Line 1529: insert_row(l_ghr_cpdf_temp_rec);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1604: l_ghr_cpdf_temp_rec.to_pay_rate_determinant := NULL;

1600: )
1601: ) THEN
1602: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;
1603: ELSE
1604: l_ghr_cpdf_temp_rec.to_pay_rate_determinant := NULL;
1605: END IF;
1606: END IF;
1607:
1608: -- Added following 'IF' according to bug# 1375333

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

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

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

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

Line 1620: l_ghr_cpdf_temp_rec.to_work_schedule := NULL;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1663: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;

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

Line 1666: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;

1662: ELSE
1663: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
1664: END IF;
1665: ELSE
1666: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
1667: END IF;
1668: END IF;
1669:
1670:

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

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

Line 1686: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;

1682: ) THEN
1683: IF get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.to_pay_plan)) <> 'FW' THEN
1684: l_ghr_cpdf_temp_rec.to_locality_adj := NVL(l_ghr_pa_requests_rec.to_locality_adj, 0);
1685: ELSE
1686: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
1687: END IF;
1688: ELSE
1689: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
1690: END IF;

Line 1689: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;

1685: ELSE
1686: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
1687: END IF;
1688: ELSE
1689: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
1690: END IF;
1691: ELSE --4163587 Loc pay is not reported for prior loc pay
1692: -- NO NEED TO MAKE PRIOR LOC PAY ADJ NULL, as we are checking for current DS not prior DS
1693: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;

Line 1693: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;

1689: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
1690: END IF;
1691: ELSE --4163587 Loc pay is not reported for prior loc pay
1692: -- NO NEED TO MAKE PRIOR LOC PAY ADJ NULL, as we are checking for current DS not prior DS
1693: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
1694: END IF;
1695:
1696:
1697: l_ghr_cpdf_temp_rec.to_staffing_differential := l_ghr_pa_requests_rec.to_staffing_differential; -- format in report

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

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

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

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

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

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

Line 1705: IF l_ghr_cpdf_temp_rec.award_amount IS NULL THEN

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

Line 1717: ,p_value => l_ghr_cpdf_temp_rec.award_amount

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

Line 1721: IF l_ghr_cpdf_temp_rec.award_amount IS NULL THEN

1717: ,p_value => l_ghr_cpdf_temp_rec.award_amount
1718: ,p_multiple_error_flag => l_multi_error_flag);
1719:
1720: -- Added the if condition for Bug#5564750
1721: IF l_ghr_cpdf_temp_rec.award_amount IS NULL THEN
1722: l_ghr_cpdf_temp_rec.award_amount := 0;
1723: END IF;
1724:
1725: EXCEPTION

Line 1722: l_ghr_cpdf_temp_rec.award_amount := 0;

1718: ,p_multiple_error_flag => l_multi_error_flag);
1719:
1720: -- Added the if condition for Bug#5564750
1721: IF l_ghr_cpdf_temp_rec.award_amount IS NULL THEN
1722: l_ghr_cpdf_temp_rec.award_amount := 0;
1723: END IF;
1724:
1725: EXCEPTION
1726: WHEN OTHERS THEN

Line 1750: ,p_value => l_ghr_cpdf_temp_rec.award_amount

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

Line 1754: IF l_ghr_cpdf_temp_rec.award_amount IS NULL THEN

1750: ,p_value => l_ghr_cpdf_temp_rec.award_amount
1751: ,p_multiple_error_flag => l_multi_error_flag);
1752:
1753: -- Added the if condition for Bug#5564750
1754: IF l_ghr_cpdf_temp_rec.award_amount IS NULL THEN
1755: l_ghr_cpdf_temp_rec.award_amount := 0;
1756: END IF;
1757:
1758: EXCEPTION

Line 1755: l_ghr_cpdf_temp_rec.award_amount := 0;

1751: ,p_multiple_error_flag => l_multi_error_flag);
1752:
1753: -- Added the if condition for Bug#5564750
1754: IF l_ghr_cpdf_temp_rec.award_amount IS NULL THEN
1755: l_ghr_cpdf_temp_rec.award_amount := 0;
1756: END IF;
1757:
1758: EXCEPTION
1759: WHEN OTHERS THEN

Line 1778: IF l_ghr_cpdf_temp_rec.to_supervisory_differential IS NULL THEN

1774: -- Bug#2789704 Added Exception Handling
1775: END IF;
1776: END IF;
1777: ELSE
1778: IF l_ghr_cpdf_temp_rec.to_supervisory_differential IS NULL THEN
1779: -- Bug#2789704 Added Exception Handling
1780: BEGIN
1781: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
1782: ,p_input_value_name => 'Amount'

Line 1785: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential

1781: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
1782: ,p_input_value_name => 'Amount'
1783: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1784: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1785: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential
1786: ,p_multiple_error_flag => l_multi_error_flag);
1787: EXCEPTION
1788: WHEN OTHERS THEN
1789: --Bug # 9329643 Modified SSN to Emp No

Line 1806: IF l_ghr_cpdf_temp_rec.to_retention_allowance IS NULL THEN

1802: END;
1803: -- Bug#2789704 Added Exception Handling
1804:
1805: END IF;
1806: IF l_ghr_cpdf_temp_rec.to_retention_allowance IS NULL THEN
1807: -- Bug#2789704 Added Exception Handling
1808: BEGIN
1809: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
1810: ,p_input_value_name => 'Amount'

Line 1813: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance

1809: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
1810: ,p_input_value_name => 'Amount'
1811: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
1812: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
1813: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance
1814: ,p_multiple_error_flag => l_multi_error_flag);
1815: EXCEPTION
1816: WHEN OTHERS THEN
1817: --Bug # 9329643 Modified SSN to Emp No

Line 1840: p_education_level => l_ghr_cpdf_temp_rec.education_level,

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

Line 1841: p_academic_discipline => l_ghr_cpdf_temp_rec.academic_discipline,

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

Line 1842: p_year_degree_attained => l_ghr_cpdf_temp_rec.year_degree_attained);

1838: ghr_api.return_education_details(p_person_id => l_ghr_pa_requests_rec.person_id,
1839: p_effective_date => l_ghr_pa_requests_rec.effective_date,
1840: p_education_level => l_ghr_cpdf_temp_rec.education_level,
1841: p_academic_discipline => l_ghr_cpdf_temp_rec.academic_discipline,
1842: p_year_degree_attained => l_ghr_cpdf_temp_rec.year_degree_attained);
1843: -- End changes for education Commented below code
1844:
1845: /* l_ghr_cpdf_temp_rec.education_level := l_ghr_pa_requests_rec.education_level;
1846: -- academic_discipline is refered to as 'Instructional Program' in the dynamics report

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

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

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

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

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

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

Line 1863: ,l_ghr_cpdf_temp_rec.organizational_component);

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

Line 1887: ,l_ghr_cpdf_temp_rec.sex);

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

Line 1912: ,l_ghr_cpdf_temp_rec.rating_of_record_level

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

Line 1913: ,l_ghr_cpdf_temp_rec.rating_of_record_pattern

1909: BEGIN
1910: get_per_sit_perf_appraisal(l_ghr_pa_requests_rec.person_id
1911: ,l_ghr_pa_requests_rec.effective_date
1912: ,l_ghr_cpdf_temp_rec.rating_of_record_level
1913: ,l_ghr_cpdf_temp_rec.rating_of_record_pattern
1914: ,l_ghr_cpdf_temp_rec.rating_of_record_period_ends); -- format in report
1915: EXCEPTION
1916: WHEN OTHERS THEN
1917: --Bug # 9329643 Modified SSN to Emp No

Line 1914: ,l_ghr_cpdf_temp_rec.rating_of_record_period_ends); -- format in report

1910: get_per_sit_perf_appraisal(l_ghr_pa_requests_rec.person_id
1911: ,l_ghr_pa_requests_rec.effective_date
1912: ,l_ghr_cpdf_temp_rec.rating_of_record_level
1913: ,l_ghr_cpdf_temp_rec.rating_of_record_pattern
1914: ,l_ghr_cpdf_temp_rec.rating_of_record_period_ends); -- format in report
1915: EXCEPTION
1916: WHEN OTHERS THEN
1917: --Bug # 9329643 Modified SSN to Emp No
1918: l_message_name := 'get_per_sit_perf_apprisal';

Line 1943: ,l_ghr_cpdf_temp_rec.creditable_military_service -- no format assumed yymm?

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

Line 1944: ,l_ghr_cpdf_temp_rec.frozen_service -- no format assumed yymm?

1940: ,l_ghr_pa_requests_rec.noa_family_code
1941: ,l_ghr_pa_requests_rec.person_id
1942: ,l_ghr_pa_requests_rec.effective_date
1943: ,l_ghr_cpdf_temp_rec.creditable_military_service -- no format assumed yymm?
1944: ,l_ghr_cpdf_temp_rec.frozen_service -- no format assumed yymm?
1945: ,l_ghr_cpdf_temp_rec.from_retirement_coverage -- previous retirement coverage
1946: ,l_ghr_cpdf_temp_rec.race_national_origin
1947: ,l_ghr_cpdf_temp_rec.handicap_code
1948: ,l_ghr_cpdf_temp_rec.individual_group_award -- format in report

Line 1945: ,l_ghr_cpdf_temp_rec.from_retirement_coverage -- previous retirement coverage

1941: ,l_ghr_pa_requests_rec.person_id
1942: ,l_ghr_pa_requests_rec.effective_date
1943: ,l_ghr_cpdf_temp_rec.creditable_military_service -- no format assumed yymm?
1944: ,l_ghr_cpdf_temp_rec.frozen_service -- no format assumed yymm?
1945: ,l_ghr_cpdf_temp_rec.from_retirement_coverage -- previous retirement coverage
1946: ,l_ghr_cpdf_temp_rec.race_national_origin
1947: ,l_ghr_cpdf_temp_rec.handicap_code
1948: ,l_ghr_cpdf_temp_rec.individual_group_award -- format in report
1949: ,l_ghr_cpdf_temp_rec.benefit_amount -- format in report

Line 1946: ,l_ghr_cpdf_temp_rec.race_national_origin

1942: ,l_ghr_pa_requests_rec.effective_date
1943: ,l_ghr_cpdf_temp_rec.creditable_military_service -- no format assumed yymm?
1944: ,l_ghr_cpdf_temp_rec.frozen_service -- no format assumed yymm?
1945: ,l_ghr_cpdf_temp_rec.from_retirement_coverage -- previous retirement coverage
1946: ,l_ghr_cpdf_temp_rec.race_national_origin
1947: ,l_ghr_cpdf_temp_rec.handicap_code
1948: ,l_ghr_cpdf_temp_rec.individual_group_award -- format in report
1949: ,l_ghr_cpdf_temp_rec.benefit_amount -- format in report
1950: ,l_ghr_cpdf_temp_rec.race_ethnic_info); -- -- Bug 4724337 Race or National Origin changes

Line 1947: ,l_ghr_cpdf_temp_rec.handicap_code

1943: ,l_ghr_cpdf_temp_rec.creditable_military_service -- no format assumed yymm?
1944: ,l_ghr_cpdf_temp_rec.frozen_service -- no format assumed yymm?
1945: ,l_ghr_cpdf_temp_rec.from_retirement_coverage -- previous retirement coverage
1946: ,l_ghr_cpdf_temp_rec.race_national_origin
1947: ,l_ghr_cpdf_temp_rec.handicap_code
1948: ,l_ghr_cpdf_temp_rec.individual_group_award -- format in report
1949: ,l_ghr_cpdf_temp_rec.benefit_amount -- format in report
1950: ,l_ghr_cpdf_temp_rec.race_ethnic_info); -- -- Bug 4724337 Race or National Origin changes
1951: EXCEPTION

Line 1948: ,l_ghr_cpdf_temp_rec.individual_group_award -- format in report

1944: ,l_ghr_cpdf_temp_rec.frozen_service -- no format assumed yymm?
1945: ,l_ghr_cpdf_temp_rec.from_retirement_coverage -- previous retirement coverage
1946: ,l_ghr_cpdf_temp_rec.race_national_origin
1947: ,l_ghr_cpdf_temp_rec.handicap_code
1948: ,l_ghr_cpdf_temp_rec.individual_group_award -- format in report
1949: ,l_ghr_cpdf_temp_rec.benefit_amount -- format in report
1950: ,l_ghr_cpdf_temp_rec.race_ethnic_info); -- -- Bug 4724337 Race or National Origin changes
1951: EXCEPTION
1952: WHEN OTHERS THEN

Line 1949: ,l_ghr_cpdf_temp_rec.benefit_amount -- format in report

1945: ,l_ghr_cpdf_temp_rec.from_retirement_coverage -- previous retirement coverage
1946: ,l_ghr_cpdf_temp_rec.race_national_origin
1947: ,l_ghr_cpdf_temp_rec.handicap_code
1948: ,l_ghr_cpdf_temp_rec.individual_group_award -- format in report
1949: ,l_ghr_cpdf_temp_rec.benefit_amount -- format in report
1950: ,l_ghr_cpdf_temp_rec.race_ethnic_info); -- -- Bug 4724337 Race or National Origin changes
1951: EXCEPTION
1952: WHEN OTHERS THEN
1953: l_message_name := 'get_par_ei_noac';

Line 1950: ,l_ghr_cpdf_temp_rec.race_ethnic_info); -- -- Bug 4724337 Race or National Origin changes

1946: ,l_ghr_cpdf_temp_rec.race_national_origin
1947: ,l_ghr_cpdf_temp_rec.handicap_code
1948: ,l_ghr_cpdf_temp_rec.individual_group_award -- format in report
1949: ,l_ghr_cpdf_temp_rec.benefit_amount -- format in report
1950: ,l_ghr_cpdf_temp_rec.race_ethnic_info); -- -- Bug 4724337 Race or National Origin changes
1951: EXCEPTION
1952: WHEN OTHERS THEN
1953: l_message_name := 'get_par_ei_noac';
1954: --Bug # 9329643 Modified SSN to Emp No

Line 1973: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;

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

Line 1974: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;

1970: IF (l_ghr_pa_requests_rec.first_noa_code LIKE '2%' OR
1971: (l_ghr_pa_requests_rec.first_noa_code = '002' AND
1972: NVL(l_ghr_pa_requests_rec.second_noa_code, '@#') LIKE '2%')) THEN
1973: l_ghr_cpdf_temp_rec.creditable_military_service := NULL;
1974: l_ghr_cpdf_temp_rec.from_retirement_coverage := NULL;
1975: -- for bug 3327389
1976: END IF;
1977:
1978: -- get current appointment auth codes.

Line 1983: ,p_auth_code1 => l_ghr_cpdf_temp_rec.current_appointment_auth1

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

Line 1984: ,p_auth_code2 => l_ghr_cpdf_temp_rec.current_appointment_auth2);

1980: BEGIN
1981: ghr_sf52_pre_update.get_auth_codes
1982: (p_pa_req_rec => l_ghr_pa_requests_rec
1983: ,p_auth_code1 => l_ghr_cpdf_temp_rec.current_appointment_auth1
1984: ,p_auth_code2 => l_ghr_cpdf_temp_rec.current_appointment_auth2);
1985: EXCEPTION
1986: WHEN OTHERS THEN
1987: l_message_name := 'get_auth_codes';
1988: --Bug # 9329643 Modified SSN to Emp No

Line 2021: ,l_ghr_cpdf_temp_rec.from_work_schedule

2017: ,l_ghr_pa_requests_rec.employee_assignment_id
2018: ,l_ghr_pa_requests_rec.from_position_id
2019: ,l_ghr_pa_requests_rec.effective_date
2020: ,l_ghr_pa_requests_rec.status
2021: ,l_ghr_cpdf_temp_rec.from_work_schedule
2022: ,l_ghr_cpdf_temp_rec.from_pay_rate_determinant
2023: ,l_ghr_cpdf_temp_rec.from_duty_station_code);
2024: EXCEPTION
2025: WHEN OTHERS THEN

Line 2022: ,l_ghr_cpdf_temp_rec.from_pay_rate_determinant

2018: ,l_ghr_pa_requests_rec.from_position_id
2019: ,l_ghr_pa_requests_rec.effective_date
2020: ,l_ghr_pa_requests_rec.status
2021: ,l_ghr_cpdf_temp_rec.from_work_schedule
2022: ,l_ghr_cpdf_temp_rec.from_pay_rate_determinant
2023: ,l_ghr_cpdf_temp_rec.from_duty_station_code);
2024: EXCEPTION
2025: WHEN OTHERS THEN
2026: l_message_name := 'get_prior_ws_prd_ds';

Line 2023: ,l_ghr_cpdf_temp_rec.from_duty_station_code);

2019: ,l_ghr_pa_requests_rec.effective_date
2020: ,l_ghr_pa_requests_rec.status
2021: ,l_ghr_cpdf_temp_rec.from_work_schedule
2022: ,l_ghr_cpdf_temp_rec.from_pay_rate_determinant
2023: ,l_ghr_cpdf_temp_rec.from_duty_station_code);
2024: EXCEPTION
2025: WHEN OTHERS THEN
2026: l_message_name := 'get_prior_ws_prd_ds';
2027: --Bug # 9329643 Modified SSN to Emp No

Line 2044: l_ghr_cpdf_temp_rec.to_pay_rate_determinant := l_ghr_cpdf_temp_rec.from_pay_rate_determinant;

2040:
2041: --bug# 5328177 IF l_noa_family_code = 'AWARD' THEN
2042: IF l_noa_family_code IN ('AWARD','GHR_INCENTIVE') THEN
2043:
2044: l_ghr_cpdf_temp_rec.to_pay_rate_determinant := l_ghr_cpdf_temp_rec.from_pay_rate_determinant;
2045: END IF;
2046: -- Added IF Condition to fix bug#3231946
2047: IF get_loc_pay_area_code(p_duty_station_code => l_ghr_cpdf_temp_rec.from_duty_station_code,
2048: p_effective_date => l_ghr_pa_requests_rec.effective_date) = '99'

Line 2047: IF get_loc_pay_area_code(p_duty_station_code => l_ghr_cpdf_temp_rec.from_duty_station_code,

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

Line 2050: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;

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

Line 2062: ,l_ghr_cpdf_temp_rec.from_national_identifier);

2058: BEGIN
2059: get_prev_ssn (l_ghr_pa_requests_rec.altered_pa_request_id
2060: ,l_ghr_pa_requests_rec.employee_national_identifier
2061: ,l_ghr_pa_requests_rec.noa_family_code
2062: ,l_ghr_cpdf_temp_rec.from_national_identifier);
2063: EXCEPTION
2064: WHEN OTHERS THEN
2065: l_message_name := 'get_prev_ssn';
2066: --Bug # 9329643 Modified SSN to Emp No

Line 2084: l_ghr_cpdf_temp_rec := l_ghr_empty_cpdf_temp;

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

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

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

Line 2086: l_ghr_cpdf_temp_rec.to_national_identifier

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2128: l_ghr_cpdf_temp_rec.position_title := NULL;

2124: )
2125: ) THEN
2126: l_ghr_cpdf_temp_rec.position_title := l_ghr_pa_requests_rec.to_position_title;
2127: ELSE
2128: l_ghr_cpdf_temp_rec.position_title := NULL;
2129: END IF;
2130:
2131: -- Bug#5328177 Added NOAC 827 in the NOAC list.
2132: -- Bug # 8510442 Added 885 into the list to display award amount for 885 action

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2187: l_ghr_cpdf_temp_rec.name_title := l_suffix;

2183: l_ghr_pa_requests_rec.effective_date,
2184: l_suffix,
2185: l_last_name);
2186: --End Bug# 4648811
2187: l_ghr_cpdf_temp_rec.name_title := l_suffix;
2188: END LOOP;
2189:
2190: FOR scd_dates IN cur_scd_dates(l_ghr_pa_requests_rec.pa_request_id)
2191: LOOP

Line 2192: l_ghr_cpdf_temp_rec.SCD_rif := fnd_date.canonical_to_date(scd_dates.rif);

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

Line 2193: l_ghr_cpdf_temp_rec.SCD_retirement := fnd_date.canonical_to_date(scd_dates.ret);

2189:
2190: FOR scd_dates IN cur_scd_dates(l_ghr_pa_requests_rec.pa_request_id)
2191: LOOP
2192: l_ghr_cpdf_temp_rec.SCD_rif := fnd_date.canonical_to_date(scd_dates.rif);
2193: l_ghr_cpdf_temp_rec.SCD_retirement := fnd_date.canonical_to_date(scd_dates.ret);
2194: -- Added date conversion for bug#3808473-EHRI reports
2195: END LOOP;
2196:
2197: IF (l_ghr_cpdf_temp_rec.SCD_rif IS NULL

Line 2197: IF (l_ghr_cpdf_temp_rec.SCD_rif IS NULL

2193: l_ghr_cpdf_temp_rec.SCD_retirement := fnd_date.canonical_to_date(scd_dates.ret);
2194: -- Added date conversion for bug#3808473-EHRI reports
2195: END LOOP;
2196:
2197: IF (l_ghr_cpdf_temp_rec.SCD_rif IS NULL
2198: and l_ghr_cpdf_temp_rec.SCD_retirement IS NULL) THEN
2199:
2200: BEGIN
2201: ghr_history_fetch.fetch_peopleei

Line 2198: and l_ghr_cpdf_temp_rec.SCD_retirement IS NULL) THEN

2194: -- Added date conversion for bug#3808473-EHRI reports
2195: END LOOP;
2196:
2197: IF (l_ghr_cpdf_temp_rec.SCD_rif IS NULL
2198: and l_ghr_cpdf_temp_rec.SCD_retirement IS NULL) THEN
2199:
2200: BEGIN
2201: ghr_history_fetch.fetch_peopleei
2202: (p_person_id => l_ghr_pa_requests_rec.person_id,

Line 2208: l_ghr_cpdf_temp_rec.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);

2204: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2205: p_per_ei_data => ll_per_ei_data
2206: );
2207:
2208: l_ghr_cpdf_temp_rec.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
2209: l_ghr_cpdf_temp_rec.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
2210:
2211: EXCEPTION
2212: WHEN OTHERS THEN

Line 2209: l_ghr_cpdf_temp_rec.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);

2205: p_per_ei_data => ll_per_ei_data
2206: );
2207:
2208: l_ghr_cpdf_temp_rec.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
2209: l_ghr_cpdf_temp_rec.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
2210:
2211: EXCEPTION
2212: WHEN OTHERS THEN
2213: l_message_name := 'fetch_peopleei';

Line 2230: l_ghr_cpdf_temp_rec.employee_last_name := NULL;

2226: END;
2227: END IF;
2228:
2229: ELSE -- if NOAC is 817
2230: l_ghr_cpdf_temp_rec.employee_last_name := NULL;
2231: l_ghr_cpdf_temp_rec.employee_first_name := NULL;
2232: l_ghr_cpdf_temp_rec.employee_middle_names := NULL;
2233: l_ghr_cpdf_temp_rec.name_title := NULL;
2234: l_ghr_cpdf_temp_rec.SCD_rif := NULL;

Line 2231: l_ghr_cpdf_temp_rec.employee_first_name := NULL;

2227: END IF;
2228:
2229: ELSE -- if NOAC is 817
2230: l_ghr_cpdf_temp_rec.employee_last_name := NULL;
2231: l_ghr_cpdf_temp_rec.employee_first_name := NULL;
2232: l_ghr_cpdf_temp_rec.employee_middle_names := NULL;
2233: l_ghr_cpdf_temp_rec.name_title := NULL;
2234: l_ghr_cpdf_temp_rec.SCD_rif := NULL;
2235: l_ghr_cpdf_temp_rec.SCD_retirement := NULL;

Line 2232: l_ghr_cpdf_temp_rec.employee_middle_names := NULL;

2228:
2229: ELSE -- if NOAC is 817
2230: l_ghr_cpdf_temp_rec.employee_last_name := NULL;
2231: l_ghr_cpdf_temp_rec.employee_first_name := NULL;
2232: l_ghr_cpdf_temp_rec.employee_middle_names := NULL;
2233: l_ghr_cpdf_temp_rec.name_title := NULL;
2234: l_ghr_cpdf_temp_rec.SCD_rif := NULL;
2235: l_ghr_cpdf_temp_rec.SCD_retirement := NULL;
2236: END IF; -- not in 817

Line 2233: l_ghr_cpdf_temp_rec.name_title := NULL;

2229: ELSE -- if NOAC is 817
2230: l_ghr_cpdf_temp_rec.employee_last_name := NULL;
2231: l_ghr_cpdf_temp_rec.employee_first_name := NULL;
2232: l_ghr_cpdf_temp_rec.employee_middle_names := NULL;
2233: l_ghr_cpdf_temp_rec.name_title := NULL;
2234: l_ghr_cpdf_temp_rec.SCD_rif := NULL;
2235: l_ghr_cpdf_temp_rec.SCD_retirement := NULL;
2236: END IF; -- not in 817
2237: END IF;

Line 2234: l_ghr_cpdf_temp_rec.SCD_rif := NULL;

2230: l_ghr_cpdf_temp_rec.employee_last_name := NULL;
2231: l_ghr_cpdf_temp_rec.employee_first_name := NULL;
2232: l_ghr_cpdf_temp_rec.employee_middle_names := NULL;
2233: l_ghr_cpdf_temp_rec.name_title := NULL;
2234: l_ghr_cpdf_temp_rec.SCD_rif := NULL;
2235: l_ghr_cpdf_temp_rec.SCD_retirement := NULL;
2236: END IF; -- not in 817
2237: END IF;
2238: -- EHRI changes END

Line 2235: l_ghr_cpdf_temp_rec.SCD_retirement := NULL;

2231: l_ghr_cpdf_temp_rec.employee_first_name := NULL;
2232: l_ghr_cpdf_temp_rec.employee_middle_names := NULL;
2233: l_ghr_cpdf_temp_rec.name_title := NULL;
2234: l_ghr_cpdf_temp_rec.SCD_rif := NULL;
2235: l_ghr_cpdf_temp_rec.SCD_retirement := NULL;
2236: END IF; -- not in 817
2237: END IF;
2238: -- EHRI changes END
2239: --

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2260: IF l_ghr_cpdf_temp_rec.to_supervisory_differential IS NULL THEN

2256: l_ghr_cpdf_temp_rec.to_pay_rate_determinant:= l_ghr_pa_requests_rec.pay_rate_determinant;
2257: l_ghr_cpdf_temp_rec.position_title := l_ghr_pa_requests_rec.from_position_title;
2258: END IF;
2259:
2260: IF l_ghr_cpdf_temp_rec.to_supervisory_differential IS NULL THEN
2261:
2262: BEGIN
2263: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
2264: ,p_input_value_name => 'Amount'

Line 2267: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential

2263: ghr_api.retrieve_element_entry_value (p_element_name => 'Supervisory Differential'
2264: ,p_input_value_name => 'Amount'
2265: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
2266: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
2267: ,p_value => l_ghr_cpdf_temp_rec.to_supervisory_differential
2268: ,p_multiple_error_flag => l_multi_error_flag);
2269: EXCEPTION
2270: WHEN OTHERS THEN
2271: --Bug # 9329643 Modified SSN to Emp No

Line 2287: IF l_ghr_cpdf_temp_rec.to_retention_allowance IS NULL THEN

2283: Raise CPDF_DYNRPT_ERROR;
2284: END;
2285:
2286: END IF;
2287: IF l_ghr_cpdf_temp_rec.to_retention_allowance IS NULL THEN
2288:
2289: BEGIN
2290: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
2291: ,p_input_value_name => 'Amount'

Line 2294: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance

2290: ghr_api.retrieve_element_entry_value (p_element_name => 'Retention Allowance'
2291: ,p_input_value_name => 'Amount'
2292: ,p_assignment_id => l_ghr_pa_requests_rec.employee_assignment_id
2293: ,p_effective_date => l_ghr_pa_requests_rec.effective_date
2294: ,p_value => l_ghr_cpdf_temp_rec.to_retention_allowance
2295: ,p_multiple_error_flag => l_multi_error_flag);
2296: EXCEPTION
2297: WHEN OTHERS THEN
2298: --Bug # 9329643 Modified SSN to Emp No

Line 2331: l_ghr_cpdf_temp_rec.from_retirement_coverage := ll_per_ei_data.pei_information4;

2327: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2328: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2329: p_per_ei_data => ll_per_ei_data
2330: );
2331: l_ghr_cpdf_temp_rec.from_retirement_coverage := ll_per_ei_data.pei_information4;
2332: -- Cerditable mil serv, frozen serv are already picked up from get_PAR_EI_noac procedure
2333: -- information5 for Frozen service
2334: ll_per_ei_data:=NULL;
2335:

Line 2351: l_ghr_cpdf_temp_rec.creditable_military_service:= SUBSTR(ll_per_ei_data.pei_information5,1,4);

2347: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2348: p_per_ei_data => ll_per_ei_data
2349: );
2350:
2351: l_ghr_cpdf_temp_rec.creditable_military_service:= SUBSTR(ll_per_ei_data.pei_information5,1,4);
2352: ll_per_ei_data :=NULL;
2353:
2354: ghr_history_fetch.fetch_peopleei
2355: (p_person_id => l_ghr_pa_requests_rec.person_id,

Line 2360: l_ghr_cpdf_temp_rec.from_retirement_coverage := ll_per_ei_data.pei_information4;

2356: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
2357: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2358: p_per_ei_data => ll_per_ei_data
2359: );
2360: l_ghr_cpdf_temp_rec.from_retirement_coverage := ll_per_ei_data.pei_information4;
2361: l_ghr_cpdf_temp_rec.Frozen_service:= SUBSTR(ll_per_ei_data.pei_information5,1,4);
2362:
2363: ll_per_ei_data:=NULL;
2364: END IF;

Line 2361: l_ghr_cpdf_temp_rec.Frozen_service:= SUBSTR(ll_per_ei_data.pei_information5,1,4);

2357: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2358: p_per_ei_data => ll_per_ei_data
2359: );
2360: l_ghr_cpdf_temp_rec.from_retirement_coverage := ll_per_ei_data.pei_information4;
2361: l_ghr_cpdf_temp_rec.Frozen_service:= SUBSTR(ll_per_ei_data.pei_information5,1,4);
2362:
2363: ll_per_ei_data:=NULL;
2364: END IF;
2365:

Line 2367: IF l_ghr_cpdf_temp_rec.race_ethnic_info IS NOT NULL THEN

2363: ll_per_ei_data:=NULL;
2364: END IF;
2365:
2366: -- If Ethnicity is reported, RNO should be null
2367: IF l_ghr_cpdf_temp_rec.race_ethnic_info IS NOT NULL THEN
2368: l_ghr_cpdf_temp_rec.race_national_origin := NULL;
2369: END IF;
2370:
2371:

Line 2368: l_ghr_cpdf_temp_rec.race_national_origin := NULL;

2364: END IF;
2365:
2366: -- If Ethnicity is reported, RNO should be null
2367: IF l_ghr_cpdf_temp_rec.race_ethnic_info IS NOT NULL THEN
2368: l_ghr_cpdf_temp_rec.race_national_origin := NULL;
2369: END IF;
2370:
2371:
2372: -- Bug 4542476

Line 2378: IF l_ghr_cpdf_temp_rec.to_pay_rate_determinant IN ('3', 'J', 'K', 'U', 'V', '6', 'E', 'F') THEN

2374: p_effective_date => l_ghr_pa_requests_rec.effective_date);
2375: l_equiv_plan := get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.to_pay_plan));
2376:
2377: -- Bug# 8939586 added the bug fix 5011003 which is fixed for EHRI Dynamics report
2378: IF l_ghr_cpdf_temp_rec.to_pay_rate_determinant IN ('3', 'J', 'K', 'U', 'V', '6', 'E', 'F') THEN
2379: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2380: ELSE
2381: IF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
2382: AND l_equiv_plan = 'GS' THEN

Line 2379: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;

2375: l_equiv_plan := get_equivalent_pay_plan(NVL(l_retained_pay_plan, l_ghr_pa_requests_rec.to_pay_plan));
2376:
2377: -- Bug# 8939586 added the bug fix 5011003 which is fixed for EHRI Dynamics report
2378: IF l_ghr_cpdf_temp_rec.to_pay_rate_determinant IN ('3', 'J', 'K', 'U', 'V', '6', 'E', 'F') THEN
2379: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2380: ELSE
2381: IF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
2382: AND l_equiv_plan = 'GS' THEN
2383: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;

Line 2381: IF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'

2377: -- Bug# 8939586 added the bug fix 5011003 which is fixed for EHRI Dynamics report
2378: IF l_ghr_cpdf_temp_rec.to_pay_rate_determinant IN ('3', 'J', 'K', 'U', 'V', '6', 'E', 'F') THEN
2379: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2380: ELSE
2381: IF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
2382: AND l_equiv_plan = 'GS' THEN
2383: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2384: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_equiv_plan = 'GS'
2385: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN

Line 2383: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;

2379: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2380: ELSE
2381: IF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
2382: AND l_equiv_plan = 'GS' THEN
2383: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2384: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_equiv_plan = 'GS'
2385: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
2386: l_ghr_cpdf_temp_rec.to_locality_adj := 0;
2387: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN

Line 2384: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_equiv_plan = 'GS'

2380: ELSE
2381: IF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
2382: AND l_equiv_plan = 'GS' THEN
2383: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2384: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_equiv_plan = 'GS'
2385: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
2386: l_ghr_cpdf_temp_rec.to_locality_adj := 0;
2387: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
2388: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;

Line 2386: l_ghr_cpdf_temp_rec.to_locality_adj := 0;

2382: AND l_equiv_plan = 'GS' THEN
2383: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2384: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_equiv_plan = 'GS'
2385: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
2386: l_ghr_cpdf_temp_rec.to_locality_adj := 0;
2387: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
2388: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2389: END IF;
2390: END IF;

Line 2387: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN

2383: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2384: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_equiv_plan = 'GS'
2385: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
2386: l_ghr_cpdf_temp_rec.to_locality_adj := 0;
2387: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
2388: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2389: END IF;
2390: END IF;
2391:

Line 2388: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;

2384: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND l_equiv_plan = 'GS'
2385: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
2386: l_ghr_cpdf_temp_rec.to_locality_adj := 0;
2387: ELSIF l_ghr_cpdf_temp_rec.to_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
2388: l_ghr_cpdf_temp_rec.to_locality_adj := NULL;
2389: END IF;
2390: END IF;
2391:
2392: -- For Prior locality pay

Line 2394: IF l_ghr_cpdf_temp_rec.from_pay_rate_determinant IN ('3', 'J', 'K', 'U', 'V', '6', 'E', 'F') THEN

2390: END IF;
2391:
2392: -- For Prior locality pay
2393: -- Bug 8939586
2394: IF l_ghr_cpdf_temp_rec.from_pay_rate_determinant IN ('3', 'J', 'K', 'U', 'V', '6', 'E', 'F') THEN
2395: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
2396: ELSE
2397: IF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
2398: AND l_equiv_plan = 'GS' THEN

Line 2395: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;

2391:
2392: -- For Prior locality pay
2393: -- Bug 8939586
2394: IF l_ghr_cpdf_temp_rec.from_pay_rate_determinant IN ('3', 'J', 'K', 'U', 'V', '6', 'E', 'F') THEN
2395: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
2396: ELSE
2397: IF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
2398: AND l_equiv_plan = 'GS' THEN
2399: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;

Line 2397: IF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'

2393: -- Bug 8939586
2394: IF l_ghr_cpdf_temp_rec.from_pay_rate_determinant IN ('3', 'J', 'K', 'U', 'V', '6', 'E', 'F') THEN
2395: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
2396: ELSE
2397: IF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
2398: AND l_equiv_plan = 'GS' THEN
2399: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
2400: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_equiv_plan = 'GS'
2401: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN

Line 2399: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;

2395: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
2396: ELSE
2397: IF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
2398: AND l_equiv_plan = 'GS' THEN
2399: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
2400: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_equiv_plan = 'GS'
2401: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
2402: l_ghr_cpdf_temp_rec.from_locality_adj := 0;
2403: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN

Line 2400: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_equiv_plan = 'GS'

2396: ELSE
2397: IF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_locality_pay_area_code = 'ZZ'
2398: AND l_equiv_plan = 'GS' THEN
2399: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
2400: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_equiv_plan = 'GS'
2401: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
2402: l_ghr_cpdf_temp_rec.from_locality_adj := 0;
2403: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
2404: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;

Line 2402: l_ghr_cpdf_temp_rec.from_locality_adj := 0;

2398: AND l_equiv_plan = 'GS' THEN
2399: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
2400: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_equiv_plan = 'GS'
2401: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
2402: l_ghr_cpdf_temp_rec.from_locality_adj := 0;
2403: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
2404: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
2405: END IF;
2406: -- End Bug 4542476

Line 2403: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN

2399: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
2400: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_equiv_plan = 'GS'
2401: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
2402: l_ghr_cpdf_temp_rec.from_locality_adj := 0;
2403: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
2404: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
2405: END IF;
2406: -- End Bug 4542476
2407: END IF;

Line 2404: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;

2400: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND l_equiv_plan = 'GS'
2401: AND NVL(l_locality_pay_area_code,'-1') <> 'ZZ' THEN
2402: l_ghr_cpdf_temp_rec.from_locality_adj := 0;
2403: ELSIF l_ghr_cpdf_temp_rec.from_locality_adj = 0 AND NVL(l_equiv_plan,'-1') <> 'GS' THEN
2404: l_ghr_cpdf_temp_rec.from_locality_adj := NULL;
2405: END IF;
2406: -- End Bug 4542476
2407: END IF;
2408:

Line 2428: insert_row(l_ghr_cpdf_temp_rec);

2424: '; ** Error Message ** : ' ||substr(sqlerrm,1,1000);
2425: END;
2426: -- End of changes for CPDF reports picking creditable mil serv, frozen serv and prev retirement coverage
2427: -- 3327389 Bug fix end
2428: insert_row(l_ghr_cpdf_temp_rec);
2429: l_records_found:=TRUE;
2430: --
2431: <>
2432: NULL;

Line 2488: END populate_ghr_cpdf_temp;

2484: --
2485: hr_utility.set_location('Leaving:'||l_proc, 99);
2486: -- hr_utility.trace_off;
2487: --
2488: END populate_ghr_cpdf_temp;
2489: --
2490: END ghr_cpdf_dynrpt;