APPS.CSF_REQUESTS_PVT dependencies on CSF_R_SPARES_OPTIONS

Line 267: FROM csf_r_resource_results rr, csf_r_spares_options so

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
271: AND so.resource_result_id(+) = rr.resource_result_id

Line 302: INSERT INTO csf_r_spares_options

298: END IF;
299: CLOSE c_resource;
300:
301: IF l_resource_rec.spares_option_id IS NULL THEN
302: INSERT INTO csf_r_spares_options
303: (
304: spares_option_id
305: , resource_result_id
306: , availability_date

Line 311: csf_r_spares_options_s1.NEXTVAL

307: , COST
308: , object_version_number
309: )
310: VALUES (
311: csf_r_spares_options_s1.NEXTVAL
312: , l_resource_rec.resource_result_id
313: , p_spares_date
314: , p_spares_cost
315: , 1

Line 656: FROM csf_r_resource_results rr, csf_r_spares_options so

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
660: AND so.resource_result_id(+) = rr.resource_result_id

Line 715: INSERT INTO csf_r_spares_options

711: l_spares_shippingDistance :=p_spares_shippingDistance_tbl(j);
712: END IF;
713:
714: IF l_resource_rec.spares_option_id IS NULL THEN
715: INSERT INTO csf_r_spares_options
716: (
717: spares_option_id
718: , resource_result_id
719: , availability_date

Line 727: csf_r_spares_options_s1.NEXTVAL

723: , shipment_method
724: , distance
725: )
726: VALUES (
727: csf_r_spares_options_s1.NEXTVAL
728: , l_resource_rec.resource_result_id
729: , p_spares_date_tbl(j)
730: , p_spares_cost_tbl(j)
731: , 1