1: package ibe_msite_grp_w 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
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
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
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:
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
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
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
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:
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
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
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: );
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
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
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
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
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
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