eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.IBE_MSITE_GRP_W

Source


1 package ibe_msite_grp_w AUTHID CURRENT_USER as
2   /* $Header: IBEGRMSS.pls 120.1 2005/06/13 11:25 appldev  $ */
3   procedure rosetta_table_copy_in_p7(t out nocopy ibe_msite_grp.msite_currencies_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_NUMBER_TABLE
11     );
12   procedure rosetta_table_copy_out_p7(t ibe_msite_grp.msite_currencies_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
13     , a1 out nocopy JTF_NUMBER_TABLE
14     , a2 out nocopy JTF_NUMBER_TABLE
15     , a3 out nocopy JTF_NUMBER_TABLE
16     , a4 out nocopy JTF_NUMBER_TABLE
17     , a5 out nocopy JTF_VARCHAR2_TABLE_100
18     , a6 out nocopy JTF_NUMBER_TABLE
19     , a7 out nocopy JTF_NUMBER_TABLE
20     );
21 
22   procedure rosetta_table_copy_in_p8(t out nocopy ibe_msite_grp.msite_languages_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23     , a1 JTF_VARCHAR2_TABLE_100
24     , a2 JTF_VARCHAR2_TABLE_100
25     );
26   procedure rosetta_table_copy_out_p8(t ibe_msite_grp.msite_languages_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
27     , a1 out nocopy JTF_VARCHAR2_TABLE_100
28     , a2 out nocopy JTF_VARCHAR2_TABLE_100
29     );
30 
31   procedure rosetta_table_copy_in_p9(t out nocopy ibe_msite_grp.msite_orgids_tbl_type, a0 JTF_NUMBER_TABLE
32     , a1 JTF_VARCHAR2_TABLE_100
33     );
34   procedure rosetta_table_copy_out_p9(t ibe_msite_grp.msite_orgids_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35     , a1 out nocopy JTF_VARCHAR2_TABLE_100
36     );
37 
38   procedure rosetta_table_copy_in_p10(t out nocopy ibe_msite_grp.msite_delete_tbl_type, a0 JTF_NUMBER_TABLE
39     , a1 JTF_NUMBER_TABLE
40     );
41   procedure rosetta_table_copy_out_p10(t ibe_msite_grp.msite_delete_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42     , a1 out nocopy JTF_NUMBER_TABLE
43     );
44 
45   procedure rosetta_table_copy_in_p11(t out nocopy ibe_msite_grp.msite_prtyids_tbl_type, a0 JTF_NUMBER_TABLE);
46   procedure rosetta_table_copy_out_p11(t ibe_msite_grp.msite_prtyids_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
47 
48   procedure delete_msite(p_api_version  NUMBER
49     , p_init_msg_list  VARCHAR2
50     , p_commit  VARCHAR2
51     , x_return_status out nocopy  VARCHAR2
52     , x_msg_count out nocopy  NUMBER
53     , x_msg_data out nocopy  VARCHAR2
54     , p6_a0 JTF_NUMBER_TABLE
55     , p6_a1 JTF_NUMBER_TABLE
56   );
57   procedure save_msite(p_api_version  NUMBER
58     , p_init_msg_list  VARCHAR2
59     , p_commit  VARCHAR2
60     , x_return_status out nocopy  VARCHAR2
61     , x_msg_count out nocopy  NUMBER
62     , x_msg_data out nocopy  VARCHAR2
63     , p6_a0 in out nocopy  NUMBER
64     , p6_a1 in out nocopy  NUMBER
65     , p6_a2 in out nocopy  VARCHAR2
66     , p6_a3 in out nocopy  VARCHAR2
67     , p6_a4 in out nocopy  NUMBER
68     , p6_a5 in out nocopy  VARCHAR2
69     , p6_a6 in out nocopy  VARCHAR2
70     , p6_a7 in out nocopy  VARCHAR2
71     , p6_a8 in out nocopy  VARCHAR2
72     , p6_a9 in out nocopy  NUMBER
73     , p6_a10 in out nocopy  VARCHAR2
74     , p6_a11 in out nocopy  VARCHAR2
75     , p6_a12 in out nocopy  VARCHAR2
76     , p6_a13 in out nocopy  VARCHAR2
77     , p6_a14 in out nocopy  DATE
78     , p6_a15 in out nocopy  DATE
79     , p6_a16 in out nocopy  VARCHAR2
80     , p6_a17 in out nocopy  NUMBER
81     , p6_a18 in out nocopy  VARCHAR2
82     , p6_a19 in out nocopy  VARCHAR2
83     , p6_a20 in out nocopy  VARCHAR2
84     , p6_a21 in out nocopy  VARCHAR2
85     , p6_a22 in out nocopy  VARCHAR2
86   );
87   procedure duplicate_msite(p_api_version  NUMBER
88     , p_init_msg_list  VARCHAR2
89     , p_commit  VARCHAR2
90     , p_default_language_code  VARCHAR2
91     , p_default_currency_code  VARCHAR2
92     , p_walkin_pricing_id  NUMBER
93     , x_minisite_id out nocopy  NUMBER
94     , x_version_number out nocopy  NUMBER
95     , x_return_status out nocopy  VARCHAR2
96     , x_msg_count out nocopy  NUMBER
97     , x_msg_data out nocopy  VARCHAR2
98     , p11_a0 in out nocopy  NUMBER
99     , p11_a1 in out nocopy  NUMBER
100     , p11_a2 in out nocopy  VARCHAR2
101     , p11_a3 in out nocopy  VARCHAR2
102     , p11_a4 in out nocopy  NUMBER
103     , p11_a5 in out nocopy  VARCHAR2
104     , p11_a6 in out nocopy  VARCHAR2
105     , p11_a7 in out nocopy  VARCHAR2
106     , p11_a8 in out nocopy  VARCHAR2
107     , p11_a9 in out nocopy  NUMBER
108     , p11_a10 in out nocopy  VARCHAR2
109     , p11_a11 in out nocopy  VARCHAR2
110     , p11_a12 in out nocopy  VARCHAR2
111     , p11_a13 in out nocopy  VARCHAR2
112     , p11_a14 in out nocopy  DATE
113     , p11_a15 in out nocopy  DATE
114     , p11_a16 in out nocopy  VARCHAR2
115     , p11_a17 in out nocopy  NUMBER
116     , p11_a18 in out nocopy  VARCHAR2
117     , p11_a19 in out nocopy  VARCHAR2
118     , p11_a20 in out nocopy  VARCHAR2
119     , p11_a21 in out nocopy  VARCHAR2
120     , p11_a22 in out nocopy  VARCHAR2
121   );
122   procedure save_msite_languages(p_api_version  NUMBER
123     , p_init_msg_list  VARCHAR2
124     , p_commit  VARCHAR2
125     , x_return_status out nocopy  VARCHAR2
126     , x_msg_count out nocopy  NUMBER
127     , x_msg_data out nocopy  VARCHAR2
128     , p_msite_id  NUMBER
129     , p7_a0 JTF_VARCHAR2_TABLE_100
130     , p7_a1 JTF_VARCHAR2_TABLE_100
131     , p7_a2 JTF_VARCHAR2_TABLE_100
132   );
133   procedure save_msite_currencies(p_api_version  NUMBER
134     , p_init_msg_list  VARCHAR2
135     , p_commit  VARCHAR2
136     , x_return_status out nocopy  VARCHAR2
137     , x_msg_count out nocopy  NUMBER
138     , x_msg_data out nocopy  VARCHAR2
139     , p_msite_id  NUMBER
140     , p7_a0 JTF_VARCHAR2_TABLE_100
141     , p7_a1 JTF_NUMBER_TABLE
142     , p7_a2 JTF_NUMBER_TABLE
143     , p7_a3 JTF_NUMBER_TABLE
144     , p7_a4 JTF_NUMBER_TABLE
145     , p7_a5 JTF_VARCHAR2_TABLE_100
146     , p7_a6 JTF_NUMBER_TABLE
147     , p7_a7 JTF_NUMBER_TABLE
148   );
149   procedure save_msite_orgids(p_api_version  NUMBER
150     , p_init_msg_list  VARCHAR2
151     , p_commit  VARCHAR2
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  NUMBER
156     , p7_a0 JTF_NUMBER_TABLE
157     , p7_a1 JTF_VARCHAR2_TABLE_100
158   );
159   procedure insert_row(x_rowid in out nocopy  VARCHAR2
160     , x_msite_id  NUMBER
161     , x_attribute_category  VARCHAR2
162     , x_attribute1  VARCHAR2
163     , x_attribute2  VARCHAR2
164     , x_attribute3  VARCHAR2
165     , x_attribute4  VARCHAR2
166     , x_attribute5  VARCHAR2
167     , x_attribute6  VARCHAR2
168     , x_attribute7  VARCHAR2
169     , x_attribute8  VARCHAR2
170     , x_attribute9  VARCHAR2
171     , x_attribute11  VARCHAR2
172     , x_attribute10  VARCHAR2
173     , x_attribute12  VARCHAR2
174     , x_attribute13  VARCHAR2
175     , x_attribute14  VARCHAR2
176     , x_attribute15  VARCHAR2
177     , x_object_version_number  NUMBER
178     , x_store_id  NUMBER
179     , x_start_date_active  date
180     , x_end_date_active  date
181     , x_default_language_code  VARCHAR2
182     , x_default_currency_code  VARCHAR2
183     , x_default_date_format  VARCHAR2
184     , x_default_org_id  NUMBER
185     , x_atp_check_flag  VARCHAR2
186     , x_walkin_allowed_flag  VARCHAR2
187     , x_msite_root_section_id  NUMBER
188     , x_profile_id  NUMBER
189     , x_master_msite_flag  VARCHAR2
190     , x_msite_name  VARCHAR2
191     , x_msite_description  VARCHAR2
192     , x_creation_date  date
193     , x_created_by  NUMBER
194     , x_last_update_date  date
195     , x_last_updated_by  NUMBER
196     , x_last_update_login  NUMBER
197     , x_resp_access_flag  VARCHAR2
198     , x_party_access_code  VARCHAR2
199     , x_access_name  VARCHAR2
200     , x_url  VARCHAR2
201     , x_theme_id  NUMBER
202     , x_payment_thresh_enable_flag  VARCHAR2
203     , x_domain_name  VARCHAR2
204     , x_enable_traffic_filter  VARCHAR2
205     , x_reporting_status  VARCHAR2
206     , x_site_type  VARCHAR2
207   );
208   procedure lock_row(x_msite_id  NUMBER
209     , x_attribute_category  VARCHAR2
210     , x_attribute1  VARCHAR2
211     , x_attribute2  VARCHAR2
212     , x_attribute3  VARCHAR2
213     , x_attribute4  VARCHAR2
214     , x_attribute5  VARCHAR2
215     , x_attribute6  VARCHAR2
216     , x_attribute7  VARCHAR2
217     , x_attribute8  VARCHAR2
218     , x_attribute9  VARCHAR2
219     , x_attribute11  VARCHAR2
220     , x_attribute10  VARCHAR2
221     , x_attribute12  VARCHAR2
222     , x_attribute13  VARCHAR2
223     , x_attribute14  VARCHAR2
224     , x_attribute15  VARCHAR2
225     , x_object_version_number  NUMBER
226     , x_store_id  NUMBER
227     , x_start_date_active  date
228     , x_end_date_active  date
229     , x_default_language_code  VARCHAR2
230     , x_default_currency_code  VARCHAR2
231     , x_default_date_format  VARCHAR2
232     , x_default_org_id  NUMBER
233     , x_atp_check_flag  VARCHAR2
234     , x_walkin_allowed_flag  VARCHAR2
235     , x_msite_root_section_id  NUMBER
236     , x_profile_id  NUMBER
237     , x_master_msite_flag  VARCHAR2
238     , x_msite_name  VARCHAR2
239     , x_msite_description  VARCHAR2
240     , x_resp_access_flag  VARCHAR2
241     , x_party_access_code  VARCHAR2
242     , x_access_name  VARCHAR2
243     , x_url  VARCHAR2
244     , x_theme_id  NUMBER
245     , x_payment_thresh_enable_flag  VARCHAR2
246     , x_domain_name  VARCHAR2
247     , x_enable_traffic_filter  VARCHAR2
248     , x_reporting_status  VARCHAR2
249     , x_site_type  VARCHAR2
250   );
251   procedure update_row(x_msite_id  NUMBER
252     , x_attribute_category  VARCHAR2
253     , x_attribute1  VARCHAR2
254     , x_attribute2  VARCHAR2
255     , x_attribute3  VARCHAR2
256     , x_attribute4  VARCHAR2
257     , x_attribute5  VARCHAR2
258     , x_attribute6  VARCHAR2
259     , x_attribute7  VARCHAR2
260     , x_attribute8  VARCHAR2
261     , x_attribute9  VARCHAR2
262     , x_attribute11  VARCHAR2
263     , x_attribute10  VARCHAR2
264     , x_attribute12  VARCHAR2
265     , x_attribute13  VARCHAR2
266     , x_attribute14  VARCHAR2
267     , x_attribute15  VARCHAR2
268     , x_object_version_number  NUMBER
269     , x_store_id  NUMBER
270     , x_start_date_active  date
271     , x_end_date_active  date
272     , x_default_language_code  VARCHAR2
273     , x_default_currency_code  VARCHAR2
274     , x_default_date_format  VARCHAR2
275     , x_default_org_id  NUMBER
276     , x_atp_check_flag  VARCHAR2
277     , x_walkin_allowed_flag  VARCHAR2
278     , x_msite_root_section_id  NUMBER
279     , x_profile_id  NUMBER
280     , x_master_msite_flag  VARCHAR2
281     , x_msite_name  VARCHAR2
282     , x_msite_description  VARCHAR2
283     , x_last_update_date  date
284     , x_last_updated_by  NUMBER
285     , x_last_update_login  NUMBER
286     , x_resp_access_flag  VARCHAR2
287     , x_party_access_code  VARCHAR2
288     , x_access_name  VARCHAR2
289     , x_url  VARCHAR2
290     , x_theme_id  NUMBER
291     , x_payment_thresh_enable_flag  VARCHAR2
292     , x_domain_name  VARCHAR2
293     , x_enable_traffic_filter  VARCHAR2
294     , x_reporting_status  VARCHAR2
295     , x_site_type  VARCHAR2
296   );
297   procedure load_row(x_msite_id  NUMBER
298     , x_owner  VARCHAR2
299     , x_attribute_category  VARCHAR2
300     , x_attribute1  VARCHAR2
301     , x_attribute2  VARCHAR2
302     , x_attribute3  VARCHAR2
303     , x_attribute4  VARCHAR2
304     , x_attribute5  VARCHAR2
305     , x_attribute6  VARCHAR2
306     , x_attribute7  VARCHAR2
307     , x_attribute8  VARCHAR2
308     , x_attribute9  VARCHAR2
309     , x_attribute11  VARCHAR2
310     , x_attribute10  VARCHAR2
311     , x_attribute12  VARCHAR2
312     , x_attribute13  VARCHAR2
313     , x_attribute14  VARCHAR2
314     , x_attribute15  VARCHAR2
315     , x_object_version_number  NUMBER
316     , x_store_id  NUMBER
317     , x_start_date_active  date
318     , x_end_date_active  date
319     , x_default_language_code  VARCHAR2
320     , x_default_currency_code  VARCHAR2
321     , x_default_date_format  VARCHAR2
322     , x_default_org_id  NUMBER
323     , x_atp_check_flag  VARCHAR2
324     , x_walkin_allowed_flag  VARCHAR2
325     , x_msite_root_section_id  NUMBER
326     , x_profile_id  NUMBER
327     , x_master_msite_flag  VARCHAR2
328     , x_msite_name  VARCHAR2
329     , x_msite_description  VARCHAR2
330     , x_resp_access_flag  VARCHAR2
331     , x_party_access_code  VARCHAR2
332     , x_access_name  VARCHAR2
333     , x_url  VARCHAR2
334     , x_theme_id  NUMBER
335     , x_payment_thresh_enable_flag  VARCHAR2
336     , x_domain_name  VARCHAR2
337     , x_enable_traffic_filter  VARCHAR2
338     , x_reporting_status  VARCHAR2
339     , x_site_type  VARCHAR2
340     , x_last_update_date  VARCHAR2
341     , x_custom_mode  VARCHAR2
342   );
343   procedure load_seed_row(x_msite_id  NUMBER
344     , x_owner  VARCHAR2
345     , x_msite_name  VARCHAR2
346     , x_msite_description  VARCHAR2
347     , x_attribute_category  VARCHAR2
348     , x_attribute1  VARCHAR2
349     , x_attribute2  VARCHAR2
350     , x_attribute3  VARCHAR2
351     , x_attribute4  VARCHAR2
352     , x_attribute5  VARCHAR2
353     , x_attribute6  VARCHAR2
354     , x_attribute7  VARCHAR2
355     , x_attribute8  VARCHAR2
356     , x_attribute9  VARCHAR2
357     , x_attribute10  VARCHAR2
358     , x_attribute11  VARCHAR2
359     , x_attribute12  VARCHAR2
360     , x_attribute13  VARCHAR2
361     , x_attribute14  VARCHAR2
362     , x_attribute15  VARCHAR2
363     , x_object_version_number  NUMBER
364     , x_store_id  NUMBER
365     , x_start_date_active  date
366     , x_end_date_active  date
367     , x_default_language_code  VARCHAR2
368     , x_default_currency_code  VARCHAR2
369     , x_default_date_format  VARCHAR2
370     , x_default_org_id  NUMBER
371     , x_atp_check_flag  VARCHAR2
372     , x_walkin_allowed_flag  VARCHAR2
373     , x_msite_root_section_id  NUMBER
374     , x_profile_id  NUMBER
375     , x_master_msite_flag  VARCHAR2
376     , x_resp_access_flag  VARCHAR2
377     , x_party_access_code  VARCHAR2
378     , x_access_name  VARCHAR2
379     , x_url  VARCHAR2
380     , x_theme_id  VARCHAR2
381     , x_payment_thresh_enable_flag  VARCHAR2
382     , x_domain_name  VARCHAR2
383     , x_enable_traffic_filter  VARCHAR2
384     , x_reporting_status  VARCHAR2
385     , x_site_type  VARCHAR2
386     , x_last_update_date  VARCHAR2
387     , x_custom_mode  VARCHAR2
388     , x_upload_mode  VARCHAR2
389   );
390 end ibe_msite_grp_w;