[Home] [Help]
PACKAGE: APPS.IBE_DSP_HIERARCHY_SETUP_PVT
Source
1 PACKAGE IBE_DSP_HIERARCHY_SETUP_PVT AS
2 /* $Header: IBEVCHSS.pls 120.3 2005/12/28 13:21:40 savarghe ship $ */
3
4 -- HISTORY
5 -- 12/12/02 SCHAK Modified for NOCOPY (Bug # 2691704) and Debug (Bug # 2691710) Changes.
6
7 -- **********************************************************************************************************
8
9 PROCEDURE Get_Master_Mini_Site_Id
10 (
11 x_mini_site_id OUT NOCOPY NUMBER,
12 x_root_section_id OUT NOCOPY NUMBER
13 );
14
15 PROCEDURE Create_Hierarchy_Section
16 (
17 p_api_version IN NUMBER,
18 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19 p_commit IN VARCHAR2 := FND_API.G_FALSE,
20 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21 p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
22 p_parent_section_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
23 p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
24 p_start_date_active IN DATE,
25 p_end_date_active IN DATE := FND_API.G_MISS_DATE,
26 p_section_type_code IN VARCHAR2,
27 p_status_code IN VARCHAR2,
28 p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
29 p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
30 p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31 p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
32 p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
33 p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
34 p_display_name IN VARCHAR2,
35 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
36 p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
37 p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
38 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
39 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
46 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
47 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
48 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54 x_section_id OUT NOCOPY NUMBER,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2
58 );
59
60 PROCEDURE Update_Hierarchy_Section
61 (
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64 p_commit IN VARCHAR2 := FND_API.G_FALSE,
65 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66 p_section_id IN NUMBER := FND_API.G_MISS_NUM,
67 p_object_version_number IN NUMBER,
68 p_mss_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
69 p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
70 p_start_date_active IN DATE := FND_API.G_MISS_DATE,
71 p_end_date_active IN DATE := FND_API.G_MISS_DATE,
72 p_section_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
73 p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
74 p_display_context_id IN NUMBER := FND_API.G_MISS_NUM,
75 p_deliverable_id IN NUMBER := FND_API.G_MISS_NUM,
76 p_available_in_all_sites_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
77 p_auto_placement_rule IN VARCHAR2 := FND_API.G_MISS_CHAR,
78 p_order_by_clause IN VARCHAR2 := FND_API.G_MISS_CHAR,
79 p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
80 p_display_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
81 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
82 p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
83 p_keywords IN VARCHAR2 := FND_API.G_MISS_CHAR,
84 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
85 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
86 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
87 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
88 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
89 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
90 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
91 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
92 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
93 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
94 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
95 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
96 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
97 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
98 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
99 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
100 p_upd_dsc_scts_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2
104 );
105
106 PROCEDURE Delete_Hierarchy_Section
107 (
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
110 p_commit IN VARCHAR2 := FND_API.G_FALSE,
111 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
112 p_section_id IN NUMBER := FND_API.G_MISS_NUM,
113 p_access_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2
117 );
118
119 --bug 2699547 (code for PROCEDURE Get_Hierarchy_Sections removed)
120
121 PROCEDURE Associate_Items_To_Section
122 (
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125 p_commit IN VARCHAR2 := FND_API.G_FALSE,
126 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
127 p_section_id IN NUMBER,
128 p_inventory_item_ids IN JTF_NUMBER_TABLE,
129 p_organization_ids IN JTF_NUMBER_TABLE,
130 p_start_date_actives IN JTF_DATE_TABLE,
131 p_end_date_actives IN JTF_DATE_TABLE,
132 p_sort_orders IN JTF_NUMBER_TABLE,
133 p_association_reason_codes IN JTF_VARCHAR2_TABLE_300,
134 x_section_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
135 x_duplicate_association_status OUT NOCOPY VARCHAR2,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2
139 );
140
141 PROCEDURE Associate_Sections_To_Item
142 (
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE,
146 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147 p_inventory_item_id IN NUMBER,
148 p_organization_id IN NUMBER,
149 p_section_ids IN JTF_NUMBER_TABLE,
150 p_start_date_actives IN JTF_DATE_TABLE,
151 p_end_date_actives IN JTF_DATE_TABLE,
152 p_sort_orders IN JTF_NUMBER_TABLE,
153 p_association_reason_codes IN JTF_VARCHAR2_TABLE_300,
154 x_section_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
155 x_duplicate_association_status OUT NOCOPY VARCHAR2,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2
159 );
160
161 PROCEDURE Disassociate_Scts_To_Itms
162 (
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165 p_commit IN VARCHAR2 := FND_API.G_FALSE,
166 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167 p_section_ids IN JTF_NUMBER_TABLE,
168 p_inventory_item_ids IN JTF_NUMBER_TABLE,
169 p_organization_ids IN JTF_NUMBER_TABLE,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2
173 );
174
175 PROCEDURE Disassociate_Scts_Itms
176 (
177 p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179 p_commit IN VARCHAR2 := FND_API.G_FALSE,
180 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181 p_section_item_ids IN JTF_NUMBER_TABLE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2
185 );
186
187 PROCEDURE Associate_MSites_To_Section
188 (
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
191 p_commit IN VARCHAR2 := FND_API.G_FALSE,
192 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193 p_section_id IN NUMBER,
194 p_mini_site_ids IN JTF_NUMBER_TABLE,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2
198 );
199
200 PROCEDURE Associate_Root_Sct_To_MSite
201 (
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
204 p_commit IN VARCHAR2 := FND_API.G_FALSE,
205 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
206 p_section_id IN NUMBER,
207 p_mini_site_id IN NUMBER,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2
211 );
212
213 PROCEDURE Update_Hierarchy_Item
214 (
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217 p_commit IN VARCHAR2 := FND_API.G_FALSE,
218 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219 p_inventory_item_id IN NUMBER,
220 p_organization_id IN NUMBER,
221 p_last_updated_by IN NUMBER,
222 p_last_update_login IN NUMBER,
223 p_last_update_date IN DATE,
224 p_web_status_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
225 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
226 p_long_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2
230 );
231
232 PROCEDURE Associate_MSites_To_Item
233 (
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
236 p_commit IN VARCHAR2 := FND_API.G_FALSE,
237 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
238 p_inventory_item_id IN NUMBER,
239 p_organization_id IN NUMBER,
240 p_mini_site_ids IN JTF_NUMBER_TABLE,
241 x_return_status OUT NOCOPY VARCHAR2,
242 x_msg_count OUT NOCOPY NUMBER,
243 x_msg_data OUT NOCOPY VARCHAR2
244 );
245
246 PROCEDURE Update_Delete_Sct_Scts
247 (
248 p_api_version IN NUMBER,
249 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250 p_commit IN VARCHAR2 := FND_API.G_FALSE,
251 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252 p_msite_section_section_ids IN JTF_NUMBER_TABLE,
253 p_object_version_numbers IN JTF_NUMBER_TABLE,
254 p_start_date_actives IN JTF_DATE_TABLE,
255 p_end_date_actives IN JTF_DATE_TABLE,
256 p_sort_orders IN JTF_NUMBER_TABLE,
257 p_delete_flags IN JTF_VARCHAR2_TABLE_300,
258 x_return_status OUT NOCOPY VARCHAR2,
259 x_msg_count OUT NOCOPY NUMBER,
260 x_msg_data OUT NOCOPY VARCHAR2
261 );
262
263 --bug 2942525 (code for PROCEDURE Copy_And_Paste_Section removed on 05/07/2003)
264
265 PROCEDURE Cut_And_Paste_Section
266 (
267 p_api_version IN NUMBER,
268 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
269 p_commit IN VARCHAR2 := FND_API.G_FALSE,
270 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
271 p_src_section_id IN NUMBER,
272 p_dst_parent_section_id IN NUMBER,
273 x_return_status OUT NOCOPY VARCHAR2,
274 x_msg_count OUT NOCOPY NUMBER,
275 x_msg_data OUT NOCOPY VARCHAR2
276 );
277
278 --begin : added by abhandar :26 apr 2002 for Copy section with content reference
279 PROCEDURE Copy_Section_Ref_Content
280 (
281 p_api_version IN NUMBER,
282 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
283 p_commit IN VARCHAR2 := FND_API.G_FALSE,
284 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285 p_src_section_id IN NUMBER,
286 p_dst_parent_section_id IN NUMBER,
287 x_new_src_section_id OUT NOCOPY NUMBER,
288 x_return_status OUT NOCOPY VARCHAR2,
289 x_msg_count OUT NOCOPY NUMBER,
290 x_msg_data OUT NOCOPY VARCHAR2,
291 p_new_display_name IN VARCHAR2 := NULL
292 );
293
294 PROCEDURE Copy_Logical_Media(
295 p_item_id IN NUMBER,
296 p_object_id IN NUMBER,
297 p_context_id IN NUMBER,
298 x_new_item_id OUT NOCOPY NUMBER,
299 x_msg_count OUT NOCOPY NUMBER,
300 x_return_status OUT NOCOPY VARCHAR2,
301 x_msg_data OUT NOCOPY VARCHAR2
302 );
303
304
305 PROCEDURE Save_Physical_Map(p_item_id IN NUMBER,
306 p_msite_id IN NUMBER,
307 p_language_code IN VARCHAR2,
308 p_attachment_id IN NUMBER,
309 p_default_site IN VARCHAR2,
310 p_default_language IN VARCHAR2,
311 x_return_status OUT NOCOPY VARCHAR2,
312 x_msg_count OUT NOCOPY NUMBER,
313 x_msg_data OUT NOCOPY VARCHAR2);
314
315 PROCEDURE Save_Object_Logical_Content(
316 p_object_id IN NUMBER,
317 p_context_id IN NUMBER,
318 p_item_id IN NUMBER,
319 p_object_type IN VARCHAR2,
320 x_return_status OUT NOCOPY VARCHAR2,
321 x_msg_count OUT NOCOPY NUMBER,
322 x_msg_data OUT NOCOPY VARCHAR2);
323
324 PROCEDURE Reference_Section_Content
325 (
326 p_old_section_id IN NUMBER,
327 p_new_section_id IN NUMBER,
328 x_return_status OUT NOCOPY VARCHAR2,
329 x_msg_count OUT NOCOPY NUMBER,
330 x_msg_data OUT NOCOPY VARCHAR2 );
331
332 -- end : added by abhandar
333
334 -- For 11.5.10, Layout Components Map
335 PROCEDURE Update_Hierarchy_Layout_Map
336 (p_api_version IN NUMBER,
337 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338 p_commit IN VARCHAR2 := FND_API.G_FALSE,
339 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
340 p_section_id IN NUMBER,
341 p_layout_id IN NUMBER,
342 p_layout_comp_id IN JTF_NUMBER_TABLE,
343 p_layout_temp_id IN JTF_NUMBER_TABLE,
344 p_object_versions IN JTF_NUMBER_TABLE,
345 p_actionflags IN JTF_VARCHAR2_TABLE_100,
346 p_cascading_flag IN NUMBER := 0,
347 x_return_status OUT NOCOPY VARCHAR2,
348 x_msg_count OUT NOCOPY NUMBER,
349 x_msg_data OUT NOCOPY VARCHAR2,
350 x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
351 x_layout_comp_ids OUT NOCOPY JTF_NUMBER_TABLE
352 );
353
354 PROCEDURE Update_Section_Dlv_Ctx
355 (p_api_version IN NUMBER,
356 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
357 p_commit IN VARCHAR2 := FND_API.G_FALSE,
358 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
359 p_section_id IN NUMBER,
360 p_deliverable_id IN NUMBER,
361 p_display_context_id IN NUMBER,
362 p_object_version_number IN NUMBER,
363 p_saveds_flag IN NUMBER,
364 x_return_status OUT NOCOPY VARCHAR2,
365 x_msg_count OUT NOCOPY NUMBER,
366 x_msg_data OUT NOCOPY VARCHAR2);
367
368 PROCEDURE Batch_Duplicate_Section(
369 errbuf OUT NOCOPY VARCHAR2,
370 retcode OUT NOCOPY NUMBER,
371 p_source_section_id IN VARCHAR2,
372 p_dest_parent_section_id IN VARCHAR2,
373 p_new_sect_display_name IN VARCHAR2 ,
374 p_enable_trace IN VARCHAR2
375 );
376
377 PROCEDURE Cascade_Layout_Comp_Mapping
378 (p_api_version IN NUMBER,
379 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
380 p_commit IN VARCHAR2 := FND_API.G_FALSE,
381 p_source_section_id IN NUMBER,
382 p_target_section_id IN NUMBER,
383 x_return_status OUT NOCOPY VARCHAR2,
384 x_msg_count OUT NOCOPY NUMBER,
385 x_msg_data OUT NOCOPY VARCHAR2,
386 x_section_ids IN OUT NOCOPY JTF_NUMBER_TABLE,
387 x_layout_comp_ids IN OUT NOCOPY JTF_NUMBER_TABLE);
388
389
390 PROCEDURE Batch_Cascade_Sec_Layout_Map (
391 errbuf OUT NOCOPY VARCHAR2,
392 retcode OUT NOCOPY NUMBER,
393 p_section_id IN VARCHAR2,
394 p_enable_trace_flag IN VARCHAR2);
395
396
397 PROCEDURE Associate_Items_To_Section(
398 p_api_version IN NUMBER,
399 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
400 p_commit IN VARCHAR2 := FND_API.G_FALSE,
401 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
402 x_return_status OUT NOCOPY VARCHAR2,
403 x_msg_count OUT NOCOPY NUMBER,
404 x_msg_data OUT NOCOPY VARCHAR2,
405 p_section_id IN NUMBER,
406 p_section_item_tbl IN IBE_DSP_HIERARCHY_SETUP_PUB.SECTION_ITEM_TBL_TYPE,
407 x_section_item_out_tbl OUT NOCOPY IBE_DSP_HIERARCHY_SETUP_PUB.SECTION_ITEM_OUT_TBL_TYPE);
408
409 END IBE_DSP_HIERARCHY_SETUP_PVT;