72:
73: g_ghr_cpdf_temp GHR_CPDF_TEMP%ROWTYPE;
74: g_agency VARCHAR2(04);
75: g_report_date DATE;
76: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
77: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
78: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
79: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
80: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
73: g_ghr_cpdf_temp GHR_CPDF_TEMP%ROWTYPE;
74: g_agency VARCHAR2(04);
75: g_report_date DATE;
76: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
77: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
78: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
79: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
80: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
81: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
74: g_agency VARCHAR2(04);
75: g_report_date DATE;
76: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
77: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
78: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
79: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
80: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
81: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
82: g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;
75: g_report_date DATE;
76: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
77: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
78: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
79: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
80: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
81: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
82: g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;
83: --Begin Bug# 4168162
76: g_assignment_id PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
77: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
78: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
79: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
80: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
81: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
82: g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;
83: --Begin Bug# 4168162
84: g_message_name ghr_process_log.message_name%type;
77: g_person_id PER_ASSIGNMENTS_F.PERSON_ID%TYPE;
78: g_position_id PER_ASSIGNMENTS_F.POSITION_ID%TYPE;
79: g_grade_id PER_ASSIGNMENTS_F.GRADE_ID%TYPE;
80: g_job_id PER_ASSIGNMENTS_F.JOB_ID%TYPE;
81: g_location_id PER_ASSIGNMENTS_F.LOCATION_ID%TYPE;
82: g_appointment_date PER_PEOPLE_V.HIRE_DATE%TYPE;
83: --Begin Bug# 4168162
84: g_message_name ghr_process_log.message_name%type;
85: --End Bug# 4168162