1 PACKAGE OE_Delayed_Requests_UTIL AS
2 /* $Header: OEXUREQS.pls 120.1.12010000.3 2008/11/19 10:35:40 vbkapoor ship $ */
3
4 -- bug 5738023
5 TYPE t_list_line_rec is Record
6 ( line_id NUMBER);
7 TYPE Line_ID_List IS TABLE OF t_list_line_rec INDEX BY BINARY_INTEGER;
8
9 -- for bug 2372098
10 Type t_line_rec IS RECORD
11 ( header_id NUMBER
12 , line_id NUMBER
13 , shipment_number NUMBER
14 , line_number NUMBER
15 , option_number NUMBER
16 , component_number NUMBER
17 , service_txn_reason_code VARCHAR2(30)
18 , service_txn_comments VARCHAR2(2000)
19 , service_duration NUMBER
20 , service_period VARCHAR2(3)
21 , service_start_date DATE
22 , service_end_date DATE
23 , service_coterminate_flag VARCHAR2(1)
24 , ordered_quantity NUMBER
25 );
26 l_child t_line_rec;
27
28
29 -- l_child would be used to fetch records from the cursor srv_children
30 -- in the procedure INSERT_SERVICE_FOR_OPTIONS
31 -- end bug 2372098
32
33 Procedure Validate_LSC_QUOTA_TOTAL
34 ( x_return_status OUT NOCOPY VARCHAR2
35
36 , p_line_id IN NUMBER);
37
38 Procedure Validate_HSC_QUOTA_TOTAL
39 ( x_return_status OUT NOCOPY VARCHAR2
40
41 , p_header_id IN NUMBER);
42
43 Procedure Cascade_Service_Scredit
44 ( x_return_status OUT NOCOPY Varchar2
45
46 ,p_request_rec IN OE_ORDER_PUB.request_rec_type);
47
48
49 Procedure DFLT_Hscredit_Primary_Srep
50 ( p_header_id IN NUMBER
51 , p_SalesRep_id IN NUMBER
52 , x_return_status OUT NOCOPY VARCHAR2
53
54 );
55
56 PROCEDURE update_link_to_line_id
57 ( x_return_status OUT NOCOPY VARCHAR2
58
59 ,p_top_model_line_id IN NUMBER
60 );
61 PROCEDURE check_duplicate
62 (P_request_rec IN OE_ORDER_PUB.request_rec_type
63 ,x_return_status OUT NOCOPY VARCHAR2);
64
65
66 PROCEDURE check_fixed_price
67 (P_request_rec IN OE_ORDER_PUB.request_rec_type
68 ,x_return_status OUT NOCOPY VARCHAR2);
69
70
71 PROCEDURE check_percentage
72 (P_request_rec IN OE_ORDER_PUB.request_rec_type
73 ,x_return_status OUT NOCOPY VARCHAR2);
74
75
76 PROCEDURE create_config_item
77 ( x_return_status OUT NOCOPY VARCHAR2
78
79 , p_top_model_line_id IN NUMBER
80 , p_header_id IN NUMBER
81 );
82
83 PROCEDURE ins_included_items
84 ( x_return_status OUT NOCOPY VARCHAR2
85
86 , p_line_id IN NUMBER
87 );
88
89 PROCEDURE verify_payment
90 ( x_return_status OUT NOCOPY VARCHAR2
91
92 , p_header_id IN NUMBER
93 );
94
95 Procedure INSERT_RMA_SCREDIT_ADJUSTMENT
96 (p_line_id IN NUMBER
97 ,x_return_status OUT NOCOPY VARCHAR2
98
99 );
100
101 Procedure INSERT_RMA_OPTIONS_INCLUDED
102 (p_line_id IN NUMBER
103 ,x_return_status OUT NOCOPY VARCHAR2
104
105 );
106
107 Procedure INSERT_RMA_LOT_SERIAL
108 (p_line_id IN NUMBER
109 ,x_return_status OUT NOCOPY VARCHAR2
110
111 );
112
113 /* - Commenting out this procedure as it is not needed in R12
114 PROCEDURE Tax_Line
115 (x_return_status OUT NOCOPY VARCHAR2
116 ,p_line_id IN NUMBER
117 );
118 */
119
120
121 PROCEDURE split_hold
122 (p_entity_code IN VARCHAR2
123 ,p_entity_id IN NUMBER
124 ,p_split_from_line_id IN NUMBER
125 ,x_return_status OUT NOCOPY VARCHAR2
126
127 );
128
129 PROCEDURE Eval_Hold_Source
130 ( x_return_status OUT NOCOPY VARCHAR2
131
132 , p_entity_code IN VARCHAR2
133 , p_entity_id IN NUMBER
134 , p_hold_entity_code IN VARCHAR2
135 --ER#7479609 , p_hold_entity_id IN NUMBER
136 , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
137 );
138
139 PROCEDURE Apply_Hold
140 ( p_validation_level IN NUMBER
141 , x_request_rec IN OUT NOCOPY OE_Order_PUB.Request_Rec_Type
142 );
143
144 PROCEDURE Release_Hold
145 (p_validation_level IN NUMBER
146 ,x_request_rec IN OUT NOCOPY OE_Order_PUB.Request_Rec_Type
147 );
148
149 PROCEDURE Insert_Set
150 (P_request_rec IN OE_ORDER_PUB.request_rec_type
151 ,x_return_status OUT NOCOPY VARCHAR2);
152
153
154 PROCEDURE Split_Set
155 (P_request_rec IN OE_ORDER_PUB.request_rec_type
156 ,x_return_status OUT NOCOPY VARCHAR2);
157
158
159 PROCEDURE Book_Order
160 ( p_validation_level IN NUMBER
161 , p_header_id IN NUMBER
162 , x_return_status OUT NOCOPY VARCHAR2
163
164 );
165
166 PROCEDURE Get_Ship_Method
167 (p_entity_code IN VARCHAR2
168 , p_entity_id IN NUMBER
169 , p_action_code IN VARCHAR2
170 , x_return_status OUT NOCOPY VARCHAR2
171
172 );
173
174 PROCEDURE Fulfillment_sets
175 ( p_entity_code IN VARCHAR2
176 , p_entity_id IN VARCHAR2
177 , p_action_code IN VARCHAR2
178 , p_fulfillment_set_name IN VARCHAR2
179 , x_return_status OUT NOCOPY VARCHAR2
180 );
181
182
183 PROCEDURE Ship_Confirmation
184 (p_ship_confirmation_tbl IN OE_ORDER_PUB.request_tbl_type
185 ,p_line_id IN NUMBER
186 ,p_process_type IN VARCHAR2
187 ,p_process_id IN VARCHAR2
188 ,x_return_status OUT NOCOPY VARCHAR2);
189
190
191 PROCEDURE Update_Shipping
192 (p_update_shipping_tbl IN OE_ORDER_PUB.request_tbl_type
193 ,p_line_id IN NUMBER
194 ,p_operation IN VARCHAR2
195 ,x_return_status OUT NOCOPY VARCHAR2);
196
197
198 PROCEDURE SPLIT_RESERVATIONS
199 ( p_reserved_line_id IN NUMBER
200 , p_ordered_quantity IN NUMBER
201 , p_reserved_quantity IN NUMBER
202 , x_return_status OUT NOCOPY VARCHAR2
203
204 );
205
206 Procedure COMPLETE_CONFIGURATION
207 ( p_top_model_line_id IN NUMBER
208 , x_return_status OUT NOCOPY VARCHAR2);
209
210
211 Procedure VALIDATE_CONFIGURATION
212 ( p_top_model_line_id IN NUMBER
213 , p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
214 , p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
215 , x_return_status OUT NOCOPY VARCHAR2
216
217 );
218
219
220 Procedure MATCH_AND_RESERVE
221 ( p_line_id IN NUMBER
222 , x_return_status OUT NOCOPY VARCHAR2);
223
224
225 Procedure Group_Schedule
226 (p_request_rec IN OE_ORDER_PUB.request_rec_type
227 ,x_return_status OUT NOCOPY VARCHAR2);
228
229
230 Procedure DELINK_CONFIG
231 ( p_line_id IN NUMBER
232 , x_return_status OUT NOCOPY VARCHAR2);
233
234
235 Procedure Validate_Line_Set
236 ( p_line_set_id IN NUMBER
237 , x_return_status OUT NOCOPY VARCHAR2);
238
239
240 PROCEDURE PROCESS_ADJUSTMENTS
241 ( p_adjust_tbl IN OE_ORDER_PUB.request_tbl_type
242 , x_return_status OUT NOCOPY VARCHAR2);
243
244
245 PROCEDURE INSERT_SERVICE_FOR_OPTIONS
246 ( p_serviced_line_id IN NUMBER
247 , x_return_status OUT NOCOPY VARCHAR2);
248
249
250 /* lchen added for bug 1761154*/
251 PROCEDURE CASCADE_SERVICE_FOR_OPTIONS
252 ( p_option_line_id IN NUMBER
253 , x_return_status OUT NOCOPY VARCHAR2);
254
255
256 PROCEDURE Apply_Automatic_Attachments
257 ( p_entity_code IN VARCHAR2
258 , p_entity_id IN NUMBER
259 , p_is_user_action IN VARCHAR2
260 , x_return_status OUT NOCOPY VARCHAR2
261
262 );
263
264 PROCEDURE Copy_Attachments
265 ( p_entity_code IN VARCHAR2
266 , p_from_entity_id IN NUMBER
267 , p_to_entity_id IN NUMBER
268 , p_manual_attachments_only IN VARCHAR2 DEFAULT 'N'
269 , x_return_status OUT NOCOPY VARCHAR2
270
271 );
272
273 Procedure Schedule_Line
274 ( p_sch_set_tbl IN OE_ORDER_PUB.request_tbl_type
275 , x_return_status OUT NOCOPY VARCHAR2);
276
277
278 PROCEDURE Process_Tax
279 ( p_entity_id_tbl IN OE_Delayed_Requests_PVT.Entity_Id_Tbl_Type
280 , x_return_status OUT NOCOPY VARCHAR2);
281
282 --Included for the Spares Management (Ikon) project mshenoy
283 PROCEDURE auto_create_internal_req
284 (p_ord_header_id IN NUMBER
285 ,x_return_status OUT NOCOPY VARCHAR2);
286
287
288
289 -- BUG 2013611 BEGIN
290 Procedure Reverse_Limits
291 (p_action_code IN VARCHAR2
292 ,p_cons_price_request_code IN VARCHAR2
293 ,p_orig_ordered_qty IN NUMBER DEFAULT NULL
294 ,p_amended_qty IN NUMBER DEFAULT NULL
295 ,p_ret_price_request_code IN VARCHAR2 DEFAULT NULL
296 ,p_returned_qty IN NUMBER DEFAULT NULL
297 ,p_line_id IN NUMBER DEFAULT NULL
298 ,x_return_status OUT NOCOPY VARCHAR2);
299
300 -- BUG 2013611 END
301
302
303 Procedure Process_XML_Delayed_Request (p_request_ind IN NUMBER,
304 x_return_status OUT NOCOPY VARCHAR2);
305
306
307 /* 7576948: IR ISO Change Management project Start */
308 -- This program unit is added for IR ISO Change management
309 -- project, so as to trigger the new program unit
310 -- OE_Process_Requisition_Pvt.Update_Internal_Requisition
311 -- introduced as part of this project, and responsible for
312 -- calling several Purchasing APIs based on the action
313 -- performed on the internal sales order header/line.
314 -- Possible actions can be:
315 -- Header Level FULL Cancellation
316 -- Header Level PARTIAL Cancellation (This is currently
317 -- *NOT* supported on internal requisition)
318 -- Line Level Cancellation
319 -- Line Ordered Quantity update
320 -- Line Schedule Ship/Arrival Date update
321 -- Line Ordered Quantity and Schedule Ship/Arrival Date update
322
323 -- For details on IR ISO CMS project, please refer to FOL >
324 -- OM Development > OM GM > 12.1.1 > TDD > IR_ISO_CMS_TDD.doc
325
326 Procedure Update_Requisition_Info -- Package Specification
327 ( p_header_id IN NUMBER
328 , p_line_id IN NUMBER
329 , P_Line_ids IN VARCHAR2
330 , P_num_records IN NUMBER
331 , P_Requisition_Header_id IN NUMBER
332 , P_Requisition_Line_id IN NUMBER DEFAULT NULL
333 , P_Quantity_Change IN NUMBER DEFAULT NULL
334 , P_New_Schedule_Ship_Date IN DATE DEFAULT NULL
335 , P_Cancel_order IN BOOLEAN
336 , x_return_status OUT NOCOPY VARCHAR2
337 );
338
339 /* ============================= */
340 /* IR ISO Change Management Ends */
341
342
343 END;