eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AHL_WIP_JOB_PVT_W

Source


1 package ahl_wip_job_pvt_w AUTHID CURRENT_USER as
2   /* $Header: AHLWWIPS.pls 120.1 2006/05/03 00:46 bachandr noship $ */
3   procedure rosetta_table_copy_in_p2(t out nocopy ahl_wip_job_pvt.ahl_wo_op_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_VARCHAR2_TABLE_300
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_DATE_TABLE
11     , a8 JTF_DATE_TABLE
12     , a9 JTF_VARCHAR2_TABLE_100
13     );
14   procedure rosetta_table_copy_out_p2(t ahl_wip_job_pvt.ahl_wo_op_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15     , a1 out nocopy JTF_NUMBER_TABLE
16     , a2 out nocopy JTF_NUMBER_TABLE
17     , a3 out nocopy JTF_VARCHAR2_TABLE_300
18     , a4 out nocopy JTF_NUMBER_TABLE
19     , a5 out nocopy JTF_NUMBER_TABLE
20     , a6 out nocopy JTF_NUMBER_TABLE
21     , a7 out nocopy JTF_DATE_TABLE
22     , a8 out nocopy JTF_DATE_TABLE
23     , a9 out nocopy JTF_VARCHAR2_TABLE_100
24     );
25 
26   procedure rosetta_table_copy_in_p4(t out nocopy ahl_wip_job_pvt.ahl_wo_res_tbl_type, a0 JTF_NUMBER_TABLE
27     , a1 JTF_NUMBER_TABLE
28     , a2 JTF_NUMBER_TABLE
29     , a3 JTF_NUMBER_TABLE
30     , a4 JTF_NUMBER_TABLE
31     , a5 JTF_NUMBER_TABLE
32     , a6 JTF_NUMBER_TABLE
33     , a7 JTF_VARCHAR2_TABLE_100
34     , a8 JTF_NUMBER_TABLE
35     , a9 JTF_NUMBER_TABLE
36     , a10 JTF_NUMBER_TABLE
37     , a11 JTF_NUMBER_TABLE
38     , a12 JTF_NUMBER_TABLE
39     , a13 JTF_NUMBER_TABLE
40     , a14 JTF_NUMBER_TABLE
41     , a15 JTF_NUMBER_TABLE
42     , a16 JTF_NUMBER_TABLE
43     , a17 JTF_VARCHAR2_TABLE_300
44     , a18 JTF_DATE_TABLE
45     , a19 JTF_DATE_TABLE
46     , a20 JTF_NUMBER_TABLE
47     , a21 JTF_VARCHAR2_TABLE_100
48     );
49   procedure rosetta_table_copy_out_p4(t ahl_wip_job_pvt.ahl_wo_res_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50     , a1 out nocopy JTF_NUMBER_TABLE
51     , a2 out nocopy JTF_NUMBER_TABLE
52     , a3 out nocopy JTF_NUMBER_TABLE
53     , a4 out nocopy JTF_NUMBER_TABLE
54     , a5 out nocopy JTF_NUMBER_TABLE
55     , a6 out nocopy JTF_NUMBER_TABLE
56     , a7 out nocopy JTF_VARCHAR2_TABLE_100
57     , a8 out nocopy JTF_NUMBER_TABLE
58     , a9 out nocopy JTF_NUMBER_TABLE
59     , a10 out nocopy JTF_NUMBER_TABLE
60     , a11 out nocopy JTF_NUMBER_TABLE
61     , a12 out nocopy JTF_NUMBER_TABLE
62     , a13 out nocopy JTF_NUMBER_TABLE
63     , a14 out nocopy JTF_NUMBER_TABLE
64     , a15 out nocopy JTF_NUMBER_TABLE
65     , a16 out nocopy JTF_NUMBER_TABLE
66     , a17 out nocopy JTF_VARCHAR2_TABLE_300
67     , a18 out nocopy JTF_DATE_TABLE
68     , a19 out nocopy JTF_DATE_TABLE
69     , a20 out nocopy JTF_NUMBER_TABLE
70     , a21 out nocopy JTF_VARCHAR2_TABLE_100
71     );
72 
73   procedure rosetta_table_copy_in_p6(t out nocopy ahl_wip_job_pvt.ahl_wo_mtl_tbl_type, a0 JTF_NUMBER_TABLE
74     , a1 JTF_NUMBER_TABLE
75     , a2 JTF_NUMBER_TABLE
76     , a3 JTF_NUMBER_TABLE
77     , a4 JTF_NUMBER_TABLE
78     , a5 JTF_NUMBER_TABLE
79     , a6 JTF_NUMBER_TABLE
80     , a7 JTF_NUMBER_TABLE
81     , a8 JTF_NUMBER_TABLE
82     , a9 JTF_VARCHAR2_TABLE_100
83     , a10 JTF_DATE_TABLE
84     , a11 JTF_VARCHAR2_TABLE_100
85     );
86   procedure rosetta_table_copy_out_p6(t ahl_wip_job_pvt.ahl_wo_mtl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
87     , a1 out nocopy JTF_NUMBER_TABLE
88     , a2 out nocopy JTF_NUMBER_TABLE
89     , a3 out nocopy JTF_NUMBER_TABLE
90     , a4 out nocopy JTF_NUMBER_TABLE
91     , a5 out nocopy JTF_NUMBER_TABLE
92     , a6 out nocopy JTF_NUMBER_TABLE
93     , a7 out nocopy JTF_NUMBER_TABLE
94     , a8 out nocopy JTF_NUMBER_TABLE
95     , a9 out nocopy JTF_VARCHAR2_TABLE_100
96     , a10 out nocopy JTF_DATE_TABLE
97     , a11 out nocopy JTF_VARCHAR2_TABLE_100
98     );
99 
100   procedure rosetta_table_copy_in_p8(t out nocopy ahl_wip_job_pvt.ahl_res_txn_tbl_type, a0 JTF_NUMBER_TABLE
101     , a1 JTF_NUMBER_TABLE
102     , a2 JTF_NUMBER_TABLE
103     , a3 JTF_NUMBER_TABLE
104     , a4 JTF_NUMBER_TABLE
105     , a5 JTF_DATE_TABLE
106     , a6 JTF_NUMBER_TABLE
107     , a7 JTF_VARCHAR2_TABLE_100
108     , a8 JTF_NUMBER_TABLE
109     , a9 JTF_NUMBER_TABLE
110     , a10 JTF_NUMBER_TABLE
111     , a11 JTF_VARCHAR2_TABLE_100
112     , a12 JTF_NUMBER_TABLE
113     , a13 JTF_VARCHAR2_TABLE_100
114     , a14 JTF_VARCHAR2_TABLE_100
115     , a15 JTF_VARCHAR2_TABLE_300
116     );
117   procedure rosetta_table_copy_out_p8(t ahl_wip_job_pvt.ahl_res_txn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
118     , a1 out nocopy JTF_NUMBER_TABLE
119     , a2 out nocopy JTF_NUMBER_TABLE
120     , a3 out nocopy JTF_NUMBER_TABLE
121     , a4 out nocopy JTF_NUMBER_TABLE
122     , a5 out nocopy JTF_DATE_TABLE
123     , a6 out nocopy JTF_NUMBER_TABLE
124     , a7 out nocopy JTF_VARCHAR2_TABLE_100
125     , a8 out nocopy JTF_NUMBER_TABLE
126     , a9 out nocopy JTF_NUMBER_TABLE
127     , a10 out nocopy JTF_NUMBER_TABLE
128     , a11 out nocopy JTF_VARCHAR2_TABLE_100
129     , a12 out nocopy JTF_NUMBER_TABLE
130     , a13 out nocopy JTF_VARCHAR2_TABLE_100
131     , a14 out nocopy JTF_VARCHAR2_TABLE_100
132     , a15 out nocopy JTF_VARCHAR2_TABLE_300
133     );
134 
135   procedure rosetta_table_copy_in_p10(t out nocopy ahl_wip_job_pvt.ahl_wip_job_tbl_type, a0 JTF_NUMBER_TABLE
136     , a1 JTF_VARCHAR2_TABLE_300
137     , a2 JTF_NUMBER_TABLE
138     , a3 JTF_VARCHAR2_TABLE_32767
139     );
140   procedure rosetta_table_copy_out_p10(t ahl_wip_job_pvt.ahl_wip_job_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
141     , a1 out nocopy JTF_VARCHAR2_TABLE_300
142     , a2 out nocopy JTF_NUMBER_TABLE
143     , a3 out nocopy JTF_VARCHAR2_TABLE_32767
144     );
145 
146   procedure load_wip_job(p_api_version  NUMBER
147     , p_init_msg_list  VARCHAR2
148     , p_validation_level  NUMBER
149     , x_return_status out nocopy  VARCHAR2
150     , x_msg_count out nocopy  NUMBER
151     , x_msg_data out nocopy  VARCHAR2
152     , p6_a0  VARCHAR2
153     , p6_a1  NUMBER
154     , p6_a2  NUMBER
155     , p6_a3  DATE
156     , p6_a4  DATE
157     , p6_a5  NUMBER
158     , p6_a6  NUMBER
159     , p6_a7  VARCHAR2
160     , p6_a8  NUMBER
161     , p6_a9  NUMBER
162     , p6_a10  NUMBER
163     , p6_a11  NUMBER
164     , p6_a12  NUMBER
165     , p6_a13  NUMBER
166     , p6_a14  NUMBER
167     , p6_a15  VARCHAR2
168     , p6_a16  NUMBER
169     , p6_a17  NUMBER
170     , p6_a18  VARCHAR2
171     , p6_a19  VARCHAR2
172     , p6_a20  VARCHAR2
173     , p6_a21  NUMBER
174     , p6_a22  VARCHAR2
175     , p6_a23  VARCHAR2
176     , p7_a0 JTF_NUMBER_TABLE
177     , p7_a1 JTF_NUMBER_TABLE
178     , p7_a2 JTF_NUMBER_TABLE
179     , p7_a3 JTF_VARCHAR2_TABLE_300
180     , p7_a4 JTF_NUMBER_TABLE
181     , p7_a5 JTF_NUMBER_TABLE
182     , p7_a6 JTF_NUMBER_TABLE
183     , p7_a7 JTF_DATE_TABLE
184     , p7_a8 JTF_DATE_TABLE
185     , p7_a9 JTF_VARCHAR2_TABLE_100
186     , p8_a0 JTF_NUMBER_TABLE
187     , p8_a1 JTF_NUMBER_TABLE
188     , p8_a2 JTF_NUMBER_TABLE
189     , p8_a3 JTF_NUMBER_TABLE
190     , p8_a4 JTF_NUMBER_TABLE
191     , p8_a5 JTF_NUMBER_TABLE
192     , p8_a6 JTF_NUMBER_TABLE
193     , p8_a7 JTF_VARCHAR2_TABLE_100
194     , p8_a8 JTF_NUMBER_TABLE
195     , p8_a9 JTF_NUMBER_TABLE
196     , p8_a10 JTF_NUMBER_TABLE
197     , p8_a11 JTF_NUMBER_TABLE
198     , p8_a12 JTF_NUMBER_TABLE
199     , p8_a13 JTF_NUMBER_TABLE
200     , p8_a14 JTF_NUMBER_TABLE
201     , p8_a15 JTF_NUMBER_TABLE
202     , p8_a16 JTF_NUMBER_TABLE
203     , p8_a17 JTF_VARCHAR2_TABLE_300
204     , p8_a18 JTF_DATE_TABLE
205     , p8_a19 JTF_DATE_TABLE
206     , p8_a20 JTF_NUMBER_TABLE
207     , p8_a21 JTF_VARCHAR2_TABLE_100
208     , p9_a0 JTF_NUMBER_TABLE
209     , p9_a1 JTF_NUMBER_TABLE
210     , p9_a2 JTF_NUMBER_TABLE
211     , p9_a3 JTF_NUMBER_TABLE
212     , p9_a4 JTF_NUMBER_TABLE
213     , p9_a5 JTF_NUMBER_TABLE
214     , p9_a6 JTF_NUMBER_TABLE
215     , p9_a7 JTF_NUMBER_TABLE
216     , p9_a8 JTF_NUMBER_TABLE
217     , p9_a9 JTF_VARCHAR2_TABLE_100
218     , p9_a10 JTF_DATE_TABLE
219     , p9_a11 JTF_VARCHAR2_TABLE_100
220     , x_wip_entity_id out nocopy  NUMBER
221   );
222   procedure insert_resource_txn(p_api_version  NUMBER
223     , p_init_msg_list  VARCHAR2
224     , p_commit  VARCHAR2
225     , p_validation_level  NUMBER
226     , x_return_status out nocopy  VARCHAR2
227     , x_msg_count out nocopy  NUMBER
228     , x_msg_data out nocopy  VARCHAR2
229     , p7_a0 JTF_NUMBER_TABLE
230     , p7_a1 JTF_NUMBER_TABLE
231     , p7_a2 JTF_NUMBER_TABLE
232     , p7_a3 JTF_NUMBER_TABLE
233     , p7_a4 JTF_NUMBER_TABLE
234     , p7_a5 JTF_DATE_TABLE
235     , p7_a6 JTF_NUMBER_TABLE
236     , p7_a7 JTF_VARCHAR2_TABLE_100
237     , p7_a8 JTF_NUMBER_TABLE
238     , p7_a9 JTF_NUMBER_TABLE
239     , p7_a10 JTF_NUMBER_TABLE
240     , p7_a11 JTF_VARCHAR2_TABLE_100
241     , p7_a12 JTF_NUMBER_TABLE
242     , p7_a13 JTF_VARCHAR2_TABLE_100
243     , p7_a14 JTF_VARCHAR2_TABLE_100
244     , p7_a15 JTF_VARCHAR2_TABLE_300
245   );
246   procedure wip_massload_pending(p_wip_entity_id  NUMBER
247     , ddrosetta_retval_bool OUT NOCOPY NUMBER
248   );
249   procedure load_wip_batch_jobs(p_api_version  NUMBER
250     , p_init_msg_list  VARCHAR2
251     , p_validation_level  NUMBER
252     , x_return_status out nocopy  VARCHAR2
253     , x_msg_count out nocopy  NUMBER
254     , x_msg_data out nocopy  VARCHAR2
255     , p_group_id  NUMBER
256     , p_header_id  NUMBER
257     , p_submit_flag  VARCHAR2
258     , p9_a0  VARCHAR2
259     , p9_a1  NUMBER
260     , p9_a2  NUMBER
261     , p9_a3  DATE
262     , p9_a4  DATE
263     , p9_a5  NUMBER
264     , p9_a6  NUMBER
265     , p9_a7  VARCHAR2
266     , p9_a8  NUMBER
267     , p9_a9  NUMBER
268     , p9_a10  NUMBER
269     , p9_a11  NUMBER
270     , p9_a12  NUMBER
271     , p9_a13  NUMBER
272     , p9_a14  NUMBER
273     , p9_a15  VARCHAR2
274     , p9_a16  NUMBER
275     , p9_a17  NUMBER
276     , p9_a18  VARCHAR2
277     , p9_a19  VARCHAR2
278     , p9_a20  VARCHAR2
279     , p9_a21  NUMBER
280     , p9_a22  VARCHAR2
281     , p9_a23  VARCHAR2
282     , p10_a0 JTF_NUMBER_TABLE
283     , p10_a1 JTF_NUMBER_TABLE
284     , p10_a2 JTF_NUMBER_TABLE
285     , p10_a3 JTF_VARCHAR2_TABLE_300
286     , p10_a4 JTF_NUMBER_TABLE
287     , p10_a5 JTF_NUMBER_TABLE
288     , p10_a6 JTF_NUMBER_TABLE
289     , p10_a7 JTF_DATE_TABLE
290     , p10_a8 JTF_DATE_TABLE
291     , p10_a9 JTF_VARCHAR2_TABLE_100
292     , p11_a0 JTF_NUMBER_TABLE
293     , p11_a1 JTF_NUMBER_TABLE
294     , p11_a2 JTF_NUMBER_TABLE
295     , p11_a3 JTF_NUMBER_TABLE
296     , p11_a4 JTF_NUMBER_TABLE
297     , p11_a5 JTF_NUMBER_TABLE
298     , p11_a6 JTF_NUMBER_TABLE
299     , p11_a7 JTF_VARCHAR2_TABLE_100
300     , p11_a8 JTF_NUMBER_TABLE
301     , p11_a9 JTF_NUMBER_TABLE
302     , p11_a10 JTF_NUMBER_TABLE
303     , p11_a11 JTF_NUMBER_TABLE
304     , p11_a12 JTF_NUMBER_TABLE
305     , p11_a13 JTF_NUMBER_TABLE
306     , p11_a14 JTF_NUMBER_TABLE
307     , p11_a15 JTF_NUMBER_TABLE
308     , p11_a16 JTF_NUMBER_TABLE
309     , p11_a17 JTF_VARCHAR2_TABLE_300
310     , p11_a18 JTF_DATE_TABLE
311     , p11_a19 JTF_DATE_TABLE
312     , p11_a20 JTF_NUMBER_TABLE
313     , p11_a21 JTF_VARCHAR2_TABLE_100
314     , p12_a0 JTF_NUMBER_TABLE
315     , p12_a1 JTF_NUMBER_TABLE
316     , p12_a2 JTF_NUMBER_TABLE
317     , p12_a3 JTF_NUMBER_TABLE
318     , p12_a4 JTF_NUMBER_TABLE
319     , p12_a5 JTF_NUMBER_TABLE
320     , p12_a6 JTF_NUMBER_TABLE
321     , p12_a7 JTF_NUMBER_TABLE
322     , p12_a8 JTF_NUMBER_TABLE
323     , p12_a9 JTF_VARCHAR2_TABLE_100
324     , p12_a10 JTF_DATE_TABLE
325     , p12_a11 JTF_VARCHAR2_TABLE_100
326     , x_group_id out nocopy  NUMBER
327     , x_header_id out nocopy  NUMBER
328     , p15_a0 out nocopy JTF_NUMBER_TABLE
329     , p15_a1 out nocopy JTF_VARCHAR2_TABLE_300
330     , p15_a2 out nocopy JTF_NUMBER_TABLE
331     , p15_a3 out nocopy JTF_VARCHAR2_TABLE_32767
332   );
333 end ahl_wip_job_pvt_w;