133:
134: FUNCTION get_vehicle_info
135: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
136: p_date_earned DATE,
137: p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,
138: p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,
139: p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE
140: )
141: return NUMBER;
134: FUNCTION get_vehicle_info
135: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
136: p_date_earned DATE,
137: p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,
138: p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,
139: p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE
140: )
141: return NUMBER;
142:
135: ( p_assignment_id per_all_assignments_f.assignment_id%TYPE,
136: p_date_earned DATE,
137: p_list_price OUT NOCOPY pqp_vehicle_repository_f.LIST_PRICE%TYPE,
138: p_reg_number OUT NOCOPY pqp_vehicle_repository_f.REGISTRATION_NUMBER%TYPE,
139: p_reg_date OUT NOCOPY pqp_vehicle_repository_f.INITIAL_REGISTRATION%TYPE
140: )
141: return NUMBER;
142:
143: -- function for Norway BIK Company Cars to get number of periods and months