1: package cac_view_pvt_w as
2: /* $Header: cacvpws.pls 120.3 2006/02/22 07:16:45 sankgupt noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cac_view_pvt.callsttbltype, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400
6: , a3 JTF_VARCHAR2_TABLE_100
7: );
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400
6: , a3 JTF_VARCHAR2_TABLE_100
7: );
8: procedure rosetta_table_copy_out_p1(t cac_view_pvt.callsttbltype, a0 out nocopy JTF_NUMBER_TABLE
9: , a1 out nocopy JTF_VARCHAR2_TABLE_100
10: , a2 out nocopy JTF_VARCHAR2_TABLE_400
11: , a3 out nocopy JTF_VARCHAR2_TABLE_100
12: );
10: , a2 out nocopy JTF_VARCHAR2_TABLE_400
11: , a3 out nocopy JTF_VARCHAR2_TABLE_100
12: );
13:
14: procedure rosetta_table_copy_in_p4(t out nocopy cac_view_pvt.queryouttab, a0 JTF_NUMBER_TABLE
15: , a1 JTF_NUMBER_TABLE
16: , a2 JTF_VARCHAR2_TABLE_100
17: , a3 JTF_VARCHAR2_TABLE_2000
18: , a4 JTF_VARCHAR2_TABLE_2000
11: , a3 out nocopy JTF_VARCHAR2_TABLE_100
12: );
13:
14: procedure rosetta_table_copy_in_p4(t out nocopy cac_view_pvt.queryouttab, a0 JTF_NUMBER_TABLE
15: , a1 JTF_NUMBER_TABLE
16: , a2 JTF_VARCHAR2_TABLE_100
17: , a3 JTF_VARCHAR2_TABLE_2000
18: , a4 JTF_VARCHAR2_TABLE_2000
19: , a5 JTF_VARCHAR2_TABLE_100
16: , a2 JTF_VARCHAR2_TABLE_100
17: , a3 JTF_VARCHAR2_TABLE_2000
18: , a4 JTF_VARCHAR2_TABLE_2000
19: , a5 JTF_VARCHAR2_TABLE_100
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_NUMBER_TABLE
22: , a8 JTF_NUMBER_TABLE
23: , a9 JTF_NUMBER_TABLE
24: , a10 JTF_NUMBER_TABLE
17: , a3 JTF_VARCHAR2_TABLE_2000
18: , a4 JTF_VARCHAR2_TABLE_2000
19: , a5 JTF_VARCHAR2_TABLE_100
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_NUMBER_TABLE
22: , a8 JTF_NUMBER_TABLE
23: , a9 JTF_NUMBER_TABLE
24: , a10 JTF_NUMBER_TABLE
25: , a11 JTF_DATE_TABLE
18: , a4 JTF_VARCHAR2_TABLE_2000
19: , a5 JTF_VARCHAR2_TABLE_100
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_NUMBER_TABLE
22: , a8 JTF_NUMBER_TABLE
23: , a9 JTF_NUMBER_TABLE
24: , a10 JTF_NUMBER_TABLE
25: , a11 JTF_DATE_TABLE
26: , a12 JTF_VARCHAR2_TABLE_100
19: , a5 JTF_VARCHAR2_TABLE_100
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_NUMBER_TABLE
22: , a8 JTF_NUMBER_TABLE
23: , a9 JTF_NUMBER_TABLE
24: , a10 JTF_NUMBER_TABLE
25: , a11 JTF_DATE_TABLE
26: , a12 JTF_VARCHAR2_TABLE_100
27: , a13 JTF_DATE_TABLE
20: , a6 JTF_NUMBER_TABLE
21: , a7 JTF_NUMBER_TABLE
22: , a8 JTF_NUMBER_TABLE
23: , a9 JTF_NUMBER_TABLE
24: , a10 JTF_NUMBER_TABLE
25: , a11 JTF_DATE_TABLE
26: , a12 JTF_VARCHAR2_TABLE_100
27: , a13 JTF_DATE_TABLE
28: , a14 JTF_VARCHAR2_TABLE_2000
35: , a21 JTF_VARCHAR2_TABLE_100
36: , a22 JTF_VARCHAR2_TABLE_100
37: , a23 JTF_VARCHAR2_TABLE_400
38: , a24 JTF_VARCHAR2_TABLE_4000
39: , a25 JTF_NUMBER_TABLE
40: , a26 JTF_VARCHAR2_TABLE_100
41: , a27 JTF_VARCHAR2_TABLE_100
42: );
43: procedure rosetta_table_copy_out_p4(t cac_view_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
39: , a25 JTF_NUMBER_TABLE
40: , a26 JTF_VARCHAR2_TABLE_100
41: , a27 JTF_VARCHAR2_TABLE_100
42: );
43: procedure rosetta_table_copy_out_p4(t cac_view_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
44: , a1 out nocopy JTF_NUMBER_TABLE
45: , a2 out nocopy JTF_VARCHAR2_TABLE_100
46: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
40: , a26 JTF_VARCHAR2_TABLE_100
41: , a27 JTF_VARCHAR2_TABLE_100
42: );
43: procedure rosetta_table_copy_out_p4(t cac_view_pvt.queryouttab, a0 out nocopy JTF_NUMBER_TABLE
44: , a1 out nocopy JTF_NUMBER_TABLE
45: , a2 out nocopy JTF_VARCHAR2_TABLE_100
46: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
48: , a5 out nocopy JTF_VARCHAR2_TABLE_100
45: , a2 out nocopy JTF_VARCHAR2_TABLE_100
46: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
48: , a5 out nocopy JTF_VARCHAR2_TABLE_100
49: , a6 out nocopy JTF_NUMBER_TABLE
50: , a7 out nocopy JTF_NUMBER_TABLE
51: , a8 out nocopy JTF_NUMBER_TABLE
52: , a9 out nocopy JTF_NUMBER_TABLE
53: , a10 out nocopy JTF_NUMBER_TABLE
46: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
48: , a5 out nocopy JTF_VARCHAR2_TABLE_100
49: , a6 out nocopy JTF_NUMBER_TABLE
50: , a7 out nocopy JTF_NUMBER_TABLE
51: , a8 out nocopy JTF_NUMBER_TABLE
52: , a9 out nocopy JTF_NUMBER_TABLE
53: , a10 out nocopy JTF_NUMBER_TABLE
54: , a11 out nocopy JTF_DATE_TABLE
47: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
48: , a5 out nocopy JTF_VARCHAR2_TABLE_100
49: , a6 out nocopy JTF_NUMBER_TABLE
50: , a7 out nocopy JTF_NUMBER_TABLE
51: , a8 out nocopy JTF_NUMBER_TABLE
52: , a9 out nocopy JTF_NUMBER_TABLE
53: , a10 out nocopy JTF_NUMBER_TABLE
54: , a11 out nocopy JTF_DATE_TABLE
55: , a12 out nocopy JTF_VARCHAR2_TABLE_100
48: , a5 out nocopy JTF_VARCHAR2_TABLE_100
49: , a6 out nocopy JTF_NUMBER_TABLE
50: , a7 out nocopy JTF_NUMBER_TABLE
51: , a8 out nocopy JTF_NUMBER_TABLE
52: , a9 out nocopy JTF_NUMBER_TABLE
53: , a10 out nocopy JTF_NUMBER_TABLE
54: , a11 out nocopy JTF_DATE_TABLE
55: , a12 out nocopy JTF_VARCHAR2_TABLE_100
56: , a13 out nocopy JTF_DATE_TABLE
49: , a6 out nocopy JTF_NUMBER_TABLE
50: , a7 out nocopy JTF_NUMBER_TABLE
51: , a8 out nocopy JTF_NUMBER_TABLE
52: , a9 out nocopy JTF_NUMBER_TABLE
53: , a10 out nocopy JTF_NUMBER_TABLE
54: , a11 out nocopy JTF_DATE_TABLE
55: , a12 out nocopy JTF_VARCHAR2_TABLE_100
56: , a13 out nocopy JTF_DATE_TABLE
57: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
64: , a21 out nocopy JTF_VARCHAR2_TABLE_100
65: , a22 out nocopy JTF_VARCHAR2_TABLE_100
66: , a23 out nocopy JTF_VARCHAR2_TABLE_400
67: , a24 out nocopy JTF_VARCHAR2_TABLE_4000
68: , a25 out nocopy JTF_NUMBER_TABLE
69: , a26 out nocopy JTF_VARCHAR2_TABLE_100
70: , a27 out nocopy JTF_VARCHAR2_TABLE_100
71: );
72:
78: , x_msg_data out nocopy VARCHAR2
79: , p_resourceid in out nocopy NUMBER
80: , p_resourcetype in out nocopy VARCHAR2
81: , p_userid NUMBER
82: , p9_a0 out nocopy JTF_NUMBER_TABLE
83: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
84: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_400
85: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
86: );
123: , p6_a30 CHAR
124: , p6_a31 CHAR
125: , p6_a32 CHAR
126: , p6_a33 NUMBER
127: , p7_a0 out nocopy JTF_NUMBER_TABLE
128: , p7_a1 out nocopy JTF_NUMBER_TABLE
129: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
130: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_2000
131: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_2000
124: , p6_a31 CHAR
125: , p6_a32 CHAR
126: , p6_a33 NUMBER
127: , p7_a0 out nocopy JTF_NUMBER_TABLE
128: , p7_a1 out nocopy JTF_NUMBER_TABLE
129: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
130: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_2000
131: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_2000
132: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
129: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
130: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_2000
131: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_2000
132: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
133: , p7_a6 out nocopy JTF_NUMBER_TABLE
134: , p7_a7 out nocopy JTF_NUMBER_TABLE
135: , p7_a8 out nocopy JTF_NUMBER_TABLE
136: , p7_a9 out nocopy JTF_NUMBER_TABLE
137: , p7_a10 out nocopy JTF_NUMBER_TABLE
130: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_2000
131: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_2000
132: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
133: , p7_a6 out nocopy JTF_NUMBER_TABLE
134: , p7_a7 out nocopy JTF_NUMBER_TABLE
135: , p7_a8 out nocopy JTF_NUMBER_TABLE
136: , p7_a9 out nocopy JTF_NUMBER_TABLE
137: , p7_a10 out nocopy JTF_NUMBER_TABLE
138: , p7_a11 out nocopy JTF_DATE_TABLE
131: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_2000
132: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
133: , p7_a6 out nocopy JTF_NUMBER_TABLE
134: , p7_a7 out nocopy JTF_NUMBER_TABLE
135: , p7_a8 out nocopy JTF_NUMBER_TABLE
136: , p7_a9 out nocopy JTF_NUMBER_TABLE
137: , p7_a10 out nocopy JTF_NUMBER_TABLE
138: , p7_a11 out nocopy JTF_DATE_TABLE
139: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
132: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
133: , p7_a6 out nocopy JTF_NUMBER_TABLE
134: , p7_a7 out nocopy JTF_NUMBER_TABLE
135: , p7_a8 out nocopy JTF_NUMBER_TABLE
136: , p7_a9 out nocopy JTF_NUMBER_TABLE
137: , p7_a10 out nocopy JTF_NUMBER_TABLE
138: , p7_a11 out nocopy JTF_DATE_TABLE
139: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
140: , p7_a13 out nocopy JTF_DATE_TABLE
133: , p7_a6 out nocopy JTF_NUMBER_TABLE
134: , p7_a7 out nocopy JTF_NUMBER_TABLE
135: , p7_a8 out nocopy JTF_NUMBER_TABLE
136: , p7_a9 out nocopy JTF_NUMBER_TABLE
137: , p7_a10 out nocopy JTF_NUMBER_TABLE
138: , p7_a11 out nocopy JTF_DATE_TABLE
139: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
140: , p7_a13 out nocopy JTF_DATE_TABLE
141: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
148: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
149: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
150: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_400
151: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_4000
152: , p7_a25 out nocopy JTF_NUMBER_TABLE
153: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
154: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
155: );
156: end cac_view_pvt_w;