1: package csf_debrief_pub_w AUTHID CURRENT_USER as
2: /* $Header: csfrwdbs.pls 120.0 2005/05/25 11:19:18 appldev noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy csf_debrief_pub.debrief_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
5: , a2 JTF_DATE_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: , a10 JTF_VARCHAR2_TABLE_200
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: , a10 JTF_VARCHAR2_TABLE_200
14: , a11 JTF_VARCHAR2_TABLE_200
15: , a12 JTF_VARCHAR2_TABLE_200
28: , a25 JTF_VARCHAR2_TABLE_100
29: );
30: procedure rosetta_table_copy_out_p5(t csf_debrief_pub.debrief_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_VARCHAR2_TABLE_100
32: , a2 out nocopy JTF_DATE_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_NUMBER_TABLE
36: , a6 out nocopy JTF_DATE_TABLE
32: , a2 out nocopy JTF_DATE_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_NUMBER_TABLE
36: , a6 out nocopy JTF_DATE_TABLE
37: , a7 out nocopy JTF_NUMBER_TABLE
38: , a8 out nocopy JTF_DATE_TABLE
39: , a9 out nocopy JTF_NUMBER_TABLE
40: , a10 out nocopy JTF_VARCHAR2_TABLE_200
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_NUMBER_TABLE
36: , a6 out nocopy JTF_DATE_TABLE
37: , a7 out nocopy JTF_NUMBER_TABLE
38: , a8 out nocopy JTF_DATE_TABLE
39: , a9 out nocopy JTF_NUMBER_TABLE
40: , a10 out nocopy JTF_VARCHAR2_TABLE_200
41: , a11 out nocopy JTF_VARCHAR2_TABLE_200
42: , a12 out nocopy JTF_VARCHAR2_TABLE_200
57:
58: procedure rosetta_table_copy_in_p10(t out nocopy csf_debrief_pub.debrief_line_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_NUMBER_TABLE
60: , a2 JTF_NUMBER_TABLE
61: , a3 JTF_DATE_TABLE
62: , a4 JTF_NUMBER_TABLE
63: , a5 JTF_NUMBER_TABLE
64: , a6 JTF_NUMBER_TABLE
65: , a7 JTF_NUMBER_TABLE
81: , a23 JTF_VARCHAR2_TABLE_100
82: , a24 JTF_VARCHAR2_TABLE_100
83: , a25 JTF_VARCHAR2_TABLE_100
84: , a26 JTF_VARCHAR2_TABLE_100
85: , a27 JTF_DATE_TABLE
86: , a28 JTF_DATE_TABLE
87: , a29 JTF_NUMBER_TABLE
88: , a30 JTF_NUMBER_TABLE
89: , a31 JTF_NUMBER_TABLE
82: , a24 JTF_VARCHAR2_TABLE_100
83: , a25 JTF_VARCHAR2_TABLE_100
84: , a26 JTF_VARCHAR2_TABLE_100
85: , a27 JTF_DATE_TABLE
86: , a28 JTF_DATE_TABLE
87: , a29 JTF_NUMBER_TABLE
88: , a30 JTF_NUMBER_TABLE
89: , a31 JTF_NUMBER_TABLE
90: , a32 JTF_VARCHAR2_TABLE_100
99: , a41 JTF_VARCHAR2_TABLE_100
100: , a42 JTF_VARCHAR2_TABLE_100
101: , a43 JTF_VARCHAR2_TABLE_300
102: , a44 JTF_NUMBER_TABLE
103: , a45 JTF_DATE_TABLE
104: , a46 JTF_NUMBER_TABLE
105: , a47 JTF_DATE_TABLE
106: , a48 JTF_NUMBER_TABLE
107: , a49 JTF_VARCHAR2_TABLE_200
101: , a43 JTF_VARCHAR2_TABLE_300
102: , a44 JTF_NUMBER_TABLE
103: , a45 JTF_DATE_TABLE
104: , a46 JTF_NUMBER_TABLE
105: , a47 JTF_DATE_TABLE
106: , a48 JTF_NUMBER_TABLE
107: , a49 JTF_VARCHAR2_TABLE_200
108: , a50 JTF_VARCHAR2_TABLE_200
109: , a51 JTF_VARCHAR2_TABLE_200
121: , a63 JTF_VARCHAR2_TABLE_200
122: , a64 JTF_VARCHAR2_TABLE_100
123: , a65 JTF_VARCHAR2_TABLE_100
124: , a66 JTF_NUMBER_TABLE
125: , a67 JTF_DATE_TABLE
126: );
127: procedure rosetta_table_copy_out_p10(t csf_debrief_pub.debrief_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_NUMBER_TABLE
129: , a2 out nocopy JTF_NUMBER_TABLE
126: );
127: procedure rosetta_table_copy_out_p10(t csf_debrief_pub.debrief_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_NUMBER_TABLE
129: , a2 out nocopy JTF_NUMBER_TABLE
130: , a3 out nocopy JTF_DATE_TABLE
131: , a4 out nocopy JTF_NUMBER_TABLE
132: , a5 out nocopy JTF_NUMBER_TABLE
133: , a6 out nocopy JTF_NUMBER_TABLE
134: , a7 out nocopy JTF_NUMBER_TABLE
150: , a23 out nocopy JTF_VARCHAR2_TABLE_100
151: , a24 out nocopy JTF_VARCHAR2_TABLE_100
152: , a25 out nocopy JTF_VARCHAR2_TABLE_100
153: , a26 out nocopy JTF_VARCHAR2_TABLE_100
154: , a27 out nocopy JTF_DATE_TABLE
155: , a28 out nocopy JTF_DATE_TABLE
156: , a29 out nocopy JTF_NUMBER_TABLE
157: , a30 out nocopy JTF_NUMBER_TABLE
158: , a31 out nocopy JTF_NUMBER_TABLE
151: , a24 out nocopy JTF_VARCHAR2_TABLE_100
152: , a25 out nocopy JTF_VARCHAR2_TABLE_100
153: , a26 out nocopy JTF_VARCHAR2_TABLE_100
154: , a27 out nocopy JTF_DATE_TABLE
155: , a28 out nocopy JTF_DATE_TABLE
156: , a29 out nocopy JTF_NUMBER_TABLE
157: , a30 out nocopy JTF_NUMBER_TABLE
158: , a31 out nocopy JTF_NUMBER_TABLE
159: , a32 out nocopy JTF_VARCHAR2_TABLE_100
168: , a41 out nocopy JTF_VARCHAR2_TABLE_100
169: , a42 out nocopy JTF_VARCHAR2_TABLE_100
170: , a43 out nocopy JTF_VARCHAR2_TABLE_300
171: , a44 out nocopy JTF_NUMBER_TABLE
172: , a45 out nocopy JTF_DATE_TABLE
173: , a46 out nocopy JTF_NUMBER_TABLE
174: , a47 out nocopy JTF_DATE_TABLE
175: , a48 out nocopy JTF_NUMBER_TABLE
176: , a49 out nocopy JTF_VARCHAR2_TABLE_200
170: , a43 out nocopy JTF_VARCHAR2_TABLE_300
171: , a44 out nocopy JTF_NUMBER_TABLE
172: , a45 out nocopy JTF_DATE_TABLE
173: , a46 out nocopy JTF_NUMBER_TABLE
174: , a47 out nocopy JTF_DATE_TABLE
175: , a48 out nocopy JTF_NUMBER_TABLE
176: , a49 out nocopy JTF_VARCHAR2_TABLE_200
177: , a50 out nocopy JTF_VARCHAR2_TABLE_200
178: , a51 out nocopy JTF_VARCHAR2_TABLE_200
190: , a63 out nocopy JTF_VARCHAR2_TABLE_200
191: , a64 out nocopy JTF_VARCHAR2_TABLE_100
192: , a65 out nocopy JTF_VARCHAR2_TABLE_100
193: , a66 out nocopy JTF_NUMBER_TABLE
194: , a67 out nocopy JTF_DATE_TABLE
195: );
196:
197: procedure create_debrief(p_api_version_number NUMBER
198: , p_init_msg_list VARCHAR2
225: , p3_a25 VARCHAR2
226: , p4_a0 JTF_NUMBER_TABLE
227: , p4_a1 JTF_NUMBER_TABLE
228: , p4_a2 JTF_NUMBER_TABLE
229: , p4_a3 JTF_DATE_TABLE
230: , p4_a4 JTF_NUMBER_TABLE
231: , p4_a5 JTF_NUMBER_TABLE
232: , p4_a6 JTF_NUMBER_TABLE
233: , p4_a7 JTF_NUMBER_TABLE
249: , p4_a23 JTF_VARCHAR2_TABLE_100
250: , p4_a24 JTF_VARCHAR2_TABLE_100
251: , p4_a25 JTF_VARCHAR2_TABLE_100
252: , p4_a26 JTF_VARCHAR2_TABLE_100
253: , p4_a27 JTF_DATE_TABLE
254: , p4_a28 JTF_DATE_TABLE
255: , p4_a29 JTF_NUMBER_TABLE
256: , p4_a30 JTF_NUMBER_TABLE
257: , p4_a31 JTF_NUMBER_TABLE
250: , p4_a24 JTF_VARCHAR2_TABLE_100
251: , p4_a25 JTF_VARCHAR2_TABLE_100
252: , p4_a26 JTF_VARCHAR2_TABLE_100
253: , p4_a27 JTF_DATE_TABLE
254: , p4_a28 JTF_DATE_TABLE
255: , p4_a29 JTF_NUMBER_TABLE
256: , p4_a30 JTF_NUMBER_TABLE
257: , p4_a31 JTF_NUMBER_TABLE
258: , p4_a32 JTF_VARCHAR2_TABLE_100
267: , p4_a41 JTF_VARCHAR2_TABLE_100
268: , p4_a42 JTF_VARCHAR2_TABLE_100
269: , p4_a43 JTF_VARCHAR2_TABLE_300
270: , p4_a44 JTF_NUMBER_TABLE
271: , p4_a45 JTF_DATE_TABLE
272: , p4_a46 JTF_NUMBER_TABLE
273: , p4_a47 JTF_DATE_TABLE
274: , p4_a48 JTF_NUMBER_TABLE
275: , p4_a49 JTF_VARCHAR2_TABLE_200
269: , p4_a43 JTF_VARCHAR2_TABLE_300
270: , p4_a44 JTF_NUMBER_TABLE
271: , p4_a45 JTF_DATE_TABLE
272: , p4_a46 JTF_NUMBER_TABLE
273: , p4_a47 JTF_DATE_TABLE
274: , p4_a48 JTF_NUMBER_TABLE
275: , p4_a49 JTF_VARCHAR2_TABLE_200
276: , p4_a50 JTF_VARCHAR2_TABLE_200
277: , p4_a51 JTF_VARCHAR2_TABLE_200
289: , p4_a63 JTF_VARCHAR2_TABLE_200
290: , p4_a64 JTF_VARCHAR2_TABLE_100
291: , p4_a65 JTF_VARCHAR2_TABLE_100
292: , p4_a66 JTF_NUMBER_TABLE
293: , p4_a67 JTF_DATE_TABLE
294: , x_debrief_header_id out nocopy NUMBER
295: , x_return_status out nocopy VARCHAR2
296: , x_msg_count out nocopy NUMBER
297: , x_msg_data out nocopy VARCHAR2
336: , p_task_assignment_status VARCHAR2
337: , p5_a0 JTF_NUMBER_TABLE
338: , p5_a1 JTF_NUMBER_TABLE
339: , p5_a2 JTF_NUMBER_TABLE
340: , p5_a3 JTF_DATE_TABLE
341: , p5_a4 JTF_NUMBER_TABLE
342: , p5_a5 JTF_NUMBER_TABLE
343: , p5_a6 JTF_NUMBER_TABLE
344: , p5_a7 JTF_NUMBER_TABLE
360: , p5_a23 JTF_VARCHAR2_TABLE_100
361: , p5_a24 JTF_VARCHAR2_TABLE_100
362: , p5_a25 JTF_VARCHAR2_TABLE_100
363: , p5_a26 JTF_VARCHAR2_TABLE_100
364: , p5_a27 JTF_DATE_TABLE
365: , p5_a28 JTF_DATE_TABLE
366: , p5_a29 JTF_NUMBER_TABLE
367: , p5_a30 JTF_NUMBER_TABLE
368: , p5_a31 JTF_NUMBER_TABLE
361: , p5_a24 JTF_VARCHAR2_TABLE_100
362: , p5_a25 JTF_VARCHAR2_TABLE_100
363: , p5_a26 JTF_VARCHAR2_TABLE_100
364: , p5_a27 JTF_DATE_TABLE
365: , p5_a28 JTF_DATE_TABLE
366: , p5_a29 JTF_NUMBER_TABLE
367: , p5_a30 JTF_NUMBER_TABLE
368: , p5_a31 JTF_NUMBER_TABLE
369: , p5_a32 JTF_VARCHAR2_TABLE_100
378: , p5_a41 JTF_VARCHAR2_TABLE_100
379: , p5_a42 JTF_VARCHAR2_TABLE_100
380: , p5_a43 JTF_VARCHAR2_TABLE_300
381: , p5_a44 JTF_NUMBER_TABLE
382: , p5_a45 JTF_DATE_TABLE
383: , p5_a46 JTF_NUMBER_TABLE
384: , p5_a47 JTF_DATE_TABLE
385: , p5_a48 JTF_NUMBER_TABLE
386: , p5_a49 JTF_VARCHAR2_TABLE_200
380: , p5_a43 JTF_VARCHAR2_TABLE_300
381: , p5_a44 JTF_NUMBER_TABLE
382: , p5_a45 JTF_DATE_TABLE
383: , p5_a46 JTF_NUMBER_TABLE
384: , p5_a47 JTF_DATE_TABLE
385: , p5_a48 JTF_NUMBER_TABLE
386: , p5_a49 JTF_VARCHAR2_TABLE_200
387: , p5_a50 JTF_VARCHAR2_TABLE_200
388: , p5_a51 JTF_VARCHAR2_TABLE_200
400: , p5_a63 JTF_VARCHAR2_TABLE_200
401: , p5_a64 JTF_VARCHAR2_TABLE_100
402: , p5_a65 JTF_VARCHAR2_TABLE_100
403: , p5_a66 JTF_NUMBER_TABLE
404: , p5_a67 JTF_DATE_TABLE
405: , p_debrief_header_id NUMBER
406: , p_source_object_type_code VARCHAR2
407: , x_return_status out nocopy VARCHAR2
408: , x_msg_count out nocopy NUMBER