DBA Data[Home] [Help]

APPS.OKL_PQY_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 4: , a1 JTF_VARCHAR2_TABLE_200

1: package okl_pqy_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIPQYS.pls 115.5 2002/12/24 04:09:21 sgorantl noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pqy_pvt.pqy_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_2000
8: , a5 JTF_DATE_TABLE

Line 7: , a4 JTF_VARCHAR2_TABLE_2000

3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pqy_pvt.pqy_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_2000
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE

Line 17: , a1 out nocopy JTF_VARCHAR2_TABLE_200

13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: );
16: procedure rosetta_table_copy_out_p2(t okl_pqy_pvt.pqy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_VARCHAR2_TABLE_200
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_NUMBER_TABLE
20: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
21: , a5 out nocopy JTF_DATE_TABLE

Line 20: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

16: procedure rosetta_table_copy_out_p2(t okl_pqy_pvt.pqy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_VARCHAR2_TABLE_200
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_NUMBER_TABLE
20: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
21: , a5 out nocopy JTF_DATE_TABLE
22: , a6 out nocopy JTF_DATE_TABLE
23: , a7 out nocopy JTF_NUMBER_TABLE
24: , a8 out nocopy JTF_DATE_TABLE

Line 32: , a2 JTF_VARCHAR2_TABLE_200

28: );
29:
30: procedure rosetta_table_copy_in_p5(t out nocopy okl_pqy_pvt.pqyv_tbl_type, a0 JTF_NUMBER_TABLE
31: , a1 JTF_NUMBER_TABLE
32: , a2 JTF_VARCHAR2_TABLE_200
33: , a3 JTF_VARCHAR2_TABLE_2000
34: , a4 JTF_VARCHAR2_TABLE_100
35: , a5 JTF_DATE_TABLE
36: , a6 JTF_DATE_TABLE

Line 33: , a3 JTF_VARCHAR2_TABLE_2000

29:
30: procedure rosetta_table_copy_in_p5(t out nocopy okl_pqy_pvt.pqyv_tbl_type, a0 JTF_NUMBER_TABLE
31: , a1 JTF_NUMBER_TABLE
32: , a2 JTF_VARCHAR2_TABLE_200
33: , a3 JTF_VARCHAR2_TABLE_2000
34: , a4 JTF_VARCHAR2_TABLE_100
35: , a5 JTF_DATE_TABLE
36: , a6 JTF_DATE_TABLE
37: , a7 JTF_NUMBER_TABLE

Line 45: , a2 out nocopy JTF_VARCHAR2_TABLE_200

41: , a11 JTF_NUMBER_TABLE
42: );
43: procedure rosetta_table_copy_out_p5(t okl_pqy_pvt.pqyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
44: , a1 out nocopy JTF_NUMBER_TABLE
45: , a2 out nocopy JTF_VARCHAR2_TABLE_200
46: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a4 out nocopy JTF_VARCHAR2_TABLE_100
48: , a5 out nocopy JTF_DATE_TABLE
49: , a6 out nocopy JTF_DATE_TABLE

Line 46: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

42: );
43: procedure rosetta_table_copy_out_p5(t okl_pqy_pvt.pqyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
44: , a1 out nocopy JTF_NUMBER_TABLE
45: , a2 out nocopy JTF_VARCHAR2_TABLE_200
46: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a4 out nocopy JTF_VARCHAR2_TABLE_100
48: , a5 out nocopy JTF_DATE_TABLE
49: , a6 out nocopy JTF_DATE_TABLE
50: , a7 out nocopy JTF_NUMBER_TABLE

Line 94: , p5_a2 JTF_VARCHAR2_TABLE_200

90: , x_msg_count out nocopy NUMBER
91: , x_msg_data out nocopy VARCHAR2
92: , p5_a0 JTF_NUMBER_TABLE
93: , p5_a1 JTF_NUMBER_TABLE
94: , p5_a2 JTF_VARCHAR2_TABLE_200
95: , p5_a3 JTF_VARCHAR2_TABLE_2000
96: , p5_a4 JTF_VARCHAR2_TABLE_100
97: , p5_a5 JTF_DATE_TABLE
98: , p5_a6 JTF_DATE_TABLE

Line 95: , p5_a3 JTF_VARCHAR2_TABLE_2000

91: , x_msg_data out nocopy VARCHAR2
92: , p5_a0 JTF_NUMBER_TABLE
93: , p5_a1 JTF_NUMBER_TABLE
94: , p5_a2 JTF_VARCHAR2_TABLE_200
95: , p5_a3 JTF_VARCHAR2_TABLE_2000
96: , p5_a4 JTF_VARCHAR2_TABLE_100
97: , p5_a5 JTF_DATE_TABLE
98: , p5_a6 JTF_DATE_TABLE
99: , p5_a7 JTF_NUMBER_TABLE

Line 106: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

102: , p5_a10 JTF_DATE_TABLE
103: , p5_a11 JTF_NUMBER_TABLE
104: , p6_a0 out nocopy JTF_NUMBER_TABLE
105: , p6_a1 out nocopy JTF_NUMBER_TABLE
106: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
107: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
108: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
109: , p6_a5 out nocopy JTF_DATE_TABLE
110: , p6_a6 out nocopy JTF_DATE_TABLE

Line 107: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

103: , p5_a11 JTF_NUMBER_TABLE
104: , p6_a0 out nocopy JTF_NUMBER_TABLE
105: , p6_a1 out nocopy JTF_NUMBER_TABLE
106: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
107: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
108: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
109: , p6_a5 out nocopy JTF_DATE_TABLE
110: , p6_a6 out nocopy JTF_DATE_TABLE
111: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 142: , p5_a2 JTF_VARCHAR2_TABLE_200

138: , x_msg_count out nocopy NUMBER
139: , x_msg_data out nocopy VARCHAR2
140: , p5_a0 JTF_NUMBER_TABLE
141: , p5_a1 JTF_NUMBER_TABLE
142: , p5_a2 JTF_VARCHAR2_TABLE_200
143: , p5_a3 JTF_VARCHAR2_TABLE_2000
144: , p5_a4 JTF_VARCHAR2_TABLE_100
145: , p5_a5 JTF_DATE_TABLE
146: , p5_a6 JTF_DATE_TABLE

Line 143: , p5_a3 JTF_VARCHAR2_TABLE_2000

139: , x_msg_data out nocopy VARCHAR2
140: , p5_a0 JTF_NUMBER_TABLE
141: , p5_a1 JTF_NUMBER_TABLE
142: , p5_a2 JTF_VARCHAR2_TABLE_200
143: , p5_a3 JTF_VARCHAR2_TABLE_2000
144: , p5_a4 JTF_VARCHAR2_TABLE_100
145: , p5_a5 JTF_DATE_TABLE
146: , p5_a6 JTF_DATE_TABLE
147: , p5_a7 JTF_NUMBER_TABLE

Line 190: , p5_a2 JTF_VARCHAR2_TABLE_200

186: , x_msg_count out nocopy NUMBER
187: , x_msg_data out nocopy VARCHAR2
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_VARCHAR2_TABLE_200
191: , p5_a3 JTF_VARCHAR2_TABLE_2000
192: , p5_a4 JTF_VARCHAR2_TABLE_100
193: , p5_a5 JTF_DATE_TABLE
194: , p5_a6 JTF_DATE_TABLE

Line 191: , p5_a3 JTF_VARCHAR2_TABLE_2000

187: , x_msg_data out nocopy VARCHAR2
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_VARCHAR2_TABLE_200
191: , p5_a3 JTF_VARCHAR2_TABLE_2000
192: , p5_a4 JTF_VARCHAR2_TABLE_100
193: , p5_a5 JTF_DATE_TABLE
194: , p5_a6 JTF_DATE_TABLE
195: , p5_a7 JTF_NUMBER_TABLE

Line 202: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

198: , p5_a10 JTF_DATE_TABLE
199: , p5_a11 JTF_NUMBER_TABLE
200: , p6_a0 out nocopy JTF_NUMBER_TABLE
201: , p6_a1 out nocopy JTF_NUMBER_TABLE
202: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
203: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
204: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
205: , p6_a5 out nocopy JTF_DATE_TABLE
206: , p6_a6 out nocopy JTF_DATE_TABLE

Line 203: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

199: , p5_a11 JTF_NUMBER_TABLE
200: , p6_a0 out nocopy JTF_NUMBER_TABLE
201: , p6_a1 out nocopy JTF_NUMBER_TABLE
202: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
203: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
204: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
205: , p6_a5 out nocopy JTF_DATE_TABLE
206: , p6_a6 out nocopy JTF_DATE_TABLE
207: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 238: , p5_a2 JTF_VARCHAR2_TABLE_200

234: , x_msg_count out nocopy NUMBER
235: , x_msg_data out nocopy VARCHAR2
236: , p5_a0 JTF_NUMBER_TABLE
237: , p5_a1 JTF_NUMBER_TABLE
238: , p5_a2 JTF_VARCHAR2_TABLE_200
239: , p5_a3 JTF_VARCHAR2_TABLE_2000
240: , p5_a4 JTF_VARCHAR2_TABLE_100
241: , p5_a5 JTF_DATE_TABLE
242: , p5_a6 JTF_DATE_TABLE

Line 239: , p5_a3 JTF_VARCHAR2_TABLE_2000

235: , x_msg_data out nocopy VARCHAR2
236: , p5_a0 JTF_NUMBER_TABLE
237: , p5_a1 JTF_NUMBER_TABLE
238: , p5_a2 JTF_VARCHAR2_TABLE_200
239: , p5_a3 JTF_VARCHAR2_TABLE_2000
240: , p5_a4 JTF_VARCHAR2_TABLE_100
241: , p5_a5 JTF_DATE_TABLE
242: , p5_a6 JTF_DATE_TABLE
243: , p5_a7 JTF_NUMBER_TABLE

Line 274: , p5_a2 JTF_VARCHAR2_TABLE_200

270: , x_msg_count out nocopy NUMBER
271: , x_msg_data out nocopy VARCHAR2
272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_200
275: , p5_a3 JTF_VARCHAR2_TABLE_2000
276: , p5_a4 JTF_VARCHAR2_TABLE_100
277: , p5_a5 JTF_DATE_TABLE
278: , p5_a6 JTF_DATE_TABLE

Line 275: , p5_a3 JTF_VARCHAR2_TABLE_2000

271: , x_msg_data out nocopy VARCHAR2
272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_200
275: , p5_a3 JTF_VARCHAR2_TABLE_2000
276: , p5_a4 JTF_VARCHAR2_TABLE_100
277: , p5_a5 JTF_DATE_TABLE
278: , p5_a6 JTF_DATE_TABLE
279: , p5_a7 JTF_NUMBER_TABLE