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