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
8: , a5 JTF_VARCHAR2_TABLE_100
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
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
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
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: );
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
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
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
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
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
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: );
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
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
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
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
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
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: );
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);
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);
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
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
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
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
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
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
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
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: );
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
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