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.OZF_TASK_GROUP_PVT_W

Source


1 package ozf_task_group_pvt_w AUTHID CURRENT_USER as
2   /* $Header: ozfwttgs.pls 115.0 2003/06/26 05:13:01 mchang noship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy ozf_task_group_pvt.task_group_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_DATE_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_DATE_TABLE
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_DATE_TABLE
10     , a7 JTF_DATE_TABLE
11     , a8 JTF_VARCHAR2_TABLE_100
12     , a9 JTF_NUMBER_TABLE
13     , a10 JTF_VARCHAR2_TABLE_100
14     , a11 JTF_VARCHAR2_TABLE_200
15     , a12 JTF_VARCHAR2_TABLE_200
16     , a13 JTF_VARCHAR2_TABLE_200
17     , a14 JTF_VARCHAR2_TABLE_200
18     , a15 JTF_VARCHAR2_TABLE_200
19     , a16 JTF_VARCHAR2_TABLE_200
20     , a17 JTF_VARCHAR2_TABLE_200
21     , a18 JTF_VARCHAR2_TABLE_200
22     , a19 JTF_VARCHAR2_TABLE_200
23     , a20 JTF_VARCHAR2_TABLE_200
24     , a21 JTF_VARCHAR2_TABLE_200
25     , a22 JTF_VARCHAR2_TABLE_200
26     , a23 JTF_VARCHAR2_TABLE_200
27     , a24 JTF_VARCHAR2_TABLE_200
28     , a25 JTF_VARCHAR2_TABLE_200
29     , a26 JTF_VARCHAR2_TABLE_100
30     , a27 JTF_VARCHAR2_TABLE_100
31     , a28 JTF_VARCHAR2_TABLE_4000
32     );
33   procedure rosetta_table_copy_out_p1(t ozf_task_group_pvt.task_group_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34     , a1 out nocopy JTF_DATE_TABLE
35     , a2 out nocopy JTF_NUMBER_TABLE
36     , a3 out nocopy JTF_DATE_TABLE
37     , a4 out nocopy JTF_NUMBER_TABLE
38     , a5 out nocopy JTF_NUMBER_TABLE
39     , a6 out nocopy JTF_DATE_TABLE
40     , a7 out nocopy JTF_DATE_TABLE
41     , a8 out nocopy JTF_VARCHAR2_TABLE_100
42     , a9 out nocopy JTF_NUMBER_TABLE
43     , a10 out nocopy JTF_VARCHAR2_TABLE_100
44     , a11 out nocopy JTF_VARCHAR2_TABLE_200
45     , a12 out nocopy JTF_VARCHAR2_TABLE_200
46     , a13 out nocopy JTF_VARCHAR2_TABLE_200
47     , a14 out nocopy JTF_VARCHAR2_TABLE_200
48     , a15 out nocopy JTF_VARCHAR2_TABLE_200
49     , a16 out nocopy JTF_VARCHAR2_TABLE_200
50     , a17 out nocopy JTF_VARCHAR2_TABLE_200
51     , a18 out nocopy JTF_VARCHAR2_TABLE_200
52     , a19 out nocopy JTF_VARCHAR2_TABLE_200
53     , a20 out nocopy JTF_VARCHAR2_TABLE_200
54     , a21 out nocopy JTF_VARCHAR2_TABLE_200
55     , a22 out nocopy JTF_VARCHAR2_TABLE_200
56     , a23 out nocopy JTF_VARCHAR2_TABLE_200
57     , a24 out nocopy JTF_VARCHAR2_TABLE_200
58     , a25 out nocopy JTF_VARCHAR2_TABLE_200
59     , a26 out nocopy JTF_VARCHAR2_TABLE_100
60     , a27 out nocopy JTF_VARCHAR2_TABLE_100
61     , a28 out nocopy JTF_VARCHAR2_TABLE_4000
62     );
63 
64   procedure rosetta_table_copy_in_p5(t out nocopy ozf_task_group_pvt.ozf_sort_data, a0 JTF_VARCHAR2_TABLE_100
65     , a1 JTF_VARCHAR2_TABLE_100
66     );
67   procedure rosetta_table_copy_out_p5(t ozf_task_group_pvt.ozf_sort_data, a0 out nocopy JTF_VARCHAR2_TABLE_100
68     , a1 out nocopy JTF_VARCHAR2_TABLE_100
69     );
70 
71   procedure create_task_group(p_api_version  NUMBER
72     , p_init_msg_list  VARCHAR2
73     , p_commit  VARCHAR2
74     , p_validation_level  NUMBER
75     , x_return_status out nocopy  VARCHAR2
76     , x_msg_data out nocopy  VARCHAR2
77     , x_msg_count out nocopy  NUMBER
78     , p7_a0  NUMBER
79     , p7_a1  DATE
80     , p7_a2  NUMBER
81     , p7_a3  DATE
82     , p7_a4  NUMBER
83     , p7_a5  NUMBER
84     , p7_a6  DATE
85     , p7_a7  DATE
86     , p7_a8  VARCHAR2
87     , p7_a9  NUMBER
88     , p7_a10  VARCHAR2
89     , p7_a11  VARCHAR2
90     , p7_a12  VARCHAR2
91     , p7_a13  VARCHAR2
92     , p7_a14  VARCHAR2
93     , p7_a15  VARCHAR2
94     , p7_a16  VARCHAR2
95     , p7_a17  VARCHAR2
96     , p7_a18  VARCHAR2
97     , p7_a19  VARCHAR2
98     , p7_a20  VARCHAR2
99     , p7_a21  VARCHAR2
100     , p7_a22  VARCHAR2
101     , p7_a23  VARCHAR2
102     , p7_a24  VARCHAR2
103     , p7_a25  VARCHAR2
104     , p7_a26  VARCHAR2
105     , p7_a27  VARCHAR2
106     , p7_a28  VARCHAR2
107     , x_task_template_group_id out nocopy  NUMBER
108   );
109   procedure update_task_group(p_api_version  NUMBER
110     , p_init_msg_list  VARCHAR2
111     , p_commit  VARCHAR2
112     , p_validation_level  NUMBER
113     , x_return_status out nocopy  VARCHAR2
114     , x_msg_data out nocopy  VARCHAR2
115     , x_msg_count out nocopy  NUMBER
116     , p7_a0  NUMBER
117     , p7_a1  DATE
118     , p7_a2  NUMBER
119     , p7_a3  DATE
120     , p7_a4  NUMBER
121     , p7_a5  NUMBER
122     , p7_a6  DATE
123     , p7_a7  DATE
124     , p7_a8  VARCHAR2
125     , p7_a9  NUMBER
126     , p7_a10  VARCHAR2
127     , p7_a11  VARCHAR2
128     , p7_a12  VARCHAR2
129     , p7_a13  VARCHAR2
130     , p7_a14  VARCHAR2
131     , p7_a15  VARCHAR2
132     , p7_a16  VARCHAR2
133     , p7_a17  VARCHAR2
134     , p7_a18  VARCHAR2
135     , p7_a19  VARCHAR2
136     , p7_a20  VARCHAR2
137     , p7_a21  VARCHAR2
138     , p7_a22  VARCHAR2
139     , p7_a23  VARCHAR2
140     , p7_a24  VARCHAR2
141     , p7_a25  VARCHAR2
142     , p7_a26  VARCHAR2
143     , p7_a27  VARCHAR2
144     , p7_a28  VARCHAR2
145     , x_object_version_number out nocopy  NUMBER
146   );
147   procedure get_task_group(p_api_version  NUMBER
148     , p_init_msg_list  VARCHAR2
149     , p_validation_level  NUMBER
150     , x_return_status out nocopy  VARCHAR2
151     , x_msg_data out nocopy  VARCHAR2
152     , x_msg_count out nocopy  NUMBER
153     , p_task_template_group_id  NUMBER
154     , p_template_group_name  VARCHAR2
155     , p_source_object_type_code  VARCHAR2
156     , p_start_date_active  date
157     , p_end_date_active  date
158     , p11_a0 JTF_VARCHAR2_TABLE_100
159     , p11_a1 JTF_VARCHAR2_TABLE_100
160     , p12_a0  NUMBER
161     , p12_a1  NUMBER
162     , p12_a2  VARCHAR2
163     , p13_a0 out nocopy  NUMBER
164     , p13_a1 out nocopy  NUMBER
165     , p13_a2 out nocopy  NUMBER
166     , p14_a0 out nocopy JTF_NUMBER_TABLE
167     , p14_a1 out nocopy JTF_DATE_TABLE
168     , p14_a2 out nocopy JTF_NUMBER_TABLE
169     , p14_a3 out nocopy JTF_DATE_TABLE
170     , p14_a4 out nocopy JTF_NUMBER_TABLE
171     , p14_a5 out nocopy JTF_NUMBER_TABLE
172     , p14_a6 out nocopy JTF_DATE_TABLE
173     , p14_a7 out nocopy JTF_DATE_TABLE
174     , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100
175     , p14_a9 out nocopy JTF_NUMBER_TABLE
176     , p14_a10 out nocopy JTF_VARCHAR2_TABLE_100
177     , p14_a11 out nocopy JTF_VARCHAR2_TABLE_200
178     , p14_a12 out nocopy JTF_VARCHAR2_TABLE_200
179     , p14_a13 out nocopy JTF_VARCHAR2_TABLE_200
180     , p14_a14 out nocopy JTF_VARCHAR2_TABLE_200
181     , p14_a15 out nocopy JTF_VARCHAR2_TABLE_200
182     , p14_a16 out nocopy JTF_VARCHAR2_TABLE_200
183     , p14_a17 out nocopy JTF_VARCHAR2_TABLE_200
184     , p14_a18 out nocopy JTF_VARCHAR2_TABLE_200
185     , p14_a19 out nocopy JTF_VARCHAR2_TABLE_200
186     , p14_a20 out nocopy JTF_VARCHAR2_TABLE_200
187     , p14_a21 out nocopy JTF_VARCHAR2_TABLE_200
188     , p14_a22 out nocopy JTF_VARCHAR2_TABLE_200
189     , p14_a23 out nocopy JTF_VARCHAR2_TABLE_200
190     , p14_a24 out nocopy JTF_VARCHAR2_TABLE_200
191     , p14_a25 out nocopy JTF_VARCHAR2_TABLE_200
192     , p14_a26 out nocopy JTF_VARCHAR2_TABLE_100
193     , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100
194     , p14_a28 out nocopy JTF_VARCHAR2_TABLE_4000
195   );
196   procedure validate_task_group(p_api_version  NUMBER
197     , p_init_msg_list  VARCHAR2
198     , p_validation_level  NUMBER
199     , x_return_status out nocopy  VARCHAR2
200     , x_msg_count out nocopy  NUMBER
201     , x_msg_data out nocopy  VARCHAR2
202     , p6_a0  NUMBER
203     , p6_a1  DATE
204     , p6_a2  NUMBER
205     , p6_a3  DATE
206     , p6_a4  NUMBER
207     , p6_a5  NUMBER
208     , p6_a6  DATE
209     , p6_a7  DATE
210     , p6_a8  VARCHAR2
211     , p6_a9  NUMBER
212     , p6_a10  VARCHAR2
213     , p6_a11  VARCHAR2
214     , p6_a12  VARCHAR2
215     , p6_a13  VARCHAR2
216     , p6_a14  VARCHAR2
217     , p6_a15  VARCHAR2
218     , p6_a16  VARCHAR2
219     , p6_a17  VARCHAR2
220     , p6_a18  VARCHAR2
221     , p6_a19  VARCHAR2
222     , p6_a20  VARCHAR2
223     , p6_a21  VARCHAR2
224     , p6_a22  VARCHAR2
225     , p6_a23  VARCHAR2
226     , p6_a24  VARCHAR2
227     , p6_a25  VARCHAR2
228     , p6_a26  VARCHAR2
229     , p6_a27  VARCHAR2
230     , p6_a28  VARCHAR2
231   );
232   procedure check_task_group_items(p_validation_mode  VARCHAR2
233     , x_return_status out nocopy  VARCHAR2
234     , p2_a0  NUMBER
235     , p2_a1  DATE
236     , p2_a2  NUMBER
237     , p2_a3  DATE
238     , p2_a4  NUMBER
239     , p2_a5  NUMBER
240     , p2_a6  DATE
241     , p2_a7  DATE
242     , p2_a8  VARCHAR2
243     , p2_a9  NUMBER
244     , p2_a10  VARCHAR2
245     , p2_a11  VARCHAR2
246     , p2_a12  VARCHAR2
247     , p2_a13  VARCHAR2
248     , p2_a14  VARCHAR2
249     , p2_a15  VARCHAR2
250     , p2_a16  VARCHAR2
251     , p2_a17  VARCHAR2
252     , p2_a18  VARCHAR2
253     , p2_a19  VARCHAR2
254     , p2_a20  VARCHAR2
255     , p2_a21  VARCHAR2
256     , p2_a22  VARCHAR2
257     , p2_a23  VARCHAR2
258     , p2_a24  VARCHAR2
259     , p2_a25  VARCHAR2
260     , p2_a26  VARCHAR2
261     , p2_a27  VARCHAR2
262     , p2_a28  VARCHAR2
263   );
264   procedure check_task_group_record(p0_a0  NUMBER
265     , p0_a1  DATE
266     , p0_a2  NUMBER
267     , p0_a3  DATE
268     , p0_a4  NUMBER
269     , p0_a5  NUMBER
270     , p0_a6  DATE
271     , p0_a7  DATE
272     , p0_a8  VARCHAR2
273     , p0_a9  NUMBER
274     , p0_a10  VARCHAR2
275     , p0_a11  VARCHAR2
276     , p0_a12  VARCHAR2
277     , p0_a13  VARCHAR2
278     , p0_a14  VARCHAR2
279     , p0_a15  VARCHAR2
280     , p0_a16  VARCHAR2
281     , p0_a17  VARCHAR2
282     , p0_a18  VARCHAR2
283     , p0_a19  VARCHAR2
284     , p0_a20  VARCHAR2
285     , p0_a21  VARCHAR2
286     , p0_a22  VARCHAR2
287     , p0_a23  VARCHAR2
288     , p0_a24  VARCHAR2
289     , p0_a25  VARCHAR2
290     , p0_a26  VARCHAR2
291     , p0_a27  VARCHAR2
292     , p0_a28  VARCHAR2
293     , p1_a0  NUMBER
294     , p1_a1  DATE
295     , p1_a2  NUMBER
296     , p1_a3  DATE
297     , p1_a4  NUMBER
298     , p1_a5  NUMBER
299     , p1_a6  DATE
300     , p1_a7  DATE
301     , p1_a8  VARCHAR2
302     , p1_a9  NUMBER
303     , p1_a10  VARCHAR2
304     , p1_a11  VARCHAR2
305     , p1_a12  VARCHAR2
306     , p1_a13  VARCHAR2
307     , p1_a14  VARCHAR2
308     , p1_a15  VARCHAR2
309     , p1_a16  VARCHAR2
310     , p1_a17  VARCHAR2
311     , p1_a18  VARCHAR2
312     , p1_a19  VARCHAR2
313     , p1_a20  VARCHAR2
314     , p1_a21  VARCHAR2
315     , p1_a22  VARCHAR2
316     , p1_a23  VARCHAR2
317     , p1_a24  VARCHAR2
318     , p1_a25  VARCHAR2
319     , p1_a26  VARCHAR2
320     , p1_a27  VARCHAR2
321     , p1_a28  VARCHAR2
322     , x_return_status out nocopy  VARCHAR2
323   );
324   procedure init_task_group_rec(p0_a0 out nocopy  NUMBER
325     , p0_a1 out nocopy  DATE
326     , p0_a2 out nocopy  NUMBER
327     , p0_a3 out nocopy  DATE
328     , p0_a4 out nocopy  NUMBER
329     , p0_a5 out nocopy  NUMBER
330     , p0_a6 out nocopy  DATE
331     , p0_a7 out nocopy  DATE
332     , p0_a8 out nocopy  VARCHAR2
333     , p0_a9 out nocopy  NUMBER
334     , p0_a10 out nocopy  VARCHAR2
335     , p0_a11 out nocopy  VARCHAR2
336     , p0_a12 out nocopy  VARCHAR2
337     , p0_a13 out nocopy  VARCHAR2
338     , p0_a14 out nocopy  VARCHAR2
339     , p0_a15 out nocopy  VARCHAR2
340     , p0_a16 out nocopy  VARCHAR2
341     , p0_a17 out nocopy  VARCHAR2
342     , p0_a18 out nocopy  VARCHAR2
343     , p0_a19 out nocopy  VARCHAR2
344     , p0_a20 out nocopy  VARCHAR2
345     , p0_a21 out nocopy  VARCHAR2
346     , p0_a22 out nocopy  VARCHAR2
347     , p0_a23 out nocopy  VARCHAR2
348     , p0_a24 out nocopy  VARCHAR2
349     , p0_a25 out nocopy  VARCHAR2
350     , p0_a26 out nocopy  VARCHAR2
351     , p0_a27 out nocopy  VARCHAR2
352     , p0_a28 out nocopy  VARCHAR2
353   );
354   procedure complete_task_group_rec(p0_a0  NUMBER
355     , p0_a1  DATE
356     , p0_a2  NUMBER
357     , p0_a3  DATE
358     , p0_a4  NUMBER
359     , p0_a5  NUMBER
360     , p0_a6  DATE
361     , p0_a7  DATE
362     , p0_a8  VARCHAR2
363     , p0_a9  NUMBER
364     , p0_a10  VARCHAR2
365     , p0_a11  VARCHAR2
366     , p0_a12  VARCHAR2
367     , p0_a13  VARCHAR2
368     , p0_a14  VARCHAR2
369     , p0_a15  VARCHAR2
373     , p0_a19  VARCHAR2
370     , p0_a16  VARCHAR2
371     , p0_a17  VARCHAR2
372     , p0_a18  VARCHAR2
374     , p0_a20  VARCHAR2
375     , p0_a21  VARCHAR2
376     , p0_a22  VARCHAR2
377     , p0_a23  VARCHAR2
378     , p0_a24  VARCHAR2
379     , p0_a25  VARCHAR2
380     , p0_a26  VARCHAR2
381     , p0_a27  VARCHAR2
382     , p0_a28  VARCHAR2
383     , p1_a0 out nocopy  NUMBER
384     , p1_a1 out nocopy  DATE
385     , p1_a2 out nocopy  NUMBER
386     , p1_a3 out nocopy  DATE
387     , p1_a4 out nocopy  NUMBER
388     , p1_a5 out nocopy  NUMBER
389     , p1_a6 out nocopy  DATE
390     , p1_a7 out nocopy  DATE
391     , p1_a8 out nocopy  VARCHAR2
392     , p1_a9 out nocopy  NUMBER
393     , p1_a10 out nocopy  VARCHAR2
394     , p1_a11 out nocopy  VARCHAR2
395     , p1_a12 out nocopy  VARCHAR2
396     , p1_a13 out nocopy  VARCHAR2
397     , p1_a14 out nocopy  VARCHAR2
398     , p1_a15 out nocopy  VARCHAR2
399     , p1_a16 out nocopy  VARCHAR2
400     , p1_a17 out nocopy  VARCHAR2
401     , p1_a18 out nocopy  VARCHAR2
402     , p1_a19 out nocopy  VARCHAR2
403     , p1_a20 out nocopy  VARCHAR2
404     , p1_a21 out nocopy  VARCHAR2
405     , p1_a22 out nocopy  VARCHAR2
406     , p1_a23 out nocopy  VARCHAR2
407     , p1_a24 out nocopy  VARCHAR2
408     , p1_a25 out nocopy  VARCHAR2
409     , p1_a26 out nocopy  VARCHAR2
410     , p1_a27 out nocopy  VARCHAR2
411     , p1_a28 out nocopy  VARCHAR2
412   );
413 end ozf_task_group_pvt_w;