137: l_as_alpha_prefix VARCHAR2(30);
138: l_transaction_date DATE;
139: l_orig_shipped NUMBER; /* Bug 2312461 */
140:
141: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
142: l_quantity_reserved NUMBER;
143: l_qty_to_reserve NUMBER;
144: l_rsv_id NUMBER := 0;
145: l_sales_order_id NUMBER;
2207: ,p_prim_reservation_qty IN NUMBER DEFAULT NULL -- 12794393
2208: )IS
2209:
2210: l_locator_id NUMBER := 0;
2211: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2212: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
2213: l_quantity_reserved NUMBER;
2214: l_quantity2_reserved NUMBER; -- INVCONV
2215: l_qty2_to_be_reserved NUMBER; --INVCONV
2208: )IS
2209:
2210: l_locator_id NUMBER := 0;
2211: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2212: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
2213: l_quantity_reserved NUMBER;
2214: l_quantity2_reserved NUMBER; -- INVCONV
2215: l_qty2_to_be_reserved NUMBER; --INVCONV
2216: l_rsv_id NUMBER := 0;
2233: l_reservation_rec.reservation_id := fnd_api.g_miss_num; -- cannot know
2234: l_reservation_rec.requirement_date := p_line_rec.schedule_ship_date;
2235: l_reservation_rec.organization_id := p_line_rec.ship_from_org_id;
2236: l_reservation_rec.inventory_item_id := p_line_rec.inventory_item_id;
2237: l_reservation_rec.demand_source_type_id := INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;
2238: l_reservation_rec.demand_source_name := NULL;
2239:
2240: -- Get demand_source_header_id from mtl_sales_orders
2241:
2264: l_reservation_rec.primary_reservation_quantity := p_prim_reservation_qty; -- 12794393
2265: l_reservation_rec.autodetail_group_id := NULL;
2266: l_reservation_rec.external_source_code := NULL;
2267: l_reservation_rec.external_source_line_id := NULL;
2268: l_reservation_rec.supply_source_type_id := INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;
2269: l_reservation_rec.supply_source_header_id := NULL;
2270: l_reservation_rec.supply_source_line_id := NULL;
2271: l_reservation_rec.supply_source_name := NULL;
2272: l_reservation_rec.supply_source_line_detail := NULL;