1 package OE_RESERVE_CONC AUTHID CURRENT_USER as
2 /* $Header: OEXCRSVS.pls 120.4.12020000.2 2012/07/03 09:50:20 amallik 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 project_id NUMBER, --13397472
47 task_id NUMBER --13397472
48 );
49
50 TYPE Rsv_Tbl_Type IS TABLE OF Res_Rec_Type
51 INDEX BY BINARY_INTEGER;
52
53
54 Procedure Reserve
55 (ERRBUF OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
56 RETCODE OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
57 /* Moac */
58 p_org_id IN NUMBER,
59 p_use_reservation_time_fence IN CHAR,
60 p_order_number_low IN NUMBER,
61 p_order_number_high IN NUMBER,
62 p_customer_id IN VARCHAR2,
63 p_order_type IN VARCHAR2,
64 p_line_type_id IN VARCHAR2,
65 p_warehouse IN VARCHAR2,
66 p_inventory_item_id IN VARCHAR2,
67 p_request_date_low IN VARCHAR2,
68 p_request_date_high IN VARCHAR2,
69 p_schedule_ship_date_low IN VARCHAR2,
70 p_schedule_ship_date_high IN VARCHAR2,
71 p_schedule_arrival_date_low IN VARCHAR2,
72 p_schedule_arrival_date_high IN VARCHAR2,
73 p_ordered_date_low IN VARCHAR2,
74 p_ordered_date_high IN VARCHAR2,
75 p_demand_class_code IN VARCHAR2,
76 p_planning_priority IN NUMBER,
77 p_booked IN VARCHAR2 DEFAULT NULL,
78 p_reservation_mode IN VARCHAR2 DEFAULT NULL,
79 p_dummy1 IN VARCHAR2 DEFAULT NULL,
80 p_dummy2 IN VARCHAR2 DEFAULT NULL,
81 p_percent IN NUMBER DEFAULT NULL,
82 p_shipment_priority IN VARCHAR2 DEFAULT NULL,
83 p_reserve_run_type IN VARCHAR2 DEFAULT NULL,
84 p_reserve_set_name IN VARCHAR2 DEFAULT NULL,
85 p_override_set IN VARCHAR2 DEFAULT NULL,
86 p_order_by IN VARCHAR2,
87 p_selected_ids IN VARCHAR2 DEFAULT NULL,
88 p_dummy3 IN VARCHAR2 DEFAULT NULL,
89 p_partial_preference IN VARCHAR2 DEFAULT 'N'
90 );
91
92 Procedure Reserve_Eligible
93 ( p_line_rec IN OE_ORDER_PUB.line_rec_type,
94 p_use_reservation_time_fence IN VARCHAR2,
95 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96 );
97
98 Procedure Create_Reservation
99 (p_line_rec IN OE_ORDER_PUB.line_rec_type,
100 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
101
102
103 Procedure Calculate_Percentage
104 ( p_inventory_item_id IN NUMBER,
105 p_ship_from_org_id IN NUMBER,
106 p_subinventory IN VARCHAR2,
107 p_rsv_tbl IN OE_RESERVE_CONC.rsv_tbl_type,
108 x_percentage OUT NOCOPY /* file.sql.39 change */ NUMBER,
109 x_primary_uom OUT NOCOPY VARCHAR2 -- 4695715
110 );
111
112 Procedure Create_Reservation
113 (p_x_rsv_tbl IN OUT NOCOPY OE_RESERVE_CONC.rsv_tbl_type,
114 p_partial_reservation IN VARCHAR2 DEFAULT FND_API.G_TRUE,
115 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
116 );
117
118
119 END OE_RESERVE_CONC;