1 PACKAGE CS_InstalledBase_PUB AS
2 /* $Header: cspibs.pls 120.1 2005/08/29 16:34:21 epajaril noship $ */
3
4 -- ---------------------------------------------------------
5 -- Declare Data Types
6 -- ---------------------------------------------------------
7 TYPE DFF_Rec_Type IS RECORD
8 (
9 context VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
10 attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
11 attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
12 attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
13 attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
14 attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
15 attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
16 attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
17 attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
18 attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
19 attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
20 attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
21 attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
22 attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
23 attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
24 attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
25 );
26
27 TYPE OrderInfo_Rec_Type IS RECORD
28 (
29 line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
30 line_service_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM
31 );
32
33 TYPE PRICE_ATT_Rec_Type IS RECORD
34 (
35 PRICING_CONTEXT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
36 PRICING_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
37 PRICING_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
38 PRICING_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
39 PRICING_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
40 PRICING_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
41 PRICING_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
42 PRICING_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43 PRICING_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
44 PRICING_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
45 PRICING_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46 PRICING_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47 PRICING_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48 PRICING_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49 PRICING_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50 PRICING_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51 PRICING_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52 PRICING_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53 PRICING_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54 PRICING_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55 PRICING_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56 PRICING_ATTRIBUTE21 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57 PRICING_ATTRIBUTE22 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58 PRICING_ATTRIBUTE23 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59 PRICING_ATTRIBUTE24 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60 PRICING_ATTRIBUTE25 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61 PRICING_ATTRIBUTE26 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62 PRICING_ATTRIBUTE27 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63 PRICING_ATTRIBUTE28 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64 PRICING_ATTRIBUTE29 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65 PRICING_ATTRIBUTE30 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66 PRICING_ATTRIBUTE31 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67 PRICING_ATTRIBUTE32 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68 PRICING_ATTRIBUTE33 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69 PRICING_ATTRIBUTE34 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70 PRICING_ATTRIBUTE35 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71 PRICING_ATTRIBUTE36 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72 PRICING_ATTRIBUTE37 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73 PRICING_ATTRIBUTE38 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74 PRICING_ATTRIBUTE39 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75 PRICING_ATTRIBUTE40 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76 PRICING_ATTRIBUTE41 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77 PRICING_ATTRIBUTE42 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78 PRICING_ATTRIBUTE43 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79 PRICING_ATTRIBUTE44 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80 PRICING_ATTRIBUTE45 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81 PRICING_ATTRIBUTE46 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82 PRICING_ATTRIBUTE47 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83 PRICING_ATTRIBUTE48 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84 PRICING_ATTRIBUTE49 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85 PRICING_ATTRIBUTE50 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86 PRICING_ATTRIBUTE51 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87 PRICING_ATTRIBUTE52 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88 PRICING_ATTRIBUTE53 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89 PRICING_ATTRIBUTE54 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90 PRICING_ATTRIBUTE55 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91 PRICING_ATTRIBUTE56 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92 PRICING_ATTRIBUTE57 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93 PRICING_ATTRIBUTE58 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94 PRICING_ATTRIBUTE59 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95 PRICING_ATTRIBUTE60 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96 PRICING_ATTRIBUTE61 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97 PRICING_ATTRIBUTE62 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98 PRICING_ATTRIBUTE63 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99 PRICING_ATTRIBUTE64 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100 PRICING_ATTRIBUTE65 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101 PRICING_ATTRIBUTE66 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102 PRICING_ATTRIBUTE67 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103 PRICING_ATTRIBUTE68 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104 PRICING_ATTRIBUTE69 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105 PRICING_ATTRIBUTE70 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106 PRICING_ATTRIBUTE71 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107 PRICING_ATTRIBUTE72 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108 PRICING_ATTRIBUTE73 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109 PRICING_ATTRIBUTE74 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110 PRICING_ATTRIBUTE75 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111 PRICING_ATTRIBUTE76 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112 PRICING_ATTRIBUTE77 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113 PRICING_ATTRIBUTE78 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114 PRICING_ATTRIBUTE79 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115 PRICING_ATTRIBUTE80 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116 PRICING_ATTRIBUTE81 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
117 PRICING_ATTRIBUTE82 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
118 PRICING_ATTRIBUTE83 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
119 PRICING_ATTRIBUTE84 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
120 PRICING_ATTRIBUTE85 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
121 PRICING_ATTRIBUTE86 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
122 PRICING_ATTRIBUTE87 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
123 PRICING_ATTRIBUTE88 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
124 PRICING_ATTRIBUTE89 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
125 PRICING_ATTRIBUTE90 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
126 PRICING_ATTRIBUTE91 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
127 PRICING_ATTRIBUTE92 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
128 PRICING_ATTRIBUTE93 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129 PRICING_ATTRIBUTE94 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130 PRICING_ATTRIBUTE95 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
131 PRICING_ATTRIBUTE96 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132 PRICING_ATTRIBUTE97 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133 PRICING_ATTRIBUTE98 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
134 PRICING_ATTRIBUTE99 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
135 PRICING_ATTRIBUTE100 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
136 );
137
138 TYPE ReturnInfo_Rec_Type IS RECORD
139 (
140 return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
141 rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
142 actual_returned_date DATE DEFAULT FND_API.G_MISS_DATE
143 );
144
145 TYPE CP_Prod_Rec_Type IS RECORD
146 (
147 customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
148 inv_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
149 cp_status_id NUMBER DEFAULT FND_API.G_MISS_NUM,
150 start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
151 end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
152 misc_order_info OrderInfo_Rec_Type,
153 misc_return_info ReturnInfo_Rec_Type,
154 quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
155 uom_code VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
156 net_amount NUMBER DEFAULT FND_API.G_MISS_NUM,
157 currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
158 po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
159 delivered_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
160 shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
161 cp_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162 system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163 prod_agreement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
164 ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
165 bill_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
166 install_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
167 installation_date DATE DEFAULT FND_API.G_MISS_DATE,
168 config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
169 config_start_date DATE DEFAULT FND_API.G_MISS_DATE,
170 config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
171 project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
172 task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
173 platform_version_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174 customer_view_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
175 merchant_view_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
176 desc_flex DFF_Rec_Type,
177 price_attribs PRICE_ATT_Rec_Type,
178 shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
179 ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
180 invoice_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
181 expired_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
182 customer_product_status_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
183 split_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184 organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
185 returned_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
186 config_root_id NUMBER DEFAULT FND_API.G_MISS_NUM -- Bug 1898630 srramakr
187 );
188
189
190 TYPE CP_Ship_Rec_Type IS RECORD
191 (
192 cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
193 cp_revision_id NUMBER DEFAULT FND_API.G_MISS_NUM,
194 order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
195 shipped_qty NUMBER DEFAULT FND_API.G_MISS_NUM,
196 shipped_date DATE DEFAULT FND_API.G_MISS_DATE,
197 ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198 serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
199 lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
200 revision VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR
201 );
202
203
204 TYPE Cascade_Upd_Flag_Rec_Type IS RECORD
205 (
206 cp_status_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
207 start_date_active_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
208 end_date_active_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
209 misc_order_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
210 misc_return_info_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
211 delivered_flag_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
212 system_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
213 prod_agreement_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
214 ship_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
215 bill_to_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
216 install_site_use_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
217 installation_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
218 config_type_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
219 config_start_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
220 shipped_date_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
221 project_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE,
222 task_id_cascade VARCHAR2(1) DEFAULT FND_API.G_TRUE
223 );
224
225
226 TYPE Abort_Upd_On_Warn_Rec_Type IS RECORD
227 (
228 srl_owned_by_diff_cust VARCHAR2(1) DEFAULT FND_API.G_TRUE,
229 srl_exists_for_diff_item VARCHAR2(1) DEFAULT FND_API.G_TRUE
230 );
231
232
233 TYPE Config_Rec_Type IS RECORD
234 (
235 config_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
236 config_parent_cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
237 config_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
238 customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
239 inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
240 serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
241 lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
242 );
243
244 TYPE Config_Tbl_Type IS TABLE OF Config_Rec_Type
245 INDEX BY BINARY_INTEGER;
246
247
248 TYPE CP_Param_Rec_Type IS RECORD
249 (
250 customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
251 parameter_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
252 name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
253 value VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
254 status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
255 application_id NUMBER DEFAULT FND_API.G_MISS_NUM,
256 start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
257 end_date_active DATE DEFAULT FND_API.G_MISS_DATE
258 );
259
260
261 TYPE CP_Query_IP_Rec_Type IS RECORD
262 (
263 cp_rec CP_Prod_Rec_Type,
264 ship_rec CP_Ship_Rec_Type,
265 party_id NUMBER DEFAULT FND_API.G_MISS_NUM,
266 svc_provider_id NUMBER DEFAULT FND_API.G_MISS_NUM
267 );
268
269
270 TYPE CP_Query_OP_Rec_Type IS RECORD
271 (
272 cp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
273 account_id NUMBER DEFAULT FND_API.G_MISS_NUM,
274 account_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
275 inv_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
276 serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
277 lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
278 ship_date DATE DEFAULT FND_API.G_MISS_DATE
279 );
280
281
282 TYPE CP_Query_OP_Tbl_Type IS TABLE OF CP_Query_OP_Rec_Type
283 INDEX BY BINARY_INTEGER;
284
285
286 TYPE CP_Contact_Rec_Type IS RECORD
287 (
288 source_object_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
289 source_object_id NUMBER DEFAULT FND_API.G_MISS_NUM,
290 contact_category VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
291 contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
292 contact_type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
293 svc_provider_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
294 primary_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
295 preferred_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
296 start_date_active DATE DEFAULT FND_API.G_MISS_DATE,
297 end_date_active DATE DEFAULT FND_API.G_MISS_DATE,
298 desc_flex DFF_Rec_Type
299 );
300
301 -- Added the line_inst_detail_id to this record type becoz this same record type
302 -- is used for getting the line installation details given an order_line_id and
303 -- it must return the line_inst_detail_id.
307
304 -- Also, had to remove desc_flex from this record type since a PL/SQL table
305 -- cannot be based on a record type that is non-scalar.
306
308 TYPE Line_Inst_Dtl_Rec_Type IS RECORD
309 (
310 line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
311 order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
312 quote_line_shipment_id NUMBER DEFAULT FND_API.G_MISS_NUM,
313 source_line_inst_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
314 transaction_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
315 system_id NUMBER DEFAULT FND_API.G_MISS_NUM,
316 customer_product_id NUMBER DEFAULT FND_API.G_MISS_NUM,
317 type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
318 quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
319 installed_at_party_site_id NUMBER DEFAULT FND_API.G_MISS_NUM,
320 installed_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
321 installed_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
322 new_cp_rma_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
323 new_cp_return_by_date DATE DEFAULT FND_API.G_MISS_DATE,
324 expected_installation_date DATE DEFAULT FND_API.G_MISS_DATE
325 --desc_flex DFF_Rec_Type
326 );
327
328 TYPE Line_Inst_Dtl_Tbl_Type is TABLE OF Line_Inst_Dtl_Rec_Type
329 INDEX BY BINARY_INTEGER;
330
331
332 --------------------------------------------------------------------------
333
334 -- Start of comments
335 -- API name : Create_Base_Product
336 -- Type : Public
337 -- Function : This API creates a product record in the installed base in the
338 -- absence of shipment-related information.
339 -- Pre-reqs : None.
340 --
341 -- Standard IN Parameters:
342 -- p_api_version IN NUMBER Required
343 -- p_init_msg_list IN VARCHAR2 Optional
344 -- Default = FND_API.G_FALSE
345 -- p_commit IN VARCHAR2 Optional
346 -- Default = FND_API.G_FALSE
347 --
348 -- Standard OUT NOCOPY Parameters:
349 -- x_return_status OUT NOCOPY VARCHAR2(1)
350 -- x_msg_count OUT NOCOPY NUMBER
351 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
352 --
353 -- Create_Base_Product IN Parameters:
354 -- p_cp_rec IN CP_Prod_Rec_Type Required
355 --
356 -- Create_Base_Product OUT NOCOPY Parameters:
357 -- x_cp_id OUT NOCOPY NUMBER
358 -- x_object_version_number OUT NOCOPY NUMBER
359 --
360 --
361 -- Version : Current version 2.0
362 -- Initial version 1.0
363 --
364 -- End of comments
365 --------------------------------------------------------------------------
366
367 PROCEDURE Create_Base_Product
368 (
369 p_api_version IN NUMBER,
370 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
371 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
372 x_return_status OUT NOCOPY VARCHAR2,
373 x_msg_count OUT NOCOPY NUMBER,
374 x_msg_data OUT NOCOPY VARCHAR2,
375 p_cp_rec IN CP_Prod_Rec_Type,
376 p_created_manually_flag IN VARCHAR2 DEFAULT 'N',
377 p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
378 x_cp_id OUT NOCOPY NUMBER,
379 x_object_version_number OUT NOCOPY NUMBER
380 );
381
382 --------------------------------------------------------------------------
383
384 -- Start of comments
385 -- API name : Record_Shipment_Info
386 -- Type : Public
387 -- Function : This API modifies a product record already existing in the
388 -- installed base to record shipment-related information.
389 -- Pre-reqs : None.
390 --
391 -- Standard IN Parameters:
392 -- p_api_version IN NUMBER Required
393 -- p_init_msg_list IN VARCHAR2 Optional
394 -- Default = FND_API.G_FALSE
395 -- p_commit IN VARCHAR2 Optional
396 -- Default = FND_API.G_FALSE
397 --
398 -- Standard OUT NOCOPY Parameters:
399 -- x_return_status OUT NOCOPY VARCHAR2(1)
400 -- x_msg_count OUT NOCOPY NUMBER
401 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
402 --
403 -- Record_Shipment_Info IN Parameters:
404 -- p_ship_rec IN CP_Ship_Rec_Type Required
405 --
406 --
407 -- Record_Shipment_Info OUT NOCOPY Parameters:
408 -- x_new_cp_id OUT NOCOPY NUMBER
409 --
410 --
411 -- Version : Current version 1.0
412 -- Initial version 1.0
413 --
414 -- End of comments
415 --------------------------------------------------------------------------
416
417 PROCEDURE Record_Shipment_Info
418 (
419 p_api_version IN NUMBER,
420 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
421 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
422 x_return_status OUT NOCOPY VARCHAR2,
423 x_msg_count OUT NOCOPY NUMBER,
424 x_msg_data OUT NOCOPY VARCHAR2,
425 p_ship_rec IN CP_Ship_Rec_Type,
426 p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
427 x_new_cp_id OUT NOCOPY NUMBER
428 );
429
430 --------------------------------------------------------------------------
431
432 -- Start of comments
433 -- API name : Replace_Product
434 -- Type : Public
438 -- Pre-reqs : None.
435 -- Function : This API replaces a product in the installed base with another
436 -- one. It also replaces the components of the product being
437 -- replaced.
439 --
440 -- Standard IN Parameters:
441 -- p_api_version IN NUMBER Required
442 -- p_init_msg_list IN VARCHAR2 Optional
443 -- Default = FND_API.G_FALSE
444 -- p_commit IN VARCHAR2 Optional
445 -- Default = FND_API.G_FALSE
446 --
447 -- Standard OUT NOCOPY Parameters:
448 -- x_return_status OUT NOCOPY VARCHAR2(1)
449 -- x_msg_count OUT NOCOPY NUMBER
450 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
451 --
452 -- Replace_Product IN Parameters:
453 -- p_cp_id IN NUMBER Required
454 -- p_old_cp_status_id IN NUMBER Required
455 -- p_cp_rec IN CP_Prod_Rec_Type Required
456 -- p_inherit_contacts IN VARCHAR2 Optional
457 -- Default = FND_API.G_FALSE
458 -- p_upgrade IN VARCHAR2 Optional
459 -- Default = FND_API.G_FALSE
460 --
461 -- Replace_Product OUT NOCOPY Parameters:
462 -- x_new_cp_id OUT NOCOPY NUMBER
463 --
464 --
465 -- Version : Current version 1.0
466 -- Initial version 1.0
467 --
468 -- End of comments
469 --------------------------------------------------------------------------
470
471 PROCEDURE Replace_Product
472 (
473 p_api_version IN NUMBER,
474 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
475 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
476 x_return_status OUT NOCOPY VARCHAR2,
477 x_msg_count OUT NOCOPY NUMBER,
478 x_msg_data OUT NOCOPY VARCHAR2,
479 p_cp_id IN NUMBER,
480 p_old_cp_status_id IN NUMBER,
481 p_cp_rec IN CP_Prod_Rec_Type,
482 p_inherit_contacts IN VARCHAR2 DEFAULT FND_API.G_FALSE,
483 p_upgrade IN VARCHAR2 DEFAULT FND_API.G_FALSE,
484 p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
485 x_new_cp_id OUT NOCOPY NUMBER,
486 p_qty_mismatch_ok IN VARCHAR2 DEFAULT FND_API.G_FALSE
487 );
488
489 --------------------------------------------------------------------------
490
491 -- Start of comments
492 -- API name : Update_Product
493 -- Type : Public
494 -- Function : This API updates product information in the installed base.
495 -- Depending on "cascade" parameters passed, it also replaces the
496 -- components of the product being updated with the same
497 -- information.
498 -- Pre-reqs : None.
499 --
500 -- Standard IN Parameters:
501 -- p_api_version IN NUMBER Required
502 -- p_init_msg_list IN VARCHAR2 Optional
503 -- Default = FND_API.G_FALSE
504 -- p_commit IN VARCHAR2 Optional
505 -- Default = FND_API.G_FALSE
506 --
507 -- Standard OUT OCOPY Parameters:
508 -- x_return_status OUT NOCOPY VARCHAR2(1)
509 -- x_msg_count OUT NOCOPY NUMBER
510 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
511 --
512 -- Update_Product IN Parameters:
513 -- p_cp_id IN NUMBER Required
514 -- p_as_of_date IN DATE Optional
515 -- Default = SYSDATE
516 -- p_cp_rec IN CP_Prod_Rec_Type Required
517 -- p_ship_rec IN CP_Ship_Rec_Type Required
518 -- p_abort_on_warn_flag IN Abort_Upd_On_Warn_Rec_Type Required
519 -- p_cascade_updates_flagIN Cascade_Upd_Flag_Rec_Type Required
520 -- p_cascade_inst_date_change_war IN VARCHAR2 Optional
521 -- Default=FND_API.G_TRUE,
522 -- p_comments IN VARCHAR2 Optional
523 -- Default=NULL,
524 -- p_update_by_customer_flag IN VARCHAR2 Optional
525 -- Default=FND_API.G_TRUE
526 -- The last parameter indicates whether this update to the record is being made
527 -- by a customer (from iSupport UI) or by an agent of the merchant. A customer
528 -- will be able to update only those records in the customer's view but a
529 -- merchant will be able to update both records in the merchant's view as well
530 -- as customer's view.
531 --
532 -- Update_Product OUT NOCOPY Parameters:
533
534 -- None
535 --
536 -- Version : Current version 1.0
537 -- Initial version 1.0
538 --
539 -- End of comments
540 --------------------------------------------------------------------------
541
542 PROCEDURE Update_Product
543 (
544 p_api_version IN NUMBER,
545 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
546 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
547 x_return_status OUT NOCOPY VARCHAR2,
548 x_msg_count OUT NOCOPY NUMBER,
549 x_msg_data OUT NOCOPY VARCHAR2,
550 p_cp_id IN NUMBER,
551 p_as_of_date IN DATE DEFAULT sysdate,
552 p_cp_rec IN CP_Prod_Rec_Type,
553 p_ship_rec IN CP_Ship_Rec_Type,
554 p_comments IN VARCHAR2 DEFAULT NULL,
555 p_update_by_customer_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
559 p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
556 p_abort_on_warn_flag IN Abort_Upd_On_Warn_Rec_Type,
557 p_cascade_updates_flag IN Cascade_Upd_Flag_Rec_Type,
558 p_cascade_inst_date_change_war IN VARCHAR2 DEFAULT FND_API.G_TRUE,
560 );
561 --------------------------------------------------------------------------
562
563 -- Start of comments
564 -- API name : Create_Revision
565 -- Type : Public
566 -- Function :
567 -- Pre-reqs : None.
568 --
569 -- Standard IN Parameters:
570 -- p_api_version IN NUMBER Required
571 -- p_init_msg_list IN VARCHAR2 Optional
572 -- Default = FND_API.G_FALSE
573 -- p_commit IN VARCHAR2 Optional
574 -- Default = FND_API.G_FALSE
575 --
576 -- Standard OUT NOCOPY Parameters:
577 -- x_return_status OUT NOCOPY VARCHAR2(1)
578 -- x_msg_count OUT NOCOPY NUMBER
579 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
580 --
581 -- Create_Revision IN Parameters:
582 -- p_cp_id IN NUMBER Required
583 -- p_rev_inv_item_id IN NUMBER Required
584 -- p_quantity IN NUMBER Required
585 -- p_order_info IN OrderInfo_Rec_Type Required
586 -- p_desc_flex IN DFF_Rec_Type Required
587 -- p_start_date_active IN DATE Optional
588 -- Default = FND_API.G_MISS_DATE
589 -- p_end_date_active IN DATE Optional
590 -- Default = FND_API.G_MISS_DATE
591 -- p_delivered_flag IN VARCHAR2(1) Optional
592 -- Default = FND_API.G_MISS_CHAR
593
594 -- Create_Revision OUT NOCOPY Parameters:
595 -- x_cp_rev_id OUT NOCOPY NUMBER
596 -- x_curr_rev_of_cp_updtd OUT NOCOPY VARCHAR2
597 -- x_object_version_number OUT NOCOPY NUMBER
598 --
599 -- Version : Current version 1.0
600 -- Initial version 1.0
601 --
602 -- End of comments
603 --------------------------------------------------------------------------
604
605 PROCEDURE Create_Revision
606 (
607 p_api_version IN NUMBER,
608 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
609 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
610 x_return_status OUT NOCOPY VARCHAR2,
611 x_msg_count OUT NOCOPY NUMBER,
612 x_msg_data OUT NOCOPY VARCHAR2,
613 p_cp_id IN NUMBER,
614 p_rev_inv_item_id IN NUMBER,
615 p_order_info IN OrderInfo_Rec_Type,
616 p_desc_flex IN DFF_Rec_Type,
617 p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
618 p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
619 p_delivered_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
620 x_cp_rev_id OUT NOCOPY NUMBER,
621 x_curr_rev_of_cp_updtd OUT NOCOPY VARCHAR2,
622 x_object_version_number OUT NOCOPY NUMBER
623 );
624
625
626 PROCEDURE Update_Revision
627 (
628 p_api_version IN NUMBER,
629 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
630 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
631 x_return_status OUT NOCOPY VARCHAR2,
632 x_msg_count OUT NOCOPY NUMBER,
633 x_msg_data OUT NOCOPY VARCHAR2,
634 p_cp_rev_id IN NUMBER,
635 p_object_version_number IN NUMBER,
636 p_start_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
637 p_end_date_active IN DATE DEFAULT FND_API.G_MISS_DATE,
638 p_desc_flex IN CS_InstalledBase_PUB.DFF_Rec_Type,
639 x_object_version_number OUT NOCOPY NUMBER
640 );
641 --------------------------------------------------------------------------
642
643 -- Start of comments
644 -- API name : Specify_Contact
645 -- Type : Public
646 -- Function :
647 -- Pre-reqs : None.
648 --
649 -- Standard IN Parameters:
650 -- p_api_version IN NUMBER Required
651 -- p_init_msg_list IN VARCHAR2 Optional
652 -- Default = FND_API.G_FALSE
653 -- p_commit IN VARCHAR2 Optional
654 -- Default = FND_API.G_FALSE
655 --
656 -- Standard OUT NOCOPY Parameters:
657 -- x_return_status OUT NOCOPY VARCHAR2(1)
658 -- x_msg_count OUT NOCOPY NUMBER
659 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
660 --
661 -- Specify_Contact IN Parameters:
662 -- p_contact_rec IN CP_Contact_Rec_Type
663
664 -- Specify_Contact OUT NOCOPY Parameters:
665 -- x_cs_contact_id OUT NOCOPY NUMBER
666 -- x_object_version_number OUT NOCOPY NUMBER
667 --
668 -- Version : Current version 2.0
669 -- Initial version 1.0
670 --
671 -- End of comments
672 --------------------------------------------------------------------------
673
674 PROCEDURE Specify_Contact
675 (
676 p_api_version IN NUMBER,
677 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
678 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
679 x_return_status OUT NOCOPY VARCHAR2,
680 x_msg_count OUT NOCOPY NUMBER,
681 x_msg_data OUT NOCOPY VARCHAR2,
682 p_contact_rec IN CP_Contact_Rec_Type,
683 x_cs_contact_id OUT NOCOPY NUMBER,
684 x_object_version_number OUT NOCOPY NUMBER
685 );
686
687
691 -- API name : Update_Contact
688 --------------------------------------------------------------------------
689
690 -- Start of comments
692 -- Type : Public
693 -- Function :
694 -- Pre-reqs : None.
695 --
696 -- Standard IN Parameters:
697 -- p_api_version IN NUMBER Required
698 -- p_init_msg_list IN VARCHAR2 Optional
699 -- Default = FND_API.G_FALSE
700 -- p_commit IN VARCHAR2 Optional
701 -- Default = FND_API.G_FALSE
702 --
703 -- Standard OUT NOCOPY Parameters:
704 -- x_return_status OUT NOCOPY VARCHAR2(1)
705 -- x_msg_count OUT NOCOPY NUMBER
706 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
707 --
708 -- Update_Contact IN Parameters:
709 -- p_cs_contact_id IN NUMBER Required
710 -- p_contact_rec IN CP_Contact_Rec_Type
711
712 -- Update_Contact OUT NOCOPY Parameters:
713 -- None
714 --
715 -- Version : Current version 2.0
716 -- Initial version 1.0
717 --
718 -- End of comments
719 --------------------------------------------------------------------------
720
721 PROCEDURE Update_Contact
722 (
723 p_api_version IN NUMBER,
724 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
725 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
726 x_return_status OUT NOCOPY VARCHAR2,
727 x_msg_count OUT NOCOPY NUMBER,
728 x_msg_data OUT NOCOPY VARCHAR2,
729 p_cs_contact_id IN NUMBER,
730 p_object_version_number IN NUMBER,
731 p_contact_rec IN CP_Contact_Rec_Type,
732 x_object_version_number OUT NOCOPY NUMBER
733 );
734
735 --------------------------------------------------------------------------
736
737 -- Start of comments
738 -- API name : Delete_Contact
739 -- Type : Public
740 -- Function : Deletes a specified contact.
741 -- Pre-reqs : None.
742 --
743 -- Standard IN Parameters:
744 -- p_api_version IN NUMBER Required
745 -- p_init_msg_list IN VARCHAR2 Optional
746 -- Default = FND_API.G_FALSE
747 -- p_commit IN VARCHAR2 Optional
748 -- Default = FND_API.G_FALSE
749 --
750 -- Standard OUT NOCOPY Parameters:
751 -- x_return_status OUT NOCOPY VARCHAR2(1)
752 -- x_msg_count OUT NOCOPY NUMBER
753 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
754 --
755 -- Delete_Contact IN Parameters:
756 -- p_cs_contact_id IN NUMBER Required
757
758 -- Delete_Contact OUT NOCOPY Parameters:
759 -- None
760
761 -- Version : Current version 1.0
762 -- Initial version 1.0
763 --
764 -- End of comments
765 --------------------------------------------------------------------------
766
767 PROCEDURE Delete_Contact
768 (
769 p_api_version IN NUMBER,
770 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
771 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
772 x_return_status OUT NOCOPY VARCHAR2,
773 x_msg_count OUT NOCOPY NUMBER,
774 x_msg_data OUT NOCOPY VARCHAR2,
775 p_cs_contact_id IN NUMBER
776 );
777
778 --------------------------------------------------------------------------
779
780 -- Start of comments
781 -- API name : Get_CP_ID
782 -- Type : Public
783 -- Function : This API accepts p_reference_number and passes back the
784 -- Customer Product Id based on a lookup on the REFERENCE_NUMBER
785 -- column in CS_CUSTOMER_PRODUCTS table.
786 -- Pre-reqs : None.
787 --
788 -- Standard IN Parameters:
789 -- p_api_version IN NUMBER Required
790 -- p_init_msg_list IN VARCHAR2 Optional
791 -- Default = FND_API.G_FALSE
792 --
793 -- Standard OUT NOCOPY Parameters:
794 -- x_return_status OUT NOCOPY VARCHAR2(1)
795 -- x_msg_count OUT NOCOPY NUMBER
796 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
797 --
798 -- Get_CP_ID IN Parameters:
799 -- p_reference_number IN NUMBER Required
800
801 -- Get_CP_ID OUT NOCOPY Parameters:
802 -- x_cp_id OUT NOCOPY NUMBER
803 --
804 -- Version : Current version 1.0
805 -- Initial version 1.0
806 --
807 -- End of comments
808 --------------------------------------------------------------------------
809
810 PROCEDURE Get_CP_ID
811 (
812 p_api_version IN NUMBER,
813 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
814 x_return_status OUT NOCOPY VARCHAR2,
815 x_msg_count OUT NOCOPY NUMBER,
816 x_msg_data OUT NOCOPY VARCHAR2,
817 p_reference_number IN NUMBER,
818 x_cp_id OUT NOCOPY NUMBER
819 );
820
821 --------------------------------------------------------------------------
822
823 -- Start of comments
824 -- API name : Get_Reference_Number
825 -- Type : Public
826 -- Function : This API accepts p_cp_id and passes back the Reference Number
827 -- based on a lookup on the Customer Product Id column in
828 -- CS_CUSTOMER_PRODUCTS table.
829 -- Pre-reqs : None.
830 --
831 -- Standard IN Parameters:
832 -- p_api_version IN NUMBER Required
836 -- Standard OUT NOCOPY Parameters:
833 -- p_init_msg_list IN VARCHAR2 Optional
834 -- Default = FND_API.G_FALSE
835 --
837 -- x_return_status OUT NOCOPY VARCHAR2(1)
838 -- x_msg_count OUT NOCOPY NUMBER
839 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
840 --
841 -- Get_Reference_Number IN Parameters:
842 -- p_cp_id IN NUMBER Required
843
844 -- Get_Reference_Number OUT NOCOPY Parameters:
845 -- x_reference_number OUT NOCOPY NUMBER
846 --
847 -- Version : Current version 1.0
848 -- Initial version 1.0
849 --
850 -- End of comments
851 --------------------------------------------------------------------------
852
853 PROCEDURE Get_Reference_Number
854 (
855 p_api_version IN NUMBER,
856 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
857 x_return_status OUT NOCOPY VARCHAR2,
858 x_msg_count OUT NOCOPY NUMBER,
859 x_msg_data OUT NOCOPY VARCHAR2,
860 p_cp_id IN NUMBER,
861 x_reference_number OUT NOCOPY NUMBER
862 );
863
864 --------------------------------------------------------------------------
865
866 -- Start of comments
867 -- API name : Get_CP_ID (overloaded procedure)
868 -- Type : Public
869 -- Function : This API passes back the Customer Product Id and the Reference
870 -- Number based on certain lookups on the CUSTOMER_PRODUCTS table -- depending on the parameters passed.
871 -- Pre-reqs : None.
872 --
873 -- Standard IN Parameters:
874 -- p_api_version IN NUMBER Required
875 -- p_init_msg_list IN VARCHAR2 Optional
876 -- Default = FND_API.G_FALSE
877 --
878 -- Standard OUT OCOPY Parameters:
879 -- x_return_status OUT NOCOPY VARCHAR2(1)
880 -- x_msg_count OUT NOCOPY NUMBER
881 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
882 --
883 -- Get_CP_ID IN Parameters:
884 -- p_serial_number IN VARCHAR2 Optional
885 -- Default = FND_API.G_MISS_CHAR
886 -- p_config_type IN VARCHAR2 Optional
887 -- Default = FND_API.G_MISS_CHAR
888 -- p_as_of_date IN DATE Optional
889 -- Default = FND_API.G_MISS_DATE
890 -- p_customer_id IN NUMBER Optional
891 -- Default = FND_API.G_MISS_NUM
892 -- p_inv_item_id IN NUMBER Optional
893 -- Default = FND_API.G_MISS_NUM
894
895 -- Get_CP_ID OUT NOCOPY Parameters:
896 -- x_cp_id OUT NOCOPY NUMBER
897 -- x_reference_number OUT NOCOPY NUMBER
898 -- x_unique_flag OUT NOCOPY VARCHAR2
899 --
900 -- Version : Current version 1.0
901 -- Initial version 1.0
902 --
903 -- End of comments
904 --------------------------------------------------------------------------
905
906 PROCEDURE Get_CP_ID
907 (
908 p_api_version IN NUMBER,
909 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
910 x_return_status OUT NOCOPY VARCHAR2,
911 x_msg_count OUT NOCOPY NUMBER,
912 x_msg_data OUT NOCOPY VARCHAR2,
913 p_serial_number IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
914 p_config_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
915 p_as_of_date IN DATE DEFAULT FND_API.G_MISS_DATE,
916 p_customer_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
917 p_inv_item_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
918 x_unique_flag OUT NOCOPY VARCHAR2,
919 x_reference_number OUT NOCOPY NUMBER,
920 x_cp_id OUT NOCOPY NUMBER
921 );
922
923 --------------------------------------------------------------------------
924
925 -- Start of comments
926 -- API name : Get_Configuration
927 -- Type : Public
928 -- Function : This API passes back the the configuration of a particular
929 -- product in the installed base having a certain configuration
930 -- type as of a given date, in the form of a table of records.
931 -- Pre-reqs : None.
932 --
933 -- Standard IN Parameters:
934 -- p_api_version IN NUMBER Required
935 -- p_init_msg_list IN VARCHAR2 Optional
936 -- Default = FND_API.G_FALSE
937 --
938 -- Standard OUT NOCOPY Parameters:
939 -- x_return_status OUT NOCOPY VARCHAR2(1)
940 -- x_msg_count OUT NOCOPY NUMBER
941 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
942 --
943 -- Get_Configuration IN Parameters:
944 -- p_cp_id IN NUMBER Required
945 -- p_config_type IN VARCHAR2 Required
946 -- p_as_of_date IN DATE Required
947
948 -- Get_Configuration OUT NOCOPY Parameters:
949 -- x_config_tbl OUT NOCOPY Config_Tbl_Type
950 -- x_config_tbl_count OUT NOCOPY NUMBER
951 --
952 -- Version : Current version 1.0
953 -- Initial version 1.0
954 --
955 -- End of comments
956 --------------------------------------------------------------------------
957
958 PROCEDURE Get_Configuration
959 (
960 p_api_version IN NUMBER,
961 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
962 x_return_status OUT NOCOPY VARCHAR2,
963 x_msg_count OUT NOCOPY NUMBER,
964 x_msg_data OUT NOCOPY VARCHAR2,
965 p_cp_id IN NUMBER,
966 p_config_type IN VARCHAR2 DEFAULT NULL,
970 );
967 p_as_of_date IN DATE DEFAULT SYSDATE,
968 x_config_tbl OUT NOCOPY Config_Tbl_Type,
969 x_config_tbl_count OUT NOCOPY NUMBER
971
972 --------------------------------------------------------------------------
973
974 -- Start of comments
975 -- API name : Get_ProductInfo
976 -- Type : Public
977 -- Function : This API passes back all information abOUT NOCOPY a product in the
978 -- installed base
979 -- Pre-reqs : None.
980 --
981 -- Standard IN Parameters:
982 -- p_api_version IN NUMBER Required
983 -- p_init_msg_list IN VARCHAR2 Optional
984 -- Default = FND_API.G_FALSE
985 --
986 -- Standard OUT NOCOPY Parameters:
987 -- x_return_status OUT NOCOPY VARCHAR2(1)
988 -- x_msg_count OUT NOCOPY NUMBER
989 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
990 --
991 -- Get_ProductInfo IN Parameters:
992 -- p_cp_id IN NUMBER Required
993 -- p_as_of_date IN DATE Optional default = sysdate.
994
995 -- Get_ProductInfo OUT NOCOPY Parameters:
996 -- x_cp_rec OUT NOCOPY CP_Prod_Rec_Type
997 -- x_ship_rec OUT NOCOPY CP_Ship_Rec_Type
998 -- x_created_manually_flag OUT NOCOPY VARCJAR2(1);
999 --
1000 -- Version : Current version 1.0
1001 -- Initial version 1.0
1002 --
1003 -- End of comments
1004 --------------------------------------------------------------------------
1005
1006 PROCEDURE Get_ProductInfo
1007 (
1008 p_api_version IN NUMBER,
1009 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1010 x_return_status OUT NOCOPY VARCHAR2,
1011 x_msg_count OUT NOCOPY NUMBER,
1012 x_msg_data OUT NOCOPY VARCHAR2,
1013 p_cp_id IN NUMBER,
1014 p_as_of_date IN DATE DEFAULT sysdate,
1015 x_cp_rec OUT NOCOPY CP_Prod_Rec_Type,
1016 x_ship_rec OUT NOCOPY CP_Ship_Rec_Type,
1017 x_created_manually_flag OUT NOCOPY VARCHAR2
1018 );
1019
1020 --------------------------------------------------------------------------
1021
1022 -- Start of comments
1023 -- API name : Split_Product
1024 -- Type : Public
1025 -- Function : This overloaded API splits a product in the Installed Base into
1026 -- two.
1027 -- Pre-reqs : None.
1028 --
1029 -- Standard IN Parameters:
1030 -- p_api_version IN NUMBER Required
1031 -- p_init_msg_list IN VARCHAR2 Optional
1032 -- Default = FND_API.G_FALSE
1033 --
1034 -- Standard OUT NOCOPY Parameters:
1035 -- x_return_status OUT NOCOPY VARCHAR2(1)
1036 -- x_msg_count OUT NOCOPY NUMBER
1037 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
1038 --
1039 -- Split_Product IN Parameters:
1040 -- p_cp_id IN NUMBER Required
1041 -- p_qty1 IN NUMBER Required
1042 -- p_qty2 IN NUMBER Required
1043 -- p_reason_code IN NUMBER Required
1044
1045 -- Split_Product OUT NOCOPY Parameters:
1046 -- x_new_parent_cp_id OUT NOCOPY NUMBER
1047 --
1048 -- Version : Current version 1.0
1049 -- Initial version 1.0
1050 --
1051 -- End of comments
1052 --------------------------------------------------------------------------
1053
1054 PROCEDURE Split_Product
1055 (
1056 p_api_version IN NUMBER,
1057 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1058 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1059 x_return_status OUT NOCOPY VARCHAR2,
1060 x_msg_count OUT NOCOPY NUMBER,
1061 x_msg_data OUT NOCOPY VARCHAR2,
1062 p_cp_id IN NUMBER,
1063 p_qty1 IN NUMBER,
1064 p_qty2 IN NUMBER,
1065 p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1066 p_reason_code IN VARCHAR2,
1067 x_new_parent_cp_id OUT NOCOPY NUMBER
1068 ) ;
1069
1070
1071 --------------------------------------------------------------------------
1072
1073 -- Start of comments
1074 -- API name : Split_Product
1075 -- Type : Public
1076 -- Function : This overloaded API splits a product in the Installed Base into
1077 -- one each.
1078 -- Pre-reqs : None.
1079 --
1080 -- Standard IN Parameters:
1081 -- p_api_version IN NUMBER Required
1082 -- p_init_msg_list IN VARCHAR2 Optional
1083 -- Default = FND_API.G_FALSE
1084 --
1085 -- Standard OUT NOCOPY Parameters:
1086 -- x_return_status OUT NOCOPY VARCHAR2(1)
1087 -- x_msg_count OUT NOCOPY NUMBER
1088 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
1089 --
1090 -- Split_Product IN Parameters:
1091 -- p_cp_id IN NUMBER Required
1092 -- p_reason_code IN NUMBER Required
1093
1094 -- Split_Product OUT NOCOPY Parameters:
1095 -- None
1096 --
1097 -- Version : Current version 1.0
1098 -- Initial version 1.0
1099 --
1100 -- End of comments
1101 --------------------------------------------------------------------------
1102
1103 PROCEDURE Split_Product
1104 (
1105 p_api_version IN NUMBER,
1106 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1107 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1108 x_return_status OUT NOCOPY VARCHAR2,
1109 x_msg_count OUT NOCOPY NUMBER,
1110 x_msg_data OUT NOCOPY VARCHAR2,
1111 p_cp_id IN NUMBER,
1112 p_reason_code IN VARCHAR2,
1113 p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
1114 );
1115
1119 p_api_version IN NUMBER,
1116
1117 PROCEDURE Create_Product_Parameters
1118 (
1120 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1121 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1122 x_return_status OUT NOCOPY VARCHAR2,
1123 x_msg_count OUT NOCOPY NUMBER,
1124 x_msg_data OUT NOCOPY VARCHAR2,
1125 p_cp_param_rec IN CP_Param_Rec_Type,
1126 x_cp_parameter_id OUT NOCOPY NUMBER,
1127 x_object_version_number OUT NOCOPY NUMBER
1128 );
1129
1130
1131 PROCEDURE Update_Product_Parameters
1132 (
1133 p_api_version IN NUMBER,
1134 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1135 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1136 x_return_status OUT NOCOPY VARCHAR2,
1137 x_msg_count OUT NOCOPY NUMBER,
1138 x_msg_data OUT NOCOPY VARCHAR2,
1139 p_cp_parameter_id IN NUMBER,
1140 p_object_version_number IN NUMBER,
1141 p_cp_param_rec IN CP_Param_Rec_Type,
1142 x_object_version_number OUT NOCOPY NUMBER
1143 );
1144
1145
1146 PROCEDURE Delete_Product_Parameters
1147 (
1148 p_api_version IN NUMBER,
1149 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1150 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1151 x_return_status OUT NOCOPY VARCHAR2,
1152 x_msg_count OUT NOCOPY NUMBER,
1153 x_msg_data OUT NOCOPY VARCHAR2,
1154 p_cp_parameter_id IN NUMBER
1155 );
1156
1157 END CS_InstalledBase_PUB;