APPS.OE_RESERVE_CONC dependencies on INV_RESERVATION_GLOBAL

Line 122: l_failed_rsv_temp_tbl INV_RESERVATION_GLOBAL.mtl_failed_rsv_tbl_type;

118: IS
119: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
120: l_msg_count NUMBER;
121: l_msg_data VARCHAR2(1000);
122: l_failed_rsv_temp_tbl INV_RESERVATION_GLOBAL.mtl_failed_rsv_tbl_type;
123: --
124: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
125: --
126:

Line 1299: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;

1295: p_partial_reservation IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1296: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1297: IS
1298: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1299: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;
1300: l_msg_count NUMBER;
1301: l_dummy_sn Inv_Reservation_Global.Serial_Number_Tbl_Type;
1302: l_msg_data VARCHAR2(1000);
1303: l_buffer VARCHAR2(1000);

Line 1301: l_dummy_sn Inv_Reservation_Global.Serial_Number_Tbl_Type;

1297: IS
1298: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1299: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;
1300: l_msg_count NUMBER;
1301: l_dummy_sn Inv_Reservation_Global.Serial_Number_Tbl_Type;
1302: l_msg_data VARCHAR2(1000);
1303: l_buffer VARCHAR2(1000);
1304: l_quantity_reserved NUMBER;
1305: l_quantity2_reserved NUMBER; -- INVCONV

Line 1378: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD; -- intenal order

1374: IF p_x_rsv_tbl(I).source_document_type_id = 10 THEN
1375: -- This is an internal order line. We need to give
1376: -- a different demand source type for these lines.
1377: l_reservation_rec.demand_source_type_id :=
1378: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD; -- intenal order
1379: ELSE
1380: l_reservation_rec.demand_source_type_id :=
1381: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry
1382: END IF;

Line 1381: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry

1377: l_reservation_rec.demand_source_type_id :=
1378: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD; -- intenal order
1379: ELSE
1380: l_reservation_rec.demand_source_type_id :=
1381: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry
1382: END IF;
1383: l_reservation_rec.demand_source_header_id :=
1384: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_x_rsv_tbl(I).header_id);
1385: l_reservation_rec.demand_source_line_id := p_x_rsv_tbl(I).line_id;

Line 1410: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;

1406: END IF;
1407:
1408:
1409: l_reservation_rec.supply_source_type_id :=
1410: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;
1411: l_reservation_rec.subinventory_code := p_x_rsv_tbl(I).subinventory;
1412: -- check if derived qty has changed then validate the quantity
1413: IF NVL(l_reservation_rec.reservation_quantity,0)
1414: <> NVL(p_x_rsv_tbl(I).derived_reserved_qty_mir,0) THEN

Line 1926: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;

1922: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
1923: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1924: IS
1925: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1926: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;
1927: l_msg_count NUMBER;
1928: l_dummy_sn Inv_Reservation_Global.Serial_Number_Tbl_Type;
1929: l_msg_data VARCHAR2(1000);
1930: l_buffer VARCHAR2(1000);

Line 1928: l_dummy_sn Inv_Reservation_Global.Serial_Number_Tbl_Type;

1924: IS
1925: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1926: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;
1927: l_msg_count NUMBER;
1928: l_dummy_sn Inv_Reservation_Global.Serial_Number_Tbl_Type;
1929: l_msg_data VARCHAR2(1000);
1930: l_buffer VARCHAR2(1000);
1931: l_quantity_reserved NUMBER;
1932: l_quantity_to_reserve NUMBER;