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