1 package OE_RESERVE_CONC as
2 /* $Header: OEXCRSVS.pls 120.3.12010000.2 2008/11/11 08:12:34 rmoharan ship $ */
3
4 OESCH_ACT_RESERVE CONSTANT VARCHAR2(30) := 'RESERVE';
5
6 /* Valid Scheduling Status. */
7
8 SCH_LEVEL_ONE CONSTANT VARCHAR2(30) := 'ONE';
9 SCH_LEVEL_TWO CONSTANT VARCHAR2(30) := 'TWO';
10 SCH_LEVEL_THREE CONSTANT VARCHAR2(30) := 'THREE';
11 SCH_LEVEL_FOUR CONSTANT VARCHAR2(30) := 'FOUR';
12 SCH_LEVEL_FIVE CONSTANT VARCHAR2(30) := 'FIVE';
13
14 /* API message record type */
15
16 TYPE Res_Rec_Type IS RECORD
17 (line_id NUMBER, -- Internal Line id
18 header_id NUMBER, -- Internal Header Id
19 inventory_item_id NUMBER, -- Item being processed
20 ordered_qty NUMBER, -- Ordered Quantity on the line
21 ordered_qty_UOM VARCHAR2(3), -- Ordered qty Uom on the line
22 derived_reserved_qty NUMBER, -- Derived reservation qty based on the logic
23 ordered_qty2 NUMBER, -- Ordered Quantity2 on the line -- INVCONV
24 ordered_qty_UOM2 VARCHAR2(3), -- Ordered qty Uom2 on the line -- INVCONV
25 derived_reserved_qty2 NUMBER, -- Derived reservation qty based on the logic -- INVCONV
26 reserved_qty_UOM VARCHAR2(3), -- Derived reservation qty2 UOM
27 ship_from_org_id NUMBER, -- Warehouse on the line
28 subinventory VARCHAR2(10),-- Subinventory on the line
29 schedule_ship_date DATE, -- Schedule ship date on the line
30 corrected_reserved_qty NUMBER, -- Customer can correct the derived qty
31 corrected_reserved_qty2 NUMBER, -- Customer can correct the derived qty2 -- INVCONV
32 source_document_type_id NUMBER,
33 order_source_id NUMBER, -- For internal use only
34 orig_sys_document_ref VARCHAR2(50),-- For internal use only
35 orig_sys_line_ref VARCHAR2(50),-- For internal use only
36 orig_sys_shipment_ref VARCHAR2(50),-- For internal use only
37 change_sequence VARCHAR2(50),-- For internal use only
38 source_document_id NUMBER, -- For internal use only
39 source_document_line_id NUMBER, -- For internal use only
40 shipped_quantity NUMBER, -- For internal use only
41 shipped_quantity2 NUMBER, -- For internal use only -- INVCONV
42 reservation_exists VARCHAR2(1), -- For internal use only
43 derived_reserved_qty_mir NUMBER, -- For internal use only
44 derived_reserved_qty2_mir NUMBER, -- For internal use only -- INVCONV
45 org_id NUMBER -- MOAC: 4759251
46 );
47
48 TYPE Rsv_Tbl_Type IS TABLE OF Res_Rec_Type
49 INDEX BY BINARY_INTEGER;
50
51
52 Procedure Reserve
53 (ERRBUF OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
54 RETCODE OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
55 /* Moac */
56 p_org_id IN NUMBER,
57 p_use_reservation_time_fence IN CHAR,
58 p_order_number_low IN NUMBER,
59 p_order_number_high IN NUMBER,
60 p_customer_id IN VARCHAR2,
61 p_order_type IN VARCHAR2,
62 p_line_type_id IN VARCHAR2,
63 p_warehouse IN VARCHAR2,
64 p_inventory_item_id IN VARCHAR2,
65 p_request_date_low IN VARCHAR2,
66 p_request_date_high IN VARCHAR2,
67 p_schedule_ship_date_low IN VARCHAR2,
68 p_schedule_ship_date_high IN VARCHAR2,
69 p_schedule_arrival_date_low IN VARCHAR2,
70 p_schedule_arrival_date_high IN VARCHAR2,
71 p_ordered_date_low IN VARCHAR2,
72 p_ordered_date_high IN VARCHAR2,
73 p_demand_class_code IN VARCHAR2,
74 p_planning_priority IN NUMBER,
75 p_booked IN VARCHAR2 DEFAULT NULL,
76 p_reservation_mode IN VARCHAR2 DEFAULT NULL,
77 p_dummy1 IN VARCHAR2 DEFAULT NULL,
78 p_dummy2 IN VARCHAR2 DEFAULT NULL,
79 p_percent IN NUMBER DEFAULT NULL,
80 p_shipment_priority IN VARCHAR2 DEFAULT NULL,
81 p_reserve_run_type IN VARCHAR2 DEFAULT NULL,
82 p_reserve_set_name IN VARCHAR2 DEFAULT NULL,
83 p_override_set IN VARCHAR2 DEFAULT NULL,
84 p_order_by IN VARCHAR2,
85 p_selected_ids IN VARCHAR2 DEFAULT NULL,
86 p_dummy3 IN VARCHAR2 DEFAULT NULL,
87 p_partial_preference IN VARCHAR2 DEFAULT 'N'
88 );
89
90 Procedure Reserve_Eligible
91 ( p_line_rec IN OE_ORDER_PUB.line_rec_type,
92 p_use_reservation_time_fence IN VARCHAR2,
93 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 );
95
96 Procedure Create_Reservation
97 (p_line_rec IN OE_ORDER_PUB.line_rec_type,
98 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
99
100
101 Procedure Calculate_Percentage
102 ( p_inventory_item_id IN NUMBER,
103 p_ship_from_org_id IN NUMBER,
104 p_subinventory IN VARCHAR2,
105 p_rsv_tbl IN OE_RESERVE_CONC.rsv_tbl_type,
106 x_percentage OUT NOCOPY /* file.sql.39 change */ NUMBER,
107 x_primary_uom OUT NOCOPY VARCHAR2 -- 4695715
108 );
109
110 Procedure Create_Reservation
111 (p_x_rsv_tbl IN OUT NOCOPY OE_RESERVE_CONC.rsv_tbl_type,
112 p_partial_reservation IN VARCHAR2 DEFAULT FND_API.G_TRUE,
113 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114 );
115
116
117 END OE_RESERVE_CONC;