[Home] [Help]
PACKAGE: APPS.IBE_CATALOG_PVT
Source
1 package IBE_CATALOG_PVT as
2 /* $Header: IBEVCCTS.pls 120.3 2006/01/27 12:46:50 madesai ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_CATALOG_PVT';
5
6 /* The values here must match the values for Item.SHALLOW,
7 Item.DEEP, Item.DEEP_ONLY
8 */
9 G_ITEM_SHALLOW CONSTANT NUMBER := 0;
10 G_ITEM_DEEP CONSTANT NUMBER := 1;
11 G_ITEM_DEEP_ONLY CONSTANT NUMBER := 3;
12 G_ITEM_MODEL CONSTANT VARCHAR(3) := 'MDL';
13 G_ITEM_SERVICEABLE CONSTANT VARCHAR(3) := 'SVA';
14 G_ITEM_SERVICE CONSTANT VARCHAR(3) := 'SRV';
15 G_ITEM_STANDARD CONSTANT VARCHAR(3) := 'STD';
16
17 TYPE IBE_SECTION_REC IS RECORD
18 (
19 section_id NUMBER,
20 access_name VARCHAR2(240),
21 display_name VARCHAR2(120),
22 description VARCHAR2(4000),
23 object_version_num NUMBER,
24 section_type_code VARCHAR2(30),
25 status_code VARCHAR2(30),
26 start_date_active DATE,
27 end_date_active DATE,
28 dispctx_id NUMBER,
29 template_id NUMBER,
30 long_desc VARCHAR2(4000),
31 order_by_clause VARCHAR2(512),
32 avail_all_sites VARCHAR2(1),
33 auto_placement_rule VARCHAR2(512),
34 keywords VARCHAR2(512),
35 attribute_category VARCHAR2(30),
36 attribute1 VARCHAR2(150),
37 attribute2 VARCHAR2(150),
38 attribute3 VARCHAR2(150),
39 attribute4 VARCHAR2(150),
40 attribute5 VARCHAR2(150),
41 attribute6 VARCHAR2(150),
42 attribute7 VARCHAR2(150),
43 attribute8 VARCHAR2(150),
44 attribute9 VARCHAR2(150),
45 attribute10 VARCHAR2(150),
46 attribute11 VARCHAR2(150),
47 attribute12 VARCHAR2(150),
48 attribute13 VARCHAR2(150),
49 attribute14 VARCHAR2(150),
50 attribute15 VARCHAR2(150)
51 );
52
53 type IBE_SUBSECT_REC is RECORD
54 (
55 section_id NUMBER,
56 subsect_id NUMBER,
57 subsect_type VARCHAR2(30)
58 );
59
60 type IBE_ID_REC is RECORD
61 (
62 id NUMBER
63 );
64
65 type IBE_CATEGORY_ID_REC is RECORD
66 (
67 inventory_item_id NUMBER,
68 category_id NUMBER
69 );
70
71 type IBE_ITEM_ORG_ID_REC is RECORD
72 (
73 inventory_item_id NUMBER,
74 organization_id NUMBER
75 );
76
77 type IBE_UOM_REC is RECORD
78 (
79 inventory_item_id NUMBER,
80 uom_code VARCHAR2(3)
81 );
82
83 type IBE_SHALLOW_ITEM_REC is RECORD
84 (
85 bom_enabled_flag VARCHAR2(1),
86 orderable_on_web_flag VARCHAR2(1),
87 back_orderable_flag VARCHAR2(1),
88 primary_unit_of_measure VARCHAR2(25),
89 primary_uom_code VARCHAR2(3),
90 item_type VARCHAR2(30),
91 description VARCHAR2(240),
92 long_description VARCHAR2(4000),
93 bom_item_type NUMBER,
94 indivisible_flag VARCHAR2(1),
95 serial_control_code NUMBER,
96 web_status VARCHAR2(30),
97 concatenated_segments VARCHAR2(40),
98 inventory_item_id NUMBER
99 );
100
101
102 type IBE_DEEP_ITEM_REC is RECORD
103 (
104 bom_enabled_flag VARCHAR2(1),
105 orderable_on_web_flag VARCHAR2(1),
106 back_orderable_flag VARCHAR2(1),
107 primary_unit_of_measure VARCHAR2(25),
108 primary_uom_code VARCHAR2(3),
109 item_type VARCHAR2(30),
110 description VARCHAR2(240),
111 long_description VARCHAR2(4000),
112 bom_item_type NUMBER,
113 indivisible_flag VARCHAR2(1),
114 serial_control_code NUMBER,
115 web_status VARCHAR2(30),
116 concatenated_segments VARCHAR2(40),
117 inventory_item_id NUMBER,
118 taxable_flag VARCHAR(1),
119 shippable_item_flag VARCHAR2(1),
120 atp_flag VARCHAR2(1),
121 returnable_flag VARCHAR2(1),
122 service_item_flag VARCHAR2(1),
123 serviceable_flag VARCHAR2(1),
124 downloadable_flag VARCHAR2(1),
125 service_duration_period VARCHAR2(10),
126 min_order_qty NUMBER,
127 max_order_qty NUMBER,
128 fixed_order_qty NUMBER,
129 service_duration NUMBER,
130 service_starting_delay NUMBER,
131 segment1 VARCHAR2(40),
132 segment2 VARCHAR2(40),
133 segment3 VARCHAR2(40),
134 segment4 VARCHAR2(40),
135 segment5 VARCHAR2(40),
136 segment6 VARCHAR2(40),
137 segment7 VARCHAR2(40),
138 segment8 VARCHAR2(40),
139 segment9 VARCHAR2(40),
140 segment10 VARCHAR2(40),
141 segment11 VARCHAR2(40),
142 segment12 VARCHAR2(40),
143 segment13 VARCHAR2(40),
144 segment14 VARCHAR2(40),
145 segment15 VARCHAR2(40),
146 segment16 VARCHAR2(40),
147 segment17 VARCHAR2(40),
148 segment18 VARCHAR2(40),
149 segment19 VARCHAR2(40),
150 segment20 VARCHAR2(40),
151 attribute1 VARCHAR2(150),
152 attribute2 VARCHAR2(150),
153 attribute3 VARCHAR2(150),
154 attribute4 VARCHAR2(150),
155 attribute5 VARCHAR2(150),
156 attribute6 VARCHAR2(150),
157 attribute7 VARCHAR2(150),
158 attribute8 VARCHAR2(150),
159 attribute9 VARCHAR2(150),
160 attribute10 VARCHAR2(150),
161 attribute11 VARCHAR2(150),
162 attribute12 VARCHAR2(150),
163 attribute13 VARCHAR2(150),
164 attribute14 VARCHAR2(150),
165 attribute15 VARCHAR2(150),
166 attribute_category VARCHAR2(30),
167 coupon_exempt_flag VARCHAR2(1),
168 vol_discount_exempt_flag VARCHAR2(1),
169 electronic_flag VARCHAR2(1),
170 start_date_active DATE,
171 end_date_active DATE,
172 global_attribute_category VARCHAR2(150),
173 global_attribute1 VARCHAR2(150),
174 global_attribute2 VARCHAR2(150),
175 global_attribute3 VARCHAR2(150),
176 global_attribute4 VARCHAR2(150),
177 global_attribute5 VARCHAR2(150),
178 global_attribute6 VARCHAR2(150),
179 global_attribute7 VARCHAR2(150),
180 global_attribute8 VARCHAR2(150),
181 global_attribute9 VARCHAR2(150),
182 global_attribute10 VARCHAR2(150)
183 );
184
185
186 type IBE_DEEP_ONLY_ITEM_REC is RECORD
187 (
188 taxable_flag VARCHAR(1),
189 shippable_item_flag VARCHAR2(1),
190 atp_flag VARCHAR2(1),
191 returnable_flag VARCHAR2(1),
192 service_item_flag VARCHAR2(1),
193 serviceable_flag VARCHAR2(1),
194 downloadable_flag VARCHAR2(1),
195 service_duration_period VARCHAR2(10),
196 min_order_qty NUMBER,
197 max_order_qty NUMBER,
198 fixed_order_qty NUMBER,
199 service_duration NUMBER,
200 service_starting_delay NUMBER,
201 segment1 VARCHAR2(40),
202 segment2 VARCHAR2(40),
203 segment3 VARCHAR2(40),
204 segment4 VARCHAR2(40),
205 segment5 VARCHAR2(40),
206 segment6 VARCHAR2(40),
207 segment7 VARCHAR2(40),
208 segment8 VARCHAR2(40),
209 segment9 VARCHAR2(40),
210 segment10 VARCHAR2(40),
211 segment11 VARCHAR2(40),
212 segment12 VARCHAR2(40),
213 segment13 VARCHAR2(40),
214 segment14 VARCHAR2(40),
215 segment15 VARCHAR2(40),
216 segment16 VARCHAR2(40),
217 segment17 VARCHAR2(40),
218 segment18 VARCHAR2(40),
219 segment19 VARCHAR2(40),
220 segment20 VARCHAR2(40),
221 attribute1 VARCHAR2(150),
222 attribute2 VARCHAR2(150),
223 attribute3 VARCHAR2(150),
224 attribute4 VARCHAR2(150),
225 attribute5 VARCHAR2(150),
226 attribute6 VARCHAR2(150),
227 attribute7 VARCHAR2(150),
228 attribute8 VARCHAR2(150),
229 attribute9 VARCHAR2(150),
230 attribute10 VARCHAR2(150),
231 attribute11 VARCHAR2(150),
232 attribute12 VARCHAR2(150),
233 attribute13 VARCHAR2(150),
234 attribute14 VARCHAR2(150),
235 attribute15 VARCHAR2(150),
236 attribute_category VARCHAR2(30),
237 coupon_exempt_flag VARCHAR2(1),
238 vol_discount_exempt_flag VARCHAR2(1),
239 electronic_flag VARCHAR2(1),
240 start_date_active DATE,
241 end_date_active DATE,
242 global_attribute_category VARCHAR2(150),
243 global_attribute1 VARCHAR2(150),
244 global_attribute2 VARCHAR2(150),
245 global_attribute3 VARCHAR2(150),
246 global_attribute4 VARCHAR2(150),
247 global_attribute5 VARCHAR2(150),
248 global_attribute6 VARCHAR2(150),
249 global_attribute7 VARCHAR2(150),
250 global_attribute8 VARCHAR2(150),
251 global_attribute9 VARCHAR2(150),
252 global_attribute10 VARCHAR2(150),
253 concatenated_segments VARCHAR2(40),
254 inventory_item_id NUMBER
255 );
256
257 type IBE_CATALOG_REFCURSOR_CSR_TYPE is REF CURSOR;
258
259
260
261 -------
262 -- (code for PROCEDURE Load_Section removed on 01/19/2005 by rgupta)
263 -- This procedure is no longer necessary due to a redesign of the iStore
264 -- Section cache.
265 --
266
267
268
269 -- Start of comments
270 -- API name : Load_Sections
271 -- Type : Private.
272 -- Function : Given a list of section IDs, loads supersection and item
273 -- information for each section.
274 -- Pre-reqs : None.
275 -- Parameters :
276 -- IN : p_api_version IN NUMBER Required
277 -- p_init_msg_list IN VARCHAR2 Optional
278 -- p_validation_level IN NUMBER Optional
279 -- p_sectid_tbl IN JTF_NUMBER_TABLE
280 -- p_msite_id IN NUMBER
281 --
282 -- OUT : x_return_status OUT VARCHAR2(1)
283 -- x_msg_count OUT NUMBER
284 -- x_msg_data OUT VARCHAR2(2000)
285 -- x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE
286 -- x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE
287 -- x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE
288 -- x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE
289 -- x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE
290 -- x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
291 -- x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300
292 -- x_sctitm_startdt_tbl OUT NOCOPY JTF_DATE_TABLE
293 -- x_sctitm_enddt_tbl OUT NOCOPY JTF_DATE_TABLE
294 -- x_sctitm_assoc_startdt_tbl OUT NOCOPY JTF_DATE_TABLE
295 -- x_sctitm_assoc_enddt_tbl OUT NOCOPY JTF_DATE_TABLE
296 --
297 -- Version : Current version 1.0
298 --
299 -- Previous version None
300 --
301 -- Initial version 1.0
302 --
303 -- Notes : Note text
304 --
305 -- End of comments
306
307 procedure Load_Sections
308 (p_api_version IN NUMBER,
309 p_init_msg_list IN VARCHAR2 := NULL,
310 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
311 x_return_status OUT NOCOPY VARCHAR2,
312 x_msg_count OUT NOCOPY NUMBER,
313 x_msg_data OUT NOCOPY VARCHAR2,
314 p_sectid_tbl IN JTF_NUMBER_TABLE,
315 p_msite_id IN NUMBER,
316 x_supersect_sect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
317 x_supersect_supersect_tbl OUT NOCOPY JTF_NUMBER_TABLE,
318 x_sctitm_sectid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
319 x_sctitm_itmid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
320 x_sctitm_orgid_tbl OUT NOCOPY JTF_NUMBER_TABLE,
321 x_sctitm_usage_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,
322 x_sctitm_flags_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300,
323 x_sctitm_startdt_tbl OUT NOCOPY JTF_DATE_TABLE,
324 x_sctitm_enddt_tbl OUT NOCOPY JTF_DATE_TABLE,
325 x_sctitm_assoc_startdt_tbl OUT NOCOPY JTF_DATE_TABLE,
326 x_sctitm_assoc_enddt_tbl OUT NOCOPY JTF_DATE_TABLE
327 );
328
329
330
331 -- Start of comments
332 -- API name : GetLeafSubSectIDs
333 -- Type : Private.
334 -- Function : Given a section id, drills down to the
335 -- leaf level and returns leaf level section ids
336 -- If p_preview_flag = 'T' returns sections
337 -- whose status_code is 'PUBLISHED' or 'UNPUBLISHED'.
338 -- Otherwise, returns information for sections whose
339 -- status_code is 'PUBLISHED'
340 --
341 -- Pre-reqs : None.
342 -- Parameters :
343 -- IN : p_api_version IN NUMBER Required
344 -- p_init_msg_list IN VARCHAR2 Optional
345 -- Default = FND_API.G_FALSE
346 -- p_validation_level IN NUMBER Optional
347 -- Default = FND_API.G_VALID_LEVEL_FULL
348 -- p_preview_flag IN VARCHAR2 Optional
349 -- Default = FND_API.G_FALSE
350 -- p_sectid IN NUMBER
351 -- p_msite_id IN NUMBER
352 --
353 -- OUT : x_return_status OUT VARCHAR2(1)
354 -- x_msg_count OUT NUMBER
355 -- x_msg_data OUT VARCHAR2(2000)
356 -- x_leaf_subsect_ids OUT IBE_CATALOG_REFCURSOR_CSR_TYPE
357 -- Record Type = (leaf_section_id NUMBER, sort_order NUMBER)
358 --
359 -- Version : Current version 1.0
360 --
361 -- previous version None
362 --
363 -- Initial version 1.0
364 --
365 -- Notes : Note text
366 --
367 -- End of comments
368
369 procedure GetLeafSubSectIDs
370 (
371 p_api_version IN NUMBER,
372 p_init_msg_list IN VARCHAR2 := NULL,
373 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
374 x_return_status OUT NOCOPY VARCHAR2,
375 x_msg_count OUT NOCOPY NUMBER,
376 x_msg_data OUT NOCOPY VARCHAR2,
377
378 p_preview_flag IN VARCHAR2 := NULL,
379 p_sectid IN NUMBER,
380 p_msite_id IN NUMBER,
381 x_leafsubsectid_csr OUT NOCOPY IBE_CATALOG_REFCURSOR_CSR_TYPE
382 );
383
384
385
386 -- Start of comments
387 -- API name : GetSuperSectIDs
388 -- Type : Private.
389 -- Function : Given a section ID, returns the super sections up to
390 -- the root of the store, ordered from the section's immediate
391 -- parent to the root.
392 -- Pre-reqs : None.
393 -- Parameters :
394 -- IN : p_api_version IN NUMBER Required
395 -- p_init_msg_list IN VARCHAR2 Optional
396 -- Default = FND_API.G_FALSE
397 -- p_validation_level IN NUMBER Optional
398 -- Default = FND_API.G_VALID_LEVEL_FULL
399 -- p_sectid IN NUMBER Required
400 -- p_msite_id IN NUMBER Required
401 --
402 -- OUT : x_return_status OUT VARCHAR2(1)
403 -- x_msg_count OUT NUMBER
404 -- x_msg_data OUT VARCHAR2(2000)
405 -- x_supersectid_csr OUT IBE_CATALOG_REFCURSOR_CSR_TYPE
406 -- Record Type = IBE_ID_REC
407 --
408 -- Version : Current version 1.0
409 --
410 -- Previous version None
411 --
412 -- Initial version 1.0
413 --
414 -- Notes : Note text
415 --
416 -- End of comments
417
418 procedure GetSuperSectIDs
419 (p_api_version IN NUMBER,
420 p_init_msg_list IN VARCHAR2 := NULL,
421 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
422 x_return_status OUT NOCOPY VARCHAR2,
423 x_msg_count OUT NOCOPY NUMBER,
424 x_msg_data OUT NOCOPY VARCHAR2,
425 p_sectid IN NUMBER,
426 p_msite_id IN NUMBER,
430
427 x_supersectid_csr OUT NOCOPY IBE_CATALOG_REFCURSOR_CSR_TYPE
428 );
429
431
432 -- Start of comments
433 -- API name : GetAvailableServices
434 -- Type : Public
435 -- Function : retrieve Service Items related to this Item.
436 -- After a service item is set up, it is generally available to all
437 -- serviceable products. OKS provides functionalites to set up exclusion
438 -- between serviceable product and serivce item; exclusion between customer
439 -- and service item. This API will take the exclusion rules into account
440 -- as well.
441 --
442 -- Pre-reqs : None.
443 -- Parameters :
444 -- IN :
445 -- p_api_version IN NUMBER Required
446 -- p_init_msg_list IN VARCHAR2 Optional
447 -- Default = FND_API.G_FALSE
448 -- p_validation_level IN NUMBER Optional
449 -- Default = FND_API.G_VALID_LEVEL_FULL
450 -- p_preview_flag IN VARCHAR2 Optional
451 -- Default = FND_API.G_FALSE
452 -- p_originid IN NUMBER Required
453 -- p_origintype IN VARCHAR2(240) Required
454 -- p_reltype_code IN VARCHAR2(30) Required
455 -- p_dest_type IN VARCHAR2(240) Required
456 -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
457 -- p_product_item_id IN NUMBER Required
458 -- p_customer_id IN NUMBER Optional,
459 -- p_product_revision IN VARCHAR2 Optional
460 -- p_request_date IN DATE Optional
461 --
462 --
463 -- OUT :
464 -- x_return_status OUT VARCHAR2(1)
465 -- x_msg_count OUT NUMBER
466 -- x_msg_data OUT VARCHAR2(2000)
467 -- x_service_item_ids OUT nocopy JTF_NUMBER_TABLE
468 --
469 -- Version : Current version 1.0
470 --
471 -- previous version None
472 --
473 -- Initial version 1.0
474 --
475 -- Notes : Note text
476 --
477 -- End of comments
478 PROCEDURE GetAvailableServices(
479 p_api_version_number IN NUMBER := 1,
480 p_init_msg_list IN VARCHAR2 := NULL,
481 p_commit IN VARCHAR2 := NULL,
482 x_return_status OUT NOCOPY VARCHAR2,
483 x_msg_count OUT NOCOPY NUMBER,
484 x_msg_data OUT NOCOPY VARCHAR2,
485 p_product_item_id IN NUMBER,
486 p_customer_id IN NUMBER,
487 p_product_revision IN VARCHAR2,
488 p_request_date IN DATE,
489 x_service_item_ids OUT NOCOPY JTF_NUMBER_TABLE
490 );
491 -- Start of comments
492 -- API name : GetRelatedCatOrSectIDs
493 -- Type : Private.
494 -- Function : Given an origin id, origin type, relationship type code,
495 -- and destination object type, returns the ids
496 -- of all objects of the given type related to the
497 -- section by the given relationship code. This API
498 -- should only be used for destination types 'S' (section)
499 -- and 'C' (category). The p_preview_flag is only applicable
500 -- when the destination object type is 'S' (section). If
501 -- p_preview_flag is true, returns sections whose
502 -- web_status is 'PUBLISHED' or 'UNPUBLISHED'.
503 -- Otherwise, returns sections whose web_status is
504 -- 'PUBLISHED'.
505 -- Pre-reqs : None.
506 -- Parameters :
507 -- IN : p_api_version IN NUMBER Required
508 -- p_init_msg_list IN VARCHAR2 Optional
509 -- Default = FND_API.G_FALSE
510 -- p_validation_level IN NUMBER Optional
511 -- Default = FND_API.G_VALID_LEVEL_FULL
512 -- p_preview_flag IN VARCHAR2(1) Optional
513 -- Default = FND_API.G_FALSE
514 -- p_originid IN NUMBER Required
515 -- p_origintype IN VARCHAR2(240) Required
516 -- p_reltype_code IN VARCHAR2(30) Required
517 -- p_dest_type IN VARCHAR2(240) Required
518 --
519 -- OUT : x_return_status OUT VARCHAR2(1)
520 -- x_msg_count OUT NUMBER
521 -- x_msg_data OUT VARCHAR2(2000)
522 -- x_relatedid_tbl OUT nocopy JTF_NUMBER_TABLE
523 --
524 -- Version : Current version 1.0
525 --
526 -- previous version None
527 --
528 -- Initial version 1.0
529 --
530 -- Notes : Note text
531 --
532 -- End of comments
533 procedure GetRelatedCatOrSectIDs
534 (
535 p_api_version IN NUMBER,
536 p_init_msg_list IN VARCHAR2 := NULL,
537 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
538 x_return_status OUT NOCOPY VARCHAR2,
539 x_msg_count OUT NOCOPY NUMBER,
540 x_msg_data OUT NOCOPY VARCHAR2,
541
542 p_preview_flag IN VARCHAR2 := NULL,
543 p_originid IN NUMBER,
544 p_origintype IN VARCHAR2,
545 p_reltype_code IN VARCHAR2,
546 p_dest_type IN VARCHAR2,
547 x_relatedid_tbl OUT nocopy JTF_NUMBER_TABLE
548 );
549
550
551
552 -- Start of comments
553 -- API name : Get_Basic_Item_Load_Query
554 -- Type : Private.
558 -- Parameters :
555 -- Function : Returns select and from clauses for an item load query when given
556 -- the load level and category set id.
557 -- Pre-reqs : None.
559 -- IN : p_load_level IN NUMBER
560 -- Possible Values: G_ITEM_SHALLOW, G_ITEM_DEEP, G_ITEM_DEEP_ONLY
561 -- p_category_set_id IN NUMBER
562 --
563 -- OUT : x_basic_query
564 --
565 -- Version : Current version 1.0
566 --
567 -- previous version None
568 --
569 -- Initial version 1.0
570 --
571 -- Notes : Note text
572 --
573 -- End of comments
574 procedure Get_Basic_Item_Load_Query
575 (
576 p_load_level IN NUMBER,
577 x_basic_query OUT NOCOPY VARCHAR2
578 );
579
580 -- Start of comments
581 -- API name : Process_Order_By_Clause
582 -- Type : Private.
583 -- Function : Takes comma separated list of columns (with option asc or desc) of
584 -- MTL_SYSTEM_ITEMS_VL and appends 'MSIV.' in front of each column name so
585 -- it can be used in the order by clause of a query that joins with
586 -- MTL_SYSTEM_ITEMS_VL.
587 -- Pre-reqs : None.
588 -- Parameters :
589 -- IN : p_order_by_clause IN VARCHAR2
590 --
591 --
592 -- OUT : x_order_by_clause OUT VARCHAR2
593 --
594 --
595 -- Version : Current version 1.0
596 --
597 -- previous version None
598 --
599 -- Initial version 1.0
600 --
601 -- Notes : Note text
602 --
603 -- End of comments
604 procedure Process_Order_By_Clause
605 (p_order_by_clause IN VARCHAR2,
606 x_order_by_clause OUT NOCOPY VARCHAR2
607 );
608
609 -- Start of comments
610 -- API name : Get_Format_Mask_and_Symbol
611 -- Type : Private.
612 -- Function : Given currency code and length, retrieves format mask and
613 -- currency symbol. Uses FND_CURRENCY.get_format_mask().
614 -- Pre-reqs : None.
615 -- Parameters :
616 -- IN : p_api_version IN NUMBER Required
617 -- p_init_msg_list IN VARCHAR2 Optional
618 -- Default = FND_API.G_FALSE
619 -- p_validation_level IN NUMBER Optional
620 -- Default = FND_API.G_VALID_LEVEL_FULL
621 -- p_currency_code IN NUMBER
622 -- p_length IN NUMBER
623 --
624 -- OUT : x_return_status OUT VARCHAR2(1)
625 -- x_msg_count OUT NUMBER
626 -- x_msg_data OUT VARCHAR2(2000)
627 -- x_format_mask OUT nocopy VARCHAR2
628 -- x_currency_symbol OUT nocopy VARCHAR2
629 -- Version : Current version 1.0
630 --
631 -- previous version None
632 --
633 -- Initial version 1.0
634 --
635 -- Notes : Note text
636 --
637 -- End of comments
638 procedure Get_Format_Mask_and_Symbol
639 (p_api_version IN NUMBER,
640 p_init_msg_list IN VARCHAR2 := NULL,
641 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
642 x_return_status OUT NOCOPY VARCHAR2,
643 x_msg_count OUT NOCOPY NUMBER,
644 x_msg_data OUT NOCOPY VARCHAR2,
645
646 p_currency_code IN VARCHAR2,
647 p_length IN NUMBER,
648 x_format_mask OUT nocopy VARCHAR2,
649 x_currency_symbol OUT nocopy VARCHAR2
650 );
651
652 procedure validate_quantity
653 (p_api_version IN NUMBER,
654 p_init_msg_list IN VARCHAR2 := NULL,
655 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
656 x_return_status OUT NOCOPY VARCHAR2,
657 x_msg_count OUT NOCOPY NUMBER,
658 x_msg_data OUT NOCOPY VARCHAR2,
659
660 p_item_id_tbl IN JTF_NUMBER_TABLE,
661 p_organization_id_tbl IN JTF_NUMBER_TABLE,
662 p_qty_tbl IN JTF_NUMBER_TABLE,
663 p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100,
664 x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
665 );
666
667 --Bug 3063233
668 procedure validate_de_qty_msite_check
669 (p_api_version IN NUMBER,
670 p_init_msg_list IN VARCHAR2 := NULL,
671 p_reqd_validation IN JTF_VARCHAR2_TABLE_100,
672 p_msite_id IN NUMBER,
673 x_return_status OUT NOCOPY VARCHAR2,
674 x_msg_count OUT NOCOPY NUMBER,
675 x_msg_data OUT NOCOPY VARCHAR2,
676 p_item_id_tbl IN JTF_NUMBER_TABLE,
677 p_organization_id_tbl IN JTF_NUMBER_TABLE,
678 p_qty_tbl IN JTF_NUMBER_TABLE,
682
679 p_uom_code_tbl IN JTF_VARCHAR2_TABLE_100,
680 x_valid_qty_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100
681 );
683 procedure load_msite_languages
684 (x_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
685 x_tran_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
686 x_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300 --gzhang 07/19/2002, bug#2469521
687 );
688
689 procedure load_language
690 (p_lang_code IN VARCHAR2,
691 x_tran_lang_code_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
692 x_desc_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_300, --gzhang 07/19/2002, bug#2469521
693 x_nls_lang OUT NOCOPY VARCHAR2 --jqu 1/19/2005
694 );
695
696 Procedure LOAD_ITEM
697 (p_api_version IN NUMBER,
698 p_init_msg_list IN VARCHAR2 := NULL,
699 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
700 x_return_status OUT NOCOPY VARCHAR2,
701 x_msg_count OUT NOCOPY NUMBER,
702 x_msg_data OUT NOCOPY VARCHAR2,
703
704 p_load_level IN NUMBER,
705 p_preview_flag IN VARCHAR2,
706 p_itmid IN NUMBER,
707 p_partnum IN VARCHAR2,
708 p_model_id IN NUMBER := FND_API.G_MISS_NUM,
709 p_organization_id IN NUMBER,
710 p_category_set_id IN NUMBER,
711 p_retrieve_price IN VARCHAR2,
712
713 p_price_list_id IN NUMBER,
714 p_currency_code IN VARCHAR2,
715 p_price_request_type IN VARCHAR2,
716 p_price_event IN VARCHAR2,
717 p_minisite_id IN NUMBER := NULL,
718 x_item_csr OUT NOCOPY IBE_CATALOG_REFCURSOR_CSR_TYPE,
719 x_category_id_csr OUT NOCOPY IBE_CATALOG_REFCURSOR_CSR_TYPE,
720 x_configurable OUT NOCOPY VARCHAR2,
721 x_model_bundle_flag OUT NOCOPY VARCHAR2,
722 x_uom_csr OUT NOCOPY IBE_CATALOG_REFCURSOR_CSR_TYPE,
723
724 x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,
725 x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
726 x_price_status_code OUT NOCOPY VARCHAR2,
727 x_price_status_text OUT NOCOPY VARCHAR2
728 );
729
730
731 Procedure Load_Items
732 (p_api_version IN NUMBER,
733 p_init_msg_list IN VARCHAR2 := NULL,
734 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
735 x_return_status OUT NOCOPY VARCHAR2,
736 x_msg_count OUT NOCOPY NUMBER,
737 x_msg_data OUT NOCOPY VARCHAR2,
738
739 p_load_level IN NUMBER,
740 p_preview_flag IN VARCHAR2,
741 p_itmid_tbl IN JTF_NUMBER_TABLE,
742 p_partnum_tbl IN JTF_VARCHAR2_TABLE_100,
743 p_model_id_tbl IN JTF_NUMBER_TABLE,
744 p_organization_id IN NUMBER,
745 p_category_set_id IN NUMBER,
746 p_retrieve_price IN VARCHAR2,
747 p_price_list_id IN NUMBER,
748 p_currency_code IN VARCHAR2,
749 p_price_request_type IN VARCHAR2,
750 p_price_event IN VARCHAR2,
751 p_minisite_id IN NUMBER := NULL,
752 x_category_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
753 x_configurable_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
754 x_model_bundle_flag_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
755 x_price_csr OUT NOCOPY IBE_PRICE_PVT.PRICE_REFCURSOR_TYPE,
756 x_line_index_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
757 x_price_status_code OUT NOCOPY VARCHAR2,
758 x_price_status_text OUT NOCOPY VARCHAR2
759 );
760
761 Procedure Get_Item_Type
762 (
763 p_api_version IN NUMBER,
764 p_init_msg_list IN VARCHAR2 := NULL,
765 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
766 p_item_ids IN JTF_NUMBER_TABLE,
767 p_organization_id IN NUMBER,
768 x_item_type OUT NOCOPY JTF_VARCHAR2_TABLE_100,
769 x_return_status OUT NOCOPY VARCHAR2,
770 x_msg_count OUT NOCOPY NUMBER,
771 x_msg_data OUT NOCOPY VARCHAR2
772 );
773
774 PROCEDURE IS_ITEM_IN_MINISITE
775 (
776 p_api_version IN NUMBER,
777 p_init_msg_list IN VARCHAR2 := NULL,
778 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
779 p_item_ids IN JTF_NUMBER_TABLE,
780 p_minisite_id IN NUMBER,
781 x_minisite_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
782 x_return_status OUT NOCOPY VARCHAR2,
783 x_msg_count OUT NOCOPY NUMBER,
784 x_msg_data OUT NOCOPY VARCHAR2
785 );
786
787 PROCEDURE IS_ITEM_CONFIGURABLE
788 (
789 p_item_id IN NUMBER,
790 p_organization_id IN NUMBER,
791 x_configurable OUT NOCOPY VARCHAR2
792 ) ;
793
794
795 end IBE_CATALOG_PVT;
796