[Home] [Help]
PACKAGE: APPS.AMS_APPROVAL_DETAILS_PVT_W
Source
1 package ams_approval_details_pvt_w AUTHID CURRENT_USER as
2 /* $Header: amswapds.pls 115.7 2002/12/29 08:28:26 vmodur ship $ */
3 procedure rosetta_table_copy_in_p1(t OUT NOCOPY ams_approval_details_pvt.t_approval_id_table, a0 JTF_NUMBER_TABLE);
4 procedure rosetta_table_copy_out_p1(t ams_approval_details_pvt.t_approval_id_table, a0 OUT NOCOPY JTF_NUMBER_TABLE);
5
6 procedure create_approval_details(p_api_version NUMBER
7 , p_init_msg_list VARCHAR2
8 , p_commit VARCHAR2
9 , p_validation_level NUMBER
10 , x_return_status OUT NOCOPY VARCHAR2
11 , x_msg_count OUT NOCOPY NUMBER
12 , x_msg_data OUT NOCOPY VARCHAR2
13 , p7_a0 DATE
14 , p7_a1 DATE
15 , p7_a2 NUMBER
16 , p7_a3 DATE
17 , p7_a4 NUMBER
18 , p7_a5 DATE
19 , p7_a6 NUMBER
20 , p7_a7 NUMBER
21 , p7_a8 NUMBER
22 , p7_a9 NUMBER
23 , p7_a10 NUMBER
24 , p7_a11 NUMBER
25 , p7_a12 NUMBER
26 , p7_a13 NUMBER
27 , p7_a14 VARCHAR2
28 , p7_a15 VARCHAR2
29 , p7_a16 VARCHAR2
30 , p7_a17 VARCHAR2
31 , p7_a18 NUMBER
32 , p7_a19 NUMBER
33 , p7_a20 VARCHAR2
34 , p7_a21 VARCHAR2
35 , p7_a22 VARCHAR2
36 , p7_a23 VARCHAR2
37 , p7_a24 VARCHAR2
38 , p7_a25 VARCHAR2
39 , x_approval_detail_id OUT NOCOPY NUMBER
40 );
41 procedure update_approval_details(p_api_version NUMBER
42 , p_init_msg_list VARCHAR2
43 , p_commit VARCHAR2
44 , p_validation_level NUMBER
45 , x_return_status OUT NOCOPY VARCHAR2
46 , x_msg_count OUT NOCOPY NUMBER
47 , x_msg_data OUT NOCOPY VARCHAR2
48 , p7_a0 DATE
49 , p7_a1 DATE
50 , p7_a2 NUMBER
51 , p7_a3 DATE
52 , p7_a4 NUMBER
53 , p7_a5 DATE
54 , p7_a6 NUMBER
55 , p7_a7 NUMBER
56 , p7_a8 NUMBER
57 , p7_a9 NUMBER
58 , p7_a10 NUMBER
59 , p7_a11 NUMBER
60 , p7_a12 NUMBER
61 , p7_a13 NUMBER
62 , p7_a14 VARCHAR2
63 , p7_a15 VARCHAR2
64 , p7_a16 VARCHAR2
65 , p7_a17 VARCHAR2
66 , p7_a18 NUMBER
67 , p7_a19 NUMBER
68 , p7_a20 VARCHAR2
69 , p7_a21 VARCHAR2
70 , p7_a22 VARCHAR2
71 , p7_a23 VARCHAR2
72 , p7_a24 VARCHAR2
73 , p7_a25 VARCHAR2
74 );
75 procedure validate_approval_details(p_api_version NUMBER
76 , p_init_msg_list VARCHAR2
77 , p_commit VARCHAR2
78 , p_validation_level NUMBER
79 , x_return_status OUT NOCOPY VARCHAR2
80 , x_msg_count OUT NOCOPY NUMBER
81 , x_msg_data OUT NOCOPY VARCHAR2
82 , p7_a0 DATE
83 , p7_a1 DATE
84 , p7_a2 NUMBER
85 , p7_a3 DATE
86 , p7_a4 NUMBER
87 , p7_a5 DATE
88 , p7_a6 NUMBER
89 , p7_a7 NUMBER
90 , p7_a8 NUMBER
91 , p7_a9 NUMBER
92 , p7_a10 NUMBER
93 , p7_a11 NUMBER
94 , p7_a12 NUMBER
95 , p7_a13 NUMBER
96 , p7_a14 VARCHAR2
97 , p7_a15 VARCHAR2
98 , p7_a16 VARCHAR2
99 , p7_a17 VARCHAR2
100 , p7_a18 NUMBER
101 , p7_a19 NUMBER
102 , p7_a20 VARCHAR2
103 , p7_a21 VARCHAR2
104 , p7_a22 VARCHAR2
105 , p7_a23 VARCHAR2
106 , p7_a24 VARCHAR2
107 , p7_a25 VARCHAR2
108 );
109 procedure check_approval_details_items(p0_a0 DATE
110 , p0_a1 DATE
111 , p0_a2 NUMBER
112 , p0_a3 DATE
113 , p0_a4 NUMBER
114 , p0_a5 DATE
115 , p0_a6 NUMBER
116 , p0_a7 NUMBER
117 , p0_a8 NUMBER
118 , p0_a9 NUMBER
119 , p0_a10 NUMBER
120 , p0_a11 NUMBER
121 , p0_a12 NUMBER
122 , p0_a13 NUMBER
123 , p0_a14 VARCHAR2
124 , p0_a15 VARCHAR2
125 , p0_a16 VARCHAR2
126 , p0_a17 VARCHAR2
127 , p0_a18 NUMBER
128 , p0_a19 NUMBER
129 , p0_a20 VARCHAR2
130 , p0_a21 VARCHAR2
131 , p0_a22 VARCHAR2
132 , p0_a23 VARCHAR2
133 , p0_a24 VARCHAR2
134 , p0_a25 VARCHAR2
135 , p_validation_mode VARCHAR2
136 , x_return_status OUT NOCOPY VARCHAR2
137 );
138 procedure check_approval_details_record(p0_a0 DATE
139 , p0_a1 DATE
140 , p0_a2 NUMBER
141 , p0_a3 DATE
142 , p0_a4 NUMBER
143 , p0_a5 DATE
144 , p0_a6 NUMBER
145 , p0_a7 NUMBER
146 , p0_a8 NUMBER
147 , p0_a9 NUMBER
148 , p0_a10 NUMBER
149 , p0_a11 NUMBER
150 , p0_a12 NUMBER
151 , p0_a13 NUMBER
152 , p0_a14 VARCHAR2
153 , p0_a15 VARCHAR2
154 , p0_a16 VARCHAR2
155 , p0_a17 VARCHAR2
156 , p0_a18 NUMBER
157 , p0_a19 NUMBER
158 , p0_a20 VARCHAR2
159 , p0_a21 VARCHAR2
160 , p0_a22 VARCHAR2
161 , p0_a23 VARCHAR2
162 , p0_a24 VARCHAR2
163 , p0_a25 VARCHAR2
164 , p1_a0 DATE
165 , p1_a1 DATE
166 , p1_a2 NUMBER
167 , p1_a3 DATE
168 , p1_a4 NUMBER
169 , p1_a5 DATE
170 , p1_a6 NUMBER
171 , p1_a7 NUMBER
172 , p1_a8 NUMBER
173 , p1_a9 NUMBER
174 , p1_a10 NUMBER
175 , p1_a11 NUMBER
176 , p1_a12 NUMBER
177 , p1_a13 NUMBER
178 , p1_a14 VARCHAR2
179 , p1_a15 VARCHAR2
180 , p1_a16 VARCHAR2
181 , p1_a17 VARCHAR2
182 , p1_a18 NUMBER
183 , p1_a19 NUMBER
184 , p1_a20 VARCHAR2
185 , p1_a21 VARCHAR2
186 , p1_a22 VARCHAR2
187 , p1_a23 VARCHAR2
188 , p1_a24 VARCHAR2
189 , p1_a25 VARCHAR2
190 , x_return_status OUT NOCOPY VARCHAR2
191 );
192 procedure init_approval_details_rec(p0_a0 OUT NOCOPY DATE
193 , p0_a1 OUT NOCOPY DATE
194 , p0_a2 OUT NOCOPY NUMBER
195 , p0_a3 OUT NOCOPY DATE
196 , p0_a4 OUT NOCOPY NUMBER
197 , p0_a5 OUT NOCOPY DATE
198 , p0_a6 OUT NOCOPY NUMBER
199 , p0_a7 OUT NOCOPY NUMBER
200 , p0_a8 OUT NOCOPY NUMBER
201 , p0_a9 OUT NOCOPY NUMBER
202 , p0_a10 OUT NOCOPY NUMBER
203 , p0_a11 OUT NOCOPY NUMBER
204 , p0_a12 OUT NOCOPY NUMBER
205 , p0_a13 OUT NOCOPY NUMBER
206 , p0_a14 OUT NOCOPY VARCHAR2
207 , p0_a15 OUT NOCOPY VARCHAR2
208 , p0_a16 OUT NOCOPY VARCHAR2
209 , p0_a17 OUT NOCOPY VARCHAR2
210 , p0_a18 OUT NOCOPY NUMBER
211 , p0_a19 OUT NOCOPY NUMBER
212 , p0_a20 OUT NOCOPY VARCHAR2
213 , p0_a21 OUT NOCOPY VARCHAR2
214 , p0_a22 OUT NOCOPY VARCHAR2
215 , p0_a23 OUT NOCOPY VARCHAR2
216 , p0_a24 OUT NOCOPY VARCHAR2
217 , p0_a25 OUT NOCOPY VARCHAR2
218 );
219 procedure complete_approval_details_rec(p0_a0 DATE
220 , p0_a1 DATE
221 , p0_a2 NUMBER
222 , p0_a3 DATE
223 , p0_a4 NUMBER
224 , p0_a5 DATE
225 , p0_a6 NUMBER
226 , p0_a7 NUMBER
227 , p0_a8 NUMBER
228 , p0_a9 NUMBER
229 , p0_a10 NUMBER
230 , p0_a11 NUMBER
231 , p0_a12 NUMBER
232 , p0_a13 NUMBER
233 , p0_a14 VARCHAR2
234 , p0_a15 VARCHAR2
235 , p0_a16 VARCHAR2
236 , p0_a17 VARCHAR2
237 , p0_a18 NUMBER
238 , p0_a19 NUMBER
239 , p0_a20 VARCHAR2
240 , p0_a21 VARCHAR2
241 , p0_a22 VARCHAR2
242 , p0_a23 VARCHAR2
243 , p0_a24 VARCHAR2
244 , p0_a25 VARCHAR2
245 , p1_a0 OUT NOCOPY DATE
246 , p1_a1 OUT NOCOPY DATE
247 , p1_a2 OUT NOCOPY NUMBER
248 , p1_a3 OUT NOCOPY DATE
249 , p1_a4 OUT NOCOPY NUMBER
250 , p1_a5 OUT NOCOPY DATE
251 , p1_a6 OUT NOCOPY NUMBER
252 , p1_a7 OUT NOCOPY NUMBER
253 , p1_a8 OUT NOCOPY NUMBER
254 , p1_a9 OUT NOCOPY NUMBER
255 , p1_a10 OUT NOCOPY NUMBER
256 , p1_a11 OUT NOCOPY NUMBER
257 , p1_a12 OUT NOCOPY NUMBER
258 , p1_a13 OUT NOCOPY NUMBER
259 , p1_a14 OUT NOCOPY VARCHAR2
260 , p1_a15 OUT NOCOPY VARCHAR2
261 , p1_a16 OUT NOCOPY VARCHAR2
262 , p1_a17 OUT NOCOPY VARCHAR2
263 , p1_a18 OUT NOCOPY NUMBER
264 , p1_a19 OUT NOCOPY NUMBER
265 , p1_a20 OUT NOCOPY VARCHAR2
266 , p1_a21 OUT NOCOPY VARCHAR2
267 , p1_a22 OUT NOCOPY VARCHAR2
268 , p1_a23 OUT NOCOPY VARCHAR2
269 , p1_a24 OUT NOCOPY VARCHAR2
270 , p1_a25 OUT NOCOPY VARCHAR2
271 );
272 end ams_approval_details_pvt_w;