DBA Data[Home] [Help]

APPS.OE_DS_PVT dependencies on INV_RESERVATION_GLOBAL

Line 140: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

136: l_as_alpha_prefix VARCHAR2(30);
137: l_transaction_date DATE;
138: l_orig_shipped NUMBER; /* Bug 2312461 */
139:
140: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
141: l_quantity_reserved NUMBER;
142: l_qty_to_reserve NUMBER;
143: l_rsv_id NUMBER := 0;
144: l_sales_order_id NUMBER;

Line 2185: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

2181: ,p_transfer_lpn_id IN NUMBER -- 3544019
2182: )IS
2183:
2184: l_locator_id NUMBER := 0;
2185: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2186: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
2187: l_quantity_reserved NUMBER;
2188: l_quantity2_reserved NUMBER; -- INVCONV
2189: l_qty2_to_be_reserved NUMBER; --INVCONV

Line 2186: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

2182: )IS
2183:
2184: l_locator_id NUMBER := 0;
2185: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2186: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
2187: l_quantity_reserved NUMBER;
2188: l_quantity2_reserved NUMBER; -- INVCONV
2189: l_qty2_to_be_reserved NUMBER; --INVCONV
2190: l_rsv_id NUMBER := 0;

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

2207: l_reservation_rec.reservation_id := fnd_api.g_miss_num; -- cannot know
2208: l_reservation_rec.requirement_date := p_line_rec.schedule_ship_date;
2209: l_reservation_rec.organization_id := p_line_rec.ship_from_org_id;
2210: l_reservation_rec.inventory_item_id := p_line_rec.inventory_item_id;
2211: l_reservation_rec.demand_source_type_id := INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;
2212: l_reservation_rec.demand_source_name := NULL;
2213:
2214: -- Get demand_source_header_id from mtl_sales_orders
2215:

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

2238: l_reservation_rec.primary_reservation_quantity := NULL;
2239: l_reservation_rec.autodetail_group_id := NULL;
2240: l_reservation_rec.external_source_code := NULL;
2241: l_reservation_rec.external_source_line_id := NULL;
2242: l_reservation_rec.supply_source_type_id := INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;
2243: l_reservation_rec.supply_source_header_id := NULL;
2244: l_reservation_rec.supply_source_line_id := NULL;
2245: l_reservation_rec.supply_source_name := NULL;
2246: l_reservation_rec.supply_source_line_detail := NULL;