[Home] [Help]
PACKAGE: APPS.JTF_PERZ_QUERY_PUB_W
Source
1 package jtf_perz_query_pub_w AUTHID CURRENT_USER as
2 /* $Header: jtfzwpqs.pls 120.2 2005/11/02 23:49:08 skothe ship $ */
3 procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_parameter_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_300
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_NUMBER_TABLE
10 );
11 procedure rosetta_table_copy_out_p1(t jtf_perz_query_pub.query_parameter_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
12 , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
13 , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
14 , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
15 , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
16 , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
17 , a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
18 );
19
20 procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_out_tbl_type, a0 JTF_NUMBER_TABLE
21 , a1 JTF_NUMBER_TABLE
22 , a2 JTF_NUMBER_TABLE
23 , a3 JTF_VARCHAR2_TABLE_100
24 , a4 JTF_VARCHAR2_TABLE_100
25 , a5 JTF_VARCHAR2_TABLE_300
26 , a6 JTF_VARCHAR2_TABLE_2000
27 );
28 procedure rosetta_table_copy_out_p4(t jtf_perz_query_pub.query_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
29 , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
30 , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
31 , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
32 , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
33 , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
34 , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
35 );
36
37 procedure rosetta_table_copy_in_p6(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_order_by_tbl_type, a0 JTF_NUMBER_TABLE
38 , a1 JTF_NUMBER_TABLE
39 , a2 JTF_VARCHAR2_TABLE_100
40 , a3 JTF_VARCHAR2_TABLE_100
41 , a4 JTF_NUMBER_TABLE
42 );
43 procedure rosetta_table_copy_out_p6(t jtf_perz_query_pub.query_order_by_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
44 , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
45 , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
46 , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
47 , a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
48 );
49
50 procedure save_perz_query(p_api_version_number NUMBER
51 , p_init_msg_list VARCHAR2
52 , p_commit VARCHAR2
53 , p_application_id NUMBER
54 , p_profile_id NUMBER
55 , p_profile_name VARCHAR2
56 , p_profile_type VARCHAR2
57 , p7_a0 JTF_NUMBER_TABLE
58 , p7_a1 JTF_NUMBER_TABLE
59 , p7_a2 JTF_VARCHAR2_TABLE_100
60 , p7_a3 JTF_VARCHAR2_TABLE_100
61 , p7_a4 JTF_VARCHAR2_TABLE_100
62 , p_query_id NUMBER
63 , p_query_name VARCHAR2
64 , p_query_type VARCHAR2
65 , p_query_desc VARCHAR2
66 , p_query_data_source VARCHAR2
67 , p13_a0 JTF_NUMBER_TABLE
68 , p13_a1 JTF_NUMBER_TABLE
69 , p13_a2 JTF_VARCHAR2_TABLE_100
70 , p13_a3 JTF_VARCHAR2_TABLE_100
71 , p13_a4 JTF_VARCHAR2_TABLE_300
72 , p13_a5 JTF_VARCHAR2_TABLE_100
73 , p13_a6 JTF_NUMBER_TABLE
74 , p14_a0 JTF_NUMBER_TABLE
75 , p14_a1 JTF_NUMBER_TABLE
76 , p14_a2 JTF_VARCHAR2_TABLE_100
77 , p14_a3 JTF_VARCHAR2_TABLE_100
78 , p14_a4 JTF_NUMBER_TABLE
79 , p15_a0 NUMBER
80 , p15_a1 NUMBER
81 , p15_a2 VARCHAR2
82 , p15_a3 VARCHAR2
83 , p15_a4 VARCHAR2
84 , p15_a5 VARCHAR2
85 , p15_a6 VARCHAR2
86 , p15_a7 VARCHAR2
87 , x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER
88 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
89 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
90 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
91 );
92 procedure create_perz_query(p_api_version_number NUMBER
93 , p_init_msg_list VARCHAR2
94 , p_commit VARCHAR2
95 , p_application_id NUMBER
96 , p_profile_id NUMBER
97 , p_profile_name VARCHAR2
98 , p_query_id NUMBER
99 , p_query_name VARCHAR2
100 , p_query_type VARCHAR2
101 , p_query_desc VARCHAR2
102 , p_query_data_source VARCHAR2
103 , p11_a0 JTF_NUMBER_TABLE
104 , p11_a1 JTF_NUMBER_TABLE
105 , p11_a2 JTF_VARCHAR2_TABLE_100
106 , p11_a3 JTF_VARCHAR2_TABLE_100
107 , p11_a4 JTF_VARCHAR2_TABLE_300
108 , p11_a5 JTF_VARCHAR2_TABLE_100
109 , p11_a6 JTF_NUMBER_TABLE
110 , p12_a0 JTF_NUMBER_TABLE
111 , p12_a1 JTF_NUMBER_TABLE
112 , p12_a2 JTF_VARCHAR2_TABLE_100
113 , p12_a3 JTF_VARCHAR2_TABLE_100
114 , p12_a4 JTF_NUMBER_TABLE
115 , p13_a0 NUMBER
116 , p13_a1 NUMBER
117 , p13_a2 VARCHAR2
118 , p13_a3 VARCHAR2
119 , p13_a4 VARCHAR2
120 , p13_a5 VARCHAR2
121 , p13_a6 VARCHAR2
122 , p13_a7 VARCHAR2
123 , x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER
124 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
125 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
126 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
127 );
128 procedure get_perz_query(p_api_version_number NUMBER
129 , p_init_msg_list VARCHAR2
130 , p_application_id NUMBER
131 , p_profile_id NUMBER
132 , p_profile_name VARCHAR2
133 , p_query_id NUMBER
134 , p_query_name VARCHAR2
135 , p_query_type VARCHAR2
136 , x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER
137 , x_query_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
138 , x_query_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
139 , x_query_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2
140 , x_query_data_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2
141 , p13_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
142 , p13_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
143 , p13_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
144 , p13_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
145 , p13_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
146 , p13_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
147 , p13_a6 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
148 , p14_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
149 , p14_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
150 , p14_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
151 , p14_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
152 , p14_a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
153 , p15_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
154 , p15_a1 OUT NOCOPY /* file.sql.39 change */ NUMBER
155 , p15_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
156 , p15_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
157 , p15_a4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158 , p15_a5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
159 , p15_a6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
160 , p15_a7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
161 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
162 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
163 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
164 );
165 procedure get_perz_query_summary(p_api_version_number NUMBER
166 , p_init_msg_list VARCHAR2
167 , p_application_id NUMBER
168 , p_profile_id NUMBER
169 , p_profile_name VARCHAR2
170 , p_query_id NUMBER
171 , p_query_name VARCHAR2
172 , p_query_type VARCHAR2
173 , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
174 , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
175 , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
176 , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
177 , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
178 , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
179 , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_2000
180 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
181 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
182 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
183 );
184 procedure update_perz_query(p_api_version_number NUMBER
185 , p_init_msg_list VARCHAR2
186 , p_commit VARCHAR2
187 , p_application_id NUMBER
188 , p_profile_id NUMBER
189 , p_query_id NUMBER
190 , p_query_name VARCHAR2
191 , p_query_type VARCHAR2
192 , p_query_desc VARCHAR2
193 , p_query_data_source VARCHAR2
194 , p10_a0 JTF_NUMBER_TABLE
195 , p10_a1 JTF_NUMBER_TABLE
196 , p10_a2 JTF_VARCHAR2_TABLE_100
197 , p10_a3 JTF_VARCHAR2_TABLE_100
198 , p10_a4 JTF_VARCHAR2_TABLE_300
199 , p10_a5 JTF_VARCHAR2_TABLE_100
200 , p10_a6 JTF_NUMBER_TABLE
201 , p11_a0 JTF_NUMBER_TABLE
202 , p11_a1 JTF_NUMBER_TABLE
203 , p11_a2 JTF_VARCHAR2_TABLE_100
204 , p11_a3 JTF_VARCHAR2_TABLE_100
205 , p11_a4 JTF_NUMBER_TABLE
206 , p12_a0 NUMBER
207 , p12_a1 NUMBER
208 , p12_a2 VARCHAR2
209 , p12_a3 VARCHAR2
210 , p12_a4 VARCHAR2
211 , p12_a5 VARCHAR2
212 , p12_a6 VARCHAR2
213 , p12_a7 VARCHAR2
214 , x_query_id OUT NOCOPY /* file.sql.39 change */ NUMBER
215 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
216 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
217 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
218 );
219 end jtf_perz_query_pub_w;