1 PACKAGE IBE_PhysicalMap_GRP AUTHID CURRENT_USER AS
2 /* $Header: IBEGPSLS.pls 120.1 2005/07/08 14:28:15 appldev ship $ */
3 -- Declare externally visible types, cursor, exception
4
5 /*
6 TYPE LANGUAGE_CODE_TBL_TYPE IS TABLE OF VARCHAR2(4)
7 INDEX BY BINARY_INTEGER;
8 */
9 TYPE LANGUAGE_CODE_TBL_TYPE IS TABLE OF VARCHAR2(4);
10
11 TYPE MSITE_LANG_REC_TYPE IS RECORD (
12 msite_id NUMBER,
13 lang_count NUMBER
14 );
15
16 TYPE MSITE_LANG_TBL_TYPE IS TABLE OF MSITE_LANG_REC_TYPE
17 INDEX BY BINARY_INTEGER;
18
19 TYPE LGL_PHYS_MAP_ID_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
20
21 TYPE MSITE_ID_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
22
23 g_api_version CONSTANT NUMBER := 1.0;
24 g_pkg_name CONSTANT VARCHAR2(30) := 'IBE_PhysicalMap_GRP';
25
26 -- Declare externally callable subprograms
27
28 -- Start of comments
29 -- API name: save_physicalmap
30 -- Type: Private
31 -- Function: Save a collection of Physical_Mappings for a physical attachment
32 -- and one mini-site
33 -- Pre_reqs: None
34 -- Parameters:
35 -- IN:
36 -- p_api_version IN NUMBER Required
37 -- p_init_msg_list IN VARCHAR2 Optional
38 -- Default = FND_API.g_false
39 -- p_commit IN VARCHAR2 Optional
40 -- Default = FND_API.g_false
41 -- x_return_status OUT VARCHAR2
42 -- x_msg_count OUT NUMBER
43 -- x_msg_data OUT VARCHAR2
44 -- p_attachment_id IN NUMBER Required
45 -- p_msite_id IN NUMBER Required
46 -- p_language_code_tbl IN LANGUAGE_CODE_TBL_TYPE
47 -- Required
48 -- Version: Current Version 1.0
49 -- Initial version 1.0
50 -- Notes: None
51 -- End of comments
52
53 PROCEDURE save_physicalmap (
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
56 p_commit IN VARCHAR2 := FND_API.g_false,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 p_attachment_id IN NUMBER,
61 p_msite_id IN NUMBER,
62 p_language_code_tbl IN LANGUAGE_CODE_TBL_TYPE);
63
64
65 -- Start of comments
66 -- API name: save_physicalmap
67 -- Type: Private
68 -- Function: Save a collection of Physical_Mappings for a physical attachment
69 -- and multiple mini-sites
70 -- Pre_reqs: None
71 -- Parameters:
72 -- IN:
73 -- p_api_version IN NUMBER Required
74 -- p_init_msg_list IN VARCHAR2 Optional
75 -- Default = FND_API.g_false
76 -- p_commit IN VARCHAR2 Optional
77 -- Default = FND_API.g_false
78 -- x_return_status OUT VARCHAR2
79 -- x_msg_count OUT NUMBER
80 -- x_msg_data OUT VARCHAR2
81 -- p_attachment_id IN NUMBER Required
82 -- p_msite_lang_tbl IN MSITE_LANG_TBL_TYPE
83 -- Required
84 -- p_language_code_tbl IN LANGUAGE_CODE_TBL_TYPE
85 -- Required
86 -- Version: Current Version 1.0
87 -- Initial version 1.0
88 -- Notes: None
89 -- End of comments
90
91 PROCEDURE save_physicalmap (
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
94 p_commit IN VARCHAR2 := FND_API.g_false,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_attachment_id IN NUMBER,
99 p_msite_lang_tbl IN MSITE_LANG_TBL_TYPE,
100 p_language_code_tbl IN LANGUAGE_CODE_TBL_TYPE);
101
102
103 -- Start of comments
104 -- API name: delete_physicalmap
105 -- Type: Private
106 -- Function: Delete a collection of Physical_Mappings
107 -- Pre_reqs: None
108 -- Parameters:
109 -- IN:
110 -- p_api_version IN NUMBER Required
111 -- p_init_msg_list IN VARCHAR2 Optional
112 -- Default = FND_API.g_false
113 -- p_commit IN VARCHAR2 Optional
114 -- Default = FND_API.g_false
115 -- x_return_status OUT VARCHAR2
116 -- x_msg_count OUT NUMBER
117 -- x_msg_data OUT VARCHAR2
118 -- p_lgl_phys_map_id_tbl IN LGL_PHYS_MAP_ID_TBL_TYPE
119 -- Required
120 -- Version: Current Version 1.0
121 -- Initial version 1.0
122 -- Notes: None
123 -- End of comments
124
125 PROCEDURE delete_physicalmap(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
128 p_commit IN VARCHAR2 := FND_API.g_false,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_lgl_phys_map_id_tbl IN LGL_PHYS_MAP_ID_TBL_TYPE);
133
134
135 -- Start of comments
136 -- API name: delete_attachment
137 -- Type: Private
138 -- Function: Delete all the Physical_Mappings for the given attachment
139 -- Pre_reqs: None
140 -- Parameters:
141 -- IN:
142 -- p_attachment_id IN NUMBER Required
143 -- Version: Current Version 1.0
144 -- Initial version 1.0
145 -- Notes: None
146 -- End of comments
147
148 PROCEDURE delete_attachment(
149 p_attachment_id IN NUMBER);
150
151
152 -- Start of comments
153 -- API name: delete_deliverable
154 -- Type: Private
155 -- Function: Delete all the Physical_Mappings for the given deliverable
156 -- Pre_reqs: None
157 -- Parameters:
158 -- IN:
159 -- p_deliverable_id IN NUMBER Required
160 -- Version: Current Version 1.0
161 -- Initial version 1.0
162 -- Notes: None
163 -- End of comments
164
165 PROCEDURE delete_deliverable(
166 p_deliverable_id IN NUMBER);
167
168
169 -- Start of comments
170 -- API name: delete_msite
171 -- Type: Private
172 -- Function: Delete all the Physical_Mappings for the given mini-site
173 -- Pre_reqs: None
174 -- Parameters:
175 -- IN:
176 -- p_msite_id IN NUMBER Required
177 -- Version: Current Version 1.0
178 -- Initial version 1.0
179 -- Notes: None
180 -- End of comments
181
182 PROCEDURE delete_msite(
183 p_msite_id IN NUMBER);
184
185
186 -- Start of comments
187 -- API name: delete_msite_language
188 -- Type: Private
189 -- Function: Delete all the Physical_Mappings involved the given mini-site
190 -- and the languages which have been de-supported at the mini-site
191 -- Pre_reqs: None
192 -- Parameters:
193 -- IN:
194 -- p_msite_id IN NUMBER Required
195 -- Version: Current Version 1.0
196 -- Initial version 1.0
197 -- Notes: None
198 -- End of comments
199
200 PROCEDURE delete_msite_language(
201 p_msite_id IN NUMBER);
202
203
204 -- Start of comments
205 -- API name: delete_attachment_msite
206 -- Type: Private
207 -- Function: Delete all the Physical_Mappings for the given attachment
208 -- and mini-sites
209 -- Pre_reqs: None
210 -- Parameters:
211 -- IN:
212 -- p_api_version IN NUMBER Required
213 -- p_init_msg_list IN VARCHAR2 Optional
214 -- Default = FND_API.g_false
215 -- p_commit IN VARCHAR2 Optional
216 -- Default = FND_API.g_false
217 -- x_return_status OUT VARCHAR2
218 -- x_msg_count OUT NUMBER
219 -- x_msg_data OUT VARCHAR2
220 -- p_attachment_id IN NUMBETR Required
221 -- p_msite_id_tbl IN MSITE_ID_TBL_TYPE
222 -- Required
223 -- Version: Current Version 1.0
224 -- Initial version 1.0
225 -- Notes: None
226 -- End of comments
227
228 PROCEDURE delete_attachment_msite(
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
231 p_commit IN VARCHAR2 := FND_API.g_false,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2,
235 p_attachment_id IN NUMBER,
236 p_msite_id_tbl IN MSITE_ID_TBL_TYPE);
237
238
239 -- Start of comments
240 -- API name: delete_dlv_all_all
241 -- Type: Private
242 -- Function: Delete the all-site and all-language mappings for the given
243 -- deliverable
244 -- Pre_reqs: None
245 -- Parameters:
246 -- IN:
247 -- p_deliverable_id IN NUMBETR Required
248 -- Version: Current Version 1.0
249 -- Initial version 1.0
250 -- Notes: None
251 -- End of comments
252
253 PROCEDURE delete_dlv_all_all(
254 p_deliverable_id IN NUMBER);
255
256 -- The following procedures are for OCM integration
257 PROCEDURE save_physicalmap(
258 p_api_version IN NUMBER,
259 p_init_msg_list IN VARCHAR2 := FND_API.g_false, --modified by YAXU, ewmove DEFAULT
260 p_commit IN VARCHAR2 := FND_API.g_false,
261 x_return_status OUT NOCOPY VARCHAR2,
262 x_msg_count OUT NOCOPY NUMBER,
263 x_msg_data OUT NOCOPY VARCHAR2,
264 p_deliverable_id IN NUMBER,
265 p_old_content_key IN VARCHAR2,
266 p_new_content_key IN VARCHAR2,
267 p_msite_lang_tbl IN MSITE_LANG_TBL_TYPE,
268 p_language_code_tbl IN LANGUAGE_CODE_TBL_TYPE);
269
270 PROCEDURE delete_physicalmap(
271 p_api_version IN NUMBER,
272 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
273 p_commit IN VARCHAR2 := FND_API.g_false,
274 x_return_status OUT NOCOPY VARCHAR2,
275 x_msg_count OUT NOCOPY NUMBER,
276 x_msg_data OUT NOCOPY VARCHAR2,
277 p_deliverable_id IN NUMBER,
278 p_content_key IN VARCHAR2);
279
280 PROCEDURE replace_content(
281 p_api_version IN NUMBER,
282 p_init_msg_list IN VARCHAR2 := FND_API.g_false, --modified by YAXU, ewmove DEFAULT
283 p_commit IN VARCHAR2 := FND_API.g_false,
284 x_return_status OUT NOCOPY VARCHAR2,
285 x_msg_count OUT NOCOPY NUMBER,
286 x_msg_data OUT NOCOPY VARCHAR2,
287 p_old_content_key IN VARCHAR2,
288 p_new_content_key IN VARCHAR2);
289
290 PROCEDURE LOAD_SEED_ROW(
291 P_LGL_PHYS_MAP_ID IN NUMBER,
292 P_OBJECT_VERSION_NUMBER IN NUMBER,
293 P_MSITE_ID IN NUMBER,
294 P_LANGUAGE_CODE IN VARCHAR2,
295 P_ATTACHMENT_ID IN NUMBER,
296 P_ITEM_ID IN NUMBER,
297 P_DEFAULT_LANGUAGE IN VARCHAR2,
298 P_DEFAULT_SITE IN VARCHAR2,
299 P_OWNER IN VARCHAR2,
300 P_LAST_UPDATE_DATE IN VARCHAR2,
301 P_CUSTOM_MODE IN VARCHAR2,
302 P_UPLOAD_MODE IN VARCHAR2);
303
304 PROCEDURE LOAD_ROW(
305 P_LGL_PHYS_MAP_ID IN NUMBER,
306 P_OBJECT_VERSION_NUMBER IN NUMBER,
307 P_MSITE_ID IN NUMBER,
308 P_LANGUAGE_CODE IN VARCHAR2,
309 P_ATTACHMENT_ID IN NUMBER,
310 P_ITEM_ID IN NUMBER,
311 P_DEFAULT_LANGUAGE IN VARCHAR2,
312 P_DEFAULT_SITE IN VARCHAR2,
313 P_OWNER IN VARCHAR2,
314 P_LAST_UPDATE_DATE IN VARCHAR2,
315 P_CUSTOM_MODE IN VARCHAR2);
316
317 END IBE_PhysicalMap_GRP;