242: , p_spares_cost NUMBER
243: ) IS
244: SELECT rr.resource_result_id
245: , so.spares_option_id
246: , csf_r_plan_options_s1.NEXTVAL plan_option_id
247: FROM csf_r_resource_results rr, csf_r_spares_options so
248: WHERE rr.request_task_id = p_request_task_id
249: AND rr.resource_id = p_resource_id
250: AND rr.resource_type = p_resource_type
296: )
297: RETURNING spares_option_id INTO l_resource_rec.spares_option_id;
298: END IF;
299:
300: INSERT INTO csf_r_plan_options
301: (
302: plan_option_id
303: , resource_result_id
304: , spares_option_id
621: , p_spares_cost NUMBER
622: ) IS
623: SELECT rr.resource_result_id
624: , so.spares_option_id
625: , csf_r_plan_options_s1.NEXTVAL plan_option_id
626: FROM csf_r_resource_results rr, csf_r_spares_options so
627: WHERE rr.request_task_id = p_request_task_id
628: AND rr.resource_id = p_resource_id
629: AND rr.resource_type = p_resource_type
681: )
682: RETURNING spares_option_id INTO l_resource_rec.spares_option_id;
683: END IF;
684:
685: INSERT INTO csf_r_plan_options
686: (
687: plan_option_id
688: , resource_result_id
689: , spares_option_id