DBA Data[Home] [Help]

APPS.OKL_FPR_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: OKLIFPRS.pls 120.1 2005/07/12 07:05:47 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_fpr_pvt.fpr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE

Line 18: , a3 out nocopy JTF_VARCHAR2_TABLE_100

14: );
15: procedure rosetta_table_copy_out_p2(t okl_fpr_pvt.fpr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_DATE_TABLE

Line 29: , a1 JTF_VARCHAR2_TABLE_100

25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure rosetta_table_copy_in_p5(t out nocopy okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_VARCHAR2_TABLE_100
30: , a2 JTF_VARCHAR2_TABLE_100
31: , a3 JTF_VARCHAR2_TABLE_100
32: , a4 JTF_VARCHAR2_TABLE_300
33: , a5 JTF_VARCHAR2_TABLE_800

Line 30: , a2 JTF_VARCHAR2_TABLE_100

26: );
27:
28: procedure rosetta_table_copy_in_p5(t out nocopy okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_VARCHAR2_TABLE_100
30: , a2 JTF_VARCHAR2_TABLE_100
31: , a3 JTF_VARCHAR2_TABLE_100
32: , a4 JTF_VARCHAR2_TABLE_300
33: , a5 JTF_VARCHAR2_TABLE_800
34: , a6 JTF_NUMBER_TABLE

Line 31: , a3 JTF_VARCHAR2_TABLE_100

27:
28: procedure rosetta_table_copy_in_p5(t out nocopy okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_VARCHAR2_TABLE_100
30: , a2 JTF_VARCHAR2_TABLE_100
31: , a3 JTF_VARCHAR2_TABLE_100
32: , a4 JTF_VARCHAR2_TABLE_300
33: , a5 JTF_VARCHAR2_TABLE_800
34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_DATE_TABLE

Line 41: , a1 out nocopy JTF_VARCHAR2_TABLE_100

37: , a9 JTF_DATE_TABLE
38: , a10 JTF_NUMBER_TABLE
39: );
40: procedure rosetta_table_copy_out_p5(t okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_VARCHAR2_TABLE_300
45: , a5 out nocopy JTF_VARCHAR2_TABLE_800

Line 42: , a2 out nocopy JTF_VARCHAR2_TABLE_100

38: , a10 JTF_NUMBER_TABLE
39: );
40: procedure rosetta_table_copy_out_p5(t okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_VARCHAR2_TABLE_300
45: , a5 out nocopy JTF_VARCHAR2_TABLE_800
46: , a6 out nocopy JTF_NUMBER_TABLE

Line 43: , a3 out nocopy JTF_VARCHAR2_TABLE_100

39: );
40: procedure rosetta_table_copy_out_p5(t okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_VARCHAR2_TABLE_300
45: , a5 out nocopy JTF_VARCHAR2_TABLE_800
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_DATE_TABLE

Line 55: , a2 JTF_VARCHAR2_TABLE_100

51: );
52:
53: procedure rosetta_table_copy_in_p8(t out nocopy okl_fpr_pvt.fprv_tbl_type, a0 JTF_NUMBER_TABLE
54: , a1 JTF_NUMBER_TABLE
55: , a2 JTF_VARCHAR2_TABLE_100
56: , a3 JTF_NUMBER_TABLE
57: , a4 JTF_NUMBER_TABLE
58: , a5 JTF_NUMBER_TABLE
59: , a6 JTF_VARCHAR2_TABLE_300

Line 61: , a8 JTF_VARCHAR2_TABLE_100

57: , a4 JTF_NUMBER_TABLE
58: , a5 JTF_NUMBER_TABLE
59: , a6 JTF_VARCHAR2_TABLE_300
60: , a7 JTF_VARCHAR2_TABLE_800
61: , a8 JTF_VARCHAR2_TABLE_100
62: , a9 JTF_NUMBER_TABLE
63: , a10 JTF_DATE_TABLE
64: , a11 JTF_NUMBER_TABLE
65: , a12 JTF_DATE_TABLE

Line 70: , a2 out nocopy JTF_VARCHAR2_TABLE_100

66: , a13 JTF_NUMBER_TABLE
67: );
68: procedure rosetta_table_copy_out_p8(t okl_fpr_pvt.fprv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_NUMBER_TABLE
72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_NUMBER_TABLE
74: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 76: , a8 out nocopy JTF_VARCHAR2_TABLE_100

72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_NUMBER_TABLE
74: , a6 out nocopy JTF_VARCHAR2_TABLE_300
75: , a7 out nocopy JTF_VARCHAR2_TABLE_800
76: , a8 out nocopy JTF_VARCHAR2_TABLE_100
77: , a9 out nocopy JTF_NUMBER_TABLE
78: , a10 out nocopy JTF_DATE_TABLE
79: , a11 out nocopy JTF_NUMBER_TABLE
80: , a12 out nocopy JTF_DATE_TABLE

Line 125: , p5_a2 JTF_VARCHAR2_TABLE_100

121: , x_msg_count out nocopy NUMBER
122: , x_msg_data out nocopy VARCHAR2
123: , p5_a0 JTF_NUMBER_TABLE
124: , p5_a1 JTF_NUMBER_TABLE
125: , p5_a2 JTF_VARCHAR2_TABLE_100
126: , p5_a3 JTF_NUMBER_TABLE
127: , p5_a4 JTF_NUMBER_TABLE
128: , p5_a5 JTF_NUMBER_TABLE
129: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 131: , p5_a8 JTF_VARCHAR2_TABLE_100

127: , p5_a4 JTF_NUMBER_TABLE
128: , p5_a5 JTF_NUMBER_TABLE
129: , p5_a6 JTF_VARCHAR2_TABLE_300
130: , p5_a7 JTF_VARCHAR2_TABLE_800
131: , p5_a8 JTF_VARCHAR2_TABLE_100
132: , p5_a9 JTF_NUMBER_TABLE
133: , p5_a10 JTF_DATE_TABLE
134: , p5_a11 JTF_NUMBER_TABLE
135: , p5_a12 JTF_DATE_TABLE

Line 139: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

135: , p5_a12 JTF_DATE_TABLE
136: , p5_a13 JTF_NUMBER_TABLE
137: , p6_a0 out nocopy JTF_NUMBER_TABLE
138: , p6_a1 out nocopy JTF_NUMBER_TABLE
139: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
140: , p6_a3 out nocopy JTF_NUMBER_TABLE
141: , p6_a4 out nocopy JTF_NUMBER_TABLE
142: , p6_a5 out nocopy JTF_NUMBER_TABLE
143: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 145: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

141: , p6_a4 out nocopy JTF_NUMBER_TABLE
142: , p6_a5 out nocopy JTF_NUMBER_TABLE
143: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
144: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_800
145: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
146: , p6_a9 out nocopy JTF_NUMBER_TABLE
147: , p6_a10 out nocopy JTF_DATE_TABLE
148: , p6_a11 out nocopy JTF_NUMBER_TABLE
149: , p6_a12 out nocopy JTF_DATE_TABLE

Line 179: , p5_a2 JTF_VARCHAR2_TABLE_100

175: , x_msg_count out nocopy NUMBER
176: , x_msg_data out nocopy VARCHAR2
177: , p5_a0 JTF_NUMBER_TABLE
178: , p5_a1 JTF_NUMBER_TABLE
179: , p5_a2 JTF_VARCHAR2_TABLE_100
180: , p5_a3 JTF_NUMBER_TABLE
181: , p5_a4 JTF_NUMBER_TABLE
182: , p5_a5 JTF_NUMBER_TABLE
183: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 185: , p5_a8 JTF_VARCHAR2_TABLE_100

181: , p5_a4 JTF_NUMBER_TABLE
182: , p5_a5 JTF_NUMBER_TABLE
183: , p5_a6 JTF_VARCHAR2_TABLE_300
184: , p5_a7 JTF_VARCHAR2_TABLE_800
185: , p5_a8 JTF_VARCHAR2_TABLE_100
186: , p5_a9 JTF_NUMBER_TABLE
187: , p5_a10 JTF_DATE_TABLE
188: , p5_a11 JTF_NUMBER_TABLE
189: , p5_a12 JTF_DATE_TABLE

Line 233: , p5_a2 JTF_VARCHAR2_TABLE_100

229: , x_msg_count out nocopy NUMBER
230: , x_msg_data out nocopy VARCHAR2
231: , p5_a0 JTF_NUMBER_TABLE
232: , p5_a1 JTF_NUMBER_TABLE
233: , p5_a2 JTF_VARCHAR2_TABLE_100
234: , p5_a3 JTF_NUMBER_TABLE
235: , p5_a4 JTF_NUMBER_TABLE
236: , p5_a5 JTF_NUMBER_TABLE
237: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 239: , p5_a8 JTF_VARCHAR2_TABLE_100

235: , p5_a4 JTF_NUMBER_TABLE
236: , p5_a5 JTF_NUMBER_TABLE
237: , p5_a6 JTF_VARCHAR2_TABLE_300
238: , p5_a7 JTF_VARCHAR2_TABLE_800
239: , p5_a8 JTF_VARCHAR2_TABLE_100
240: , p5_a9 JTF_NUMBER_TABLE
241: , p5_a10 JTF_DATE_TABLE
242: , p5_a11 JTF_NUMBER_TABLE
243: , p5_a12 JTF_DATE_TABLE

Line 247: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

243: , p5_a12 JTF_DATE_TABLE
244: , p5_a13 JTF_NUMBER_TABLE
245: , p6_a0 out nocopy JTF_NUMBER_TABLE
246: , p6_a1 out nocopy JTF_NUMBER_TABLE
247: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a3 out nocopy JTF_NUMBER_TABLE
249: , p6_a4 out nocopy JTF_NUMBER_TABLE
250: , p6_a5 out nocopy JTF_NUMBER_TABLE
251: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 253: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

249: , p6_a4 out nocopy JTF_NUMBER_TABLE
250: , p6_a5 out nocopy JTF_NUMBER_TABLE
251: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
252: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_800
253: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
254: , p6_a9 out nocopy JTF_NUMBER_TABLE
255: , p6_a10 out nocopy JTF_DATE_TABLE
256: , p6_a11 out nocopy JTF_NUMBER_TABLE
257: , p6_a12 out nocopy JTF_DATE_TABLE

Line 287: , p5_a2 JTF_VARCHAR2_TABLE_100

283: , x_msg_count out nocopy NUMBER
284: , x_msg_data out nocopy VARCHAR2
285: , p5_a0 JTF_NUMBER_TABLE
286: , p5_a1 JTF_NUMBER_TABLE
287: , p5_a2 JTF_VARCHAR2_TABLE_100
288: , p5_a3 JTF_NUMBER_TABLE
289: , p5_a4 JTF_NUMBER_TABLE
290: , p5_a5 JTF_NUMBER_TABLE
291: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 293: , p5_a8 JTF_VARCHAR2_TABLE_100

289: , p5_a4 JTF_NUMBER_TABLE
290: , p5_a5 JTF_NUMBER_TABLE
291: , p5_a6 JTF_VARCHAR2_TABLE_300
292: , p5_a7 JTF_VARCHAR2_TABLE_800
293: , p5_a8 JTF_VARCHAR2_TABLE_100
294: , p5_a9 JTF_NUMBER_TABLE
295: , p5_a10 JTF_DATE_TABLE
296: , p5_a11 JTF_NUMBER_TABLE
297: , p5_a12 JTF_DATE_TABLE

Line 327: , p5_a2 JTF_VARCHAR2_TABLE_100

323: , x_msg_count out nocopy NUMBER
324: , x_msg_data out nocopy VARCHAR2
325: , p5_a0 JTF_NUMBER_TABLE
326: , p5_a1 JTF_NUMBER_TABLE
327: , p5_a2 JTF_VARCHAR2_TABLE_100
328: , p5_a3 JTF_NUMBER_TABLE
329: , p5_a4 JTF_NUMBER_TABLE
330: , p5_a5 JTF_NUMBER_TABLE
331: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 333: , p5_a8 JTF_VARCHAR2_TABLE_100

329: , p5_a4 JTF_NUMBER_TABLE
330: , p5_a5 JTF_NUMBER_TABLE
331: , p5_a6 JTF_VARCHAR2_TABLE_300
332: , p5_a7 JTF_VARCHAR2_TABLE_800
333: , p5_a8 JTF_VARCHAR2_TABLE_100
334: , p5_a9 JTF_NUMBER_TABLE
335: , p5_a10 JTF_DATE_TABLE
336: , p5_a11 JTF_NUMBER_TABLE
337: , p5_a12 JTF_DATE_TABLE