[Home] [Help]
PACKAGE: APPS.OKL_AGC_PVT_W
Source
1 package okl_agc_pvt_w as
2 /* $Header: OKLIAGCS.pls 120.1 2005/07/07 13:33:14 dkagrawa noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy okl_agc_pvt.agc_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_DATE_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_DATE_TABLE
13 , a10 JTF_NUMBER_TABLE
14 );
15 procedure rosetta_table_copy_out_p2(t okl_agc_pvt.agc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16 , a1 out nocopy JTF_NUMBER_TABLE
17 , a2 out nocopy JTF_VARCHAR2_TABLE_100
18 , a3 out nocopy JTF_NUMBER_TABLE
19 , a4 out nocopy JTF_NUMBER_TABLE
20 , a5 out nocopy JTF_NUMBER_TABLE
21 , a6 out nocopy JTF_NUMBER_TABLE
22 , a7 out nocopy JTF_DATE_TABLE
23 , a8 out nocopy JTF_NUMBER_TABLE
24 , a9 out nocopy JTF_DATE_TABLE
25 , a10 out nocopy JTF_NUMBER_TABLE
26 );
27
28 procedure rosetta_table_copy_in_p5(t out nocopy okl_agc_pvt.agcv_tbl_type, a0 JTF_NUMBER_TABLE
29 , a1 JTF_NUMBER_TABLE
30 , a2 JTF_NUMBER_TABLE
31 , a3 JTF_VARCHAR2_TABLE_100
32 , a4 JTF_NUMBER_TABLE
33 , a5 JTF_NUMBER_TABLE
34 , a6 JTF_NUMBER_TABLE
35 , a7 JTF_DATE_TABLE
36 , a8 JTF_NUMBER_TABLE
37 , a9 JTF_DATE_TABLE
38 , a10 JTF_NUMBER_TABLE
39 );
40 procedure rosetta_table_copy_out_p5(t okl_agc_pvt.agcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41 , a1 out nocopy JTF_NUMBER_TABLE
42 , a2 out nocopy JTF_NUMBER_TABLE
43 , a3 out nocopy JTF_VARCHAR2_TABLE_100
44 , a4 out nocopy JTF_NUMBER_TABLE
45 , a5 out nocopy JTF_NUMBER_TABLE
46 , a6 out nocopy JTF_NUMBER_TABLE
47 , a7 out nocopy JTF_DATE_TABLE
48 , a8 out nocopy JTF_NUMBER_TABLE
49 , a9 out nocopy JTF_DATE_TABLE
50 , a10 out nocopy JTF_NUMBER_TABLE
51 );
52
53 procedure insert_row(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 , p6_a0 out nocopy NUMBER
59 , p6_a1 out nocopy NUMBER
60 , p6_a2 out nocopy NUMBER
61 , p6_a3 out nocopy VARCHAR2
62 , p6_a4 out nocopy NUMBER
63 , p6_a5 out nocopy NUMBER
64 , p6_a6 out nocopy NUMBER
65 , p6_a7 out nocopy DATE
66 , p6_a8 out nocopy NUMBER
67 , p6_a9 out nocopy DATE
68 , p6_a10 out nocopy NUMBER
69 , p5_a0 NUMBER := 0-1962.0724
70 , p5_a1 NUMBER := 0-1962.0724
71 , p5_a2 NUMBER := 0-1962.0724
72 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
73 , p5_a4 NUMBER := 0-1962.0724
74 , p5_a5 NUMBER := 0-1962.0724
75 , p5_a6 NUMBER := 0-1962.0724
76 , p5_a7 DATE := fnd_api.g_miss_date
77 , p5_a8 NUMBER := 0-1962.0724
78 , p5_a9 DATE := fnd_api.g_miss_date
79 , p5_a10 NUMBER := 0-1962.0724
80 );
81 procedure insert_row(p_api_version NUMBER
82 , p_init_msg_list VARCHAR2
83 , x_return_status out nocopy VARCHAR2
84 , x_msg_count out nocopy NUMBER
85 , x_msg_data out nocopy VARCHAR2
86 , p5_a0 JTF_NUMBER_TABLE
87 , p5_a1 JTF_NUMBER_TABLE
88 , p5_a2 JTF_NUMBER_TABLE
89 , p5_a3 JTF_VARCHAR2_TABLE_100
90 , p5_a4 JTF_NUMBER_TABLE
91 , p5_a5 JTF_NUMBER_TABLE
92 , p5_a6 JTF_NUMBER_TABLE
93 , p5_a7 JTF_DATE_TABLE
94 , p5_a8 JTF_NUMBER_TABLE
95 , p5_a9 JTF_DATE_TABLE
96 , p5_a10 JTF_NUMBER_TABLE
97 , p6_a0 out nocopy JTF_NUMBER_TABLE
98 , p6_a1 out nocopy JTF_NUMBER_TABLE
99 , p6_a2 out nocopy JTF_NUMBER_TABLE
100 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
101 , p6_a4 out nocopy JTF_NUMBER_TABLE
102 , p6_a5 out nocopy JTF_NUMBER_TABLE
103 , p6_a6 out nocopy JTF_NUMBER_TABLE
104 , p6_a7 out nocopy JTF_DATE_TABLE
105 , p6_a8 out nocopy JTF_NUMBER_TABLE
106 , p6_a9 out nocopy JTF_DATE_TABLE
107 , p6_a10 out nocopy JTF_NUMBER_TABLE
108 );
109 procedure lock_row(p_api_version NUMBER
110 , p_init_msg_list VARCHAR2
111 , x_return_status out nocopy VARCHAR2
112 , x_msg_count out nocopy NUMBER
113 , x_msg_data out nocopy VARCHAR2
114 , p5_a0 NUMBER := 0-1962.0724
115 , p5_a1 NUMBER := 0-1962.0724
116 , p5_a2 NUMBER := 0-1962.0724
117 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
118 , p5_a4 NUMBER := 0-1962.0724
119 , p5_a5 NUMBER := 0-1962.0724
120 , p5_a6 NUMBER := 0-1962.0724
121 , p5_a7 DATE := fnd_api.g_miss_date
122 , p5_a8 NUMBER := 0-1962.0724
123 , p5_a9 DATE := fnd_api.g_miss_date
124 , p5_a10 NUMBER := 0-1962.0724
125 );
126 procedure lock_row(p_api_version NUMBER
127 , p_init_msg_list VARCHAR2
128 , x_return_status out nocopy VARCHAR2
129 , x_msg_count out nocopy NUMBER
130 , x_msg_data out nocopy VARCHAR2
131 , p5_a0 JTF_NUMBER_TABLE
132 , p5_a1 JTF_NUMBER_TABLE
133 , p5_a2 JTF_NUMBER_TABLE
134 , p5_a3 JTF_VARCHAR2_TABLE_100
135 , p5_a4 JTF_NUMBER_TABLE
136 , p5_a5 JTF_NUMBER_TABLE
137 , p5_a6 JTF_NUMBER_TABLE
138 , p5_a7 JTF_DATE_TABLE
139 , p5_a8 JTF_NUMBER_TABLE
140 , p5_a9 JTF_DATE_TABLE
141 , p5_a10 JTF_NUMBER_TABLE
142 );
143 procedure update_row(p_api_version NUMBER
144 , p_init_msg_list VARCHAR2
145 , x_return_status out nocopy VARCHAR2
146 , x_msg_count out nocopy NUMBER
147 , x_msg_data out nocopy VARCHAR2
148 , p6_a0 out nocopy NUMBER
149 , p6_a1 out nocopy NUMBER
150 , p6_a2 out nocopy NUMBER
151 , p6_a3 out nocopy VARCHAR2
152 , p6_a4 out nocopy NUMBER
153 , p6_a5 out nocopy NUMBER
154 , p6_a6 out nocopy NUMBER
155 , p6_a7 out nocopy DATE
156 , p6_a8 out nocopy NUMBER
157 , p6_a9 out nocopy DATE
158 , p6_a10 out nocopy NUMBER
159 , p5_a0 NUMBER := 0-1962.0724
160 , p5_a1 NUMBER := 0-1962.0724
161 , p5_a2 NUMBER := 0-1962.0724
162 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
163 , p5_a4 NUMBER := 0-1962.0724
164 , p5_a5 NUMBER := 0-1962.0724
165 , p5_a6 NUMBER := 0-1962.0724
166 , p5_a7 DATE := fnd_api.g_miss_date
167 , p5_a8 NUMBER := 0-1962.0724
168 , p5_a9 DATE := fnd_api.g_miss_date
169 , p5_a10 NUMBER := 0-1962.0724
170 );
171 procedure update_row(p_api_version NUMBER
172 , p_init_msg_list VARCHAR2
173 , x_return_status out nocopy VARCHAR2
174 , x_msg_count out nocopy NUMBER
175 , x_msg_data out nocopy VARCHAR2
176 , p5_a0 JTF_NUMBER_TABLE
177 , p5_a1 JTF_NUMBER_TABLE
178 , p5_a2 JTF_NUMBER_TABLE
179 , p5_a3 JTF_VARCHAR2_TABLE_100
180 , p5_a4 JTF_NUMBER_TABLE
181 , p5_a5 JTF_NUMBER_TABLE
182 , p5_a6 JTF_NUMBER_TABLE
183 , p5_a7 JTF_DATE_TABLE
184 , p5_a8 JTF_NUMBER_TABLE
185 , p5_a9 JTF_DATE_TABLE
186 , p5_a10 JTF_NUMBER_TABLE
187 , p6_a0 out nocopy JTF_NUMBER_TABLE
188 , p6_a1 out nocopy JTF_NUMBER_TABLE
189 , p6_a2 out nocopy JTF_NUMBER_TABLE
190 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
191 , p6_a4 out nocopy JTF_NUMBER_TABLE
192 , p6_a5 out nocopy JTF_NUMBER_TABLE
193 , p6_a6 out nocopy JTF_NUMBER_TABLE
194 , p6_a7 out nocopy JTF_DATE_TABLE
195 , p6_a8 out nocopy JTF_NUMBER_TABLE
196 , p6_a9 out nocopy JTF_DATE_TABLE
197 , p6_a10 out nocopy JTF_NUMBER_TABLE
198 );
199 procedure delete_row(p_api_version NUMBER
200 , p_init_msg_list VARCHAR2
201 , x_return_status out nocopy VARCHAR2
202 , x_msg_count out nocopy NUMBER
203 , x_msg_data out nocopy VARCHAR2
204 , p5_a0 NUMBER := 0-1962.0724
205 , p5_a1 NUMBER := 0-1962.0724
206 , p5_a2 NUMBER := 0-1962.0724
207 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
208 , p5_a4 NUMBER := 0-1962.0724
209 , p5_a5 NUMBER := 0-1962.0724
210 , p5_a6 NUMBER := 0-1962.0724
211 , p5_a7 DATE := fnd_api.g_miss_date
212 , p5_a8 NUMBER := 0-1962.0724
213 , p5_a9 DATE := fnd_api.g_miss_date
214 , p5_a10 NUMBER := 0-1962.0724
215 );
216 procedure delete_row(p_api_version NUMBER
217 , p_init_msg_list VARCHAR2
218 , x_return_status out nocopy VARCHAR2
219 , x_msg_count out nocopy NUMBER
220 , x_msg_data out nocopy VARCHAR2
221 , p5_a0 JTF_NUMBER_TABLE
222 , p5_a1 JTF_NUMBER_TABLE
223 , p5_a2 JTF_NUMBER_TABLE
224 , p5_a3 JTF_VARCHAR2_TABLE_100
225 , p5_a4 JTF_NUMBER_TABLE
226 , p5_a5 JTF_NUMBER_TABLE
227 , p5_a6 JTF_NUMBER_TABLE
228 , p5_a7 JTF_DATE_TABLE
229 , p5_a8 JTF_NUMBER_TABLE
230 , p5_a9 JTF_DATE_TABLE
231 , p5_a10 JTF_NUMBER_TABLE
232 );
233 procedure validate_row(p_api_version NUMBER
234 , p_init_msg_list VARCHAR2
235 , x_return_status out nocopy VARCHAR2
236 , x_msg_count out nocopy NUMBER
237 , x_msg_data out nocopy VARCHAR2
238 , p5_a0 NUMBER := 0-1962.0724
239 , p5_a1 NUMBER := 0-1962.0724
240 , p5_a2 NUMBER := 0-1962.0724
241 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
242 , p5_a4 NUMBER := 0-1962.0724
243 , p5_a5 NUMBER := 0-1962.0724
244 , p5_a6 NUMBER := 0-1962.0724
245 , p5_a7 DATE := fnd_api.g_miss_date
246 , p5_a8 NUMBER := 0-1962.0724
247 , p5_a9 DATE := fnd_api.g_miss_date
248 , p5_a10 NUMBER := 0-1962.0724
249 );
250 procedure validate_row(p_api_version NUMBER
251 , p_init_msg_list VARCHAR2
252 , x_return_status out nocopy VARCHAR2
253 , x_msg_count out nocopy NUMBER
254 , x_msg_data out nocopy VARCHAR2
255 , p5_a0 JTF_NUMBER_TABLE
256 , p5_a1 JTF_NUMBER_TABLE
257 , p5_a2 JTF_NUMBER_TABLE
258 , p5_a3 JTF_VARCHAR2_TABLE_100
259 , p5_a4 JTF_NUMBER_TABLE
260 , p5_a5 JTF_NUMBER_TABLE
261 , p5_a6 JTF_NUMBER_TABLE
262 , p5_a7 JTF_DATE_TABLE
263 , p5_a8 JTF_NUMBER_TABLE
264 , p5_a9 JTF_DATE_TABLE
265 , p5_a10 JTF_NUMBER_TABLE
266 );
267 end okl_agc_pvt_w;