APPS.CSF_REQUESTS_PVT dependencies on CSF_R_SPARES_OPTIONS

Line 247: FROM csf_r_resource_results rr, csf_r_spares_options so

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

Line 282: INSERT INTO csf_r_spares_options

278: END IF;
279: CLOSE c_resource;
280:
281: IF l_resource_rec.spares_option_id IS NULL THEN
282: INSERT INTO csf_r_spares_options
283: (
284: spares_option_id
285: , resource_result_id
286: , availability_date

Line 291: csf_r_spares_options_s1.NEXTVAL

287: , COST
288: , object_version_number
289: )
290: VALUES (
291: csf_r_spares_options_s1.NEXTVAL
292: , l_resource_rec.resource_result_id
293: , p_spares_date
294: , p_spares_cost
295: , 1

Line 626: FROM csf_r_resource_results rr, csf_r_spares_options so

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

Line 667: INSERT INTO csf_r_spares_options

663: END IF;
664: CLOSE c_resource;
665:
666: IF l_resource_rec.spares_option_id IS NULL THEN
667: INSERT INTO csf_r_spares_options
668: (
669: spares_option_id
670: , resource_result_id
671: , availability_date

Line 676: csf_r_spares_options_s1.NEXTVAL

672: , COST
673: , object_version_number
674: )
675: VALUES (
676: csf_r_spares_options_s1.NEXTVAL
677: , l_resource_rec.resource_result_id
678: , p_spares_date_tbl(j)
679: , p_spares_cost_tbl(j)
680: , 1