DBA Data[Home] [Help]

APPS.OE_RESERVE_CONC dependencies on INV_RESERVATION_GLOBAL

Line 198: l_failed_rsv_temp_tbl INV_RESERVATION_GLOBAL.mtl_failed_rsv_tbl_type;

194: IS
195: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
196: l_msg_count NUMBER;
197: l_msg_data VARCHAR2(1000);
198: l_failed_rsv_temp_tbl INV_RESERVATION_GLOBAL.mtl_failed_rsv_tbl_type;
199: --
200: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
201: --
202:

Line 1341: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;

1337: p_partial_reservation IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1338: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1339: IS
1340: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1341: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;
1342: l_msg_count NUMBER;
1343: l_dummy_sn Inv_Reservation_Global.Serial_Number_Tbl_Type;
1344: l_msg_data VARCHAR2(1000);
1345: l_buffer VARCHAR2(1000);

Line 1343: l_dummy_sn Inv_Reservation_Global.Serial_Number_Tbl_Type;

1339: IS
1340: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1341: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;
1342: l_msg_count NUMBER;
1343: l_dummy_sn Inv_Reservation_Global.Serial_Number_Tbl_Type;
1344: l_msg_data VARCHAR2(1000);
1345: l_buffer VARCHAR2(1000);
1346: l_quantity_reserved NUMBER;
1347: l_quantity2_reserved NUMBER; -- INVCONV

Line 1420: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD; -- intenal order

1416: IF p_x_rsv_tbl(I).source_document_type_id = 10 THEN
1417: -- This is an internal order line. We need to give
1418: -- a different demand source type for these lines.
1419: l_reservation_rec.demand_source_type_id :=
1420: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD; -- intenal order
1421: ELSE
1422: l_reservation_rec.demand_source_type_id :=
1423: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry
1424: END IF;

Line 1423: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry

1419: l_reservation_rec.demand_source_type_id :=
1420: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD; -- intenal order
1421: ELSE
1422: l_reservation_rec.demand_source_type_id :=
1423: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry
1424: END IF;
1425: l_reservation_rec.demand_source_header_id :=
1426: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_x_rsv_tbl(I).header_id);
1427: l_reservation_rec.demand_source_line_id := p_x_rsv_tbl(I).line_id;

Line 1462: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;

1458: END IF;
1459:
1460:
1461: l_reservation_rec.supply_source_type_id :=
1462: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;
1463: l_reservation_rec.subinventory_code := p_x_rsv_tbl(I).subinventory;
1464: -- check if derived qty has changed then validate the quantity
1465: IF NVL(l_reservation_rec.reservation_quantity,0)
1466: <> NVL(p_x_rsv_tbl(I).derived_reserved_qty_mir,0) THEN

Line 1978: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;

1974: (p_line_rec IN OE_ORDER_PUB.line_rec_type,
1975: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1976: IS
1977: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1978: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;
1979: l_msg_count NUMBER;
1980: l_dummy_sn Inv_Reservation_Global.Serial_Number_Tbl_Type;
1981: l_msg_data VARCHAR2(1000);
1982: l_buffer VARCHAR2(1000);

Line 1980: l_dummy_sn Inv_Reservation_Global.Serial_Number_Tbl_Type;

1976: IS
1977: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1978: l_reservation_rec Inv_Reservation_Global.Mtl_Reservation_Rec_Type;
1979: l_msg_count NUMBER;
1980: l_dummy_sn Inv_Reservation_Global.Serial_Number_Tbl_Type;
1981: l_msg_data VARCHAR2(1000);
1982: l_buffer VARCHAR2(1000);
1983: l_quantity_reserved NUMBER;
1984: l_quantity_to_reserve NUMBER;