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