2: /* $Header: pvxwptas.pls 120.1 2005/08/10 01:45 appldev ship $ */
3: procedure rosetta_table_copy_in_p15(t out nocopy pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_400
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p15(t out nocopy pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_400
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_500
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_500
17: , a14 JTF_VARCHAR2_TABLE_100
18: );
19: procedure rosetta_table_copy_out_p15(t pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_500
17: , a14 JTF_VARCHAR2_TABLE_100
18: );
19: procedure rosetta_table_copy_out_p15(t pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
20: , a1 out nocopy JTF_NUMBER_TABLE
21: , a2 out nocopy JTF_NUMBER_TABLE
18: );
19: procedure rosetta_table_copy_out_p15(t pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
20: , a1 out nocopy JTF_NUMBER_TABLE
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_VARCHAR2_TABLE_100
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100
24: , a5 out nocopy JTF_VARCHAR2_TABLE_100
25: , a6 out nocopy JTF_VARCHAR2_TABLE_100
26: , a7 out nocopy JTF_VARCHAR2_TABLE_100
19: procedure rosetta_table_copy_out_p15(t pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
20: , a1 out nocopy JTF_NUMBER_TABLE
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_VARCHAR2_TABLE_100
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100
24: , a5 out nocopy JTF_VARCHAR2_TABLE_100
25: , a6 out nocopy JTF_VARCHAR2_TABLE_100
26: , a7 out nocopy JTF_VARCHAR2_TABLE_100
27: , a8 out nocopy JTF_VARCHAR2_TABLE_100
20: , a1 out nocopy JTF_NUMBER_TABLE
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_VARCHAR2_TABLE_100
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100
24: , a5 out nocopy JTF_VARCHAR2_TABLE_100
25: , a6 out nocopy JTF_VARCHAR2_TABLE_100
26: , a7 out nocopy JTF_VARCHAR2_TABLE_100
27: , a8 out nocopy JTF_VARCHAR2_TABLE_100
28: , a9 out nocopy JTF_VARCHAR2_TABLE_100
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_VARCHAR2_TABLE_100
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100
24: , a5 out nocopy JTF_VARCHAR2_TABLE_100
25: , a6 out nocopy JTF_VARCHAR2_TABLE_100
26: , a7 out nocopy JTF_VARCHAR2_TABLE_100
27: , a8 out nocopy JTF_VARCHAR2_TABLE_100
28: , a9 out nocopy JTF_VARCHAR2_TABLE_100
29: , a10 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_VARCHAR2_TABLE_100
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100
24: , a5 out nocopy JTF_VARCHAR2_TABLE_100
25: , a6 out nocopy JTF_VARCHAR2_TABLE_100
26: , a7 out nocopy JTF_VARCHAR2_TABLE_100
27: , a8 out nocopy JTF_VARCHAR2_TABLE_100
28: , a9 out nocopy JTF_VARCHAR2_TABLE_100
29: , a10 out nocopy JTF_NUMBER_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100
24: , a5 out nocopy JTF_VARCHAR2_TABLE_100
25: , a6 out nocopy JTF_VARCHAR2_TABLE_100
26: , a7 out nocopy JTF_VARCHAR2_TABLE_100
27: , a8 out nocopy JTF_VARCHAR2_TABLE_100
28: , a9 out nocopy JTF_VARCHAR2_TABLE_100
29: , a10 out nocopy JTF_NUMBER_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_VARCHAR2_TABLE_100
24: , a5 out nocopy JTF_VARCHAR2_TABLE_100
25: , a6 out nocopy JTF_VARCHAR2_TABLE_100
26: , a7 out nocopy JTF_VARCHAR2_TABLE_100
27: , a8 out nocopy JTF_VARCHAR2_TABLE_100
28: , a9 out nocopy JTF_VARCHAR2_TABLE_100
29: , a10 out nocopy JTF_NUMBER_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_VARCHAR2_TABLE_100
32: , a13 out nocopy JTF_VARCHAR2_TABLE_500
27: , a8 out nocopy JTF_VARCHAR2_TABLE_100
28: , a9 out nocopy JTF_VARCHAR2_TABLE_100
29: , a10 out nocopy JTF_NUMBER_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_VARCHAR2_TABLE_100
32: , a13 out nocopy JTF_VARCHAR2_TABLE_500
33: , a14 out nocopy JTF_VARCHAR2_TABLE_100
34: );
35:
29: , a10 out nocopy JTF_NUMBER_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_VARCHAR2_TABLE_100
32: , a13 out nocopy JTF_VARCHAR2_TABLE_500
33: , a14 out nocopy JTF_VARCHAR2_TABLE_100
34: );
35:
36: procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
37: , a1 JTF_VARCHAR2_TABLE_100
32: , a13 out nocopy JTF_VARCHAR2_TABLE_500
33: , a14 out nocopy JTF_VARCHAR2_TABLE_100
34: );
35:
36: procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
37: , a1 JTF_VARCHAR2_TABLE_100
38: , a2 JTF_VARCHAR2_TABLE_100
39: , a3 JTF_VARCHAR2_TABLE_100
40: , a4 JTF_VARCHAR2_TABLE_100
33: , a14 out nocopy JTF_VARCHAR2_TABLE_100
34: );
35:
36: procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
37: , a1 JTF_VARCHAR2_TABLE_100
38: , a2 JTF_VARCHAR2_TABLE_100
39: , a3 JTF_VARCHAR2_TABLE_100
40: , a4 JTF_VARCHAR2_TABLE_100
41: , a5 JTF_VARCHAR2_TABLE_100
34: );
35:
36: procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
37: , a1 JTF_VARCHAR2_TABLE_100
38: , a2 JTF_VARCHAR2_TABLE_100
39: , a3 JTF_VARCHAR2_TABLE_100
40: , a4 JTF_VARCHAR2_TABLE_100
41: , a5 JTF_VARCHAR2_TABLE_100
42: , a6 JTF_VARCHAR2_TABLE_100
35:
36: procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
37: , a1 JTF_VARCHAR2_TABLE_100
38: , a2 JTF_VARCHAR2_TABLE_100
39: , a3 JTF_VARCHAR2_TABLE_100
40: , a4 JTF_VARCHAR2_TABLE_100
41: , a5 JTF_VARCHAR2_TABLE_100
42: , a6 JTF_VARCHAR2_TABLE_100
43: , a7 JTF_VARCHAR2_TABLE_100
36: procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
37: , a1 JTF_VARCHAR2_TABLE_100
38: , a2 JTF_VARCHAR2_TABLE_100
39: , a3 JTF_VARCHAR2_TABLE_100
40: , a4 JTF_VARCHAR2_TABLE_100
41: , a5 JTF_VARCHAR2_TABLE_100
42: , a6 JTF_VARCHAR2_TABLE_100
43: , a7 JTF_VARCHAR2_TABLE_100
44: , a8 JTF_VARCHAR2_TABLE_100
37: , a1 JTF_VARCHAR2_TABLE_100
38: , a2 JTF_VARCHAR2_TABLE_100
39: , a3 JTF_VARCHAR2_TABLE_100
40: , a4 JTF_VARCHAR2_TABLE_100
41: , a5 JTF_VARCHAR2_TABLE_100
42: , a6 JTF_VARCHAR2_TABLE_100
43: , a7 JTF_VARCHAR2_TABLE_100
44: , a8 JTF_VARCHAR2_TABLE_100
45: , a9 JTF_VARCHAR2_TABLE_100
38: , a2 JTF_VARCHAR2_TABLE_100
39: , a3 JTF_VARCHAR2_TABLE_100
40: , a4 JTF_VARCHAR2_TABLE_100
41: , a5 JTF_VARCHAR2_TABLE_100
42: , a6 JTF_VARCHAR2_TABLE_100
43: , a7 JTF_VARCHAR2_TABLE_100
44: , a8 JTF_VARCHAR2_TABLE_100
45: , a9 JTF_VARCHAR2_TABLE_100
46: , a10 JTF_VARCHAR2_TABLE_100
39: , a3 JTF_VARCHAR2_TABLE_100
40: , a4 JTF_VARCHAR2_TABLE_100
41: , a5 JTF_VARCHAR2_TABLE_100
42: , a6 JTF_VARCHAR2_TABLE_100
43: , a7 JTF_VARCHAR2_TABLE_100
44: , a8 JTF_VARCHAR2_TABLE_100
45: , a9 JTF_VARCHAR2_TABLE_100
46: , a10 JTF_VARCHAR2_TABLE_100
47: , a11 JTF_VARCHAR2_TABLE_100
40: , a4 JTF_VARCHAR2_TABLE_100
41: , a5 JTF_VARCHAR2_TABLE_100
42: , a6 JTF_VARCHAR2_TABLE_100
43: , a7 JTF_VARCHAR2_TABLE_100
44: , a8 JTF_VARCHAR2_TABLE_100
45: , a9 JTF_VARCHAR2_TABLE_100
46: , a10 JTF_VARCHAR2_TABLE_100
47: , a11 JTF_VARCHAR2_TABLE_100
48: , a12 JTF_VARCHAR2_TABLE_100
41: , a5 JTF_VARCHAR2_TABLE_100
42: , a6 JTF_VARCHAR2_TABLE_100
43: , a7 JTF_VARCHAR2_TABLE_100
44: , a8 JTF_VARCHAR2_TABLE_100
45: , a9 JTF_VARCHAR2_TABLE_100
46: , a10 JTF_VARCHAR2_TABLE_100
47: , a11 JTF_VARCHAR2_TABLE_100
48: , a12 JTF_VARCHAR2_TABLE_100
49: , a13 JTF_VARCHAR2_TABLE_100
42: , a6 JTF_VARCHAR2_TABLE_100
43: , a7 JTF_VARCHAR2_TABLE_100
44: , a8 JTF_VARCHAR2_TABLE_100
45: , a9 JTF_VARCHAR2_TABLE_100
46: , a10 JTF_VARCHAR2_TABLE_100
47: , a11 JTF_VARCHAR2_TABLE_100
48: , a12 JTF_VARCHAR2_TABLE_100
49: , a13 JTF_VARCHAR2_TABLE_100
50: );
43: , a7 JTF_VARCHAR2_TABLE_100
44: , a8 JTF_VARCHAR2_TABLE_100
45: , a9 JTF_VARCHAR2_TABLE_100
46: , a10 JTF_VARCHAR2_TABLE_100
47: , a11 JTF_VARCHAR2_TABLE_100
48: , a12 JTF_VARCHAR2_TABLE_100
49: , a13 JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
44: , a8 JTF_VARCHAR2_TABLE_100
45: , a9 JTF_VARCHAR2_TABLE_100
46: , a10 JTF_VARCHAR2_TABLE_100
47: , a11 JTF_VARCHAR2_TABLE_100
48: , a12 JTF_VARCHAR2_TABLE_100
49: , a13 JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
45: , a9 JTF_VARCHAR2_TABLE_100
46: , a10 JTF_VARCHAR2_TABLE_100
47: , a11 JTF_VARCHAR2_TABLE_100
48: , a12 JTF_VARCHAR2_TABLE_100
49: , a13 JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a11 JTF_VARCHAR2_TABLE_100
48: , a12 JTF_VARCHAR2_TABLE_100
49: , a13 JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
48: , a12 JTF_VARCHAR2_TABLE_100
49: , a13 JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
49: , a13 JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , a6 out nocopy JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , a6 out nocopy JTF_VARCHAR2_TABLE_100
58: , a7 out nocopy JTF_VARCHAR2_TABLE_100
51: procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , a6 out nocopy JTF_VARCHAR2_TABLE_100
58: , a7 out nocopy JTF_VARCHAR2_TABLE_100
59: , a8 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , a6 out nocopy JTF_VARCHAR2_TABLE_100
58: , a7 out nocopy JTF_VARCHAR2_TABLE_100
59: , a8 out nocopy JTF_VARCHAR2_TABLE_100
60: , a9 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , a6 out nocopy JTF_VARCHAR2_TABLE_100
58: , a7 out nocopy JTF_VARCHAR2_TABLE_100
59: , a8 out nocopy JTF_VARCHAR2_TABLE_100
60: , a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , a10 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , a6 out nocopy JTF_VARCHAR2_TABLE_100
58: , a7 out nocopy JTF_VARCHAR2_TABLE_100
59: , a8 out nocopy JTF_VARCHAR2_TABLE_100
60: , a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , a10 out nocopy JTF_VARCHAR2_TABLE_100
62: , a11 out nocopy JTF_VARCHAR2_TABLE_100
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , a6 out nocopy JTF_VARCHAR2_TABLE_100
58: , a7 out nocopy JTF_VARCHAR2_TABLE_100
59: , a8 out nocopy JTF_VARCHAR2_TABLE_100
60: , a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , a10 out nocopy JTF_VARCHAR2_TABLE_100
62: , a11 out nocopy JTF_VARCHAR2_TABLE_100
63: , a12 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , a6 out nocopy JTF_VARCHAR2_TABLE_100
58: , a7 out nocopy JTF_VARCHAR2_TABLE_100
59: , a8 out nocopy JTF_VARCHAR2_TABLE_100
60: , a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , a10 out nocopy JTF_VARCHAR2_TABLE_100
62: , a11 out nocopy JTF_VARCHAR2_TABLE_100
63: , a12 out nocopy JTF_VARCHAR2_TABLE_100
64: , a13 out nocopy JTF_VARCHAR2_TABLE_100
57: , a6 out nocopy JTF_VARCHAR2_TABLE_100
58: , a7 out nocopy JTF_VARCHAR2_TABLE_100
59: , a8 out nocopy JTF_VARCHAR2_TABLE_100
60: , a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , a10 out nocopy JTF_VARCHAR2_TABLE_100
62: , a11 out nocopy JTF_VARCHAR2_TABLE_100
63: , a12 out nocopy JTF_VARCHAR2_TABLE_100
64: , a13 out nocopy JTF_VARCHAR2_TABLE_100
65: );
58: , a7 out nocopy JTF_VARCHAR2_TABLE_100
59: , a8 out nocopy JTF_VARCHAR2_TABLE_100
60: , a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , a10 out nocopy JTF_VARCHAR2_TABLE_100
62: , a11 out nocopy JTF_VARCHAR2_TABLE_100
63: , a12 out nocopy JTF_VARCHAR2_TABLE_100
64: , a13 out nocopy JTF_VARCHAR2_TABLE_100
65: );
66:
59: , a8 out nocopy JTF_VARCHAR2_TABLE_100
60: , a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , a10 out nocopy JTF_VARCHAR2_TABLE_100
62: , a11 out nocopy JTF_VARCHAR2_TABLE_100
63: , a12 out nocopy JTF_VARCHAR2_TABLE_100
64: , a13 out nocopy JTF_VARCHAR2_TABLE_100
65: );
66:
67: procedure rosetta_table_copy_in_p22(t out nocopy pv_terr_assign_pub.resourcelist, a0 JTF_NUMBER_TABLE);
60: , a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , a10 out nocopy JTF_VARCHAR2_TABLE_100
62: , a11 out nocopy JTF_VARCHAR2_TABLE_100
63: , a12 out nocopy JTF_VARCHAR2_TABLE_100
64: , a13 out nocopy JTF_VARCHAR2_TABLE_100
65: );
66:
67: procedure rosetta_table_copy_in_p22(t out nocopy pv_terr_assign_pub.resourcelist, a0 JTF_NUMBER_TABLE);
68: procedure rosetta_table_copy_out_p22(t pv_terr_assign_pub.resourcelist, a0 out nocopy JTF_NUMBER_TABLE);
69:
70: procedure rosetta_table_copy_in_p23(t out nocopy pv_terr_assign_pub.personlist, a0 JTF_NUMBER_TABLE);
71: procedure rosetta_table_copy_out_p23(t pv_terr_assign_pub.personlist, a0 out nocopy JTF_NUMBER_TABLE);
72:
73: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100);
74: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100);
75:
76: procedure rosetta_table_copy_in_p25(t out nocopy pv_terr_assign_pub.grouplist, a0 JTF_NUMBER_TABLE);
77: procedure rosetta_table_copy_out_p25(t pv_terr_assign_pub.grouplist, a0 out nocopy JTF_NUMBER_TABLE);
70: procedure rosetta_table_copy_in_p23(t out nocopy pv_terr_assign_pub.personlist, a0 JTF_NUMBER_TABLE);
71: procedure rosetta_table_copy_out_p23(t pv_terr_assign_pub.personlist, a0 out nocopy JTF_NUMBER_TABLE);
72:
73: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100);
74: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100);
75:
76: procedure rosetta_table_copy_in_p25(t out nocopy pv_terr_assign_pub.grouplist, a0 JTF_NUMBER_TABLE);
77: procedure rosetta_table_copy_out_p25(t pv_terr_assign_pub.grouplist, a0 out nocopy JTF_NUMBER_TABLE);
78:
84: procedure get_res_from_team_group(p_resource_id NUMBER
85: , p_resource_type VARCHAR2
86: , p2_a0 out nocopy JTF_NUMBER_TABLE
87: , p2_a1 out nocopy JTF_NUMBER_TABLE
88: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
89: , p2_a3 out nocopy JTF_NUMBER_TABLE
90: );
91: procedure get_partner_details(p_party_id NUMBER
92: , x_return_status out nocopy VARCHAR2
94: , x_msg_data out nocopy VARCHAR2
95: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_400
96: , p4_a1 out nocopy JTF_NUMBER_TABLE
97: , p4_a2 out nocopy JTF_NUMBER_TABLE
98: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
99: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
100: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
101: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
102: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
95: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_400
96: , p4_a1 out nocopy JTF_NUMBER_TABLE
97: , p4_a2 out nocopy JTF_NUMBER_TABLE
98: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
99: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
100: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
101: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
102: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
103: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
96: , p4_a1 out nocopy JTF_NUMBER_TABLE
97: , p4_a2 out nocopy JTF_NUMBER_TABLE
98: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
99: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
100: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
101: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
102: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
103: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
104: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
97: , p4_a2 out nocopy JTF_NUMBER_TABLE
98: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
99: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
100: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
101: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
102: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
103: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
104: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
105: , p4_a10 out nocopy JTF_NUMBER_TABLE
98: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
99: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
100: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
101: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
102: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
103: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
104: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
105: , p4_a10 out nocopy JTF_NUMBER_TABLE
106: , p4_a11 out nocopy JTF_NUMBER_TABLE
99: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
100: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
101: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
102: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
103: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
104: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
105: , p4_a10 out nocopy JTF_NUMBER_TABLE
106: , p4_a11 out nocopy JTF_NUMBER_TABLE
107: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
100: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
101: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
102: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
103: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
104: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
105: , p4_a10 out nocopy JTF_NUMBER_TABLE
106: , p4_a11 out nocopy JTF_NUMBER_TABLE
107: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
108: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_500
103: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
104: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
105: , p4_a10 out nocopy JTF_NUMBER_TABLE
106: , p4_a11 out nocopy JTF_NUMBER_TABLE
107: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
108: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_500
109: , p4_a14 out nocopy JTF_VARCHAR2_TABLE_100
110: );
111: procedure create_channel_team(p_api_version_number NUMBER
105: , p4_a10 out nocopy JTF_NUMBER_TABLE
106: , p4_a11 out nocopy JTF_NUMBER_TABLE
107: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
108: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_500
109: , p4_a14 out nocopy JTF_VARCHAR2_TABLE_100
110: );
111: procedure create_channel_team(p_api_version_number NUMBER
112: , p_init_msg_list VARCHAR2
113: , p_commit VARCHAR2
131: , p_login_user NUMBER
132: , p8_a0 JTF_VARCHAR2_TABLE_400
133: , p8_a1 JTF_NUMBER_TABLE
134: , p8_a2 JTF_NUMBER_TABLE
135: , p8_a3 JTF_VARCHAR2_TABLE_100
136: , p8_a4 JTF_VARCHAR2_TABLE_100
137: , p8_a5 JTF_VARCHAR2_TABLE_100
138: , p8_a6 JTF_VARCHAR2_TABLE_100
139: , p8_a7 JTF_VARCHAR2_TABLE_100
132: , p8_a0 JTF_VARCHAR2_TABLE_400
133: , p8_a1 JTF_NUMBER_TABLE
134: , p8_a2 JTF_NUMBER_TABLE
135: , p8_a3 JTF_VARCHAR2_TABLE_100
136: , p8_a4 JTF_VARCHAR2_TABLE_100
137: , p8_a5 JTF_VARCHAR2_TABLE_100
138: , p8_a6 JTF_VARCHAR2_TABLE_100
139: , p8_a7 JTF_VARCHAR2_TABLE_100
140: , p8_a8 JTF_VARCHAR2_TABLE_100
133: , p8_a1 JTF_NUMBER_TABLE
134: , p8_a2 JTF_NUMBER_TABLE
135: , p8_a3 JTF_VARCHAR2_TABLE_100
136: , p8_a4 JTF_VARCHAR2_TABLE_100
137: , p8_a5 JTF_VARCHAR2_TABLE_100
138: , p8_a6 JTF_VARCHAR2_TABLE_100
139: , p8_a7 JTF_VARCHAR2_TABLE_100
140: , p8_a8 JTF_VARCHAR2_TABLE_100
141: , p8_a9 JTF_VARCHAR2_TABLE_100
134: , p8_a2 JTF_NUMBER_TABLE
135: , p8_a3 JTF_VARCHAR2_TABLE_100
136: , p8_a4 JTF_VARCHAR2_TABLE_100
137: , p8_a5 JTF_VARCHAR2_TABLE_100
138: , p8_a6 JTF_VARCHAR2_TABLE_100
139: , p8_a7 JTF_VARCHAR2_TABLE_100
140: , p8_a8 JTF_VARCHAR2_TABLE_100
141: , p8_a9 JTF_VARCHAR2_TABLE_100
142: , p8_a10 JTF_NUMBER_TABLE
135: , p8_a3 JTF_VARCHAR2_TABLE_100
136: , p8_a4 JTF_VARCHAR2_TABLE_100
137: , p8_a5 JTF_VARCHAR2_TABLE_100
138: , p8_a6 JTF_VARCHAR2_TABLE_100
139: , p8_a7 JTF_VARCHAR2_TABLE_100
140: , p8_a8 JTF_VARCHAR2_TABLE_100
141: , p8_a9 JTF_VARCHAR2_TABLE_100
142: , p8_a10 JTF_NUMBER_TABLE
143: , p8_a11 JTF_NUMBER_TABLE
136: , p8_a4 JTF_VARCHAR2_TABLE_100
137: , p8_a5 JTF_VARCHAR2_TABLE_100
138: , p8_a6 JTF_VARCHAR2_TABLE_100
139: , p8_a7 JTF_VARCHAR2_TABLE_100
140: , p8_a8 JTF_VARCHAR2_TABLE_100
141: , p8_a9 JTF_VARCHAR2_TABLE_100
142: , p8_a10 JTF_NUMBER_TABLE
143: , p8_a11 JTF_NUMBER_TABLE
144: , p8_a12 JTF_VARCHAR2_TABLE_100
137: , p8_a5 JTF_VARCHAR2_TABLE_100
138: , p8_a6 JTF_VARCHAR2_TABLE_100
139: , p8_a7 JTF_VARCHAR2_TABLE_100
140: , p8_a8 JTF_VARCHAR2_TABLE_100
141: , p8_a9 JTF_VARCHAR2_TABLE_100
142: , p8_a10 JTF_NUMBER_TABLE
143: , p8_a11 JTF_NUMBER_TABLE
144: , p8_a12 JTF_VARCHAR2_TABLE_100
145: , p8_a13 JTF_VARCHAR2_TABLE_500
140: , p8_a8 JTF_VARCHAR2_TABLE_100
141: , p8_a9 JTF_VARCHAR2_TABLE_100
142: , p8_a10 JTF_NUMBER_TABLE
143: , p8_a11 JTF_NUMBER_TABLE
144: , p8_a12 JTF_VARCHAR2_TABLE_100
145: , p8_a13 JTF_VARCHAR2_TABLE_500
146: , p8_a14 JTF_VARCHAR2_TABLE_100
147: , x_return_status out nocopy VARCHAR2
148: , x_msg_count out nocopy NUMBER
142: , p8_a10 JTF_NUMBER_TABLE
143: , p8_a11 JTF_NUMBER_TABLE
144: , p8_a12 JTF_VARCHAR2_TABLE_100
145: , p8_a13 JTF_VARCHAR2_TABLE_500
146: , p8_a14 JTF_VARCHAR2_TABLE_100
147: , x_return_status out nocopy VARCHAR2
148: , x_msg_count out nocopy NUMBER
149: , x_msg_data out nocopy VARCHAR2
150: , p12_a0 out nocopy JTF_NUMBER_TABLE
175: , p_login_user NUMBER
176: , p11_a0 JTF_VARCHAR2_TABLE_400
177: , p11_a1 JTF_NUMBER_TABLE
178: , p11_a2 JTF_NUMBER_TABLE
179: , p11_a3 JTF_VARCHAR2_TABLE_100
180: , p11_a4 JTF_VARCHAR2_TABLE_100
181: , p11_a5 JTF_VARCHAR2_TABLE_100
182: , p11_a6 JTF_VARCHAR2_TABLE_100
183: , p11_a7 JTF_VARCHAR2_TABLE_100
176: , p11_a0 JTF_VARCHAR2_TABLE_400
177: , p11_a1 JTF_NUMBER_TABLE
178: , p11_a2 JTF_NUMBER_TABLE
179: , p11_a3 JTF_VARCHAR2_TABLE_100
180: , p11_a4 JTF_VARCHAR2_TABLE_100
181: , p11_a5 JTF_VARCHAR2_TABLE_100
182: , p11_a6 JTF_VARCHAR2_TABLE_100
183: , p11_a7 JTF_VARCHAR2_TABLE_100
184: , p11_a8 JTF_VARCHAR2_TABLE_100
177: , p11_a1 JTF_NUMBER_TABLE
178: , p11_a2 JTF_NUMBER_TABLE
179: , p11_a3 JTF_VARCHAR2_TABLE_100
180: , p11_a4 JTF_VARCHAR2_TABLE_100
181: , p11_a5 JTF_VARCHAR2_TABLE_100
182: , p11_a6 JTF_VARCHAR2_TABLE_100
183: , p11_a7 JTF_VARCHAR2_TABLE_100
184: , p11_a8 JTF_VARCHAR2_TABLE_100
185: , p11_a9 JTF_VARCHAR2_TABLE_100
178: , p11_a2 JTF_NUMBER_TABLE
179: , p11_a3 JTF_VARCHAR2_TABLE_100
180: , p11_a4 JTF_VARCHAR2_TABLE_100
181: , p11_a5 JTF_VARCHAR2_TABLE_100
182: , p11_a6 JTF_VARCHAR2_TABLE_100
183: , p11_a7 JTF_VARCHAR2_TABLE_100
184: , p11_a8 JTF_VARCHAR2_TABLE_100
185: , p11_a9 JTF_VARCHAR2_TABLE_100
186: , p11_a10 JTF_NUMBER_TABLE
179: , p11_a3 JTF_VARCHAR2_TABLE_100
180: , p11_a4 JTF_VARCHAR2_TABLE_100
181: , p11_a5 JTF_VARCHAR2_TABLE_100
182: , p11_a6 JTF_VARCHAR2_TABLE_100
183: , p11_a7 JTF_VARCHAR2_TABLE_100
184: , p11_a8 JTF_VARCHAR2_TABLE_100
185: , p11_a9 JTF_VARCHAR2_TABLE_100
186: , p11_a10 JTF_NUMBER_TABLE
187: , p11_a11 JTF_NUMBER_TABLE
180: , p11_a4 JTF_VARCHAR2_TABLE_100
181: , p11_a5 JTF_VARCHAR2_TABLE_100
182: , p11_a6 JTF_VARCHAR2_TABLE_100
183: , p11_a7 JTF_VARCHAR2_TABLE_100
184: , p11_a8 JTF_VARCHAR2_TABLE_100
185: , p11_a9 JTF_VARCHAR2_TABLE_100
186: , p11_a10 JTF_NUMBER_TABLE
187: , p11_a11 JTF_NUMBER_TABLE
188: , p11_a12 JTF_VARCHAR2_TABLE_100
181: , p11_a5 JTF_VARCHAR2_TABLE_100
182: , p11_a6 JTF_VARCHAR2_TABLE_100
183: , p11_a7 JTF_VARCHAR2_TABLE_100
184: , p11_a8 JTF_VARCHAR2_TABLE_100
185: , p11_a9 JTF_VARCHAR2_TABLE_100
186: , p11_a10 JTF_NUMBER_TABLE
187: , p11_a11 JTF_NUMBER_TABLE
188: , p11_a12 JTF_VARCHAR2_TABLE_100
189: , p11_a13 JTF_VARCHAR2_TABLE_500
184: , p11_a8 JTF_VARCHAR2_TABLE_100
185: , p11_a9 JTF_VARCHAR2_TABLE_100
186: , p11_a10 JTF_NUMBER_TABLE
187: , p11_a11 JTF_NUMBER_TABLE
188: , p11_a12 JTF_VARCHAR2_TABLE_100
189: , p11_a13 JTF_VARCHAR2_TABLE_500
190: , p11_a14 JTF_VARCHAR2_TABLE_100
191: , p12_a0 out nocopy JTF_NUMBER_TABLE
192: );
186: , p11_a10 JTF_NUMBER_TABLE
187: , p11_a11 JTF_NUMBER_TABLE
188: , p11_a12 JTF_VARCHAR2_TABLE_100
189: , p11_a13 JTF_VARCHAR2_TABLE_500
190: , p11_a14 JTF_VARCHAR2_TABLE_100
191: , p12_a0 out nocopy JTF_NUMBER_TABLE
192: );
193: procedure create_vad_channel_team(p_api_version_number NUMBER
194: , p_init_msg_list VARCHAR2