[Home] [Help]
PACKAGE: APPS.OKL_PROCESS_TRX_TYPES_PVT_W
Source
1 package okl_process_trx_types_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLETXTS.pls 120.2 2005/07/12 09:12:19 dkagrawa noship $ */
3 procedure insert_trx_types(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , x_return_status out nocopy VARCHAR2
6 , x_msg_count out nocopy NUMBER
7 , x_msg_data out nocopy VARCHAR2
8 , p6_a0 out nocopy NUMBER
9 , p6_a1 out nocopy NUMBER
10 , p6_a2 out nocopy VARCHAR2
11 , p6_a3 out nocopy VARCHAR2
12 , p6_a4 out nocopy NUMBER
13 , p6_a5 out nocopy NUMBER
14 , p6_a6 out nocopy NUMBER
15 , p6_a7 out nocopy VARCHAR2
16 , p6_a8 out nocopy VARCHAR2
17 , p6_a9 out nocopy VARCHAR2
18 , p6_a10 out nocopy VARCHAR2
19 , p6_a11 out nocopy VARCHAR2
20 , p6_a12 out nocopy NUMBER
21 , p6_a13 out nocopy NUMBER
22 , p6_a14 out nocopy DATE
23 , p6_a15 out nocopy NUMBER
24 , p6_a16 out nocopy DATE
25 , p6_a17 out nocopy NUMBER
26 , p6_a18 out nocopy VARCHAR2
27 , p6_a19 out nocopy VARCHAR2
28 , p6_a20 out nocopy VARCHAR2
29 , p6_a21 out nocopy VARCHAR2
30 , p5_a0 NUMBER := 0-1962.0724
31 , p5_a1 NUMBER := 0-1962.0724
32 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
33 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
34 , p5_a4 NUMBER := 0-1962.0724
35 , p5_a5 NUMBER := 0-1962.0724
36 , p5_a6 NUMBER := 0-1962.0724
37 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
38 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
39 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
40 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
41 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
42 , p5_a12 NUMBER := 0-1962.0724
43 , p5_a13 NUMBER := 0-1962.0724
44 , p5_a14 DATE := fnd_api.g_miss_date
45 , p5_a15 NUMBER := 0-1962.0724
46 , p5_a16 DATE := fnd_api.g_miss_date
47 , p5_a17 NUMBER := 0-1962.0724
48 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
49 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
50 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
51 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
52 );
53 procedure insert_trx_types(p_api_version NUMBER
54 , p_init_msg_list VARCHAR2
55 , x_return_status out nocopy VARCHAR2
56 , x_msg_count out nocopy NUMBER
57 , x_msg_data out nocopy VARCHAR2
58 , p5_a0 JTF_NUMBER_TABLE
59 , p5_a1 JTF_NUMBER_TABLE
60 , p5_a2 JTF_VARCHAR2_TABLE_100
61 , p5_a3 JTF_VARCHAR2_TABLE_100
62 , p5_a4 JTF_NUMBER_TABLE
63 , p5_a5 JTF_NUMBER_TABLE
64 , p5_a6 JTF_NUMBER_TABLE
65 , p5_a7 JTF_VARCHAR2_TABLE_100
66 , p5_a8 JTF_VARCHAR2_TABLE_200
67 , p5_a9 JTF_VARCHAR2_TABLE_2000
68 , p5_a10 JTF_VARCHAR2_TABLE_100
69 , p5_a11 JTF_VARCHAR2_TABLE_100
70 , p5_a12 JTF_NUMBER_TABLE
71 , p5_a13 JTF_NUMBER_TABLE
72 , p5_a14 JTF_DATE_TABLE
73 , p5_a15 JTF_NUMBER_TABLE
74 , p5_a16 JTF_DATE_TABLE
75 , p5_a17 JTF_NUMBER_TABLE
76 , p5_a18 JTF_VARCHAR2_TABLE_100
77 , p5_a19 JTF_VARCHAR2_TABLE_100
78 , p5_a20 JTF_VARCHAR2_TABLE_100
79 , p5_a21 JTF_VARCHAR2_TABLE_100
80 , p6_a0 out nocopy JTF_NUMBER_TABLE
81 , p6_a1 out nocopy JTF_NUMBER_TABLE
82 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
83 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
84 , p6_a4 out nocopy JTF_NUMBER_TABLE
85 , p6_a5 out nocopy JTF_NUMBER_TABLE
86 , p6_a6 out nocopy JTF_NUMBER_TABLE
87 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
88 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
89 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
90 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
91 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
92 , p6_a12 out nocopy JTF_NUMBER_TABLE
93 , p6_a13 out nocopy JTF_NUMBER_TABLE
94 , p6_a14 out nocopy JTF_DATE_TABLE
95 , p6_a15 out nocopy JTF_NUMBER_TABLE
96 , p6_a16 out nocopy JTF_DATE_TABLE
97 , p6_a17 out nocopy JTF_NUMBER_TABLE
98 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
99 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
100 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
101 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
102 );
103 procedure update_trx_types(p_api_version NUMBER
104 , p_init_msg_list VARCHAR2
105 , x_return_status out nocopy VARCHAR2
106 , x_msg_count out nocopy NUMBER
107 , x_msg_data out nocopy VARCHAR2
108 , p6_a0 out nocopy NUMBER
109 , p6_a1 out nocopy NUMBER
110 , p6_a2 out nocopy VARCHAR2
111 , p6_a3 out nocopy VARCHAR2
112 , p6_a4 out nocopy NUMBER
113 , p6_a5 out nocopy NUMBER
114 , p6_a6 out nocopy NUMBER
115 , p6_a7 out nocopy VARCHAR2
116 , p6_a8 out nocopy VARCHAR2
117 , p6_a9 out nocopy VARCHAR2
118 , p6_a10 out nocopy VARCHAR2
119 , p6_a11 out nocopy VARCHAR2
120 , p6_a12 out nocopy NUMBER
121 , p6_a13 out nocopy NUMBER
122 , p6_a14 out nocopy DATE
123 , p6_a15 out nocopy NUMBER
124 , p6_a16 out nocopy DATE
125 , p6_a17 out nocopy NUMBER
126 , p6_a18 out nocopy VARCHAR2
127 , p6_a19 out nocopy VARCHAR2
128 , p6_a20 out nocopy VARCHAR2
129 , p6_a21 out nocopy VARCHAR2
130 , p5_a0 NUMBER := 0-1962.0724
131 , p5_a1 NUMBER := 0-1962.0724
132 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
133 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
134 , p5_a4 NUMBER := 0-1962.0724
135 , p5_a5 NUMBER := 0-1962.0724
136 , p5_a6 NUMBER := 0-1962.0724
137 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
138 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
139 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
140 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
141 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
142 , p5_a12 NUMBER := 0-1962.0724
143 , p5_a13 NUMBER := 0-1962.0724
144 , p5_a14 DATE := fnd_api.g_miss_date
145 , p5_a15 NUMBER := 0-1962.0724
146 , p5_a16 DATE := fnd_api.g_miss_date
147 , p5_a17 NUMBER := 0-1962.0724
148 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
149 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
150 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
151 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
152 );
153 procedure update_trx_types(p_api_version NUMBER
154 , p_init_msg_list VARCHAR2
155 , x_return_status out nocopy VARCHAR2
156 , x_msg_count out nocopy NUMBER
157 , x_msg_data out nocopy VARCHAR2
158 , p5_a0 JTF_NUMBER_TABLE
159 , p5_a1 JTF_NUMBER_TABLE
160 , p5_a2 JTF_VARCHAR2_TABLE_100
161 , p5_a3 JTF_VARCHAR2_TABLE_100
162 , p5_a4 JTF_NUMBER_TABLE
163 , p5_a5 JTF_NUMBER_TABLE
164 , p5_a6 JTF_NUMBER_TABLE
165 , p5_a7 JTF_VARCHAR2_TABLE_100
166 , p5_a8 JTF_VARCHAR2_TABLE_200
167 , p5_a9 JTF_VARCHAR2_TABLE_2000
168 , p5_a10 JTF_VARCHAR2_TABLE_100
169 , p5_a11 JTF_VARCHAR2_TABLE_100
170 , p5_a12 JTF_NUMBER_TABLE
171 , p5_a13 JTF_NUMBER_TABLE
172 , p5_a14 JTF_DATE_TABLE
173 , p5_a15 JTF_NUMBER_TABLE
174 , p5_a16 JTF_DATE_TABLE
175 , p5_a17 JTF_NUMBER_TABLE
176 , p5_a18 JTF_VARCHAR2_TABLE_100
177 , p5_a19 JTF_VARCHAR2_TABLE_100
178 , p5_a20 JTF_VARCHAR2_TABLE_100
179 , p5_a21 JTF_VARCHAR2_TABLE_100
180 , p6_a0 out nocopy JTF_NUMBER_TABLE
181 , p6_a1 out nocopy JTF_NUMBER_TABLE
182 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
183 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
184 , p6_a4 out nocopy JTF_NUMBER_TABLE
185 , p6_a5 out nocopy JTF_NUMBER_TABLE
186 , p6_a6 out nocopy JTF_NUMBER_TABLE
187 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
188 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
189 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
190 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
191 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
192 , p6_a12 out nocopy JTF_NUMBER_TABLE
193 , p6_a13 out nocopy JTF_NUMBER_TABLE
194 , p6_a14 out nocopy JTF_DATE_TABLE
195 , p6_a15 out nocopy JTF_NUMBER_TABLE
196 , p6_a16 out nocopy JTF_DATE_TABLE
197 , p6_a17 out nocopy JTF_NUMBER_TABLE
198 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
199 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
200 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
201 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
202 );
203 procedure delete_trx_types(p_api_version NUMBER
204 , p_init_msg_list VARCHAR2
205 , x_return_status out nocopy VARCHAR2
206 , x_msg_count out nocopy NUMBER
207 , x_msg_data out nocopy VARCHAR2
208 , p5_a0 NUMBER := 0-1962.0724
209 , p5_a1 NUMBER := 0-1962.0724
210 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
211 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
212 , p5_a4 NUMBER := 0-1962.0724
213 , p5_a5 NUMBER := 0-1962.0724
214 , p5_a6 NUMBER := 0-1962.0724
215 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
216 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
217 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
218 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
219 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
220 , p5_a12 NUMBER := 0-1962.0724
221 , p5_a13 NUMBER := 0-1962.0724
222 , p5_a14 DATE := fnd_api.g_miss_date
223 , p5_a15 NUMBER := 0-1962.0724
224 , p5_a16 DATE := fnd_api.g_miss_date
225 , p5_a17 NUMBER := 0-1962.0724
226 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
227 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
228 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
229 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
230 );
231 procedure delete_trx_types(p_api_version NUMBER
232 , p_init_msg_list VARCHAR2
233 , x_return_status out nocopy VARCHAR2
234 , x_msg_count out nocopy NUMBER
235 , x_msg_data out nocopy VARCHAR2
236 , p5_a0 JTF_NUMBER_TABLE
237 , p5_a1 JTF_NUMBER_TABLE
238 , p5_a2 JTF_VARCHAR2_TABLE_100
239 , p5_a3 JTF_VARCHAR2_TABLE_100
240 , p5_a4 JTF_NUMBER_TABLE
241 , p5_a5 JTF_NUMBER_TABLE
242 , p5_a6 JTF_NUMBER_TABLE
243 , p5_a7 JTF_VARCHAR2_TABLE_100
244 , p5_a8 JTF_VARCHAR2_TABLE_200
245 , p5_a9 JTF_VARCHAR2_TABLE_2000
246 , p5_a10 JTF_VARCHAR2_TABLE_100
247 , p5_a11 JTF_VARCHAR2_TABLE_100
248 , p5_a12 JTF_NUMBER_TABLE
249 , p5_a13 JTF_NUMBER_TABLE
250 , p5_a14 JTF_DATE_TABLE
251 , p5_a15 JTF_NUMBER_TABLE
252 , p5_a16 JTF_DATE_TABLE
253 , p5_a17 JTF_NUMBER_TABLE
254 , p5_a18 JTF_VARCHAR2_TABLE_100
255 , p5_a19 JTF_VARCHAR2_TABLE_100
256 , p5_a20 JTF_VARCHAR2_TABLE_100
257 , p5_a21 JTF_VARCHAR2_TABLE_100
258 );
259 end okl_process_trx_types_pvt_w;