1 PACKAGE IBE_Msite_GRP AS
2 /* $Header: IBEGMSTS.pls 120.2 2006/06/30 21:14:39 abhandar noship $ */
3
4 g_pkg_name CONSTANT varchar2(30):='IBE_Msite_GRP';
5 g_api_version CONSTANT number := 1.0;
6
7
8 TYPE msite_rec_type IS RECORD (
9 msite_id number,
10 Object_Version_number number,
11 Display_name varchar2(120),
12 Description varchar2(4000),
13 profile_id number,
14 date_format varchar2(30),
15 walkin_allowed_code varchar2(1),
16 atp_check_flag varchar2(1),
17 msite_master_flag varchar2(1),
18 msite_root_section_id number,
19 enable_for_store varchar2(1),
20 --new fields for globalisation, added by ssridhar
21 resp_access_flag varchar2(1),
22 party_access_code varchar2(1),
23 access_name varchar2(240),
24 start_date_active date,
25 end_date_active date ,
26 url varchar2(2000),
27 theme_id number,
28 payment_threshold_enable_flag varchar2(1),
29 -- new fields for OWA site integration
30 domain_name varchar2(30),
31 enable_traffic_filter varchar2(1),
32 reporting_status varchar2(1),
33 site_type varchar2(10)
34 );
35
36
37 TYPE msite_currency_rec_type IS RECORD (
38 currency_code varchar2(15),
39 walkin_prc_lst_id number,
40 registered_prc_lst_id number,
41 biz_partner_prc_lst_id number,
42 orderable_limit number,
43 default_flag varchar2(1),
44 payment_threshold number,
45 partner_prc_lst_id number);
46
47 TYPE msite_language_rec_type is RECORD (
48 language_code varchar2(4),
49 default_flag varchar2(1),
50 enable_flag varchar2(1)
51 );
52
53 TYPE msite_orgid_rec_type IS RECORD (
54 orgid number,
55 default_flag varchar2(1)
56 );
57
58 TYPE msite_delete_rec_type IS RECORD (
59 msite_id number,
60 object_version_number number
61 );
62
63
64 TYPE msite_currencies_tbl_type IS TABLE OF
65 msite_currency_rec_type INDEX BY BINARY_INTEGER;
66
67 TYPE msite_languages_tbl_type IS TABLE OF
68 msite_language_rec_type INDEX BY BINARY_INTEGER;
69
70 TYPE msite_orgids_tbl_type IS TABLE OF
71 msite_orgid_rec_type INDEX BY BINARY_INTEGER;
72
73 TYPE msite_delete_tbl_type IS TABLE OF
74 msite_delete_rec_type INDEX BY BINARY_INTEGER;
75
76 TYPE msite_prtyids_tbl_type IS TABLE OF
77 number INDEX BY BINARY_INTEGER;
78
79 PROCEDURE delete_msite(
80 p_api_version IN number,
81 p_init_msg_list IN varchar2 := FND_API.g_false,
82 p_commit IN varchar2 := FND_API.g_false,
83 x_return_status OUT NOCOPY varchar2,
84 x_msg_count OUT NOCOPY number,
85 x_msg_data OUT NOCOPY varchar2,
86 p_msite_id_tbl IN msite_delete_tbl_type
87 );
88
89 PROCEDURE save_msite(
90 p_api_version IN number,
91 p_init_msg_list IN varchar2 := FND_API.g_false,
92 p_commit IN varchar2 := FND_API.g_false,
93 x_return_status OUT NOCOPY varchar2,
94 x_msg_count OUT NOCOPY number,
95 x_msg_data OUT NOCOPY varchar2,
96 p_msite_rec IN OUT NOCOPY Msite_REC_TYPE
97 );
98
99 PROCEDURE duplicate_msite(
100 p_api_version IN number,
101 p_init_msg_list IN varchar2 := FND_API.g_false,
102 p_commit IN varchar2 := FND_API.g_false,
103 p_default_language_code IN varchar2,
104 p_default_currency_code IN varchar2,
105 p_walkin_pricing_id IN number,
106 x_minisite_id OUT NOCOPY number,
107 x_version_number OUT NOCOPY number,
108 x_return_status OUT NOCOPY varchar2,
109 x_msg_count OUT NOCOPY number,
110 x_msg_data OUT NOCOPY varchar2,
111 p_msite_rec IN OUT NOCOPY MSITE_REC_TYPE
112 );
113
114 PROCEDURE save_msite_languages(
115 p_api_version IN number,
116 p_init_msg_list IN varchar2 := FND_API.g_false,
117 p_commit IN varchar2 := FND_API.g_false,
118 x_return_status OUT NOCOPY varchar2,
119 x_msg_count OUT NOCOPY number,
120 x_msg_data OUT NOCOPY varchar2,
121 p_msite_id IN number,
122 p_msite_languages_tbl IN MSITE_LANGUAGES_TBL_TYPE
123 );
124
125 PROCEDURE save_msite_currencies(
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_msite_id IN number,
133 p_msite_currencies_tbl IN MSITE_CURRENCIES_TBL_TYPE
134 );
135
136
137 PROCEDURE get_msite_attribute (
138 p_api_version IN number,
139 p_init_msg_list IN varchar2 := FND_API.g_false,
140 p_commit IN varchar2 := FND_API.g_false,
141 x_return_status OUT NOCOPY varchar2,
142 x_msg_count OUT NOCOPY number,
143 x_msg_data OUT NOCOPY varchar2,
144 p_msite_id IN number,
145 p_msite_attribute_name IN varchar2,
146 x_msite_attribute_value OUT NOCOPY varchar2);
147
148 PROCEDURE save_msite_orgids(
149 p_api_version IN number,
150 p_init_msg_list IN varchar2 := FND_API.g_false,
151 p_commit IN varchar2 := FND_API.g_false,
152 x_return_status OUT NOCOPY varchar2,
153 x_msg_count OUT NOCOPY number,
154 x_msg_data OUT NOCOPY varchar2,
155 p_msite_id IN number,
156 p_msite_orgids_tbl IN MSITE_ORGIDS_TBL_TYPE
157 );
158
159 procedure INSERT_ROW (
160 X_ROWID in out NOCOPY varchar2,
161 X_MSITE_ID in number,
162 X_ATTRIBUTE_CATEGORY in varchar2,
163 X_ATTRIBUTE1 in varchar2,
164 X_ATTRIBUTE2 in varchar2,
165 X_ATTRIBUTE3 in varchar2,
166 X_ATTRIBUTE4 in varchar2,
167 X_ATTRIBUTE5 in varchar2,
168 X_ATTRIBUTE6 in varchar2,
169 X_ATTRIBUTE7 in varchar2,
170 X_ATTRIBUTE8 in varchar2,
171 X_ATTRIBUTE9 in varchar2,
172 X_ATTRIBUTE11 in varchar2,
173 X_ATTRIBUTE10 in varchar2,
174 X_ATTRIBUTE12 in varchar2,
175 X_ATTRIBUTE13 in varchar2,
176 X_ATTRIBUTE14 in varchar2,
177 X_ATTRIBUTE15 in varchar2,
178 X_OBJECT_VERSION_number in number,
179 X_STORE_ID in number,
180 X_START_date_ACTIVE in date,
181 X_END_date_ACTIVE in date,
182 X_DEFAULT_LANGUAGE_CODE in varchar2,
183 X_DEFAULT_CURRENCY_CODE in varchar2,
184 X_DEFAULT_date_FORMAT in varchar2,
185 X_DEFAULT_ORG_ID in number,
186 X_ATP_CHECK_FLAG in varchar2,
187 X_WALKIN_ALLOWED_FLAG in varchar2,
188 X_MSITE_ROOT_SECTION_ID in number,
189 X_PROFILE_ID in number,
190 X_MASTER_MSITE_FLAG in varchar2,
191 X_MSITE_NAME in varchar2,
192 X_MSITE_DESCRIPTION in varchar2,
193 X_CREATION_date in date,
194 X_CREATED_BY in number,
195 X_LAST_UPdate_date in date,
196 X_LAST_UPdateD_BY in number,
197 X_LAST_UPdate_LOGIN in number ,
198 X_RESP_ACCESS_FLAG in varchar2 ,
199 X_PARTY_ACCESS_CODE in varchar2 ,
200 X_ACCESS_NAME in varchar2 ,
201 X_URL in varchar2 ,
202 X_THEME_ID in number,
203 X_PAYMENT_THRESH_ENABLE_FLAG in VARCHAR2 := NULL,
204 X_DOMAIN_NAME in VARCHAR2 := NULL,
205 X_ENABLE_TRAFFIC_FILTER in VARCHAR2 := 'N',
206 X_REPORTING_STATUS in VARCHAR2 := 'N',
207 X_SITE_TYPE in VARCHAR2 := 'I'
208 );
209
210 procedure LOCK_ROW (
211 X_MSITE_ID in number,
212 X_ATTRIBUTE_CATEGORY in varchar2,
213 X_ATTRIBUTE1 in varchar2,
214 X_ATTRIBUTE2 in varchar2,
215 X_ATTRIBUTE3 in varchar2,
216 X_ATTRIBUTE4 in varchar2,
217 X_ATTRIBUTE5 in varchar2,
218 X_ATTRIBUTE6 in varchar2,
219 X_ATTRIBUTE7 in varchar2,
220 X_ATTRIBUTE8 in varchar2,
221 X_ATTRIBUTE9 in varchar2,
222 X_ATTRIBUTE11 in varchar2,
223 X_ATTRIBUTE10 in varchar2,
224 X_ATTRIBUTE12 in varchar2,
225 X_ATTRIBUTE13 in varchar2,
226 X_ATTRIBUTE14 in varchar2,
227 X_ATTRIBUTE15 in varchar2,
228 X_OBJECT_VERSION_number in number,
229 X_STORE_ID in number,
230 X_START_date_ACTIVE in date,
231 X_END_date_ACTIVE in date,
232 X_DEFAULT_LANGUAGE_CODE in varchar2,
233 X_DEFAULT_CURRENCY_CODE in varchar2,
234 X_DEFAULT_date_FORMAT in varchar2,
235 X_DEFAULT_ORG_ID in number,
236 X_ATP_CHECK_FLAG in varchar2,
237 X_WALKIN_ALLOWED_FLAG in varchar2,
238 X_MSITE_ROOT_SECTION_ID in number,
239 X_PROFILE_ID in number,
240 X_MASTER_MSITE_FLAG in varchar2,
241 X_MSITE_NAME in varchar2,
242 X_MSITE_DESCRIPTION in varchar2 ,
243 X_RESP_ACCESS_FLAG in varchar2 ,
244 X_PARTY_ACCESS_CODE in varchar2 ,
245 X_ACCESS_NAME in varchar2 ,
246 X_URL in varchar2 ,
247 X_THEME_ID in number,
248 X_PAYMENT_THRESH_ENABLE_FLAG in VARCHAR2 := NULL,
249 X_DOMAIN_NAME in VARCHAR2 := NULL,
250 X_ENABLE_TRAFFIC_FILTER in VARCHAR2 := 'N',
251 X_REPORTING_STATUS in VARCHAR2 := 'N',
252 X_SITE_TYPE in VARCHAR2 := 'I'
253 );
254
255 procedure UPdate_ROW (
256 X_MSITE_ID in number,
257 X_ATTRIBUTE_CATEGORY in varchar2,
258 X_ATTRIBUTE1 in varchar2,
259 X_ATTRIBUTE2 in varchar2,
260 X_ATTRIBUTE3 in varchar2,
261 X_ATTRIBUTE4 in varchar2,
262 X_ATTRIBUTE5 in varchar2,
263 X_ATTRIBUTE6 in varchar2,
264 X_ATTRIBUTE7 in varchar2,
265 X_ATTRIBUTE8 in varchar2,
266 X_ATTRIBUTE9 in varchar2,
267 X_ATTRIBUTE11 in varchar2,
268 X_ATTRIBUTE10 in varchar2,
269 X_ATTRIBUTE12 in varchar2,
270 X_ATTRIBUTE13 in varchar2,
271 X_ATTRIBUTE14 in varchar2,
272 X_ATTRIBUTE15 in varchar2,
273 X_OBJECT_VERSION_number in number,
274 X_STORE_ID in number,
275 X_START_date_ACTIVE in date,
276 X_END_date_ACTIVE in date,
277 X_DEFAULT_LANGUAGE_CODE in varchar2,
278 X_DEFAULT_CURRENCY_CODE in varchar2,
279 X_DEFAULT_date_FORMAT in varchar2,
280 X_DEFAULT_ORG_ID in number,
281 X_ATP_CHECK_FLAG in varchar2,
282 X_WALKIN_ALLOWED_FLAG in varchar2,
283 X_MSITE_ROOT_SECTION_ID in number,
284 X_PROFILE_ID in number,
285 X_MASTER_MSITE_FLAG in varchar2,
286 X_MSITE_NAME in varchar2,
287 X_MSITE_DESCRIPTION in varchar2,
288 X_LAST_UPdate_date in date,
289 X_LAST_UPdateD_BY in number,
290 X_LAST_UPdate_LOGIN in number ,
291 X_RESP_ACCESS_FLAG in varchar2 ,
292 X_PARTY_ACCESS_CODE in varchar2 ,
293 X_ACCESS_NAME in varchar2 ,
294 X_URL in varchar2 ,
295 X_THEME_ID in number,
296 X_PAYMENT_THRESH_ENABLE_FLAG in VARCHAR2 := NULL,
297 X_DOMAIN_NAME in VARCHAR2 := NULL,
298 X_ENABLE_TRAFFIC_FILTER in VARCHAR2 := 'N',
299 X_REPORTING_STATUS in VARCHAR2 := 'N',
300 X_SITE_TYPE in VARCHAR2 := 'I'
301 );
302
303 procedure DELETE_ROW (
304 X_MSITE_ID in number
305 );
306
307 procedure TRANSLATE_ROW (
308 X_MSITE_ID in number,
309 X_OWNER in varchar2,
310 X_MSITE_NAME in varchar2,
311 X_MSITE_DESCRIPTION in varchar2,
312 X_LAST_UPDATE_DATE in varchar2,
313 X_CUSTOM_MODE in Varchar2
314 );
315
316 procedure LOAD_ROW (
317 X_MSITE_ID in number,
318 X_OWNER in varchar2,
319 X_ATTRIBUTE_CATEGORY in varchar2,
320 X_ATTRIBUTE1 in varchar2,
321 X_ATTRIBUTE2 in varchar2,
322 X_ATTRIBUTE3 in varchar2,
323 X_ATTRIBUTE4 in varchar2,
324 X_ATTRIBUTE5 in varchar2,
325 X_ATTRIBUTE6 in varchar2,
326 X_ATTRIBUTE7 in varchar2,
327 X_ATTRIBUTE8 in varchar2,
328 X_ATTRIBUTE9 in varchar2,
329 X_ATTRIBUTE11 in varchar2,
330 X_ATTRIBUTE10 in varchar2,
331 X_ATTRIBUTE12 in varchar2,
332 X_ATTRIBUTE13 in varchar2,
333 X_ATTRIBUTE14 in varchar2,
334 X_ATTRIBUTE15 in varchar2,
335 X_OBJECT_VERSION_number in number,
336 X_STORE_ID in number,
337 X_START_date_ACTIVE in date,
338 X_END_date_ACTIVE in date,
339 X_DEFAULT_LANGUAGE_CODE in varchar2,
340 X_DEFAULT_CURRENCY_CODE in varchar2,
341 X_DEFAULT_date_FORMAT in varchar2,
342 X_DEFAULT_ORG_ID in number,
343 X_ATP_CHECK_FLAG in varchar2,
344 X_WALKIN_ALLOWED_FLAG in varchar2,
345 X_MSITE_ROOT_SECTION_ID in number,
346 X_PROFILE_ID in number,
347 X_MASTER_MSITE_FLAG in varchar2,
348 X_MSITE_NAME in varchar2,
349 X_MSITE_DESCRIPTION in varchar2 ,
350 X_RESP_ACCESS_FLAG in varchar2 ,
351 X_PARTY_ACCESS_CODE in varchar2 ,
352 X_ACCESS_NAME in varchar2 ,
353 X_URL in varchar2 ,
354 X_THEME_ID in number,
355 X_PAYMENT_THRESH_ENABLE_FLAG in VARCHAR2 := NULL,
356 X_DOMAIN_NAME in VARCHAR2 := NULL,
357 X_ENABLE_TRAFFIC_FILTER in VARCHAR2 := 'N',
358 X_REPORTING_STATUS in VARCHAR2 := 'N',
359 X_SITE_TYPE in VARCHAR2 := 'I',
360 X_LAST_UPDATE_DATE in varchar2,
361 X_CUSTOM_MODE in Varchar2
362 );
363
364 PROCEDURE ADD_LANGUAGE;
365
366 PROCEDURE LOAD_SEED_ROW
367 (
368 X_MSITE_ID in NUMBER,
369 X_OWNER in VARCHAR2,
370 X_MSITE_NAME in VARCHAR2,
371 X_MSITE_DESCRIPTION in VARCHAR2,
372 X_ATTRIBUTE_CATEGORY in VARCHAR2,
373 X_ATTRIBUTE1 in VARCHAR2,
374 X_ATTRIBUTE2 in VARCHAR2,
375 X_ATTRIBUTE3 in VARCHAR2,
376 X_ATTRIBUTE4 in VARCHAR2,
377 X_ATTRIBUTE5 in VARCHAR2,
378 X_ATTRIBUTE6 in VARCHAR2,
379 X_ATTRIBUTE7 in VARCHAR2,
380 X_ATTRIBUTE8 in VARCHAR2,
381 X_ATTRIBUTE9 in VARCHAR2,
382 X_ATTRIBUTE10 in VARCHAR2,
383 X_ATTRIBUTE11 in VARCHAR2,
384 X_ATTRIBUTE12 in VARCHAR2,
385 X_ATTRIBUTE13 in VARCHAR2,
386 X_ATTRIBUTE14 in VARCHAR2,
387 X_ATTRIBUTE15 in VARCHAR2,
388 X_OBJECT_VERSION_NUMBER in NUMBER,
389 X_STORE_ID in NUMBER,
390 X_START_DATE_ACTIVE IN VARCHAR2,--IN DATE,
391 X_END_DATE_ACTIVE IN VARCHAR2,-- IN DATE,
392 X_DEFAULT_LANGUAGE_CODE in VARCHAR2,
393 X_DEFAULT_CURRENCY_CODE in VARCHAR2,
394 X_DEFAULT_DATE_FORMAT in VARCHAR2,
395 X_DEFAULT_ORG_ID in NUMBER,
396 X_ATP_CHECK_FLAG in VARCHAR2,
397 X_WALKIN_ALLOWED_FLAG in VARCHAR2,
398 X_MSITE_ROOT_SECTION_ID in NUMBER,
399 X_PROFILE_ID in NUMBER,
400 X_MASTER_MSITE_FLAG in VARCHAR2,
401 X_RESP_ACCESS_FLAG in VARCHAR2 ,
402 X_PARTY_ACCESS_CODE in VARCHAR2 ,
403 X_ACCESS_NAME in VARCHAR2 ,
404 X_URL in VARCHAR2 ,
405 X_THEME_ID in VARCHAR2 ,
406 X_PAYMENT_THRESH_ENABLE_FLAG in VARCHAR2 := NULL,
407 X_DOMAIN_NAME in VARCHAR2 := NULL,
408 X_ENABLE_TRAFFIC_FILTER in VARCHAR2 := 'N',
409 X_REPORTING_STATUS in VARCHAR2 := 'N',
410 X_SITE_TYPE in VARCHAR2 := 'I',
411 X_LAST_UPDATE_DATE IN VARCHAR2,
412 X_CUSTOM_MODE IN VARCHAR2,
413 X_UPLOAD_MODE IN VARCHAR2
414 );
415
416 END IBE_Msite_GRP;