APPS.OKL_STY_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sty_pvt.sty_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_sty_pvt_w as
2: /* $Header: OKLISTYS.pls 120.3 2008/01/29 17:21:59 gkadarka ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sty_pvt.sty_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100

Line 8: , a5 JTF_NUMBER_TABLE

4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100

Line 36: , a33 JTF_NUMBER_TABLE

32: , a29 JTF_VARCHAR2_TABLE_500
33: , a30 JTF_VARCHAR2_TABLE_500
34: , a31 JTF_VARCHAR2_TABLE_500
35: , a32 JTF_VARCHAR2_TABLE_500
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE

Line 38: , a35 JTF_NUMBER_TABLE

34: , a31 JTF_VARCHAR2_TABLE_500
35: , a32 JTF_VARCHAR2_TABLE_500
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100

Line 40: , a37 JTF_NUMBER_TABLE

36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_DATE_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_NUMBER_TABLE
44: );

Line 43: , a40 JTF_NUMBER_TABLE

39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_NUMBER_TABLE
44: );
45: procedure rosetta_table_copy_out_p2(t okl_sty_pvt.sty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_VARCHAR2_TABLE_100
47: , a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 45: procedure rosetta_table_copy_out_p2(t okl_sty_pvt.sty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_NUMBER_TABLE
44: );
45: procedure rosetta_table_copy_out_p2(t okl_sty_pvt.sty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_VARCHAR2_TABLE_100
47: , a2 out nocopy JTF_VARCHAR2_TABLE_200
48: , a3 out nocopy JTF_VARCHAR2_TABLE_100
49: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 50: , a5 out nocopy JTF_NUMBER_TABLE

46: , a1 out nocopy JTF_VARCHAR2_TABLE_100
47: , a2 out nocopy JTF_VARCHAR2_TABLE_200
48: , a3 out nocopy JTF_VARCHAR2_TABLE_100
49: , a4 out nocopy JTF_VARCHAR2_TABLE_100
50: , a5 out nocopy JTF_NUMBER_TABLE
51: , a6 out nocopy JTF_VARCHAR2_TABLE_100
52: , a7 out nocopy JTF_VARCHAR2_TABLE_100
53: , a8 out nocopy JTF_VARCHAR2_TABLE_100
54: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 78: , a33 out nocopy JTF_NUMBER_TABLE

74: , a29 out nocopy JTF_VARCHAR2_TABLE_500
75: , a30 out nocopy JTF_VARCHAR2_TABLE_500
76: , a31 out nocopy JTF_VARCHAR2_TABLE_500
77: , a32 out nocopy JTF_VARCHAR2_TABLE_500
78: , a33 out nocopy JTF_NUMBER_TABLE
79: , a34 out nocopy JTF_DATE_TABLE
80: , a35 out nocopy JTF_NUMBER_TABLE
81: , a36 out nocopy JTF_DATE_TABLE
82: , a37 out nocopy JTF_NUMBER_TABLE

Line 80: , a35 out nocopy JTF_NUMBER_TABLE

76: , a31 out nocopy JTF_VARCHAR2_TABLE_500
77: , a32 out nocopy JTF_VARCHAR2_TABLE_500
78: , a33 out nocopy JTF_NUMBER_TABLE
79: , a34 out nocopy JTF_DATE_TABLE
80: , a35 out nocopy JTF_NUMBER_TABLE
81: , a36 out nocopy JTF_DATE_TABLE
82: , a37 out nocopy JTF_NUMBER_TABLE
83: , a38 out nocopy JTF_VARCHAR2_TABLE_100
84: , a39 out nocopy JTF_VARCHAR2_TABLE_100

Line 82: , a37 out nocopy JTF_NUMBER_TABLE

78: , a33 out nocopy JTF_NUMBER_TABLE
79: , a34 out nocopy JTF_DATE_TABLE
80: , a35 out nocopy JTF_NUMBER_TABLE
81: , a36 out nocopy JTF_DATE_TABLE
82: , a37 out nocopy JTF_NUMBER_TABLE
83: , a38 out nocopy JTF_VARCHAR2_TABLE_100
84: , a39 out nocopy JTF_VARCHAR2_TABLE_100
85: , a40 out nocopy JTF_NUMBER_TABLE
86: );

Line 85: , a40 out nocopy JTF_NUMBER_TABLE

81: , a36 out nocopy JTF_DATE_TABLE
82: , a37 out nocopy JTF_NUMBER_TABLE
83: , a38 out nocopy JTF_VARCHAR2_TABLE_100
84: , a39 out nocopy JTF_VARCHAR2_TABLE_100
85: , a40 out nocopy JTF_NUMBER_TABLE
86: );
87:
88: procedure rosetta_table_copy_in_p5(t out nocopy okl_sty_pvt.okl_strm_type_tl_tbl_type, a0 JTF_NUMBER_TABLE
89: , a1 JTF_VARCHAR2_TABLE_100

Line 88: procedure rosetta_table_copy_in_p5(t out nocopy okl_sty_pvt.okl_strm_type_tl_tbl_type, a0 JTF_NUMBER_TABLE

84: , a39 out nocopy JTF_VARCHAR2_TABLE_100
85: , a40 out nocopy JTF_NUMBER_TABLE
86: );
87:
88: procedure rosetta_table_copy_in_p5(t out nocopy okl_sty_pvt.okl_strm_type_tl_tbl_type, a0 JTF_NUMBER_TABLE
89: , a1 JTF_VARCHAR2_TABLE_100
90: , a2 JTF_VARCHAR2_TABLE_100
91: , a3 JTF_VARCHAR2_TABLE_100
92: , a4 JTF_VARCHAR2_TABLE_200

Line 94: , a6 JTF_NUMBER_TABLE

90: , a2 JTF_VARCHAR2_TABLE_100
91: , a3 JTF_VARCHAR2_TABLE_100
92: , a4 JTF_VARCHAR2_TABLE_200
93: , a5 JTF_VARCHAR2_TABLE_2000
94: , a6 JTF_NUMBER_TABLE
95: , a7 JTF_DATE_TABLE
96: , a8 JTF_NUMBER_TABLE
97: , a9 JTF_DATE_TABLE
98: , a10 JTF_NUMBER_TABLE

Line 96: , a8 JTF_NUMBER_TABLE

92: , a4 JTF_VARCHAR2_TABLE_200
93: , a5 JTF_VARCHAR2_TABLE_2000
94: , a6 JTF_NUMBER_TABLE
95: , a7 JTF_DATE_TABLE
96: , a8 JTF_NUMBER_TABLE
97: , a9 JTF_DATE_TABLE
98: , a10 JTF_NUMBER_TABLE
99: , a11 JTF_VARCHAR2_TABLE_600
100: );

Line 98: , a10 JTF_NUMBER_TABLE

94: , a6 JTF_NUMBER_TABLE
95: , a7 JTF_DATE_TABLE
96: , a8 JTF_NUMBER_TABLE
97: , a9 JTF_DATE_TABLE
98: , a10 JTF_NUMBER_TABLE
99: , a11 JTF_VARCHAR2_TABLE_600
100: );
101: procedure rosetta_table_copy_out_p5(t okl_sty_pvt.okl_strm_type_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 101: procedure rosetta_table_copy_out_p5(t okl_sty_pvt.okl_strm_type_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

97: , a9 JTF_DATE_TABLE
98: , a10 JTF_NUMBER_TABLE
99: , a11 JTF_VARCHAR2_TABLE_600
100: );
101: procedure rosetta_table_copy_out_p5(t okl_sty_pvt.okl_strm_type_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_VARCHAR2_TABLE_100
103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
104: , a3 out nocopy JTF_VARCHAR2_TABLE_100
105: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 107: , a6 out nocopy JTF_NUMBER_TABLE

103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
104: , a3 out nocopy JTF_VARCHAR2_TABLE_100
105: , a4 out nocopy JTF_VARCHAR2_TABLE_200
106: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
107: , a6 out nocopy JTF_NUMBER_TABLE
108: , a7 out nocopy JTF_DATE_TABLE
109: , a8 out nocopy JTF_NUMBER_TABLE
110: , a9 out nocopy JTF_DATE_TABLE
111: , a10 out nocopy JTF_NUMBER_TABLE

Line 109: , a8 out nocopy JTF_NUMBER_TABLE

105: , a4 out nocopy JTF_VARCHAR2_TABLE_200
106: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
107: , a6 out nocopy JTF_NUMBER_TABLE
108: , a7 out nocopy JTF_DATE_TABLE
109: , a8 out nocopy JTF_NUMBER_TABLE
110: , a9 out nocopy JTF_DATE_TABLE
111: , a10 out nocopy JTF_NUMBER_TABLE
112: , a11 out nocopy JTF_VARCHAR2_TABLE_600
113: );

Line 111: , a10 out nocopy JTF_NUMBER_TABLE

107: , a6 out nocopy JTF_NUMBER_TABLE
108: , a7 out nocopy JTF_DATE_TABLE
109: , a8 out nocopy JTF_NUMBER_TABLE
110: , a9 out nocopy JTF_DATE_TABLE
111: , a10 out nocopy JTF_NUMBER_TABLE
112: , a11 out nocopy JTF_VARCHAR2_TABLE_600
113: );
114:
115: procedure rosetta_table_copy_in_p8(t out nocopy okl_sty_pvt.styv_tbl_type, a0 JTF_NUMBER_TABLE

Line 115: procedure rosetta_table_copy_in_p8(t out nocopy okl_sty_pvt.styv_tbl_type, a0 JTF_NUMBER_TABLE

111: , a10 out nocopy JTF_NUMBER_TABLE
112: , a11 out nocopy JTF_VARCHAR2_TABLE_600
113: );
114:
115: procedure rosetta_table_copy_in_p8(t out nocopy okl_sty_pvt.styv_tbl_type, a0 JTF_NUMBER_TABLE
116: , a1 JTF_VARCHAR2_TABLE_200
117: , a2 JTF_VARCHAR2_TABLE_100
118: , a3 JTF_NUMBER_TABLE
119: , a4 JTF_VARCHAR2_TABLE_200

Line 118: , a3 JTF_NUMBER_TABLE

114:
115: procedure rosetta_table_copy_in_p8(t out nocopy okl_sty_pvt.styv_tbl_type, a0 JTF_NUMBER_TABLE
116: , a1 JTF_VARCHAR2_TABLE_200
117: , a2 JTF_VARCHAR2_TABLE_100
118: , a3 JTF_NUMBER_TABLE
119: , a4 JTF_VARCHAR2_TABLE_200
120: , a5 JTF_VARCHAR2_TABLE_100
121: , a6 JTF_VARCHAR2_TABLE_100
122: , a7 JTF_VARCHAR2_TABLE_2000

Line 151: , a36 JTF_NUMBER_TABLE

147: , a32 JTF_VARCHAR2_TABLE_500
148: , a33 JTF_VARCHAR2_TABLE_500
149: , a34 JTF_VARCHAR2_TABLE_500
150: , a35 JTF_VARCHAR2_TABLE_500
151: , a36 JTF_NUMBER_TABLE
152: , a37 JTF_DATE_TABLE
153: , a38 JTF_NUMBER_TABLE
154: , a39 JTF_DATE_TABLE
155: , a40 JTF_NUMBER_TABLE

Line 153: , a38 JTF_NUMBER_TABLE

149: , a34 JTF_VARCHAR2_TABLE_500
150: , a35 JTF_VARCHAR2_TABLE_500
151: , a36 JTF_NUMBER_TABLE
152: , a37 JTF_DATE_TABLE
153: , a38 JTF_NUMBER_TABLE
154: , a39 JTF_DATE_TABLE
155: , a40 JTF_NUMBER_TABLE
156: , a41 JTF_VARCHAR2_TABLE_100
157: , a42 JTF_VARCHAR2_TABLE_100

Line 155: , a40 JTF_NUMBER_TABLE

151: , a36 JTF_NUMBER_TABLE
152: , a37 JTF_DATE_TABLE
153: , a38 JTF_NUMBER_TABLE
154: , a39 JTF_DATE_TABLE
155: , a40 JTF_NUMBER_TABLE
156: , a41 JTF_VARCHAR2_TABLE_100
157: , a42 JTF_VARCHAR2_TABLE_100
158: , a43 JTF_VARCHAR2_TABLE_600
159: , a44 JTF_NUMBER_TABLE

Line 159: , a44 JTF_NUMBER_TABLE

155: , a40 JTF_NUMBER_TABLE
156: , a41 JTF_VARCHAR2_TABLE_100
157: , a42 JTF_VARCHAR2_TABLE_100
158: , a43 JTF_VARCHAR2_TABLE_600
159: , a44 JTF_NUMBER_TABLE
160: );
161: procedure rosetta_table_copy_out_p8(t okl_sty_pvt.styv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
162: , a1 out nocopy JTF_VARCHAR2_TABLE_200
163: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 161: procedure rosetta_table_copy_out_p8(t okl_sty_pvt.styv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

157: , a42 JTF_VARCHAR2_TABLE_100
158: , a43 JTF_VARCHAR2_TABLE_600
159: , a44 JTF_NUMBER_TABLE
160: );
161: procedure rosetta_table_copy_out_p8(t okl_sty_pvt.styv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
162: , a1 out nocopy JTF_VARCHAR2_TABLE_200
163: , a2 out nocopy JTF_VARCHAR2_TABLE_100
164: , a3 out nocopy JTF_NUMBER_TABLE
165: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 164: , a3 out nocopy JTF_NUMBER_TABLE

160: );
161: procedure rosetta_table_copy_out_p8(t okl_sty_pvt.styv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
162: , a1 out nocopy JTF_VARCHAR2_TABLE_200
163: , a2 out nocopy JTF_VARCHAR2_TABLE_100
164: , a3 out nocopy JTF_NUMBER_TABLE
165: , a4 out nocopy JTF_VARCHAR2_TABLE_200
166: , a5 out nocopy JTF_VARCHAR2_TABLE_100
167: , a6 out nocopy JTF_VARCHAR2_TABLE_100
168: , a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 197: , a36 out nocopy JTF_NUMBER_TABLE

193: , a32 out nocopy JTF_VARCHAR2_TABLE_500
194: , a33 out nocopy JTF_VARCHAR2_TABLE_500
195: , a34 out nocopy JTF_VARCHAR2_TABLE_500
196: , a35 out nocopy JTF_VARCHAR2_TABLE_500
197: , a36 out nocopy JTF_NUMBER_TABLE
198: , a37 out nocopy JTF_DATE_TABLE
199: , a38 out nocopy JTF_NUMBER_TABLE
200: , a39 out nocopy JTF_DATE_TABLE
201: , a40 out nocopy JTF_NUMBER_TABLE

Line 199: , a38 out nocopy JTF_NUMBER_TABLE

195: , a34 out nocopy JTF_VARCHAR2_TABLE_500
196: , a35 out nocopy JTF_VARCHAR2_TABLE_500
197: , a36 out nocopy JTF_NUMBER_TABLE
198: , a37 out nocopy JTF_DATE_TABLE
199: , a38 out nocopy JTF_NUMBER_TABLE
200: , a39 out nocopy JTF_DATE_TABLE
201: , a40 out nocopy JTF_NUMBER_TABLE
202: , a41 out nocopy JTF_VARCHAR2_TABLE_100
203: , a42 out nocopy JTF_VARCHAR2_TABLE_100

Line 201: , a40 out nocopy JTF_NUMBER_TABLE

197: , a36 out nocopy JTF_NUMBER_TABLE
198: , a37 out nocopy JTF_DATE_TABLE
199: , a38 out nocopy JTF_NUMBER_TABLE
200: , a39 out nocopy JTF_DATE_TABLE
201: , a40 out nocopy JTF_NUMBER_TABLE
202: , a41 out nocopy JTF_VARCHAR2_TABLE_100
203: , a42 out nocopy JTF_VARCHAR2_TABLE_100
204: , a43 out nocopy JTF_VARCHAR2_TABLE_600
205: , a44 out nocopy JTF_NUMBER_TABLE

Line 205: , a44 out nocopy JTF_NUMBER_TABLE

201: , a40 out nocopy JTF_NUMBER_TABLE
202: , a41 out nocopy JTF_VARCHAR2_TABLE_100
203: , a42 out nocopy JTF_VARCHAR2_TABLE_100
204: , a43 out nocopy JTF_VARCHAR2_TABLE_600
205: , a44 out nocopy JTF_NUMBER_TABLE
206: );
207:
208: procedure insert_row(p_api_version NUMBER
209: , p_init_msg_list VARCHAR2

Line 309: , p5_a0 JTF_NUMBER_TABLE

305: , p_init_msg_list VARCHAR2
306: , x_return_status out nocopy VARCHAR2
307: , x_msg_count out nocopy NUMBER
308: , x_msg_data out nocopy VARCHAR2
309: , p5_a0 JTF_NUMBER_TABLE
310: , p5_a1 JTF_VARCHAR2_TABLE_200
311: , p5_a2 JTF_VARCHAR2_TABLE_100
312: , p5_a3 JTF_NUMBER_TABLE
313: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 312: , p5_a3 JTF_NUMBER_TABLE

308: , x_msg_data out nocopy VARCHAR2
309: , p5_a0 JTF_NUMBER_TABLE
310: , p5_a1 JTF_VARCHAR2_TABLE_200
311: , p5_a2 JTF_VARCHAR2_TABLE_100
312: , p5_a3 JTF_NUMBER_TABLE
313: , p5_a4 JTF_VARCHAR2_TABLE_200
314: , p5_a5 JTF_VARCHAR2_TABLE_100
315: , p5_a6 JTF_VARCHAR2_TABLE_100
316: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 345: , p5_a36 JTF_NUMBER_TABLE

341: , p5_a32 JTF_VARCHAR2_TABLE_500
342: , p5_a33 JTF_VARCHAR2_TABLE_500
343: , p5_a34 JTF_VARCHAR2_TABLE_500
344: , p5_a35 JTF_VARCHAR2_TABLE_500
345: , p5_a36 JTF_NUMBER_TABLE
346: , p5_a37 JTF_DATE_TABLE
347: , p5_a38 JTF_NUMBER_TABLE
348: , p5_a39 JTF_DATE_TABLE
349: , p5_a40 JTF_NUMBER_TABLE

Line 347: , p5_a38 JTF_NUMBER_TABLE

343: , p5_a34 JTF_VARCHAR2_TABLE_500
344: , p5_a35 JTF_VARCHAR2_TABLE_500
345: , p5_a36 JTF_NUMBER_TABLE
346: , p5_a37 JTF_DATE_TABLE
347: , p5_a38 JTF_NUMBER_TABLE
348: , p5_a39 JTF_DATE_TABLE
349: , p5_a40 JTF_NUMBER_TABLE
350: , p5_a41 JTF_VARCHAR2_TABLE_100
351: , p5_a42 JTF_VARCHAR2_TABLE_100

Line 349: , p5_a40 JTF_NUMBER_TABLE

345: , p5_a36 JTF_NUMBER_TABLE
346: , p5_a37 JTF_DATE_TABLE
347: , p5_a38 JTF_NUMBER_TABLE
348: , p5_a39 JTF_DATE_TABLE
349: , p5_a40 JTF_NUMBER_TABLE
350: , p5_a41 JTF_VARCHAR2_TABLE_100
351: , p5_a42 JTF_VARCHAR2_TABLE_100
352: , p5_a43 JTF_VARCHAR2_TABLE_600
353: , p5_a44 JTF_NUMBER_TABLE

Line 353: , p5_a44 JTF_NUMBER_TABLE

349: , p5_a40 JTF_NUMBER_TABLE
350: , p5_a41 JTF_VARCHAR2_TABLE_100
351: , p5_a42 JTF_VARCHAR2_TABLE_100
352: , p5_a43 JTF_VARCHAR2_TABLE_600
353: , p5_a44 JTF_NUMBER_TABLE
354: , p6_a0 out nocopy JTF_NUMBER_TABLE
355: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
356: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
357: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 354: , p6_a0 out nocopy JTF_NUMBER_TABLE

350: , p5_a41 JTF_VARCHAR2_TABLE_100
351: , p5_a42 JTF_VARCHAR2_TABLE_100
352: , p5_a43 JTF_VARCHAR2_TABLE_600
353: , p5_a44 JTF_NUMBER_TABLE
354: , p6_a0 out nocopy JTF_NUMBER_TABLE
355: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
356: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
357: , p6_a3 out nocopy JTF_NUMBER_TABLE
358: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 357: , p6_a3 out nocopy JTF_NUMBER_TABLE

353: , p5_a44 JTF_NUMBER_TABLE
354: , p6_a0 out nocopy JTF_NUMBER_TABLE
355: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
356: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
357: , p6_a3 out nocopy JTF_NUMBER_TABLE
358: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
359: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
360: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
361: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 390: , p6_a36 out nocopy JTF_NUMBER_TABLE

386: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
387: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
388: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
389: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
390: , p6_a36 out nocopy JTF_NUMBER_TABLE
391: , p6_a37 out nocopy JTF_DATE_TABLE
392: , p6_a38 out nocopy JTF_NUMBER_TABLE
393: , p6_a39 out nocopy JTF_DATE_TABLE
394: , p6_a40 out nocopy JTF_NUMBER_TABLE

Line 392: , p6_a38 out nocopy JTF_NUMBER_TABLE

388: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
389: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
390: , p6_a36 out nocopy JTF_NUMBER_TABLE
391: , p6_a37 out nocopy JTF_DATE_TABLE
392: , p6_a38 out nocopy JTF_NUMBER_TABLE
393: , p6_a39 out nocopy JTF_DATE_TABLE
394: , p6_a40 out nocopy JTF_NUMBER_TABLE
395: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
396: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100

Line 394: , p6_a40 out nocopy JTF_NUMBER_TABLE

390: , p6_a36 out nocopy JTF_NUMBER_TABLE
391: , p6_a37 out nocopy JTF_DATE_TABLE
392: , p6_a38 out nocopy JTF_NUMBER_TABLE
393: , p6_a39 out nocopy JTF_DATE_TABLE
394: , p6_a40 out nocopy JTF_NUMBER_TABLE
395: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
396: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
397: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_600
398: , p6_a44 out nocopy JTF_NUMBER_TABLE

Line 398: , p6_a44 out nocopy JTF_NUMBER_TABLE

394: , p6_a40 out nocopy JTF_NUMBER_TABLE
395: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
396: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
397: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_600
398: , p6_a44 out nocopy JTF_NUMBER_TABLE
399: );
400: procedure lock_row(p_api_version NUMBER
401: , p_init_msg_list VARCHAR2
402: , x_return_status out nocopy VARCHAR2

Line 456: , p5_a0 JTF_NUMBER_TABLE

452: , p_init_msg_list VARCHAR2
453: , x_return_status out nocopy VARCHAR2
454: , x_msg_count out nocopy NUMBER
455: , x_msg_data out nocopy VARCHAR2
456: , p5_a0 JTF_NUMBER_TABLE
457: , p5_a1 JTF_VARCHAR2_TABLE_200
458: , p5_a2 JTF_VARCHAR2_TABLE_100
459: , p5_a3 JTF_NUMBER_TABLE
460: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 459: , p5_a3 JTF_NUMBER_TABLE

455: , x_msg_data out nocopy VARCHAR2
456: , p5_a0 JTF_NUMBER_TABLE
457: , p5_a1 JTF_VARCHAR2_TABLE_200
458: , p5_a2 JTF_VARCHAR2_TABLE_100
459: , p5_a3 JTF_NUMBER_TABLE
460: , p5_a4 JTF_VARCHAR2_TABLE_200
461: , p5_a5 JTF_VARCHAR2_TABLE_100
462: , p5_a6 JTF_VARCHAR2_TABLE_100
463: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 492: , p5_a36 JTF_NUMBER_TABLE

488: , p5_a32 JTF_VARCHAR2_TABLE_500
489: , p5_a33 JTF_VARCHAR2_TABLE_500
490: , p5_a34 JTF_VARCHAR2_TABLE_500
491: , p5_a35 JTF_VARCHAR2_TABLE_500
492: , p5_a36 JTF_NUMBER_TABLE
493: , p5_a37 JTF_DATE_TABLE
494: , p5_a38 JTF_NUMBER_TABLE
495: , p5_a39 JTF_DATE_TABLE
496: , p5_a40 JTF_NUMBER_TABLE

Line 494: , p5_a38 JTF_NUMBER_TABLE

490: , p5_a34 JTF_VARCHAR2_TABLE_500
491: , p5_a35 JTF_VARCHAR2_TABLE_500
492: , p5_a36 JTF_NUMBER_TABLE
493: , p5_a37 JTF_DATE_TABLE
494: , p5_a38 JTF_NUMBER_TABLE
495: , p5_a39 JTF_DATE_TABLE
496: , p5_a40 JTF_NUMBER_TABLE
497: , p5_a41 JTF_VARCHAR2_TABLE_100
498: , p5_a42 JTF_VARCHAR2_TABLE_100

Line 496: , p5_a40 JTF_NUMBER_TABLE

492: , p5_a36 JTF_NUMBER_TABLE
493: , p5_a37 JTF_DATE_TABLE
494: , p5_a38 JTF_NUMBER_TABLE
495: , p5_a39 JTF_DATE_TABLE
496: , p5_a40 JTF_NUMBER_TABLE
497: , p5_a41 JTF_VARCHAR2_TABLE_100
498: , p5_a42 JTF_VARCHAR2_TABLE_100
499: , p5_a43 JTF_VARCHAR2_TABLE_600
500: , p5_a44 JTF_NUMBER_TABLE

Line 500: , p5_a44 JTF_NUMBER_TABLE

496: , p5_a40 JTF_NUMBER_TABLE
497: , p5_a41 JTF_VARCHAR2_TABLE_100
498: , p5_a42 JTF_VARCHAR2_TABLE_100
499: , p5_a43 JTF_VARCHAR2_TABLE_600
500: , p5_a44 JTF_NUMBER_TABLE
501: );
502: procedure update_row(p_api_version NUMBER
503: , p_init_msg_list VARCHAR2
504: , x_return_status out nocopy VARCHAR2

Line 603: , p5_a0 JTF_NUMBER_TABLE

599: , p_init_msg_list VARCHAR2
600: , x_return_status out nocopy VARCHAR2
601: , x_msg_count out nocopy NUMBER
602: , x_msg_data out nocopy VARCHAR2
603: , p5_a0 JTF_NUMBER_TABLE
604: , p5_a1 JTF_VARCHAR2_TABLE_200
605: , p5_a2 JTF_VARCHAR2_TABLE_100
606: , p5_a3 JTF_NUMBER_TABLE
607: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 606: , p5_a3 JTF_NUMBER_TABLE

602: , x_msg_data out nocopy VARCHAR2
603: , p5_a0 JTF_NUMBER_TABLE
604: , p5_a1 JTF_VARCHAR2_TABLE_200
605: , p5_a2 JTF_VARCHAR2_TABLE_100
606: , p5_a3 JTF_NUMBER_TABLE
607: , p5_a4 JTF_VARCHAR2_TABLE_200
608: , p5_a5 JTF_VARCHAR2_TABLE_100
609: , p5_a6 JTF_VARCHAR2_TABLE_100
610: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 639: , p5_a36 JTF_NUMBER_TABLE

635: , p5_a32 JTF_VARCHAR2_TABLE_500
636: , p5_a33 JTF_VARCHAR2_TABLE_500
637: , p5_a34 JTF_VARCHAR2_TABLE_500
638: , p5_a35 JTF_VARCHAR2_TABLE_500
639: , p5_a36 JTF_NUMBER_TABLE
640: , p5_a37 JTF_DATE_TABLE
641: , p5_a38 JTF_NUMBER_TABLE
642: , p5_a39 JTF_DATE_TABLE
643: , p5_a40 JTF_NUMBER_TABLE

Line 641: , p5_a38 JTF_NUMBER_TABLE

637: , p5_a34 JTF_VARCHAR2_TABLE_500
638: , p5_a35 JTF_VARCHAR2_TABLE_500
639: , p5_a36 JTF_NUMBER_TABLE
640: , p5_a37 JTF_DATE_TABLE
641: , p5_a38 JTF_NUMBER_TABLE
642: , p5_a39 JTF_DATE_TABLE
643: , p5_a40 JTF_NUMBER_TABLE
644: , p5_a41 JTF_VARCHAR2_TABLE_100
645: , p5_a42 JTF_VARCHAR2_TABLE_100

Line 643: , p5_a40 JTF_NUMBER_TABLE

639: , p5_a36 JTF_NUMBER_TABLE
640: , p5_a37 JTF_DATE_TABLE
641: , p5_a38 JTF_NUMBER_TABLE
642: , p5_a39 JTF_DATE_TABLE
643: , p5_a40 JTF_NUMBER_TABLE
644: , p5_a41 JTF_VARCHAR2_TABLE_100
645: , p5_a42 JTF_VARCHAR2_TABLE_100
646: , p5_a43 JTF_VARCHAR2_TABLE_600
647: , p5_a44 JTF_NUMBER_TABLE

Line 647: , p5_a44 JTF_NUMBER_TABLE

643: , p5_a40 JTF_NUMBER_TABLE
644: , p5_a41 JTF_VARCHAR2_TABLE_100
645: , p5_a42 JTF_VARCHAR2_TABLE_100
646: , p5_a43 JTF_VARCHAR2_TABLE_600
647: , p5_a44 JTF_NUMBER_TABLE
648: , p6_a0 out nocopy JTF_NUMBER_TABLE
649: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
650: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
651: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 648: , p6_a0 out nocopy JTF_NUMBER_TABLE

644: , p5_a41 JTF_VARCHAR2_TABLE_100
645: , p5_a42 JTF_VARCHAR2_TABLE_100
646: , p5_a43 JTF_VARCHAR2_TABLE_600
647: , p5_a44 JTF_NUMBER_TABLE
648: , p6_a0 out nocopy JTF_NUMBER_TABLE
649: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
650: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
651: , p6_a3 out nocopy JTF_NUMBER_TABLE
652: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 651: , p6_a3 out nocopy JTF_NUMBER_TABLE

647: , p5_a44 JTF_NUMBER_TABLE
648: , p6_a0 out nocopy JTF_NUMBER_TABLE
649: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
650: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
651: , p6_a3 out nocopy JTF_NUMBER_TABLE
652: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
653: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
654: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
655: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 684: , p6_a36 out nocopy JTF_NUMBER_TABLE

680: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
681: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
682: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
683: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
684: , p6_a36 out nocopy JTF_NUMBER_TABLE
685: , p6_a37 out nocopy JTF_DATE_TABLE
686: , p6_a38 out nocopy JTF_NUMBER_TABLE
687: , p6_a39 out nocopy JTF_DATE_TABLE
688: , p6_a40 out nocopy JTF_NUMBER_TABLE

Line 686: , p6_a38 out nocopy JTF_NUMBER_TABLE

682: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
683: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
684: , p6_a36 out nocopy JTF_NUMBER_TABLE
685: , p6_a37 out nocopy JTF_DATE_TABLE
686: , p6_a38 out nocopy JTF_NUMBER_TABLE
687: , p6_a39 out nocopy JTF_DATE_TABLE
688: , p6_a40 out nocopy JTF_NUMBER_TABLE
689: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
690: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100

Line 688: , p6_a40 out nocopy JTF_NUMBER_TABLE

684: , p6_a36 out nocopy JTF_NUMBER_TABLE
685: , p6_a37 out nocopy JTF_DATE_TABLE
686: , p6_a38 out nocopy JTF_NUMBER_TABLE
687: , p6_a39 out nocopy JTF_DATE_TABLE
688: , p6_a40 out nocopy JTF_NUMBER_TABLE
689: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
690: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
691: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_600
692: , p6_a44 out nocopy JTF_NUMBER_TABLE

Line 692: , p6_a44 out nocopy JTF_NUMBER_TABLE

688: , p6_a40 out nocopy JTF_NUMBER_TABLE
689: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
690: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
691: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_600
692: , p6_a44 out nocopy JTF_NUMBER_TABLE
693: );
694: procedure delete_row(p_api_version NUMBER
695: , p_init_msg_list VARCHAR2
696: , x_return_status out nocopy VARCHAR2

Line 750: , p5_a0 JTF_NUMBER_TABLE

746: , p_init_msg_list VARCHAR2
747: , x_return_status out nocopy VARCHAR2
748: , x_msg_count out nocopy NUMBER
749: , x_msg_data out nocopy VARCHAR2
750: , p5_a0 JTF_NUMBER_TABLE
751: , p5_a1 JTF_VARCHAR2_TABLE_200
752: , p5_a2 JTF_VARCHAR2_TABLE_100
753: , p5_a3 JTF_NUMBER_TABLE
754: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 753: , p5_a3 JTF_NUMBER_TABLE

749: , x_msg_data out nocopy VARCHAR2
750: , p5_a0 JTF_NUMBER_TABLE
751: , p5_a1 JTF_VARCHAR2_TABLE_200
752: , p5_a2 JTF_VARCHAR2_TABLE_100
753: , p5_a3 JTF_NUMBER_TABLE
754: , p5_a4 JTF_VARCHAR2_TABLE_200
755: , p5_a5 JTF_VARCHAR2_TABLE_100
756: , p5_a6 JTF_VARCHAR2_TABLE_100
757: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 786: , p5_a36 JTF_NUMBER_TABLE

782: , p5_a32 JTF_VARCHAR2_TABLE_500
783: , p5_a33 JTF_VARCHAR2_TABLE_500
784: , p5_a34 JTF_VARCHAR2_TABLE_500
785: , p5_a35 JTF_VARCHAR2_TABLE_500
786: , p5_a36 JTF_NUMBER_TABLE
787: , p5_a37 JTF_DATE_TABLE
788: , p5_a38 JTF_NUMBER_TABLE
789: , p5_a39 JTF_DATE_TABLE
790: , p5_a40 JTF_NUMBER_TABLE

Line 788: , p5_a38 JTF_NUMBER_TABLE

784: , p5_a34 JTF_VARCHAR2_TABLE_500
785: , p5_a35 JTF_VARCHAR2_TABLE_500
786: , p5_a36 JTF_NUMBER_TABLE
787: , p5_a37 JTF_DATE_TABLE
788: , p5_a38 JTF_NUMBER_TABLE
789: , p5_a39 JTF_DATE_TABLE
790: , p5_a40 JTF_NUMBER_TABLE
791: , p5_a41 JTF_VARCHAR2_TABLE_100
792: , p5_a42 JTF_VARCHAR2_TABLE_100

Line 790: , p5_a40 JTF_NUMBER_TABLE

786: , p5_a36 JTF_NUMBER_TABLE
787: , p5_a37 JTF_DATE_TABLE
788: , p5_a38 JTF_NUMBER_TABLE
789: , p5_a39 JTF_DATE_TABLE
790: , p5_a40 JTF_NUMBER_TABLE
791: , p5_a41 JTF_VARCHAR2_TABLE_100
792: , p5_a42 JTF_VARCHAR2_TABLE_100
793: , p5_a43 JTF_VARCHAR2_TABLE_600
794: , p5_a44 JTF_NUMBER_TABLE

Line 794: , p5_a44 JTF_NUMBER_TABLE

790: , p5_a40 JTF_NUMBER_TABLE
791: , p5_a41 JTF_VARCHAR2_TABLE_100
792: , p5_a42 JTF_VARCHAR2_TABLE_100
793: , p5_a43 JTF_VARCHAR2_TABLE_600
794: , p5_a44 JTF_NUMBER_TABLE
795: );
796: procedure validate_row(p_api_version NUMBER
797: , p_init_msg_list VARCHAR2
798: , x_return_status out nocopy VARCHAR2

Line 852: , p5_a0 JTF_NUMBER_TABLE

848: , p_init_msg_list VARCHAR2
849: , x_return_status out nocopy VARCHAR2
850: , x_msg_count out nocopy NUMBER
851: , x_msg_data out nocopy VARCHAR2
852: , p5_a0 JTF_NUMBER_TABLE
853: , p5_a1 JTF_VARCHAR2_TABLE_200
854: , p5_a2 JTF_VARCHAR2_TABLE_100
855: , p5_a3 JTF_NUMBER_TABLE
856: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 855: , p5_a3 JTF_NUMBER_TABLE

851: , x_msg_data out nocopy VARCHAR2
852: , p5_a0 JTF_NUMBER_TABLE
853: , p5_a1 JTF_VARCHAR2_TABLE_200
854: , p5_a2 JTF_VARCHAR2_TABLE_100
855: , p5_a3 JTF_NUMBER_TABLE
856: , p5_a4 JTF_VARCHAR2_TABLE_200
857: , p5_a5 JTF_VARCHAR2_TABLE_100
858: , p5_a6 JTF_VARCHAR2_TABLE_100
859: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 888: , p5_a36 JTF_NUMBER_TABLE

884: , p5_a32 JTF_VARCHAR2_TABLE_500
885: , p5_a33 JTF_VARCHAR2_TABLE_500
886: , p5_a34 JTF_VARCHAR2_TABLE_500
887: , p5_a35 JTF_VARCHAR2_TABLE_500
888: , p5_a36 JTF_NUMBER_TABLE
889: , p5_a37 JTF_DATE_TABLE
890: , p5_a38 JTF_NUMBER_TABLE
891: , p5_a39 JTF_DATE_TABLE
892: , p5_a40 JTF_NUMBER_TABLE

Line 890: , p5_a38 JTF_NUMBER_TABLE

886: , p5_a34 JTF_VARCHAR2_TABLE_500
887: , p5_a35 JTF_VARCHAR2_TABLE_500
888: , p5_a36 JTF_NUMBER_TABLE
889: , p5_a37 JTF_DATE_TABLE
890: , p5_a38 JTF_NUMBER_TABLE
891: , p5_a39 JTF_DATE_TABLE
892: , p5_a40 JTF_NUMBER_TABLE
893: , p5_a41 JTF_VARCHAR2_TABLE_100
894: , p5_a42 JTF_VARCHAR2_TABLE_100

Line 892: , p5_a40 JTF_NUMBER_TABLE

888: , p5_a36 JTF_NUMBER_TABLE
889: , p5_a37 JTF_DATE_TABLE
890: , p5_a38 JTF_NUMBER_TABLE
891: , p5_a39 JTF_DATE_TABLE
892: , p5_a40 JTF_NUMBER_TABLE
893: , p5_a41 JTF_VARCHAR2_TABLE_100
894: , p5_a42 JTF_VARCHAR2_TABLE_100
895: , p5_a43 JTF_VARCHAR2_TABLE_600
896: , p5_a44 JTF_NUMBER_TABLE

Line 896: , p5_a44 JTF_NUMBER_TABLE

892: , p5_a40 JTF_NUMBER_TABLE
893: , p5_a41 JTF_VARCHAR2_TABLE_100
894: , p5_a42 JTF_VARCHAR2_TABLE_100
895: , p5_a43 JTF_VARCHAR2_TABLE_600
896: , p5_a44 JTF_NUMBER_TABLE
897: );
898: end okl_sty_pvt_w;