1 PACKAGE IBC_STYLESHEETS_GRP AUTHID CURRENT_USER as
2 /* $Header: ibcgsshs.pls 120.2 2005/12/29 04:59:03 hsaiyed noship $ */
3
4
5 --------------------------------------------------------------------------------
6 -- Start of comments
7 -- API name : Get_Approved_Default_StyleSht
8 -- Type : Group
9 -- Pre-reqs : None
10 -- Function : Return the default style sheet for the input item's content type.
11 -- The style sheet has to be approved and its availability date
12 -- has be to valid, otherwise exception will be thrown.
13 -- Parameters :
14 -- IN : p_api_version IN NUMBER Required
15 -- p_init_msg_list IN VARCHAR2 Optional
16 -- Default = FND_API.G_FALSE
17 -- p_content_item_id IN NUMBER Required
18 -- p_stylesheet_label_code IN VARCHAR2 Optional
19 -- Default = NULL
20 -- OUT : x_stylesheet OUT NOCOPY BLOB
21 -- x_return_status OUT VARCHAR2
22 -- x_msg_count OUT NUMBER
23 -- x_msg_data OUT VARCHAR2
24 --------------------------------------------------------------------------------
25 PROCEDURE Get_Approved_Default_StyleSht (
26 p_api_version IN NUMBER,
27 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28 p_content_item_id IN NUMBER,
29 p_stylesheet_label_code IN VARCHAR2 DEFAULT NULL,
30 x_stylesheet OUT NOCOPY BLOB,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2
34 );
35
36 --------------------------------------------------------------------------------
37 -- Start of comments
38 -- API name : Get_Apprv_Default_StyleSht_Id
39 -- Type : Group
40 -- Pre-reqs : None
41 -- Function : Return the stylesheet id
42 -- Parameters :
43 -- IN : p_api_version IN NUMBER Required
44 -- p_init_msg_list IN VARCHAR2 Optional
45 -- Default = FND_API.G_FALSE
46 -- p_content_item_id IN NUMBER Required
47 -- p_stylesheet_label_code IN VARCHAR2 Optional
48 -- Default = NULL
49 -- OUT : x_stylesheet_id OUT NUMBER
50 -- x_return_status OUT VARCHAR2
51 -- x_msg_count OUT NUMBER
52 -- x_msg_data OUT VARCHAR2
53 --------------------------------------------------------------------------------
54 PROCEDURE Get_Apprv_Default_StyleSht_Id (
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57 p_content_item_id IN NUMBER,
58 p_stylesheet_label_code IN VARCHAR2 DEFAULT NULL,
59 x_stylesheet_id OUT NOCOPY NUMBER,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65 --------------------------------------------------------------------------------
66 -- Start of comments
67 -- API name : Get_Approved_StyleSheet
68 -- Type : Group
69 -- Pre-reqs : None
70 -- Function : Return the style sheet specified by its id.
71 -- The style sheet has to be approved and its availability date
72 -- has be to valid, otherwise exception will be thrown.
73 -- Parameters :
74 -- IN : p_api_version IN NUMBER Required
75 -- p_init_msg_list IN VARCHAR2 Optional
76 -- Default = FND_API.G_FALSE
77 -- p_stylesheet_item_id IN NUMBER Required
78 -- p_stylesheet_label_code IN VARCHAR2 Optional
79 -- Default = NULL
80 -- OUT : x_stylesheet OUT NOCOPY BLOB
81 -- x_return_status OUT VARCHAR2
82 -- x_msg_count OUT NUMBER
83 -- x_msg_data OUT VARCHAR2
84 --------------------------------------------------------------------------------
85 PROCEDURE Get_Approved_StyleSheet (
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88 p_stylesheet_item_id IN NUMBER,
89 p_stylesheet_label_code IN VARCHAR2 DEFAULT NULL,
90 x_stylesheet OUT NOCOPY BLOB,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2
94 );
95
96
97 --------------------------------------------------------------------------------
98 -- Start of comments
99 -- API name : Get_Approved_StyleSheet_RC
100 -- Type : Group
101 -- Pre-reqs : None
102 -- Function : Return the style sheet specified by its reference code.
103 -- The style sheet has to be approved and its availability date
104 -- has be to valid, otherwise exception will be thrown.
105 -- Parameters :
106 -- IN : p_api_version IN NUMBER Required
107 -- p_init_msg_list IN VARCHAR2 Optional
108 -- Default = FND_API.G_FALSE
109 -- p_stylesheet_ref_code IN VARCHAR2 Required
110 -- p_stylesheet_label_code IN VARCHAR2 Optional
111 -- Default = NULL
112 -- OUT : x_stylesheet OUT NOCOPY BLOB
113 -- x_return_status OUT VARCHAR2
114 -- x_msg_count OUT NUMBER
115 -- x_msg_data OUT VARCHAR2
116 --------------------------------------------------------------------------------
117 PROCEDURE Get_Approved_StyleSht_RC (
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
120 p_stylesheet_ref_code IN VARCHAR2,
121 p_stylesheet_label_code IN VARCHAR2 DEFAULT NULL,
122 x_stylesheet OUT NOCOPY BLOB,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2
126 );
127
128
129
130 --------------------------------------------------------------------------------
131 -- Start of comments
132 -- API name : Get_StyleSheet_Items
133 -- Type : Group
134 -- Pre-reqs : None
135 -- Function : Return the stylesheets associated with the content
136 -- type of the given content item.
137 -- A stylesheet label can be optionally provided to indicate
138 -- the specific versions of the stylesheet items to be retrieved.
139 -- If there is no label-version mapping for a particular stylesheet,
140 -- or the stylesheet does not satisfy all the Runtimer delivery
141 -- requirement, that stylesheet item will NOT be included in the list returned.
142 -- Parameters :
143 -- IN : p_api_version IN NUMBER Required
144 -- p_init_msg_list IN VARCHAR2 Optional
145 -- Default = FND_API.G_FALSE
146 -- p_content_item_id IN NUMBER Required
147 -- p_stylesheet_label_code IN VARCHAR2 Optional
148 -- Default = NULL
149 -- OUT : x_stylesheet_item_clobs OUT NOCOPY JTF_CLOB_TABLE
150 -- x_stylesheet_item_ids OUT NOCOPY JTF_NUMBER_TABLE
151 -- x_stylesheet_lang_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
152 -- x_return_status OUT NOCOPY VARCHAR2
153 -- x_msg_count OUT NOCOPY NUMBER
154 -- x_msg_data OUT NOCOPY VARCHAR2
155 --------------------------------------------------------------------------------
156 PROCEDURE Get_StyleSheet_Items (
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
159 p_content_item_id IN NUMBER,
160 p_stylesheets_label_code IN VARCHAR2 DEFAULT NULL,
161 x_stylesheet_item_clobs OUT NOCOPY JTF_CLOB_TABLE,
162 x_stylesheet_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
163 x_stylesheet_lang_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2
167 );
168
169
170
171 END IBC_STYLESHEETS_GRP;