[Home] [Help]
203: ship_from_org_id,
204: subinventory,
205: corrected_qty,
206: corrected_qty2 -- INVCONV
207: FROM oe_rsv_set_details
208: WHERE reservation_set_id = p_reservation_set_id
209: AND line_id = p_line_id;
210:
211: TYPE Rsv_set_rec_type IS RECORD
389:
390: /*------------------------------------------------------
391: Procedure Name : Create_Reservation_Set
392: Description : Inserts simulated or reserved records
393: into oe_reservation_sets and oe_rsv_set_details table.
394: --------------------------------------------------------------------- */
395: Procedure Create_Reservation_Set(p_rsv_tbl IN OE_RESERVE_CONC.Rsv_Tbl_Type,
396: p_reserve_set_name IN VARCHAR2,
397: p_rsv_request_id IN NUMBER DEFAULT NULL,
420: FROM oe_reservation_sets
421: WHERE reservation_set_name = P_reserve_set_name;
422: g_set_id := l_set_id;
423: -- Deleting the existing records.
424: DELETE oe_rsv_set_details
425: WHERE reservation_set_id = l_set_id;
426:
427: DELETE oe_reservation_sets
428: WHERE reservation_set_id = l_set_id;
476: FOR I IN 1..p_rsv_tbl.COUNT
477: LOOP
478: l_line_count := l_line_count + 1;
479:
480: INSERT INTO oe_rsv_set_details
481: (Reservation_set_id
482: ,Line_id
483: ,header_id
484: ,inventory_item_id
2462: IF p_selected_ids IS NOT NULL THEN --Pack J
2463: --l_stmt := l_stmt ||' AND l.line_id IN(:selected_ids)'; --p_selected_ids
2464: --R12.MOAC
2465: l_stmt := l_stmt ||' AND l.line_id IN(SELECT line_id FROM
2466: oe_rsv_set_details WHERE reservation_set_id=:set_id)';
2467: END IF;
2468: IF p_reservation_mode = 'PARTIAL_ONLY_UNRESERVED' THEN -- Pack J
2469: l_stmt := l_stmt ||' AND NOT Exists (SELECT 1 FROM mtl_reservations mrs '
2470: ||' WHERE l.line_id = mrs.demand_source_line_id)';
2942: END IF;
2943: END IF; -- Pack J
2944: --R12.MOAC
2945: IF p_selected_ids IS NOT NULL THEN
2946: DELETE FROM oe_rsv_set_details
2947: WHERE reservation_set_id = p_selected_ids;
2948: END IF;
2949:
2950: COMMIT;