[Home] [Help]
PACKAGE: APPS.OKL_RULE_EXTRACT_PVT_W
Source
1 package okl_rule_extract_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLEREXS.pls 115.7 2003/10/14 18:32:17 ashariff noship $ */
3 procedure rosetta_table_copy_in_p22(t out nocopy okl_rule_extract_pvt.rule_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_100
6 );
7 procedure rosetta_table_copy_out_p22(t okl_rule_extract_pvt.rule_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
8 , a1 out nocopy JTF_VARCHAR2_TABLE_100
9 , a2 out nocopy JTF_VARCHAR2_TABLE_100
10 );
11
12 procedure rosetta_table_copy_in_p24(t out nocopy okl_rule_extract_pvt.sc_rg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
13 , a1 JTF_VARCHAR2_TABLE_100
14 , a2 JTF_VARCHAR2_TABLE_100
15 , a3 JTF_VARCHAR2_TABLE_300
16 );
17 procedure rosetta_table_copy_out_p24(t okl_rule_extract_pvt.sc_rg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
18 , a1 out nocopy JTF_VARCHAR2_TABLE_100
19 , a2 out nocopy JTF_VARCHAR2_TABLE_100
20 , a3 out nocopy JTF_VARCHAR2_TABLE_300
21 );
22
23 procedure rosetta_table_copy_in_p26(t out nocopy okl_rule_extract_pvt.rg_rules_tbl_type, a0 JTF_VARCHAR2_TABLE_100
24 , a1 JTF_VARCHAR2_TABLE_100
25 , a2 JTF_VARCHAR2_TABLE_100
26 , a3 JTF_VARCHAR2_TABLE_100
27 , a4 JTF_VARCHAR2_TABLE_100
28 , a5 JTF_VARCHAR2_TABLE_100
29 , a6 JTF_VARCHAR2_TABLE_100
30 );
31 procedure rosetta_table_copy_out_p26(t okl_rule_extract_pvt.rg_rules_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
32 , a1 out nocopy JTF_VARCHAR2_TABLE_100
33 , a2 out nocopy JTF_VARCHAR2_TABLE_100
34 , a3 out nocopy JTF_VARCHAR2_TABLE_100
35 , a4 out nocopy JTF_VARCHAR2_TABLE_100
36 , a5 out nocopy JTF_VARCHAR2_TABLE_100
37 , a6 out nocopy JTF_VARCHAR2_TABLE_100
38 );
39
40 procedure rosetta_table_copy_in_p28(t out nocopy okl_rule_extract_pvt.rule_segment_tbl_type, a0 JTF_VARCHAR2_TABLE_100
41 , a1 JTF_VARCHAR2_TABLE_100
42 , a2 JTF_VARCHAR2_TABLE_100
43 , a3 JTF_VARCHAR2_TABLE_100
44 , a4 JTF_VARCHAR2_TABLE_100
45 , a5 JTF_VARCHAR2_TABLE_100
46 , a6 JTF_VARCHAR2_TABLE_100
47 , a7 JTF_VARCHAR2_TABLE_100
48 , a8 JTF_VARCHAR2_TABLE_100
49 , a9 JTF_VARCHAR2_TABLE_100
50 , a10 JTF_VARCHAR2_TABLE_2000
51 , a11 JTF_VARCHAR2_TABLE_2000
52 , a12 JTF_VARCHAR2_TABLE_2000
53 , a13 JTF_VARCHAR2_TABLE_2000
54 , a14 JTF_VARCHAR2_TABLE_100
55 , a15 JTF_VARCHAR2_TABLE_100
56 , a16 JTF_VARCHAR2_TABLE_100
57 , a17 JTF_VARCHAR2_TABLE_100
58 , a18 JTF_VARCHAR2_TABLE_100
59 , a19 JTF_VARCHAR2_TABLE_100
60 , a20 JTF_VARCHAR2_TABLE_100
61 , a21 JTF_VARCHAR2_TABLE_100
62 , a22 JTF_VARCHAR2_TABLE_300
63 );
64 procedure rosetta_table_copy_out_p28(t okl_rule_extract_pvt.rule_segment_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
65 , a1 out nocopy JTF_VARCHAR2_TABLE_100
66 , a2 out nocopy JTF_VARCHAR2_TABLE_100
67 , a3 out nocopy JTF_VARCHAR2_TABLE_100
68 , a4 out nocopy JTF_VARCHAR2_TABLE_100
69 , a5 out nocopy JTF_VARCHAR2_TABLE_100
70 , a6 out nocopy JTF_VARCHAR2_TABLE_100
71 , a7 out nocopy JTF_VARCHAR2_TABLE_100
72 , a8 out nocopy JTF_VARCHAR2_TABLE_100
73 , a9 out nocopy JTF_VARCHAR2_TABLE_100
74 , a10 out nocopy JTF_VARCHAR2_TABLE_2000
75 , a11 out nocopy JTF_VARCHAR2_TABLE_2000
76 , a12 out nocopy JTF_VARCHAR2_TABLE_2000
77 , a13 out nocopy JTF_VARCHAR2_TABLE_2000
78 , a14 out nocopy JTF_VARCHAR2_TABLE_100
79 , a15 out nocopy JTF_VARCHAR2_TABLE_100
80 , a16 out nocopy JTF_VARCHAR2_TABLE_100
81 , a17 out nocopy JTF_VARCHAR2_TABLE_100
82 , a18 out nocopy JTF_VARCHAR2_TABLE_100
83 , a19 out nocopy JTF_VARCHAR2_TABLE_100
84 , a20 out nocopy JTF_VARCHAR2_TABLE_100
85 , a21 out nocopy JTF_VARCHAR2_TABLE_100
86 , a22 out nocopy JTF_VARCHAR2_TABLE_300
87 );
88
89 procedure rosetta_table_copy_in_p30(t out nocopy okl_rule_extract_pvt.rule_segment_tbl_type2, a0 JTF_VARCHAR2_TABLE_100
90 , a1 JTF_VARCHAR2_TABLE_100
91 , a2 JTF_VARCHAR2_TABLE_100
92 , a3 JTF_VARCHAR2_TABLE_100
93 , a4 JTF_VARCHAR2_TABLE_100
94 , a5 JTF_VARCHAR2_TABLE_100
95 , a6 JTF_VARCHAR2_TABLE_100
96 , a7 JTF_VARCHAR2_TABLE_100
97 , a8 JTF_VARCHAR2_TABLE_100
98 , a9 JTF_VARCHAR2_TABLE_100
99 , a10 JTF_VARCHAR2_TABLE_2000
100 , a11 JTF_VARCHAR2_TABLE_2000
101 , a12 JTF_VARCHAR2_TABLE_2000
102 , a13 JTF_VARCHAR2_TABLE_2000
103 , a14 JTF_VARCHAR2_TABLE_100
104 , a15 JTF_VARCHAR2_TABLE_100
105 , a16 JTF_VARCHAR2_TABLE_100
106 , a17 JTF_VARCHAR2_TABLE_100
107 , a18 JTF_VARCHAR2_TABLE_100
108 , a19 JTF_VARCHAR2_TABLE_100
109 , a20 JTF_VARCHAR2_TABLE_100
110 , a21 JTF_VARCHAR2_TABLE_100
111 , a22 JTF_VARCHAR2_TABLE_300
112 , a23 JTF_VARCHAR2_TABLE_300
113 , a24 JTF_VARCHAR2_TABLE_300
114 , a25 JTF_VARCHAR2_TABLE_1000
115 , a26 JTF_VARCHAR2_TABLE_1000
116 , a27 JTF_VARCHAR2_TABLE_100
117 );
118 procedure rosetta_table_copy_out_p30(t okl_rule_extract_pvt.rule_segment_tbl_type2, a0 out nocopy JTF_VARCHAR2_TABLE_100
119 , a1 out nocopy JTF_VARCHAR2_TABLE_100
120 , a2 out nocopy JTF_VARCHAR2_TABLE_100
121 , a3 out nocopy JTF_VARCHAR2_TABLE_100
122 , a4 out nocopy JTF_VARCHAR2_TABLE_100
123 , a5 out nocopy JTF_VARCHAR2_TABLE_100
124 , a6 out nocopy JTF_VARCHAR2_TABLE_100
125 , a7 out nocopy JTF_VARCHAR2_TABLE_100
126 , a8 out nocopy JTF_VARCHAR2_TABLE_100
127 , a9 out nocopy JTF_VARCHAR2_TABLE_100
128 , a10 out nocopy JTF_VARCHAR2_TABLE_2000
129 , a11 out nocopy JTF_VARCHAR2_TABLE_2000
130 , a12 out nocopy JTF_VARCHAR2_TABLE_2000
131 , a13 out nocopy JTF_VARCHAR2_TABLE_2000
132 , a14 out nocopy JTF_VARCHAR2_TABLE_100
133 , a15 out nocopy JTF_VARCHAR2_TABLE_100
134 , a16 out nocopy JTF_VARCHAR2_TABLE_100
135 , a17 out nocopy JTF_VARCHAR2_TABLE_100
136 , a18 out nocopy JTF_VARCHAR2_TABLE_100
137 , a19 out nocopy JTF_VARCHAR2_TABLE_100
138 , a20 out nocopy JTF_VARCHAR2_TABLE_100
139 , a21 out nocopy JTF_VARCHAR2_TABLE_100
140 , a22 out nocopy JTF_VARCHAR2_TABLE_300
141 , a23 out nocopy JTF_VARCHAR2_TABLE_300
142 , a24 out nocopy JTF_VARCHAR2_TABLE_300
143 , a25 out nocopy JTF_VARCHAR2_TABLE_1000
144 , a26 out nocopy JTF_VARCHAR2_TABLE_1000
145 , a27 out nocopy JTF_VARCHAR2_TABLE_100
146 );
147
148 procedure get_subclass_rgs(p_api_version NUMBER
149 , p_init_msg_list VARCHAR2
150 , x_return_status out nocopy VARCHAR2
151 , x_msg_count out nocopy NUMBER
152 , x_msg_data out nocopy VARCHAR2
153 , p_chr_id VARCHAR2
154 , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
155 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
156 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
157 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
158 );
159 procedure get_rg_rules(p_api_version NUMBER
160 , p_init_msg_list VARCHAR2
161 , x_return_status out nocopy VARCHAR2
162 , x_msg_count out nocopy NUMBER
163 , x_msg_data out nocopy VARCHAR2
164 , p_rgd_code VARCHAR2
165 , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
166 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
167 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
168 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
169 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
170 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
171 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
172 );
173 procedure get_rule_def(p_api_version NUMBER
174 , p_init_msg_list VARCHAR2
175 , x_return_status out nocopy VARCHAR2
176 , x_msg_count out nocopy NUMBER
177 , x_msg_data out nocopy VARCHAR2
178 , p_rgd_code VARCHAR2
179 , p_rgs_code VARCHAR2
180 , p_buy_or_sell VARCHAR2
181 , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
182 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
183 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
184 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
185 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
186 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
187 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
188 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
189 , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
190 , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
191 , p8_a10 out nocopy JTF_VARCHAR2_TABLE_2000
192 , p8_a11 out nocopy JTF_VARCHAR2_TABLE_2000
193 , p8_a12 out nocopy JTF_VARCHAR2_TABLE_2000
194 , p8_a13 out nocopy JTF_VARCHAR2_TABLE_2000
195 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
196 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
197 , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
198 , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
199 , p8_a18 out nocopy JTF_VARCHAR2_TABLE_100
200 , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
201 , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
202 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
203 , p8_a22 out nocopy JTF_VARCHAR2_TABLE_300
204 );
205 procedure get_rules_metadata(p_api_version NUMBER
206 , p_init_msg_list VARCHAR2
207 , x_return_status out nocopy VARCHAR2
208 , x_msg_count out nocopy NUMBER
209 , x_msg_data out nocopy VARCHAR2
210 , p_rgd_code VARCHAR2
211 , p_rgs_code VARCHAR2
212 , p_buy_or_sell VARCHAR2
213 , p_contract_id NUMBER
214 , p_line_id NUMBER
215 , p_party_id NUMBER
216 , p_template_table VARCHAR2
217 , p_rule_id_column VARCHAR2
218 , p_entity_column VARCHAR2
219 , p14_a0 out nocopy JTF_VARCHAR2_TABLE_100
220 , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
221 , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
222 , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
223 , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
224 , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
225 , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
226 , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100
227 , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100
228 , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
229 , p14_a10 out nocopy JTF_VARCHAR2_TABLE_2000
230 , p14_a11 out nocopy JTF_VARCHAR2_TABLE_2000
231 , p14_a12 out nocopy JTF_VARCHAR2_TABLE_2000
232 , p14_a13 out nocopy JTF_VARCHAR2_TABLE_2000
233 , p14_a14 out nocopy JTF_VARCHAR2_TABLE_100
234 , p14_a15 out nocopy JTF_VARCHAR2_TABLE_100
235 , p14_a16 out nocopy JTF_VARCHAR2_TABLE_100
236 , p14_a17 out nocopy JTF_VARCHAR2_TABLE_100
237 , p14_a18 out nocopy JTF_VARCHAR2_TABLE_100
238 , p14_a19 out nocopy JTF_VARCHAR2_TABLE_100
239 , p14_a20 out nocopy JTF_VARCHAR2_TABLE_100
240 , p14_a21 out nocopy JTF_VARCHAR2_TABLE_100
241 , p14_a22 out nocopy JTF_VARCHAR2_TABLE_300
242 , p14_a23 out nocopy JTF_VARCHAR2_TABLE_300
243 , p14_a24 out nocopy JTF_VARCHAR2_TABLE_300
244 , p14_a25 out nocopy JTF_VARCHAR2_TABLE_1000
245 , p14_a26 out nocopy JTF_VARCHAR2_TABLE_1000
246 , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100
247 );
248 end okl_rule_extract_pvt_w;