[Home] [Help]
PACKAGE: APPS.AHL_COMPLETIONS_PVT_W
Source
1 package ahl_completions_pvt_w as
2 /* $Header: AHLWPRCS.pls 120.1 2005/07/04 10:46 rroy noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_DATE_TABLE
12 , a9 JTF_DATE_TABLE
13 , a10 JTF_DATE_TABLE
14 , a11 JTF_DATE_TABLE
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_VARCHAR2_TABLE_100
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_VARCHAR2_TABLE_100
23 , a20 JTF_VARCHAR2_TABLE_100
24 , a21 JTF_VARCHAR2_TABLE_100
25 , a22 JTF_VARCHAR2_TABLE_100
26 , a23 JTF_NUMBER_TABLE
27 );
28 procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
29 , a1 out nocopy JTF_NUMBER_TABLE
30 , a2 out nocopy JTF_VARCHAR2_TABLE_100
31 , a3 out nocopy JTF_VARCHAR2_TABLE_100
32 , a4 out nocopy JTF_NUMBER_TABLE
33 , a5 out nocopy JTF_NUMBER_TABLE
34 , a6 out nocopy JTF_NUMBER_TABLE
35 , a7 out nocopy JTF_NUMBER_TABLE
36 , a8 out nocopy JTF_DATE_TABLE
37 , a9 out nocopy JTF_DATE_TABLE
38 , a10 out nocopy JTF_DATE_TABLE
39 , a11 out nocopy JTF_DATE_TABLE
40 , a12 out nocopy JTF_VARCHAR2_TABLE_100
41 , a13 out nocopy JTF_VARCHAR2_TABLE_100
42 , a14 out nocopy JTF_NUMBER_TABLE
43 , a15 out nocopy JTF_NUMBER_TABLE
44 , a16 out nocopy JTF_NUMBER_TABLE
45 , a17 out nocopy JTF_VARCHAR2_TABLE_100
46 , a18 out nocopy JTF_NUMBER_TABLE
47 , a19 out nocopy JTF_VARCHAR2_TABLE_100
48 , a20 out nocopy JTF_VARCHAR2_TABLE_100
49 , a21 out nocopy JTF_VARCHAR2_TABLE_100
50 , a22 out nocopy JTF_VARCHAR2_TABLE_100
51 , a23 out nocopy JTF_NUMBER_TABLE
52 );
53
54 procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
55 , a1 JTF_NUMBER_TABLE
56 , a2 JTF_NUMBER_TABLE
57 , a3 JTF_VARCHAR2_TABLE_100
58 , a4 JTF_NUMBER_TABLE
59 , a5 JTF_NUMBER_TABLE
60 , a6 JTF_NUMBER_TABLE
61 , a7 JTF_VARCHAR2_TABLE_2000
62 , a8 JTF_NUMBER_TABLE
63 , a9 JTF_NUMBER_TABLE
64 , a10 JTF_DATE_TABLE
65 , a11 JTF_DATE_TABLE
66 , a12 JTF_DATE_TABLE
67 , a13 JTF_DATE_TABLE
68 , a14 JTF_VARCHAR2_TABLE_100
69 , a15 JTF_VARCHAR2_TABLE_100
70 );
71 procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
72 , a1 out nocopy JTF_NUMBER_TABLE
73 , a2 out nocopy JTF_NUMBER_TABLE
74 , a3 out nocopy JTF_VARCHAR2_TABLE_100
75 , a4 out nocopy JTF_NUMBER_TABLE
76 , a5 out nocopy JTF_NUMBER_TABLE
77 , a6 out nocopy JTF_NUMBER_TABLE
78 , a7 out nocopy JTF_VARCHAR2_TABLE_2000
79 , a8 out nocopy JTF_NUMBER_TABLE
80 , a9 out nocopy JTF_NUMBER_TABLE
81 , a10 out nocopy JTF_DATE_TABLE
82 , a11 out nocopy JTF_DATE_TABLE
83 , a12 out nocopy JTF_DATE_TABLE
84 , a13 out nocopy JTF_DATE_TABLE
85 , a14 out nocopy JTF_VARCHAR2_TABLE_100
86 , a15 out nocopy JTF_VARCHAR2_TABLE_100
87 );
88
89 procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
90 , a1 JTF_NUMBER_TABLE
91 , a2 JTF_VARCHAR2_TABLE_100
92 , a3 JTF_VARCHAR2_TABLE_100
93 , a4 JTF_NUMBER_TABLE
94 , a5 JTF_NUMBER_TABLE
95 , a6 JTF_VARCHAR2_TABLE_100
96 , a7 JTF_VARCHAR2_TABLE_200
97 , a8 JTF_NUMBER_TABLE
98 , a9 JTF_NUMBER_TABLE
99 , a10 JTF_NUMBER_TABLE
100 , a11 JTF_DATE_TABLE
101 );
102 procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103 , a1 out nocopy JTF_NUMBER_TABLE
104 , a2 out nocopy JTF_VARCHAR2_TABLE_100
105 , a3 out nocopy JTF_VARCHAR2_TABLE_100
106 , a4 out nocopy JTF_NUMBER_TABLE
107 , a5 out nocopy JTF_NUMBER_TABLE
108 , a6 out nocopy JTF_VARCHAR2_TABLE_100
109 , a7 out nocopy JTF_VARCHAR2_TABLE_200
110 , a8 out nocopy JTF_NUMBER_TABLE
111 , a9 out nocopy JTF_NUMBER_TABLE
112 , a10 out nocopy JTF_NUMBER_TABLE
113 , a11 out nocopy JTF_DATE_TABLE
114 );
115
116 procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
117 , a1 JTF_NUMBER_TABLE
118 , a2 JTF_NUMBER_TABLE
119 , a3 JTF_NUMBER_TABLE
120 , a4 JTF_NUMBER_TABLE
121 , a5 JTF_NUMBER_TABLE
122 , a6 JTF_VARCHAR2_TABLE_100
123 , a7 JTF_NUMBER_TABLE
124 );
125 procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126 , a1 out nocopy JTF_NUMBER_TABLE
127 , a2 out nocopy JTF_NUMBER_TABLE
128 , a3 out nocopy JTF_NUMBER_TABLE
129 , a4 out nocopy JTF_NUMBER_TABLE
130 , a5 out nocopy JTF_NUMBER_TABLE
131 , a6 out nocopy JTF_VARCHAR2_TABLE_100
132 , a7 out nocopy JTF_NUMBER_TABLE
133 );
134
135 procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE);
136 procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
137
138 procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
139 , a1 JTF_VARCHAR2_TABLE_100
140 , a2 JTF_NUMBER_TABLE
141 , a3 JTF_NUMBER_TABLE
142 , a4 JTF_NUMBER_TABLE
143 , a5 JTF_NUMBER_TABLE
144 , a6 JTF_NUMBER_TABLE
145 , a7 JTF_NUMBER_TABLE
146 , a8 JTF_VARCHAR2_TABLE_100
147 , a9 JTF_NUMBER_TABLE
148 , a10 JTF_NUMBER_TABLE
149 );
150 procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
151 , a1 out nocopy JTF_VARCHAR2_TABLE_100
152 , a2 out nocopy JTF_NUMBER_TABLE
153 , a3 out nocopy JTF_NUMBER_TABLE
154 , a4 out nocopy JTF_NUMBER_TABLE
155 , a5 out nocopy JTF_NUMBER_TABLE
156 , a6 out nocopy JTF_NUMBER_TABLE
157 , a7 out nocopy JTF_NUMBER_TABLE
158 , a8 out nocopy JTF_VARCHAR2_TABLE_100
159 , a9 out nocopy JTF_NUMBER_TABLE
160 , a10 out nocopy JTF_NUMBER_TABLE
161 );
162
163 procedure complete_mr_instance(p_api_version NUMBER
164 , p_init_msg_list VARCHAR2
165 , p_commit VARCHAR2
166 , p_validation_level NUMBER
167 , p_default VARCHAR2
168 , p_module_type VARCHAR2
169 , x_return_status out nocopy VARCHAR2
170 , x_msg_count out nocopy NUMBER
171 , x_msg_data out nocopy VARCHAR2
172 , p9_a0 in out nocopy NUMBER
173 , p9_a1 in out nocopy NUMBER
174 , p9_a2 in out nocopy VARCHAR2
175 , p9_a3 in out nocopy VARCHAR2
176 , p9_a4 in out nocopy NUMBER
177 , p9_a5 in out nocopy NUMBER
178 , p9_a6 in out nocopy VARCHAR2
179 , p9_a7 in out nocopy VARCHAR2
180 , p9_a8 in out nocopy NUMBER
181 , p9_a9 in out nocopy NUMBER
182 , p9_a10 in out nocopy NUMBER
183 , p9_a11 in out nocopy DATE
184 );
185 procedure signoff_mr_instance(p_api_version NUMBER
186 , p_init_msg_list VARCHAR2
187 , p_commit VARCHAR2
188 , p_validation_level NUMBER
189 , p_default VARCHAR2
190 , p_module_type VARCHAR2
191 , x_return_status out nocopy VARCHAR2
192 , x_msg_count out nocopy NUMBER
193 , x_msg_data out nocopy VARCHAR2
194 , p9_a0 NUMBER
195 , p9_a1 NUMBER
196 , p9_a2 VARCHAR2
197 , p9_a3 VARCHAR2
198 , p9_a4 VARCHAR2
199 , p9_a5 DATE
200 , p9_a6 DATE
201 , p9_a7 VARCHAR2
202 , p9_a8 VARCHAR2
203 , p9_a9 VARCHAR2
204 );
205 procedure close_visit(p_api_version NUMBER
206 , p_init_msg_list VARCHAR2
207 , p_commit VARCHAR2
208 , p_validation_level NUMBER
209 , p_default VARCHAR2
210 , p_module_type VARCHAR2
211 , x_return_status out nocopy VARCHAR2
212 , x_msg_count out nocopy NUMBER
213 , x_msg_data out nocopy VARCHAR2
214 , p9_a0 NUMBER
215 , p9_a1 NUMBER
216 , p9_a2 VARCHAR2
217 , p9_a3 VARCHAR2
218 , p9_a4 VARCHAR2
219 , p9_a5 DATE
220 , p9_a6 DATE
221 , p9_a7 VARCHAR2
222 , p9_a8 VARCHAR2
223 , p9_a9 VARCHAR2
224 );
225 procedure get_default_op_actual_dates(x_return_status out nocopy VARCHAR2
226 , x_msg_count out nocopy NUMBER
227 , x_msg_data out nocopy VARCHAR2
228 , p3_a0 in out nocopy JTF_NUMBER_TABLE
229 , p3_a1 in out nocopy JTF_NUMBER_TABLE
230 , p3_a2 in out nocopy JTF_NUMBER_TABLE
231 , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
232 , p3_a4 in out nocopy JTF_NUMBER_TABLE
233 , p3_a5 in out nocopy JTF_NUMBER_TABLE
234 , p3_a6 in out nocopy JTF_NUMBER_TABLE
235 , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
236 , p3_a8 in out nocopy JTF_NUMBER_TABLE
237 , p3_a9 in out nocopy JTF_NUMBER_TABLE
238 , p3_a10 in out nocopy JTF_DATE_TABLE
239 , p3_a11 in out nocopy JTF_DATE_TABLE
240 , p3_a12 in out nocopy JTF_DATE_TABLE
241 , p3_a13 in out nocopy JTF_DATE_TABLE
242 , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
243 , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
244 );
245 procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2
246 , p1_a0 in out nocopy JTF_NUMBER_TABLE
247 , p1_a1 in out nocopy JTF_NUMBER_TABLE
248 , p1_a2 in out nocopy JTF_NUMBER_TABLE
249 , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
250 , p1_a4 in out nocopy JTF_NUMBER_TABLE
251 , p1_a5 in out nocopy JTF_NUMBER_TABLE
252 , p1_a6 in out nocopy JTF_NUMBER_TABLE
253 , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
254 , p1_a8 in out nocopy JTF_NUMBER_TABLE
255 , p1_a9 in out nocopy JTF_NUMBER_TABLE
256 , p1_a10 in out nocopy JTF_DATE_TABLE
257 , p1_a11 in out nocopy JTF_DATE_TABLE
258 , p1_a12 in out nocopy JTF_DATE_TABLE
259 , p1_a13 in out nocopy JTF_DATE_TABLE
260 , p1_a14 in out nocopy JTF_VARCHAR2_TABLE_100
261 , p1_a15 in out nocopy JTF_VARCHAR2_TABLE_100
262 );
263 end ahl_completions_pvt_w;