DBA Data[Home] [Help]

APPS.OKL_PTQ_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 4: , a1 JTF_VARCHAR2_TABLE_200

1: package okl_ptq_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIPTQS.pls 115.3 2002/12/24 04:09:52 sgorantl noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ptq_pvt.ptq_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE

Line 6: , a3 JTF_VARCHAR2_TABLE_2000

2: /* $Header: OKLIPTQS.pls 115.3 2002/12/24 04:09:52 sgorantl noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ptq_pvt.ptq_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE

Line 16: , a1 out nocopy JTF_VARCHAR2_TABLE_200

12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p2(t okl_ptq_pvt.ptq_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_200
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
19: , a4 out nocopy JTF_DATE_TABLE
20: , a5 out nocopy JTF_DATE_TABLE

Line 18: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

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

Line 30: , a2 JTF_VARCHAR2_TABLE_200

26: );
27:
28: procedure rosetta_table_copy_in_p5(t out nocopy okl_ptq_pvt.ptqv_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_NUMBER_TABLE
30: , a2 JTF_VARCHAR2_TABLE_200
31: , a3 JTF_VARCHAR2_TABLE_2000
32: , a4 JTF_DATE_TABLE
33: , a5 JTF_DATE_TABLE
34: , a6 JTF_NUMBER_TABLE

Line 31: , a3 JTF_VARCHAR2_TABLE_2000

27:
28: procedure rosetta_table_copy_in_p5(t out nocopy okl_ptq_pvt.ptqv_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_NUMBER_TABLE
30: , a2 JTF_VARCHAR2_TABLE_200
31: , a3 JTF_VARCHAR2_TABLE_2000
32: , a4 JTF_DATE_TABLE
33: , a5 JTF_DATE_TABLE
34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_DATE_TABLE

Line 42: , a2 out nocopy JTF_VARCHAR2_TABLE_200

38: , a10 JTF_NUMBER_TABLE
39: );
40: procedure rosetta_table_copy_out_p5(t okl_ptq_pvt.ptqv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_200
43: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
44: , a4 out nocopy JTF_DATE_TABLE
45: , a5 out nocopy JTF_DATE_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE

Line 43: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

39: );
40: procedure rosetta_table_copy_out_p5(t okl_ptq_pvt.ptqv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_200
43: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
44: , a4 out nocopy JTF_DATE_TABLE
45: , a5 out nocopy JTF_DATE_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_DATE_TABLE

Line 88: , p5_a2 JTF_VARCHAR2_TABLE_200

84: , x_msg_count out nocopy NUMBER
85: , x_msg_data out nocopy VARCHAR2
86: , p5_a0 JTF_NUMBER_TABLE
87: , p5_a1 JTF_NUMBER_TABLE
88: , p5_a2 JTF_VARCHAR2_TABLE_200
89: , p5_a3 JTF_VARCHAR2_TABLE_2000
90: , p5_a4 JTF_DATE_TABLE
91: , p5_a5 JTF_DATE_TABLE
92: , p5_a6 JTF_NUMBER_TABLE

Line 89: , p5_a3 JTF_VARCHAR2_TABLE_2000

85: , x_msg_data out nocopy VARCHAR2
86: , p5_a0 JTF_NUMBER_TABLE
87: , p5_a1 JTF_NUMBER_TABLE
88: , p5_a2 JTF_VARCHAR2_TABLE_200
89: , p5_a3 JTF_VARCHAR2_TABLE_2000
90: , p5_a4 JTF_DATE_TABLE
91: , p5_a5 JTF_DATE_TABLE
92: , p5_a6 JTF_NUMBER_TABLE
93: , p5_a7 JTF_DATE_TABLE

Line 99: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

95: , p5_a9 JTF_DATE_TABLE
96: , p5_a10 JTF_NUMBER_TABLE
97: , p6_a0 out nocopy JTF_NUMBER_TABLE
98: , p6_a1 out nocopy JTF_NUMBER_TABLE
99: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
100: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
101: , p6_a4 out nocopy JTF_DATE_TABLE
102: , p6_a5 out nocopy JTF_DATE_TABLE
103: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 100: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

96: , p5_a10 JTF_NUMBER_TABLE
97: , p6_a0 out nocopy JTF_NUMBER_TABLE
98: , p6_a1 out nocopy JTF_NUMBER_TABLE
99: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
100: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
101: , p6_a4 out nocopy JTF_DATE_TABLE
102: , p6_a5 out nocopy JTF_DATE_TABLE
103: , p6_a6 out nocopy JTF_NUMBER_TABLE
104: , p6_a7 out nocopy JTF_DATE_TABLE

Line 133: , p5_a2 JTF_VARCHAR2_TABLE_200

129: , x_msg_count out nocopy NUMBER
130: , x_msg_data out nocopy VARCHAR2
131: , p5_a0 JTF_NUMBER_TABLE
132: , p5_a1 JTF_NUMBER_TABLE
133: , p5_a2 JTF_VARCHAR2_TABLE_200
134: , p5_a3 JTF_VARCHAR2_TABLE_2000
135: , p5_a4 JTF_DATE_TABLE
136: , p5_a5 JTF_DATE_TABLE
137: , p5_a6 JTF_NUMBER_TABLE

Line 134: , p5_a3 JTF_VARCHAR2_TABLE_2000

130: , x_msg_data out nocopy VARCHAR2
131: , p5_a0 JTF_NUMBER_TABLE
132: , p5_a1 JTF_NUMBER_TABLE
133: , p5_a2 JTF_VARCHAR2_TABLE_200
134: , p5_a3 JTF_VARCHAR2_TABLE_2000
135: , p5_a4 JTF_DATE_TABLE
136: , p5_a5 JTF_DATE_TABLE
137: , p5_a6 JTF_NUMBER_TABLE
138: , p5_a7 JTF_DATE_TABLE

Line 178: , p5_a2 JTF_VARCHAR2_TABLE_200

174: , x_msg_count out nocopy NUMBER
175: , x_msg_data out nocopy VARCHAR2
176: , p5_a0 JTF_NUMBER_TABLE
177: , p5_a1 JTF_NUMBER_TABLE
178: , p5_a2 JTF_VARCHAR2_TABLE_200
179: , p5_a3 JTF_VARCHAR2_TABLE_2000
180: , p5_a4 JTF_DATE_TABLE
181: , p5_a5 JTF_DATE_TABLE
182: , p5_a6 JTF_NUMBER_TABLE

Line 179: , p5_a3 JTF_VARCHAR2_TABLE_2000

175: , x_msg_data out nocopy VARCHAR2
176: , p5_a0 JTF_NUMBER_TABLE
177: , p5_a1 JTF_NUMBER_TABLE
178: , p5_a2 JTF_VARCHAR2_TABLE_200
179: , p5_a3 JTF_VARCHAR2_TABLE_2000
180: , p5_a4 JTF_DATE_TABLE
181: , p5_a5 JTF_DATE_TABLE
182: , p5_a6 JTF_NUMBER_TABLE
183: , p5_a7 JTF_DATE_TABLE

Line 189: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

185: , p5_a9 JTF_DATE_TABLE
186: , p5_a10 JTF_NUMBER_TABLE
187: , p6_a0 out nocopy JTF_NUMBER_TABLE
188: , p6_a1 out nocopy JTF_NUMBER_TABLE
189: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
190: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
191: , p6_a4 out nocopy JTF_DATE_TABLE
192: , p6_a5 out nocopy JTF_DATE_TABLE
193: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 190: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

186: , p5_a10 JTF_NUMBER_TABLE
187: , p6_a0 out nocopy JTF_NUMBER_TABLE
188: , p6_a1 out nocopy JTF_NUMBER_TABLE
189: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
190: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
191: , p6_a4 out nocopy JTF_DATE_TABLE
192: , p6_a5 out nocopy JTF_DATE_TABLE
193: , p6_a6 out nocopy JTF_NUMBER_TABLE
194: , p6_a7 out nocopy JTF_DATE_TABLE

Line 223: , p5_a2 JTF_VARCHAR2_TABLE_200

219: , x_msg_count out nocopy NUMBER
220: , x_msg_data out nocopy VARCHAR2
221: , p5_a0 JTF_NUMBER_TABLE
222: , p5_a1 JTF_NUMBER_TABLE
223: , p5_a2 JTF_VARCHAR2_TABLE_200
224: , p5_a3 JTF_VARCHAR2_TABLE_2000
225: , p5_a4 JTF_DATE_TABLE
226: , p5_a5 JTF_DATE_TABLE
227: , p5_a6 JTF_NUMBER_TABLE

Line 224: , p5_a3 JTF_VARCHAR2_TABLE_2000

220: , x_msg_data out nocopy VARCHAR2
221: , p5_a0 JTF_NUMBER_TABLE
222: , p5_a1 JTF_NUMBER_TABLE
223: , p5_a2 JTF_VARCHAR2_TABLE_200
224: , p5_a3 JTF_VARCHAR2_TABLE_2000
225: , p5_a4 JTF_DATE_TABLE
226: , p5_a5 JTF_DATE_TABLE
227: , p5_a6 JTF_NUMBER_TABLE
228: , p5_a7 JTF_DATE_TABLE

Line 257: , p5_a2 JTF_VARCHAR2_TABLE_200

253: , x_msg_count out nocopy NUMBER
254: , x_msg_data out nocopy VARCHAR2
255: , p5_a0 JTF_NUMBER_TABLE
256: , p5_a1 JTF_NUMBER_TABLE
257: , p5_a2 JTF_VARCHAR2_TABLE_200
258: , p5_a3 JTF_VARCHAR2_TABLE_2000
259: , p5_a4 JTF_DATE_TABLE
260: , p5_a5 JTF_DATE_TABLE
261: , p5_a6 JTF_NUMBER_TABLE

Line 258: , p5_a3 JTF_VARCHAR2_TABLE_2000

254: , x_msg_data out nocopy VARCHAR2
255: , p5_a0 JTF_NUMBER_TABLE
256: , p5_a1 JTF_NUMBER_TABLE
257: , p5_a2 JTF_VARCHAR2_TABLE_200
258: , p5_a3 JTF_VARCHAR2_TABLE_2000
259: , p5_a4 JTF_DATE_TABLE
260: , p5_a5 JTF_DATE_TABLE
261: , p5_a6 JTF_NUMBER_TABLE
262: , p5_a7 JTF_DATE_TABLE