APPS.CSF_REQUESTS_PVT dependencies on CSF_R_PLAN_OPTIONS

Line 266: , csf_r_plan_options_s1.NEXTVAL plan_option_id

262: , p_spares_cost NUMBER
263: ) IS
264: SELECT rr.resource_result_id
265: , so.spares_option_id
266: , csf_r_plan_options_s1.NEXTVAL plan_option_id
267: FROM csf_r_resource_results rr, csf_r_spares_options so
268: WHERE rr.request_task_id = p_request_task_id
269: AND rr.resource_id = p_resource_id
270: AND rr.resource_type = p_resource_type

Line 320: INSERT INTO csf_r_plan_options

316: )
317: RETURNING spares_option_id INTO l_resource_rec.spares_option_id;
318: END IF;
319:
320: INSERT INTO csf_r_plan_options
321: (
322: plan_option_id
323: , resource_result_id
324: , spares_option_id

Line 655: , csf_r_plan_options_s1.NEXTVAL plan_option_id

651: , p_spares_cost NUMBER
652: ) IS
653: SELECT rr.resource_result_id
654: , so.spares_option_id
655: , csf_r_plan_options_s1.NEXTVAL plan_option_id
656: FROM csf_r_resource_results rr, csf_r_spares_options so
657: WHERE rr.request_task_id = p_request_task_id
658: AND rr.resource_id = p_resource_id
659: AND rr.resource_type = p_resource_type

Line 743: INSERT INTO csf_r_plan_options

739: IF p_shift_type_tbl IS NOT NULL THEN
740: l_shift_type := p_shift_type_tbl(j);
741: END IF;
742:
743: INSERT INTO csf_r_plan_options
744: (
745: plan_option_id
746: , resource_result_id
747: , spares_option_id