APPS.CSF_DEBRIEF_PUB_W dependencies on JTF_DATE_TABLE

Line 5: , a2 JTF_DATE_TABLE

1: package csf_debrief_pub_w 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

Line 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

Line 11: , a8 JTF_DATE_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
14: , a11 JTF_VARCHAR2_TABLE_200
15: , a12 JTF_VARCHAR2_TABLE_200

Line 32: , a2 out nocopy JTF_DATE_TABLE

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

Line 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

Line 38: , a8 out nocopy JTF_DATE_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
41: , a11 out nocopy JTF_VARCHAR2_TABLE_200
42: , a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 61: , a3 JTF_DATE_TABLE

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

Line 85: , a27 JTF_DATE_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

Line 86: , a28 JTF_DATE_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

Line 103: , a45 JTF_DATE_TABLE

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

Line 105: , a47 JTF_DATE_TABLE

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

Line 125: , a67 JTF_DATE_TABLE

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

Line 130: , a3 out nocopy 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
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

Line 154: , a27 out nocopy JTF_DATE_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

Line 155: , a28 out nocopy JTF_DATE_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

Line 172: , a45 out nocopy JTF_DATE_TABLE

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

Line 174: , a47 out nocopy JTF_DATE_TABLE

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

Line 194: , a67 out nocopy JTF_DATE_TABLE

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

Line 229: , p4_a3 JTF_DATE_TABLE

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

Line 253: , p4_a27 JTF_DATE_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

Line 254: , p4_a28 JTF_DATE_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

Line 271: , p4_a45 JTF_DATE_TABLE

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

Line 273: , p4_a47 JTF_DATE_TABLE

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

Line 293: , p4_a67 JTF_DATE_TABLE

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

Line 340: , p5_a3 JTF_DATE_TABLE

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

Line 364: , p5_a27 JTF_DATE_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

Line 365: , p5_a28 JTF_DATE_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

Line 382: , p5_a45 JTF_DATE_TABLE

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

Line 384: , p5_a47 JTF_DATE_TABLE

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

Line 404: , p5_a67 JTF_DATE_TABLE

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