DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_RESERVE_PVT dependencies on INV_RESERVATION_GLOBAL

Line 45: mtl_res_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;

41: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
42: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
43: l_reservation_val_tbl OE_Order_Pub.Reservation_Val_Tbl_Type;
44:
45: mtl_res_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
46:
47: l_mtl_sales_order_id NUMBER;
48: l_reservation_id NUMBER;
49: l_qty_already_rsv_loop NUMBER := 0;

Line 180: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD; -- Internal Order

176: mtl_res_rec.inventory_item_id := l_line_tbl(l_reservation_tbl(I).line_index).inventory_item_id;
177: -- aksingh this change made on 07/28/00 after 11i2
178: If l_line_tbl(l_reservation_tbl(I).line_index).order_source_id = 10 then
179: mtl_res_rec.demand_source_type_id :=
180: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD; -- Internal Order
181: else
182: mtl_res_rec.demand_source_type_id :=
183: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- Order Entry
184: end if;

Line 183: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- Order Entry

179: mtl_res_rec.demand_source_type_id :=
180: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD; -- Internal Order
181: else
182: mtl_res_rec.demand_source_type_id :=
183: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- Order Entry
184: end if;
185: mtl_res_rec.demand_source_name := NULL;
186: mtl_res_rec.demand_source_header_id := l_mtl_sales_order_id;
187: mtl_res_rec.demand_source_line_id := l_line_tbl(l_reservation_tbl(I).line_index).line_id;

Line 200: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;

196: mtl_res_rec.autodetail_group_id := NULL;
197: mtl_res_rec.external_source_code := NULL;
198: mtl_res_rec.external_source_line_id := NULL;
199: mtl_res_rec.supply_source_type_id :=
200: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;
201: mtl_res_rec.supply_source_header_id := NULL;
202: mtl_res_rec.supply_source_line_id := NULL;
203: mtl_res_rec.supply_source_name := NULL;
204: mtl_res_rec.supply_source_line_detail := NULL;

Line 490: p_rsv IN INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE

486: ------------------------------------------------------------------
487: */
488:
489: PROCEDURE Create_Reservation (
490: p_rsv IN INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE
491: ,p_rsv_id OUT NOCOPY NUMBER
492:
493: ,p_msg_count OUT NOCOPY NUMBER
494:

Line 501: l_rsv INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE :=p_rsv;

497: ,p_return_status OUT NOCOPY VARCHAR2
498:
499: )
500: IS
501: l_rsv INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE :=p_rsv;
502: l_dummy_sn INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
503: l_rsv_id NUMBER;
504: l_rsv_qty NUMBER;
505: l_rsv_qty2 NUMBER; -- INVCONV

Line 502: l_dummy_sn INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE;

498:
499: )
500: IS
501: l_rsv INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE :=p_rsv;
502: l_dummy_sn INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
503: l_rsv_id NUMBER;
504: l_rsv_qty NUMBER;
505: l_rsv_qty2 NUMBER; -- INVCONV
506: l_msg_index NUMBER;

Line 608: p_rsv IN INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE

604:
605:
606:
607: PROCEDURE Delete_Reservation (
608: p_rsv IN INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE
609: ,p_msg_count OUT NOCOPY NUMBER
610:
611: ,p_msg_data OUT NOCOPY VARCHAR2
612:

Line 617: l_rsv INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE :=p_rsv;

613: ,p_return_status OUT NOCOPY VARCHAR2
614:
615: )
616: IS
617: l_rsv INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE :=p_rsv;
618: l_dummy_sn INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
619: l_msg_index NUMBER;
620: l_msg_count NUMBER;
621: l_msg_data VARCHAR2(240);

Line 618: l_dummy_sn INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE;

614:
615: )
616: IS
617: l_rsv INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE :=p_rsv;
618: l_dummy_sn INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
619: l_msg_index NUMBER;
620: l_msg_count NUMBER;
621: l_msg_data VARCHAR2(240);
622: l_return_status VARCHAR2(1);