[Home] [Help]
PACKAGE: APPS.EGO_ITEM_CATALOG_PUB
Source
1 PACKAGE EGO_ITEM_CATALOG_PUB AS
2 /* $Header: EGOBCAGS.pls 120.1 2005/06/29 00:01:18 lkapoor noship $ */
3
4 -- Validation level
5
6 g_VALIDATE_NONE CONSTANT NUMBER := 0;
7 g_VALIDATE_RULES CONSTANT NUMBER := 10;
8 g_VALIDATE_IDS CONSTANT NUMBER := 20;
9 g_VALIDATE_VALUES CONSTANT NUMBER := 30;
10 g_VALIDATE_ALL CONSTANT NUMBER := 100;
11 g_VALIDATE_LEVEL_FULL CONSTANT NUMBER := 100;
12
13 /* Catalog Group Exposed column record definition */
14
15 TYPE Catalog_Group_Rec_Type IS RECORD
16 (
17 Catalog_Group_Name VARCHAR2(2000)
18 , Parent_Catalog_Group_Name VARCHAR2(2000)
19 , Catalog_Group_Id NUMBER
20 , Parent_Catalog_Group_Id NUMBER
21 , Description VARCHAR2(240)
22 , Item_Creation_Allowed_Flag VARCHAR2(1)
23 , Start_Effective_Date DATE
24 , Inactive_Date DATE
25 , Enabled_Flag VARCHAR2(1)
26 , Summary_Flag VARCHAR2(1)
27 , segment1 VARCHAR2(40)
28 , segment2 VARCHAR2(40)
29 , segment3 VARCHAR2(40)
30 , segment4 VARCHAR2(40)
31 , segment5 VARCHAR2(40)
32 , segment6 VARCHAR2(40)
33 , segment7 VARCHAR2(40)
34 , segment8 VARCHAR2(40)
35 , segment9 VARCHAR2(40)
36 , segment10 VARCHAR2(40)
37 , segment11 VARCHAR2(40)
38 , segment12 VARCHAR2(40)
39 , segment13 VARCHAR2(40)
40 , segment14 VARCHAR2(40)
41 , segment15 VARCHAR2(40)
42 , segment16 VARCHAR2(40)
43 , segment17 VARCHAR2(40)
44 , segment18 VARCHAR2(40)
45 , segment19 VARCHAR2(40)
46 , segment20 VARCHAR2(40)
47 , Attribute_category VARCHAR2(30)
48 , Attribute1 VARCHAR2(150)
49 , Attribute2 VARCHAR2(150)
50 , Attribute3 VARCHAR2(150)
51 , Attribute4 VARCHAR2(150)
52 , Attribute5 VARCHAR2(150)
53 , Attribute6 VARCHAR2(150)
54 , Attribute7 VARCHAR2(150)
55 , Attribute8 VARCHAR2(150)
56 , Attribute9 VARCHAR2(150)
57 , Attribute10 VARCHAR2(150)
58 , Attribute11 VARCHAR2(150)
59 , Attribute12 VARCHAR2(150)
60 , Attribute13 VARCHAR2(150)
61 , Attribute14 VARCHAR2(150)
62 , Attribute15 VARCHAR2(150)
63 , Transaction_Type VARCHAR2(30)
64 , Return_Status VARCHAR2(1)
65 );
66
67 /* Catalog Group Unexposed Record Type */
68
69 TYPE Catalog_Group_UnExp_Rec_Type IS RECORD
70 (
71 Catalog_Group_Id NUMBER
72 ,Parent_Catalog_Group_Id NUMBER
73 );
74
75 TYPE Catalog_Group_Tbl_Type IS TABLE OF Catalog_Group_Rec_Type
76 INDEX BY BINARY_INTEGER;
77
78
79 /* Missing record and Table Definition */
80 G_MISS_CATALOG_GROUP_REC EGO_Item_Catalog_Pub.Catalog_Group_Rec_Type;
81 G_MISS_CATALOG_GROUP_TBL EGO_Item_Catalog_Pub.Catalog_Group_Tbl_Type;
82
83
84 /* Flexfield segment store */
85 G_KF_SEGMENT_VALUES FND_FLEX_EXT.SegmentArray;
86
87
88 /* Public API for processing catalog groups
89 ** Applications can call catalog group api to a create the catalog group hierarchy.
90 ** Parameters:
91 ** init_msg_list: will be used to initialize the message stack. If the calling
92 ** application intends to accumulate the messages between calls to the api,this parameter can
93 ** can be passed as False.
94 ** Catalog_Group_Tbl: This is the table calling application constructs to create the
95 ** catalog group heirarchy
96 ** return_status: this is returned by the api to indicate the success/failure of the call
97 ** msg_count: this is returned by the api to indicate the number of message logged for this
98 ** call.
99 **
100 */
101
102 Procedure Process_Catalog_Groups
103 ( p_bo_identifier IN VARCHAR2 := 'ICG'
104 , p_api_version_number IN NUMBER := 1.0
105 , p_init_msg_list IN BOOLEAN := FALSE
106 , p_catalog_group_tbl IN Ego_Item_Catalog_Pub.Catalog_Group_Tbl_Type
107 , p_user_id IN NUMBER
108 , p_language_code IN VARCHAR2 := 'US'
109 , x_catalog_group_tbl OUT NOCOPY Ego_Item_Catalog_Pub.Catalog_Group_Tbl_Type
110 , x_return_status OUT NOCOPY VARCHAR2
111 , x_msg_count OUT NOCOPY NUMBER
112 , p_debug IN VARCHAR2 := 'N'
113 , p_output_dir IN VARCHAR2 := NULL
114 , p_debug_filename IN VARCHAR2 := 'Ego_Catalog_Grp.log'
115 );
116
117
118 /* Process_Catalog_Group
119 ** Convenience method that can be called once for every catalog group in the catalog group
120 ** hierarchy
121 */
122
123 Procedure Process_Catalog_Group
124 ( p_Catalog_Group_Name IN VARCHAR2 := NULL
125 , p_Parent_Catalog_Group_Name IN VARCHAR2 := NULL
126 , p_Catalog_Group_Id IN NUMBER := NULL
127 , p_Parent_Catalog_Group_Id IN NUMBER := NULL
128 , p_Description IN VARCHAR2 := NULL
129 , p_Item_Creation_Allowed_Flag IN VARCHAR2 := NULL
130 , p_Start_Effective_Date IN DATE := NULL
131 , p_Inactive_date IN DATE := NULL
132 , p_Enabled_Flag IN VARCHAR2 := NULL
133 , p_Summary_Flag IN VARCHAR2 := NULL
134 , p_segment1 IN VARCHAR2 := NULL
135 , p_segment2 IN VARCHAR2 := NULL
136 , p_segment3 IN VARCHAR2 := NULL
137 , p_segment4 IN VARCHAR2 := NULL
138 , p_segment5 IN VARCHAR2 := NULL
139 , p_segment6 IN VARCHAR2 := NULL
140 , p_segment7 IN VARCHAR2 := NULL
141 , p_segment8 IN VARCHAR2 := NULL
142 , p_segment9 IN VARCHAR2 := NULL
143 , p_segment10 IN VARCHAR2 := NULL
144 , p_segment11 IN VARCHAR2 := NULL
145 , p_segment12 IN VARCHAR2 := NULL
146 , p_segment13 IN VARCHAR2 := NULL
147 , p_segment14 IN VARCHAR2 := NULL
148 , p_segment15 IN VARCHAR2 := NULL
149 , p_segment16 IN VARCHAR2 := NULL
150 , p_segment17 IN VARCHAR2 := NULL
151 , p_segment18 IN VARCHAR2 := NULL
152 , p_segment19 IN VARCHAR2 := NULL
153 , p_segment20 IN VARCHAR2 := NULL
154 , Attribute_category IN VARCHAR2 := NULL
155 , Attribute1 IN VARCHAR2 := NULL
156 , Attribute2 IN VARCHAR2 := NULL
157 , Attribute3 IN VARCHAR2 := NULL
158 , Attribute4 IN VARCHAR2 := NULL
159 , Attribute5 IN VARCHAR2 := NULL
160 , Attribute6 IN VARCHAR2 := NULL
161 , Attribute7 IN VARCHAR2 := NULL
162 , Attribute8 IN VARCHAR2 := NULL
163 , Attribute9 IN VARCHAR2 := NULL
164 , Attribute10 IN VARCHAR2 := NULL
165 , Attribute11 IN VARCHAR2 := NULL
166 , Attribute12 IN VARCHAR2 := NULL
167 , Attribute13 IN VARCHAR2 := NULL
168 , Attribute14 IN VARCHAR2 := NULL
169 , Attribute15 IN VARCHAR2 := NULL
170 , p_User_id IN NUMBER
171 , p_Language_Code IN VARCHAR2 := 'US'
172 , p_Transaction_Type IN VARCHAR2
173 , x_Return_Status OUT NOCOPY VARCHAR2
174 , x_msg_count OUT NOCOPY NUMBER
175 , p_debug IN VARCHAR2 := 'N'
176 , p_output_dir IN VARCHAR2 := NULL
177 , p_debug_filename IN VARCHAR2 := 'Ego_Catalog_Grp.log'
178 , x_catalog_group_id OUT NOCOPY NUMBER
179 , x_catalog_group_name OUT NOCOPY VARCHAR2
180 );
181
182 PROCEDURE Create_Catalog_Group
183 ( p_Catalog_Group_Id IN NUMBER := NULL
184 , p_Parent_Catalog_Group_Id IN NUMBER := NULL
185 , p_Description IN VARCHAR2 := NULL
186 , p_Item_Creation_Allowed_Flag IN VARCHAR2 := NULL
187 , p_Start_Effective_Date IN DATE := NULL
188 , p_Inactive_date IN DATE := NULL
189 , p_Enabled_Flag IN VARCHAR2 := NULL
190 , p_Summary_Flag IN VARCHAR2 := NULL
191 , p_segment1 IN VARCHAR2 := NULL
192 , p_segment2 IN VARCHAR2 := NULL
193 , p_segment3 IN VARCHAR2 := NULL
194 , p_segment4 IN VARCHAR2 := NULL
195 , p_segment5 IN VARCHAR2 := NULL
196 , p_segment6 IN VARCHAR2 := NULL
197 , p_segment7 IN VARCHAR2 := NULL
198 , p_segment8 IN VARCHAR2 := NULL
199 , p_segment9 IN VARCHAR2 := NULL
200 , p_segment10 IN VARCHAR2 := NULL
201 , p_segment11 IN VARCHAR2 := NULL
202 , p_segment12 IN VARCHAR2 := NULL
203 , p_segment13 IN VARCHAR2 := NULL
204 , p_segment14 IN VARCHAR2 := NULL
205 , p_segment15 IN VARCHAR2 := NULL
206 , p_segment16 IN VARCHAR2 := NULL
207 , p_segment17 IN VARCHAR2 := NULL
208 , p_segment18 IN VARCHAR2 := NULL
209 , p_segment19 IN VARCHAR2 := NULL
210 , p_segment20 IN VARCHAR2 := NULL
211 , Attribute_category IN VARCHAR2 := NULL
212 , Attribute1 IN VARCHAR2 := NULL
213 , Attribute2 IN VARCHAR2 := NULL
214 , Attribute3 IN VARCHAR2 := NULL
215 , Attribute4 IN VARCHAR2 := NULL
216 , Attribute5 IN VARCHAR2 := NULL
217 , Attribute6 IN VARCHAR2 := NULL
218 , Attribute7 IN VARCHAR2 := NULL
219 , Attribute8 IN VARCHAR2 := NULL
220 , Attribute9 IN VARCHAR2 := NULL
221 , Attribute10 IN VARCHAR2 := NULL
222 , Attribute11 IN VARCHAR2 := NULL
223 , Attribute12 IN VARCHAR2 := NULL
224 , Attribute13 IN VARCHAR2 := NULL
225 , Attribute14 IN VARCHAR2 := NULL
226 , Attribute15 IN VARCHAR2 := NULL
227 , p_Template_Id IN NUMBER
228 , p_User_id IN NUMBER
229 , x_return_status OUT NOCOPY VARCHAR2
230 , x_msg_count OUT NOCOPY NUMBER
231 , x_msg_data OUT NOCOPY VARCHAR2
232 , p_debug IN VARCHAR2 := 'N'
233 , p_output_dir IN VARCHAR2 := NULL
234 , p_debug_filename IN VARCHAR2 := 'Ego_Catalog_Grp.log'
235 , x_catalog_group_id OUT NOCOPY NUMBER
236 , x_catalog_group_name OUT NOCOPY VARCHAR2
237 );
238
239 PROCEDURE Update_Catalog_Group
240 ( p_Catalog_Group_Id IN NUMBER := NULL
241 , p_Parent_Catalog_Group_Id IN NUMBER := NULL
242 , p_Description IN VARCHAR2 := NULL
243 , p_Item_Creation_Allowed_Flag IN VARCHAR2 := NULL
244 , p_Start_Effective_Date IN DATE := NULL
245 , p_Inactive_date IN DATE := NULL
246 , p_Enabled_Flag IN VARCHAR2 := NULL
247 , p_Summary_Flag IN VARCHAR2 := NULL
248 , p_segment1 IN VARCHAR2 := NULL
249 , p_segment2 IN VARCHAR2 := NULL
250 , p_segment3 IN VARCHAR2 := NULL
251 , p_segment4 IN VARCHAR2 := NULL
252 , p_segment5 IN VARCHAR2 := NULL
253 , p_segment6 IN VARCHAR2 := NULL
254 , p_segment7 IN VARCHAR2 := NULL
255 , p_segment8 IN VARCHAR2 := NULL
256 , p_segment9 IN VARCHAR2 := NULL
257 , p_segment10 IN VARCHAR2 := NULL
258 , p_segment11 IN VARCHAR2 := NULL
259 , p_segment12 IN VARCHAR2 := NULL
260 , p_segment13 IN VARCHAR2 := NULL
261 , p_segment14 IN VARCHAR2 := NULL
262 , p_segment15 IN VARCHAR2 := NULL
263 , p_segment16 IN VARCHAR2 := NULL
264 , p_segment17 IN VARCHAR2 := NULL
265 , p_segment18 IN VARCHAR2 := NULL
266 , p_segment19 IN VARCHAR2 := NULL
267 , p_segment20 IN VARCHAR2 := NULL
268 , Attribute_category IN VARCHAR2 := NULL
269 , Attribute1 IN VARCHAR2 := NULL
270 , Attribute2 IN VARCHAR2 := NULL
271 , Attribute3 IN VARCHAR2 := NULL
272 , Attribute4 IN VARCHAR2 := NULL
273 , Attribute5 IN VARCHAR2 := NULL
274 , Attribute6 IN VARCHAR2 := NULL
275 , Attribute7 IN VARCHAR2 := NULL
276 , Attribute8 IN VARCHAR2 := NULL
277 , Attribute9 IN VARCHAR2 := NULL
278 , Attribute10 IN VARCHAR2 := NULL
279 , Attribute11 IN VARCHAR2 := NULL
280 , Attribute12 IN VARCHAR2 := NULL
281 , Attribute13 IN VARCHAR2 := NULL
282 , Attribute14 IN VARCHAR2 := NULL
283 , Attribute15 IN VARCHAR2 := NULL
284 , p_Template_Id IN NUMBER
285 , p_User_id IN NUMBER
286 , x_Return_Status OUT NOCOPY VARCHAR2
287 , x_msg_count OUT NOCOPY NUMBER
288 , x_msg_data OUT NOCOPY VARCHAR2
289 , p_debug IN VARCHAR2 := 'N'
290 , p_output_dir IN VARCHAR2 := NULL
291 , p_debug_filename IN VARCHAR2 := 'Ego_Catalog_Grp.log'
292 , x_catalog_group_id OUT NOCOPY NUMBER
293 , x_catalog_group_name OUT NOCOPY VARCHAR2
294 );
295
296 ---------------------------------------------------------------
297 -- Check before deleting an attribute group assoc ----
298 ---------------------------------------------------------------
299 PROCEDURE Check_Delete_AttrGroup_Assoc
300 (
301 p_api_version IN NUMBER
302 ,p_association_id IN NUMBER
303 ,p_classification_code IN VARCHAR2
304 ,p_data_level IN VARCHAR2
305 ,p_attr_group_id IN NUMBER
306 ,p_application_id IN NUMBER
307 ,p_attr_group_type IN VARCHAR2
308 ,p_attr_group_name IN VARCHAR2
309 ,p_enabled_code IN VARCHAR2
310 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
311 ,x_ok_to_delete OUT NOCOPY VARCHAR2
312 ,x_return_status OUT NOCOPY VARCHAR2
313 ,x_errorcode OUT NOCOPY NUMBER
314 ,x_msg_count OUT NOCOPY NUMBER
315 ,x_msg_data OUT NOCOPY VARCHAR2
316 );
317
318 ---------------------------------------------------------------
319 PROCEDURE LOCK_ROW (
320 p_item_catalog_group_id IN NUMBER,
321 p_parent_catalog_group_id IN NUMBER,
322 p_item_creation_allowed_flag IN VARCHAR2,
323 p_inactive_date IN DATE,
324 p_segment1 IN VARCHAR2,
325 p_segment2 IN VARCHAR2,
326 p_segment3 IN VARCHAR2,
330 p_segment7 IN VARCHAR2,
327 p_segment4 IN VARCHAR2,
328 p_segment5 IN VARCHAR2,
329 p_segment6 IN VARCHAR2,
331 p_segment8 IN VARCHAR2,
332 p_segment9 IN VARCHAR2,
333 p_segment10 IN VARCHAR2,
334 p_segment11 IN VARCHAR2,
335 p_segment12 IN VARCHAR2,
336 p_segment13 IN VARCHAR2,
337 p_segment14 IN VARCHAR2,
338 p_segment15 IN VARCHAR2,
339 p_segment16 IN VARCHAR2,
340 p_segment17 IN VARCHAR2,
341 p_segment18 IN VARCHAR2,
342 p_segment19 IN VARCHAR2,
343 p_segment20 IN VARCHAR2,
344 p_description IN VARCHAR2
345 );
346
347
348
349
350 END EGO_ITEM_CATALOG_PUB;