DBA Data[Home] [Help]

APPS.OE_DS_PVT dependencies on INV_RESERVATION_GLOBAL

Line 141: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

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;

Line 2211: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

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

Line 2212: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

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;

Line 2237: l_reservation_rec.demand_source_type_id := INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;

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:

Line 2268: l_reservation_rec.supply_source_type_id := INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;

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;