143:
144: FUNCTION get_vehicle_info
145: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
146: p_date_earned DATE,
147: p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,
148: p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,
149: p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE
150: )
151: return NUMBER;
144: FUNCTION get_vehicle_info
145: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
146: p_date_earned DATE,
147: p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,
148: p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,
149: p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE
150: )
151: return NUMBER;
152:
145: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
146: p_date_earned DATE,
147: p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,
148: p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,
149: p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE
150: )
151: return NUMBER;
152:
153: -- function for Norway BIK Company Cars to get number of periods and months