DBA Data[Home] [Help]

APPS.OKL_OPD_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 4: , a1 JTF_VARCHAR2_TABLE_200

1: package okl_opd_pvt_w as
2: /* $Header: OKLIOPDS.pls 120.1 2005/07/14 11:57:37 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_opd_pvt.opd_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100

Line 12: , a9 JTF_VARCHAR2_TABLE_200

8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_200
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE

Line 21: , a1 out nocopy JTF_VARCHAR2_TABLE_200

17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: );
20: procedure rosetta_table_copy_out_p2(t okl_opd_pvt.opd_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
21: , a1 out nocopy JTF_VARCHAR2_TABLE_200
22: , a2 out nocopy JTF_NUMBER_TABLE
23: , a3 out nocopy JTF_NUMBER_TABLE
24: , a4 out nocopy JTF_VARCHAR2_TABLE_100
25: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 29: , a9 out nocopy JTF_VARCHAR2_TABLE_200

25: , a5 out nocopy JTF_VARCHAR2_TABLE_100
26: , a6 out nocopy JTF_NUMBER_TABLE
27: , a7 out nocopy JTF_NUMBER_TABLE
28: , a8 out nocopy JTF_DATE_TABLE
29: , a9 out nocopy JTF_VARCHAR2_TABLE_200
30: , a10 out nocopy JTF_NUMBER_TABLE
31: , a11 out nocopy JTF_DATE_TABLE
32: , a12 out nocopy JTF_NUMBER_TABLE
33: , a13 out nocopy JTF_DATE_TABLE

Line 42: , a4 JTF_VARCHAR2_TABLE_2000

38: procedure rosetta_table_copy_in_p5(t out nocopy okl_opd_pvt.okl_operands_tl_tbl_type, a0 JTF_NUMBER_TABLE
39: , a1 JTF_VARCHAR2_TABLE_100
40: , a2 JTF_VARCHAR2_TABLE_100
41: , a3 JTF_VARCHAR2_TABLE_100
42: , a4 JTF_VARCHAR2_TABLE_2000
43: , a5 JTF_NUMBER_TABLE
44: , a6 JTF_DATE_TABLE
45: , a7 JTF_NUMBER_TABLE
46: , a8 JTF_DATE_TABLE

Line 53: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

49: procedure rosetta_table_copy_out_p5(t okl_opd_pvt.okl_operands_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_VARCHAR2_TABLE_100
51: , a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , a3 out nocopy JTF_VARCHAR2_TABLE_100
53: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
54: , a5 out nocopy JTF_NUMBER_TABLE
55: , a6 out nocopy JTF_DATE_TABLE
56: , a7 out nocopy JTF_NUMBER_TABLE
57: , a8 out nocopy JTF_DATE_TABLE

Line 66: , a5 JTF_VARCHAR2_TABLE_200

62: , a1 JTF_NUMBER_TABLE
63: , a2 JTF_VARCHAR2_TABLE_100
64: , a3 JTF_NUMBER_TABLE
65: , a4 JTF_NUMBER_TABLE
66: , a5 JTF_VARCHAR2_TABLE_200
67: , a6 JTF_VARCHAR2_TABLE_2000
68: , a7 JTF_VARCHAR2_TABLE_100
69: , a8 JTF_DATE_TABLE
70: , a9 JTF_DATE_TABLE

Line 67: , a6 JTF_VARCHAR2_TABLE_2000

63: , a2 JTF_VARCHAR2_TABLE_100
64: , a3 JTF_NUMBER_TABLE
65: , a4 JTF_NUMBER_TABLE
66: , a5 JTF_VARCHAR2_TABLE_200
67: , a6 JTF_VARCHAR2_TABLE_2000
68: , a7 JTF_VARCHAR2_TABLE_100
69: , a8 JTF_DATE_TABLE
70: , a9 JTF_DATE_TABLE
71: , a10 JTF_VARCHAR2_TABLE_200

Line 71: , a10 JTF_VARCHAR2_TABLE_200

67: , a6 JTF_VARCHAR2_TABLE_2000
68: , a7 JTF_VARCHAR2_TABLE_100
69: , a8 JTF_DATE_TABLE
70: , a9 JTF_DATE_TABLE
71: , a10 JTF_VARCHAR2_TABLE_200
72: , a11 JTF_VARCHAR2_TABLE_100
73: , a12 JTF_NUMBER_TABLE
74: , a13 JTF_NUMBER_TABLE
75: , a14 JTF_DATE_TABLE

Line 85: , a5 out nocopy JTF_VARCHAR2_TABLE_200

81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_VARCHAR2_TABLE_100
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_NUMBER_TABLE
85: , a5 out nocopy JTF_VARCHAR2_TABLE_200
86: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
87: , a7 out nocopy JTF_VARCHAR2_TABLE_100
88: , a8 out nocopy JTF_DATE_TABLE
89: , a9 out nocopy JTF_DATE_TABLE

Line 86: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

82: , a2 out nocopy JTF_VARCHAR2_TABLE_100
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_NUMBER_TABLE
85: , a5 out nocopy JTF_VARCHAR2_TABLE_200
86: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
87: , a7 out nocopy JTF_VARCHAR2_TABLE_100
88: , a8 out nocopy JTF_DATE_TABLE
89: , a9 out nocopy JTF_DATE_TABLE
90: , a10 out nocopy JTF_VARCHAR2_TABLE_200

Line 90: , a10 out nocopy JTF_VARCHAR2_TABLE_200

86: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
87: , a7 out nocopy JTF_VARCHAR2_TABLE_100
88: , a8 out nocopy JTF_DATE_TABLE
89: , a9 out nocopy JTF_DATE_TABLE
90: , a10 out nocopy JTF_VARCHAR2_TABLE_200
91: , a11 out nocopy JTF_VARCHAR2_TABLE_100
92: , a12 out nocopy JTF_NUMBER_TABLE
93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_DATE_TABLE

Line 152: , p5_a5 JTF_VARCHAR2_TABLE_200

148: , p5_a1 JTF_NUMBER_TABLE
149: , p5_a2 JTF_VARCHAR2_TABLE_100
150: , p5_a3 JTF_NUMBER_TABLE
151: , p5_a4 JTF_NUMBER_TABLE
152: , p5_a5 JTF_VARCHAR2_TABLE_200
153: , p5_a6 JTF_VARCHAR2_TABLE_2000
154: , p5_a7 JTF_VARCHAR2_TABLE_100
155: , p5_a8 JTF_DATE_TABLE
156: , p5_a9 JTF_DATE_TABLE

Line 153: , p5_a6 JTF_VARCHAR2_TABLE_2000

149: , p5_a2 JTF_VARCHAR2_TABLE_100
150: , p5_a3 JTF_NUMBER_TABLE
151: , p5_a4 JTF_NUMBER_TABLE
152: , p5_a5 JTF_VARCHAR2_TABLE_200
153: , p5_a6 JTF_VARCHAR2_TABLE_2000
154: , p5_a7 JTF_VARCHAR2_TABLE_100
155: , p5_a8 JTF_DATE_TABLE
156: , p5_a9 JTF_DATE_TABLE
157: , p5_a10 JTF_VARCHAR2_TABLE_200

Line 157: , p5_a10 JTF_VARCHAR2_TABLE_200

153: , p5_a6 JTF_VARCHAR2_TABLE_2000
154: , p5_a7 JTF_VARCHAR2_TABLE_100
155: , p5_a8 JTF_DATE_TABLE
156: , p5_a9 JTF_DATE_TABLE
157: , p5_a10 JTF_VARCHAR2_TABLE_200
158: , p5_a11 JTF_VARCHAR2_TABLE_100
159: , p5_a12 JTF_NUMBER_TABLE
160: , p5_a13 JTF_NUMBER_TABLE
161: , p5_a14 JTF_DATE_TABLE

Line 170: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

166: , p6_a1 out nocopy JTF_NUMBER_TABLE
167: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
168: , p6_a3 out nocopy JTF_NUMBER_TABLE
169: , p6_a4 out nocopy JTF_NUMBER_TABLE
170: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
171: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
172: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
173: , p6_a8 out nocopy JTF_DATE_TABLE
174: , p6_a9 out nocopy JTF_DATE_TABLE

Line 171: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

167: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
168: , p6_a3 out nocopy JTF_NUMBER_TABLE
169: , p6_a4 out nocopy JTF_NUMBER_TABLE
170: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
171: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
172: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
173: , p6_a8 out nocopy JTF_DATE_TABLE
174: , p6_a9 out nocopy JTF_DATE_TABLE
175: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200

Line 175: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200

171: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
172: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
173: , p6_a8 out nocopy JTF_DATE_TABLE
174: , p6_a9 out nocopy JTF_DATE_TABLE
175: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
176: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
177: , p6_a12 out nocopy JTF_NUMBER_TABLE
178: , p6_a13 out nocopy JTF_NUMBER_TABLE
179: , p6_a14 out nocopy JTF_DATE_TABLE

Line 218: , p5_a5 JTF_VARCHAR2_TABLE_200

214: , p5_a1 JTF_NUMBER_TABLE
215: , p5_a2 JTF_VARCHAR2_TABLE_100
216: , p5_a3 JTF_NUMBER_TABLE
217: , p5_a4 JTF_NUMBER_TABLE
218: , p5_a5 JTF_VARCHAR2_TABLE_200
219: , p5_a6 JTF_VARCHAR2_TABLE_2000
220: , p5_a7 JTF_VARCHAR2_TABLE_100
221: , p5_a8 JTF_DATE_TABLE
222: , p5_a9 JTF_DATE_TABLE

Line 219: , p5_a6 JTF_VARCHAR2_TABLE_2000

215: , p5_a2 JTF_VARCHAR2_TABLE_100
216: , p5_a3 JTF_NUMBER_TABLE
217: , p5_a4 JTF_NUMBER_TABLE
218: , p5_a5 JTF_VARCHAR2_TABLE_200
219: , p5_a6 JTF_VARCHAR2_TABLE_2000
220: , p5_a7 JTF_VARCHAR2_TABLE_100
221: , p5_a8 JTF_DATE_TABLE
222: , p5_a9 JTF_DATE_TABLE
223: , p5_a10 JTF_VARCHAR2_TABLE_200

Line 223: , p5_a10 JTF_VARCHAR2_TABLE_200

219: , p5_a6 JTF_VARCHAR2_TABLE_2000
220: , p5_a7 JTF_VARCHAR2_TABLE_100
221: , p5_a8 JTF_DATE_TABLE
222: , p5_a9 JTF_DATE_TABLE
223: , p5_a10 JTF_VARCHAR2_TABLE_200
224: , p5_a11 JTF_VARCHAR2_TABLE_100
225: , p5_a12 JTF_NUMBER_TABLE
226: , p5_a13 JTF_NUMBER_TABLE
227: , p5_a14 JTF_DATE_TABLE

Line 284: , p5_a5 JTF_VARCHAR2_TABLE_200

280: , p5_a1 JTF_NUMBER_TABLE
281: , p5_a2 JTF_VARCHAR2_TABLE_100
282: , p5_a3 JTF_NUMBER_TABLE
283: , p5_a4 JTF_NUMBER_TABLE
284: , p5_a5 JTF_VARCHAR2_TABLE_200
285: , p5_a6 JTF_VARCHAR2_TABLE_2000
286: , p5_a7 JTF_VARCHAR2_TABLE_100
287: , p5_a8 JTF_DATE_TABLE
288: , p5_a9 JTF_DATE_TABLE

Line 285: , p5_a6 JTF_VARCHAR2_TABLE_2000

281: , p5_a2 JTF_VARCHAR2_TABLE_100
282: , p5_a3 JTF_NUMBER_TABLE
283: , p5_a4 JTF_NUMBER_TABLE
284: , p5_a5 JTF_VARCHAR2_TABLE_200
285: , p5_a6 JTF_VARCHAR2_TABLE_2000
286: , p5_a7 JTF_VARCHAR2_TABLE_100
287: , p5_a8 JTF_DATE_TABLE
288: , p5_a9 JTF_DATE_TABLE
289: , p5_a10 JTF_VARCHAR2_TABLE_200

Line 289: , p5_a10 JTF_VARCHAR2_TABLE_200

285: , p5_a6 JTF_VARCHAR2_TABLE_2000
286: , p5_a7 JTF_VARCHAR2_TABLE_100
287: , p5_a8 JTF_DATE_TABLE
288: , p5_a9 JTF_DATE_TABLE
289: , p5_a10 JTF_VARCHAR2_TABLE_200
290: , p5_a11 JTF_VARCHAR2_TABLE_100
291: , p5_a12 JTF_NUMBER_TABLE
292: , p5_a13 JTF_NUMBER_TABLE
293: , p5_a14 JTF_DATE_TABLE

Line 302: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

298: , p6_a1 out nocopy JTF_NUMBER_TABLE
299: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
300: , p6_a3 out nocopy JTF_NUMBER_TABLE
301: , p6_a4 out nocopy JTF_NUMBER_TABLE
302: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
303: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
304: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
305: , p6_a8 out nocopy JTF_DATE_TABLE
306: , p6_a9 out nocopy JTF_DATE_TABLE

Line 303: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

299: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
300: , p6_a3 out nocopy JTF_NUMBER_TABLE
301: , p6_a4 out nocopy JTF_NUMBER_TABLE
302: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
303: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
304: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
305: , p6_a8 out nocopy JTF_DATE_TABLE
306: , p6_a9 out nocopy JTF_DATE_TABLE
307: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200

Line 307: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200

303: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
304: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
305: , p6_a8 out nocopy JTF_DATE_TABLE
306: , p6_a9 out nocopy JTF_DATE_TABLE
307: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
308: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
309: , p6_a12 out nocopy JTF_NUMBER_TABLE
310: , p6_a13 out nocopy JTF_NUMBER_TABLE
311: , p6_a14 out nocopy JTF_DATE_TABLE

Line 350: , p5_a5 JTF_VARCHAR2_TABLE_200

346: , p5_a1 JTF_NUMBER_TABLE
347: , p5_a2 JTF_VARCHAR2_TABLE_100
348: , p5_a3 JTF_NUMBER_TABLE
349: , p5_a4 JTF_NUMBER_TABLE
350: , p5_a5 JTF_VARCHAR2_TABLE_200
351: , p5_a6 JTF_VARCHAR2_TABLE_2000
352: , p5_a7 JTF_VARCHAR2_TABLE_100
353: , p5_a8 JTF_DATE_TABLE
354: , p5_a9 JTF_DATE_TABLE

Line 351: , p5_a6 JTF_VARCHAR2_TABLE_2000

347: , p5_a2 JTF_VARCHAR2_TABLE_100
348: , p5_a3 JTF_NUMBER_TABLE
349: , p5_a4 JTF_NUMBER_TABLE
350: , p5_a5 JTF_VARCHAR2_TABLE_200
351: , p5_a6 JTF_VARCHAR2_TABLE_2000
352: , p5_a7 JTF_VARCHAR2_TABLE_100
353: , p5_a8 JTF_DATE_TABLE
354: , p5_a9 JTF_DATE_TABLE
355: , p5_a10 JTF_VARCHAR2_TABLE_200

Line 355: , p5_a10 JTF_VARCHAR2_TABLE_200

351: , p5_a6 JTF_VARCHAR2_TABLE_2000
352: , p5_a7 JTF_VARCHAR2_TABLE_100
353: , p5_a8 JTF_DATE_TABLE
354: , p5_a9 JTF_DATE_TABLE
355: , p5_a10 JTF_VARCHAR2_TABLE_200
356: , p5_a11 JTF_VARCHAR2_TABLE_100
357: , p5_a12 JTF_NUMBER_TABLE
358: , p5_a13 JTF_NUMBER_TABLE
359: , p5_a14 JTF_DATE_TABLE

Line 398: , p5_a5 JTF_VARCHAR2_TABLE_200

394: , p5_a1 JTF_NUMBER_TABLE
395: , p5_a2 JTF_VARCHAR2_TABLE_100
396: , p5_a3 JTF_NUMBER_TABLE
397: , p5_a4 JTF_NUMBER_TABLE
398: , p5_a5 JTF_VARCHAR2_TABLE_200
399: , p5_a6 JTF_VARCHAR2_TABLE_2000
400: , p5_a7 JTF_VARCHAR2_TABLE_100
401: , p5_a8 JTF_DATE_TABLE
402: , p5_a9 JTF_DATE_TABLE

Line 399: , p5_a6 JTF_VARCHAR2_TABLE_2000

395: , p5_a2 JTF_VARCHAR2_TABLE_100
396: , p5_a3 JTF_NUMBER_TABLE
397: , p5_a4 JTF_NUMBER_TABLE
398: , p5_a5 JTF_VARCHAR2_TABLE_200
399: , p5_a6 JTF_VARCHAR2_TABLE_2000
400: , p5_a7 JTF_VARCHAR2_TABLE_100
401: , p5_a8 JTF_DATE_TABLE
402: , p5_a9 JTF_DATE_TABLE
403: , p5_a10 JTF_VARCHAR2_TABLE_200

Line 403: , p5_a10 JTF_VARCHAR2_TABLE_200

399: , p5_a6 JTF_VARCHAR2_TABLE_2000
400: , p5_a7 JTF_VARCHAR2_TABLE_100
401: , p5_a8 JTF_DATE_TABLE
402: , p5_a9 JTF_DATE_TABLE
403: , p5_a10 JTF_VARCHAR2_TABLE_200
404: , p5_a11 JTF_VARCHAR2_TABLE_100
405: , p5_a12 JTF_NUMBER_TABLE
406: , p5_a13 JTF_NUMBER_TABLE
407: , p5_a14 JTF_DATE_TABLE