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.JTF_MSITE_GRP_W

Source


1 package jtf_msite_grp_w AUTHID CURRENT_USER as
2   /* $Header: JTFGRMSS.pls 115.9 2004/07/09 18:50:55 applrt ship $ */
3   procedure rosetta_table_copy_in_p7(t out jtf_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     );
10   procedure rosetta_table_copy_out_p7(t jtf_msite_grp.msite_currencies_tbl_type, a0 out JTF_VARCHAR2_TABLE_100
11     , a1 out JTF_NUMBER_TABLE
12     , a2 out JTF_NUMBER_TABLE
13     , a3 out JTF_NUMBER_TABLE
14     , a4 out JTF_NUMBER_TABLE
15     , a5 out JTF_VARCHAR2_TABLE_100
16     );
17 
18   procedure rosetta_table_copy_in_p8(t out jtf_msite_grp.msite_languages_tbl_type, a0 JTF_VARCHAR2_TABLE_100
19     , a1 JTF_VARCHAR2_TABLE_100
20     );
21   procedure rosetta_table_copy_out_p8(t jtf_msite_grp.msite_languages_tbl_type, a0 out JTF_VARCHAR2_TABLE_100
22     , a1 out JTF_VARCHAR2_TABLE_100
23     );
24 
25   procedure rosetta_table_copy_in_p9(t out jtf_msite_grp.msite_orgids_tbl_type, a0 JTF_NUMBER_TABLE
26     , a1 JTF_VARCHAR2_TABLE_100
27     );
28   procedure rosetta_table_copy_out_p9(t jtf_msite_grp.msite_orgids_tbl_type, a0 out JTF_NUMBER_TABLE
29     , a1 out JTF_VARCHAR2_TABLE_100
30     );
31 
32   procedure rosetta_table_copy_in_p10(t out jtf_msite_grp.msite_delete_tbl_type, a0 JTF_NUMBER_TABLE
33     , a1 JTF_NUMBER_TABLE
34     );
35   procedure rosetta_table_copy_out_p10(t jtf_msite_grp.msite_delete_tbl_type, a0 out JTF_NUMBER_TABLE
36     , a1 out JTF_NUMBER_TABLE
37     );
38 
39   procedure rosetta_table_copy_in_p11(t out jtf_msite_grp.msite_prtyids_tbl_type, a0 JTF_NUMBER_TABLE);
40   procedure rosetta_table_copy_out_p11(t jtf_msite_grp.msite_prtyids_tbl_type, a0 out JTF_NUMBER_TABLE);
41 
42   procedure delete_msite(p_api_version  NUMBER
43     , p_init_msg_list  VARCHAR2
44     , p_commit  VARCHAR2
45     , x_return_status out  VARCHAR2
46     , x_msg_count out  NUMBER
47     , x_msg_data out  VARCHAR2
48     , p6_a0 JTF_NUMBER_TABLE
49     , p6_a1 JTF_NUMBER_TABLE
50   );
51   procedure save_msite(p_api_version  NUMBER
52     , p_init_msg_list  VARCHAR2
53     , p_commit  VARCHAR2
54     , x_return_status out  VARCHAR2
55     , x_msg_count out  NUMBER
56     , x_msg_data out  VARCHAR2
57     , p6_a0 in out  NUMBER
58     , p6_a1 in out  NUMBER
59     , p6_a2 in out  VARCHAR2
60     , p6_a3 in out  VARCHAR2
61     , p6_a4 in out  NUMBER
62     , p6_a5 in out  VARCHAR2
63     , p6_a6 in out  VARCHAR2
64     , p6_a7 in out  VARCHAR2
65     , p6_a8 in out  VARCHAR2
66     , p6_a9 in out  NUMBER
67     , p6_a10 in out  VARCHAR2
68     , p6_a11 in out  VARCHAR2
69     , p6_a12 in out  VARCHAR2
70     , p6_a13 in out  VARCHAR2
71     , p6_a14 in out  DATE
72     , p6_a15 in out  DATE
73     , p6_a16 in out  VARCHAR2
74     , p6_a17 in out  NUMBER
75   );
76   procedure save_msite_languages(p_api_version  NUMBER
77     , p_init_msg_list  VARCHAR2
78     , p_commit  VARCHAR2
79     , x_return_status out  VARCHAR2
80     , x_msg_count out  NUMBER
81     , x_msg_data out  VARCHAR2
82     , p_msite_id  NUMBER
83     , p7_a0 JTF_VARCHAR2_TABLE_100
84     , p7_a1 JTF_VARCHAR2_TABLE_100
85   );
86   procedure save_msite_currencies(p_api_version  NUMBER
87     , p_init_msg_list  VARCHAR2
88     , p_commit  VARCHAR2
89     , x_return_status out  VARCHAR2
90     , x_msg_count out  NUMBER
91     , x_msg_data out  VARCHAR2
92     , p_msite_id  NUMBER
93     , p7_a0 JTF_VARCHAR2_TABLE_100
94     , p7_a1 JTF_NUMBER_TABLE
95     , p7_a2 JTF_NUMBER_TABLE
96     , p7_a3 JTF_NUMBER_TABLE
97     , p7_a4 JTF_NUMBER_TABLE
98     , p7_a5 JTF_VARCHAR2_TABLE_100
99   );
100   procedure save_msite_orgids(p_api_version  NUMBER
101     , p_init_msg_list  VARCHAR2
102     , p_commit  VARCHAR2
103     , x_return_status out  VARCHAR2
104     , x_msg_count out  NUMBER
105     , x_msg_data out  VARCHAR2
106     , p_msite_id  NUMBER
107     , p7_a0 JTF_NUMBER_TABLE
108     , p7_a1 JTF_VARCHAR2_TABLE_100
109   );
110   procedure insert_row(x_rowid in out  VARCHAR2
111     , x_msite_id  NUMBER
112     , x_attribute_category  VARCHAR2
113     , x_attribute1  VARCHAR2
114     , x_attribute2  VARCHAR2
115     , x_attribute3  VARCHAR2
116     , x_attribute4  VARCHAR2
117     , x_attribute5  VARCHAR2
118     , x_attribute6  VARCHAR2
119     , x_attribute7  VARCHAR2
120     , x_attribute8  VARCHAR2
121     , x_attribute9  VARCHAR2
122     , x_attribute11  VARCHAR2
123     , x_attribute10  VARCHAR2
124     , x_attribute12  VARCHAR2
125     , x_attribute13  VARCHAR2
126     , x_attribute14  VARCHAR2
127     , x_attribute15  VARCHAR2
128     , x_security_group_id  NUMBER
129     , x_object_version_number  NUMBER
130     , x_store_id  NUMBER
131     , x_start_date_active  date
132     , x_end_date_active  date
133     , x_default_language_code  VARCHAR2
134     , x_default_currency_code  VARCHAR2
135     , x_default_date_format  VARCHAR2
136     , x_default_org_id  NUMBER
137     , x_atp_check_flag  VARCHAR2
138     , x_walkin_allowed_flag  VARCHAR2
139     , x_msite_root_section_id  NUMBER
140     , x_profile_id  NUMBER
141     , x_master_msite_flag  VARCHAR2
142     , x_msite_name  VARCHAR2
143     , x_msite_description  VARCHAR2
144     , x_creation_date  date
145     , x_created_by  NUMBER
146     , x_last_update_date  date
147     , x_last_updated_by  NUMBER
148     , x_last_update_login  NUMBER
149     , x_resp_access_flag  VARCHAR2
150     , x_party_access_code  VARCHAR2
151     , x_access_name  VARCHAR2
152     , x_url  VARCHAR2
153     , x_theme_id  NUMBER
154   );
155   procedure lock_row(x_msite_id  NUMBER
156     , x_attribute_category  VARCHAR2
157     , x_attribute1  VARCHAR2
158     , x_attribute2  VARCHAR2
159     , x_attribute3  VARCHAR2
160     , x_attribute4  VARCHAR2
161     , x_attribute5  VARCHAR2
162     , x_attribute6  VARCHAR2
163     , x_attribute7  VARCHAR2
164     , x_attribute8  VARCHAR2
165     , x_attribute9  VARCHAR2
166     , x_attribute11  VARCHAR2
167     , x_attribute10  VARCHAR2
168     , x_attribute12  VARCHAR2
169     , x_attribute13  VARCHAR2
170     , x_attribute14  VARCHAR2
171     , x_attribute15  VARCHAR2
172     , x_security_group_id  NUMBER
173     , x_object_version_number  NUMBER
174     , x_store_id  NUMBER
175     , x_start_date_active  date
176     , x_end_date_active  date
177     , x_default_language_code  VARCHAR2
178     , x_default_currency_code  VARCHAR2
179     , x_default_date_format  VARCHAR2
180     , x_default_org_id  NUMBER
181     , x_atp_check_flag  VARCHAR2
182     , x_walkin_allowed_flag  VARCHAR2
183     , x_msite_root_section_id  NUMBER
184     , x_profile_id  NUMBER
185     , x_master_msite_flag  VARCHAR2
186     , x_msite_name  VARCHAR2
187     , x_msite_description  VARCHAR2
188     , x_resp_access_flag  VARCHAR2
189     , x_party_access_code  VARCHAR2
190     , x_access_name  VARCHAR2
191     , x_url  VARCHAR2
192     , x_theme_id  NUMBER
193   );
194   procedure update_row(x_msite_id  NUMBER
195     , x_attribute_category  VARCHAR2
196     , x_attribute1  VARCHAR2
197     , x_attribute2  VARCHAR2
198     , x_attribute3  VARCHAR2
199     , x_attribute4  VARCHAR2
200     , x_attribute5  VARCHAR2
201     , x_attribute6  VARCHAR2
202     , x_attribute7  VARCHAR2
203     , x_attribute8  VARCHAR2
204     , x_attribute9  VARCHAR2
205     , x_attribute11  VARCHAR2
206     , x_attribute10  VARCHAR2
207     , x_attribute12  VARCHAR2
208     , x_attribute13  VARCHAR2
209     , x_attribute14  VARCHAR2
210     , x_attribute15  VARCHAR2
211     , x_security_group_id  NUMBER
212     , x_object_version_number  NUMBER
213     , x_store_id  NUMBER
214     , x_start_date_active  date
215     , x_end_date_active  date
216     , x_default_language_code  VARCHAR2
217     , x_default_currency_code  VARCHAR2
218     , x_default_date_format  VARCHAR2
219     , x_default_org_id  NUMBER
220     , x_atp_check_flag  VARCHAR2
221     , x_walkin_allowed_flag  VARCHAR2
222     , x_msite_root_section_id  NUMBER
223     , x_profile_id  NUMBER
224     , x_master_msite_flag  VARCHAR2
225     , x_msite_name  VARCHAR2
226     , x_msite_description  VARCHAR2
227     , x_last_update_date  date
228     , x_last_updated_by  NUMBER
229     , x_last_update_login  NUMBER
230     , x_resp_access_flag  VARCHAR2
231     , x_party_access_code  VARCHAR2
232     , x_access_name  VARCHAR2
233     , x_url  VARCHAR2
234     , x_theme_id  NUMBER
235   );
236   procedure load_row(x_msite_id  NUMBER
237     , x_owner  VARCHAR2
238     , x_attribute_category  VARCHAR2
239     , x_attribute1  VARCHAR2
240     , x_attribute2  VARCHAR2
241     , x_attribute3  VARCHAR2
242     , x_attribute4  VARCHAR2
243     , x_attribute5  VARCHAR2
244     , x_attribute6  VARCHAR2
245     , x_attribute7  VARCHAR2
249     , x_attribute10  VARCHAR2
246     , x_attribute8  VARCHAR2
247     , x_attribute9  VARCHAR2
248     , x_attribute11  VARCHAR2
250     , x_attribute12  VARCHAR2
251     , x_attribute13  VARCHAR2
252     , x_attribute14  VARCHAR2
253     , x_attribute15  VARCHAR2
254     , x_security_group_id  NUMBER
255     , x_object_version_number  NUMBER
256     , x_store_id  NUMBER
257     , x_start_date_active  date
258     , x_end_date_active  date
259     , x_default_language_code  VARCHAR2
260     , x_default_currency_code  VARCHAR2
261     , x_default_date_format  VARCHAR2
262     , x_default_org_id  NUMBER
263     , x_atp_check_flag  VARCHAR2
264     , x_walkin_allowed_flag  VARCHAR2
265     , x_msite_root_section_id  NUMBER
266     , x_profile_id  NUMBER
267     , x_master_msite_flag  VARCHAR2
268     , x_msite_name  VARCHAR2
269     , x_msite_description  VARCHAR2
270     , x_resp_access_flag  VARCHAR2
271     , x_party_access_code  VARCHAR2
272     , x_access_name  VARCHAR2
273     , x_url  VARCHAR2
274     , x_theme_id  NUMBER
275   );
276 end jtf_msite_grp_w;