3:
4: -- create the record types here
5: type position_data_rec_type is record
6: (position_id per_positions.position_id%TYPE,
7: organization_id per_organization_units.organization_id%TYPE,
8: job_id per_positions.job_id%TYPE,
9: agency_code_subelement per_position_definitions.segment1%TYPE,
10: location_id hr_locations.location_id%TYPE,
11: effective_end_date date,