1 package IBE_CATALOG_PRELOAD_PUB as
2 /* $Header: IBEPCPLS.pls 120.0 2005/05/30 03:07:11 appldev noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_CATALOG_PRELOAD_PUB';
5
6
7 type IBE_ID_REC is RECORD
8 (
9 id NUMBER
10 );
11
12 type IBE_CATALOG_REFCURSOR_CSR_TYPE is REF CURSOR;
13
14 -- Start of comments
15 -- API name : Get_Preload_Section_Ids
16 -- Type : Public.
17 -- Function : Returns ref cursor containing section_ids of sections to be preloaded
18 -- into the cache. Section IDs should come from
19 -- IBE_DSP_SECTIONS_B.SECTION_ID or a table with a foreign key to
20 -- IBE_DSP_SECTIONS_B.SECTION_ID. Current implementation returns all
21 -- section ids.
22 --
23 -- Pre-reqs : None.
24 -- Parameters :
25 --
26 -- IN : p_api_version IN NUMBER Required
27 -- p_init_msg_list IN VARCHAR2 Optional
28 -- Default = FND_API.G_FALSE
29 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
30 -- x_msg_count OUT NOCOPY NUMBER
31 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
32 -- x_section_id_csr OUT NOCOPY IBE_CATALOG_REFCURSOR_CSR_TYPE
33 -- Record type = IBE_ID_REC
34 --
35 -- Version : Current version 1.0
36 --
37 -- previous version None
38 --
39 -- Initial version 1.0
40 --
41 -- Notes : Note text
42 --
43 -- End of comments
44 procedure Get_Preload_Section_Ids
45 (p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50
51 x_section_id_csr OUT NOCOPY IBE_CATALOG_REFCURSOR_CSR_TYPE
52 );
53
54
55 -- Start of comments
56 -- API name : Get_Preload_Item_Ids
57 -- Type : Public.
58 -- Function : Returns ref cursor containing inventory_item_ids of items to be
59 -- preloaded into the cache. Item IDs should come from
60 -- MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID or a table with a foreign
61 -- key to MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID (such as
62 -- IBE_DSP_SECTION_ITEMS). Current implementation returns inventory
63 -- item ids of all items in featured sections.
64 --
65 -- Pre-reqs : None.
66 -- Parameters :
67 --
68 -- IN : p_api_version IN NUMBER Required
69 -- p_init_msg_list IN VARCHAR2 Optional
70 -- Default = FND_API.G_FALSE
71 -- OUT : x_return_status OUT NOCOPY VARCHAR2(1)
72 -- x_msg_count OUT NOCOPY NUMBER
73 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
74 -- x_item_id_csr OUT NOCOPY IBE_CATALOG_REFCURSOR_CSR_TYPE
75 -- Record type = IBE_ID_REC
76 --
77 -- Version : Current version 1.0
78 --
79 -- previous version None
80 --
81 -- Initial version 1.0
82 --
83 -- Notes : Note text
84 --
85 -- End of comments
86 procedure Get_Preload_Item_Ids
87 (p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92
93 x_item_id_csr OUT NOCOPY IBE_CATALOG_REFCURSOR_CSR_TYPE
94 );
95
96
97
98 -------
99 -- (code for PROCEDURE Preload_Sections removed on 01/19/2005 by rgupta)
100 -- This procedure is no longer necessary due to a redesign of the iStore
101 -- Section cache.
102 --
103
104
105 end IBE_CATALOG_PRELOAD_PUB;