APPS.OKL_PTM_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_ptm_pvt_w as
2: /* $Header: OKLIPTMS.pls 120.2 2006/11/03 14:11:17 sosharma noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ptm_pvt.ptm_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_500
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500
14: , a11 JTF_VARCHAR2_TABLE_500

Line 31: , a28 JTF_VARCHAR2_TABLE_100

27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: );
34: procedure rosetta_table_copy_out_p2(t okl_ptm_pvt.ptm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE

Line 32: , a29 JTF_VARCHAR2_TABLE_100

28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: );
34: procedure rosetta_table_copy_out_p2(t okl_ptm_pvt.ptm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 36: , a2 out nocopy JTF_VARCHAR2_TABLE_100

32: , a29 JTF_VARCHAR2_TABLE_100
33: );
34: procedure rosetta_table_copy_out_p2(t okl_ptm_pvt.ptm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_VARCHAR2_TABLE_100
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_DATE_TABLE
39: , a5 out nocopy JTF_DATE_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE

Line 41: , a7 out nocopy JTF_VARCHAR2_TABLE_100

37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_DATE_TABLE
39: , a5 out nocopy JTF_DATE_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_VARCHAR2_TABLE_100
42: , a8 out nocopy JTF_VARCHAR2_TABLE_500
43: , a9 out nocopy JTF_VARCHAR2_TABLE_500
44: , a10 out nocopy JTF_VARCHAR2_TABLE_500
45: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 62: , a28 out nocopy JTF_VARCHAR2_TABLE_100

58: , a24 out nocopy JTF_DATE_TABLE
59: , a25 out nocopy JTF_NUMBER_TABLE
60: , a26 out nocopy JTF_DATE_TABLE
61: , a27 out nocopy JTF_NUMBER_TABLE
62: , a28 out nocopy JTF_VARCHAR2_TABLE_100
63: , a29 out nocopy JTF_VARCHAR2_TABLE_100
64: );
65:
66: procedure rosetta_table_copy_in_p5(t out nocopy okl_ptm_pvt.okl_process_tmplts_tl_tbl_type, a0 JTF_NUMBER_TABLE

Line 63: , a29 out nocopy JTF_VARCHAR2_TABLE_100

59: , a25 out nocopy JTF_NUMBER_TABLE
60: , a26 out nocopy JTF_DATE_TABLE
61: , a27 out nocopy JTF_NUMBER_TABLE
62: , a28 out nocopy JTF_VARCHAR2_TABLE_100
63: , a29 out nocopy JTF_VARCHAR2_TABLE_100
64: );
65:
66: procedure rosetta_table_copy_in_p5(t out nocopy okl_ptm_pvt.okl_process_tmplts_tl_tbl_type, a0 JTF_NUMBER_TABLE
67: , a1 JTF_VARCHAR2_TABLE_100

Line 67: , a1 JTF_VARCHAR2_TABLE_100

63: , a29 out nocopy JTF_VARCHAR2_TABLE_100
64: );
65:
66: procedure rosetta_table_copy_in_p5(t out nocopy okl_ptm_pvt.okl_process_tmplts_tl_tbl_type, a0 JTF_NUMBER_TABLE
67: , a1 JTF_VARCHAR2_TABLE_100
68: , a2 JTF_VARCHAR2_TABLE_100
69: , a3 JTF_VARCHAR2_TABLE_100
70: , a4 JTF_VARCHAR2_TABLE_100
71: , a5 JTF_NUMBER_TABLE

Line 68: , a2 JTF_VARCHAR2_TABLE_100

64: );
65:
66: procedure rosetta_table_copy_in_p5(t out nocopy okl_ptm_pvt.okl_process_tmplts_tl_tbl_type, a0 JTF_NUMBER_TABLE
67: , a1 JTF_VARCHAR2_TABLE_100
68: , a2 JTF_VARCHAR2_TABLE_100
69: , a3 JTF_VARCHAR2_TABLE_100
70: , a4 JTF_VARCHAR2_TABLE_100
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_DATE_TABLE

Line 69: , a3 JTF_VARCHAR2_TABLE_100

65:
66: procedure rosetta_table_copy_in_p5(t out nocopy okl_ptm_pvt.okl_process_tmplts_tl_tbl_type, a0 JTF_NUMBER_TABLE
67: , a1 JTF_VARCHAR2_TABLE_100
68: , a2 JTF_VARCHAR2_TABLE_100
69: , a3 JTF_VARCHAR2_TABLE_100
70: , a4 JTF_VARCHAR2_TABLE_100
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_DATE_TABLE
73: , a7 JTF_NUMBER_TABLE

Line 70: , a4 JTF_VARCHAR2_TABLE_100

66: procedure rosetta_table_copy_in_p5(t out nocopy okl_ptm_pvt.okl_process_tmplts_tl_tbl_type, a0 JTF_NUMBER_TABLE
67: , a1 JTF_VARCHAR2_TABLE_100
68: , a2 JTF_VARCHAR2_TABLE_100
69: , a3 JTF_VARCHAR2_TABLE_100
70: , a4 JTF_VARCHAR2_TABLE_100
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_DATE_TABLE
73: , a7 JTF_NUMBER_TABLE
74: , a8 JTF_DATE_TABLE

Line 78: , a1 out nocopy JTF_VARCHAR2_TABLE_100

74: , a8 JTF_DATE_TABLE
75: , a9 JTF_NUMBER_TABLE
76: );
77: procedure rosetta_table_copy_out_p5(t okl_ptm_pvt.okl_process_tmplts_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_VARCHAR2_TABLE_100
79: , a2 out nocopy JTF_VARCHAR2_TABLE_100
80: , a3 out nocopy JTF_VARCHAR2_TABLE_100
81: , a4 out nocopy JTF_VARCHAR2_TABLE_100
82: , a5 out nocopy JTF_NUMBER_TABLE

Line 79: , a2 out nocopy JTF_VARCHAR2_TABLE_100

75: , a9 JTF_NUMBER_TABLE
76: );
77: procedure rosetta_table_copy_out_p5(t okl_ptm_pvt.okl_process_tmplts_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_VARCHAR2_TABLE_100
79: , a2 out nocopy JTF_VARCHAR2_TABLE_100
80: , a3 out nocopy JTF_VARCHAR2_TABLE_100
81: , a4 out nocopy JTF_VARCHAR2_TABLE_100
82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_DATE_TABLE

Line 80: , a3 out nocopy JTF_VARCHAR2_TABLE_100

76: );
77: procedure rosetta_table_copy_out_p5(t okl_ptm_pvt.okl_process_tmplts_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_VARCHAR2_TABLE_100
79: , a2 out nocopy JTF_VARCHAR2_TABLE_100
80: , a3 out nocopy JTF_VARCHAR2_TABLE_100
81: , a4 out nocopy JTF_VARCHAR2_TABLE_100
82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_DATE_TABLE
84: , a7 out nocopy JTF_NUMBER_TABLE

Line 81: , a4 out nocopy JTF_VARCHAR2_TABLE_100

77: procedure rosetta_table_copy_out_p5(t okl_ptm_pvt.okl_process_tmplts_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_VARCHAR2_TABLE_100
79: , a2 out nocopy JTF_VARCHAR2_TABLE_100
80: , a3 out nocopy JTF_VARCHAR2_TABLE_100
81: , a4 out nocopy JTF_VARCHAR2_TABLE_100
82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_DATE_TABLE
84: , a7 out nocopy JTF_NUMBER_TABLE
85: , a8 out nocopy JTF_DATE_TABLE

Line 91: , a2 JTF_VARCHAR2_TABLE_100

87: );
88:
89: procedure rosetta_table_copy_in_p8(t out nocopy okl_ptm_pvt.ptmv_tbl_type, a0 JTF_NUMBER_TABLE
90: , a1 JTF_NUMBER_TABLE
91: , a2 JTF_VARCHAR2_TABLE_100
92: , a3 JTF_NUMBER_TABLE
93: , a4 JTF_VARCHAR2_TABLE_100
94: , a5 JTF_VARCHAR2_TABLE_100
95: , a6 JTF_DATE_TABLE

Line 93: , a4 JTF_VARCHAR2_TABLE_100

89: procedure rosetta_table_copy_in_p8(t out nocopy okl_ptm_pvt.ptmv_tbl_type, a0 JTF_NUMBER_TABLE
90: , a1 JTF_NUMBER_TABLE
91: , a2 JTF_VARCHAR2_TABLE_100
92: , a3 JTF_NUMBER_TABLE
93: , a4 JTF_VARCHAR2_TABLE_100
94: , a5 JTF_VARCHAR2_TABLE_100
95: , a6 JTF_DATE_TABLE
96: , a7 JTF_DATE_TABLE
97: , a8 JTF_NUMBER_TABLE

Line 94: , a5 JTF_VARCHAR2_TABLE_100

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

Line 98: , a9 JTF_VARCHAR2_TABLE_100

94: , a5 JTF_VARCHAR2_TABLE_100
95: , a6 JTF_DATE_TABLE
96: , a7 JTF_DATE_TABLE
97: , a8 JTF_NUMBER_TABLE
98: , a9 JTF_VARCHAR2_TABLE_100
99: , a10 JTF_VARCHAR2_TABLE_500
100: , a11 JTF_VARCHAR2_TABLE_500
101: , a12 JTF_VARCHAR2_TABLE_500
102: , a13 JTF_VARCHAR2_TABLE_500

Line 119: , a30 JTF_VARCHAR2_TABLE_100

115: , a26 JTF_DATE_TABLE
116: , a27 JTF_NUMBER_TABLE
117: , a28 JTF_DATE_TABLE
118: , a29 JTF_NUMBER_TABLE
119: , a30 JTF_VARCHAR2_TABLE_100
120: , a31 JTF_VARCHAR2_TABLE_100
121: );
122: procedure rosetta_table_copy_out_p8(t okl_ptm_pvt.ptmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_NUMBER_TABLE

Line 120: , a31 JTF_VARCHAR2_TABLE_100

116: , a27 JTF_NUMBER_TABLE
117: , a28 JTF_DATE_TABLE
118: , a29 JTF_NUMBER_TABLE
119: , a30 JTF_VARCHAR2_TABLE_100
120: , a31 JTF_VARCHAR2_TABLE_100
121: );
122: procedure rosetta_table_copy_out_p8(t okl_ptm_pvt.ptmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_NUMBER_TABLE
124: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 124: , a2 out nocopy JTF_VARCHAR2_TABLE_100

120: , a31 JTF_VARCHAR2_TABLE_100
121: );
122: procedure rosetta_table_copy_out_p8(t okl_ptm_pvt.ptmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_NUMBER_TABLE
124: , a2 out nocopy JTF_VARCHAR2_TABLE_100
125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_VARCHAR2_TABLE_100
127: , a5 out nocopy JTF_VARCHAR2_TABLE_100
128: , a6 out nocopy JTF_DATE_TABLE

Line 126: , a4 out nocopy JTF_VARCHAR2_TABLE_100

122: procedure rosetta_table_copy_out_p8(t okl_ptm_pvt.ptmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_NUMBER_TABLE
124: , a2 out nocopy JTF_VARCHAR2_TABLE_100
125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_VARCHAR2_TABLE_100
127: , a5 out nocopy JTF_VARCHAR2_TABLE_100
128: , a6 out nocopy JTF_DATE_TABLE
129: , a7 out nocopy JTF_DATE_TABLE
130: , a8 out nocopy JTF_NUMBER_TABLE

Line 127: , a5 out nocopy JTF_VARCHAR2_TABLE_100

123: , a1 out nocopy JTF_NUMBER_TABLE
124: , a2 out nocopy JTF_VARCHAR2_TABLE_100
125: , a3 out nocopy JTF_NUMBER_TABLE
126: , a4 out nocopy JTF_VARCHAR2_TABLE_100
127: , a5 out nocopy JTF_VARCHAR2_TABLE_100
128: , a6 out nocopy JTF_DATE_TABLE
129: , a7 out nocopy JTF_DATE_TABLE
130: , a8 out nocopy JTF_NUMBER_TABLE
131: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 131: , a9 out nocopy JTF_VARCHAR2_TABLE_100

127: , a5 out nocopy JTF_VARCHAR2_TABLE_100
128: , a6 out nocopy JTF_DATE_TABLE
129: , a7 out nocopy JTF_DATE_TABLE
130: , a8 out nocopy JTF_NUMBER_TABLE
131: , a9 out nocopy JTF_VARCHAR2_TABLE_100
132: , a10 out nocopy JTF_VARCHAR2_TABLE_500
133: , a11 out nocopy JTF_VARCHAR2_TABLE_500
134: , a12 out nocopy JTF_VARCHAR2_TABLE_500
135: , a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 152: , a30 out nocopy JTF_VARCHAR2_TABLE_100

148: , a26 out nocopy JTF_DATE_TABLE
149: , a27 out nocopy JTF_NUMBER_TABLE
150: , a28 out nocopy JTF_DATE_TABLE
151: , a29 out nocopy JTF_NUMBER_TABLE
152: , a30 out nocopy JTF_VARCHAR2_TABLE_100
153: , a31 out nocopy JTF_VARCHAR2_TABLE_100
154: );
155:
156: procedure insert_row(p_api_version NUMBER

Line 153: , a31 out nocopy JTF_VARCHAR2_TABLE_100

149: , a27 out nocopy JTF_NUMBER_TABLE
150: , a28 out nocopy JTF_DATE_TABLE
151: , a29 out nocopy JTF_NUMBER_TABLE
152: , a30 out nocopy JTF_VARCHAR2_TABLE_100
153: , a31 out nocopy JTF_VARCHAR2_TABLE_100
154: );
155:
156: procedure insert_row(p_api_version NUMBER
157: , p_init_msg_list VARCHAR2

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_VARCHAR2_TABLE_100
236: , p5_a5 JTF_VARCHAR2_TABLE_100
237: , p5_a6 JTF_DATE_TABLE

Line 235: , p5_a4 JTF_VARCHAR2_TABLE_100

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_VARCHAR2_TABLE_100
236: , p5_a5 JTF_VARCHAR2_TABLE_100
237: , p5_a6 JTF_DATE_TABLE
238: , p5_a7 JTF_DATE_TABLE
239: , p5_a8 JTF_NUMBER_TABLE

Line 236: , p5_a5 JTF_VARCHAR2_TABLE_100

232: , p5_a1 JTF_NUMBER_TABLE
233: , p5_a2 JTF_VARCHAR2_TABLE_100
234: , p5_a3 JTF_NUMBER_TABLE
235: , p5_a4 JTF_VARCHAR2_TABLE_100
236: , p5_a5 JTF_VARCHAR2_TABLE_100
237: , p5_a6 JTF_DATE_TABLE
238: , p5_a7 JTF_DATE_TABLE
239: , p5_a8 JTF_NUMBER_TABLE
240: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 240: , p5_a9 JTF_VARCHAR2_TABLE_100

236: , p5_a5 JTF_VARCHAR2_TABLE_100
237: , p5_a6 JTF_DATE_TABLE
238: , p5_a7 JTF_DATE_TABLE
239: , p5_a8 JTF_NUMBER_TABLE
240: , p5_a9 JTF_VARCHAR2_TABLE_100
241: , p5_a10 JTF_VARCHAR2_TABLE_500
242: , p5_a11 JTF_VARCHAR2_TABLE_500
243: , p5_a12 JTF_VARCHAR2_TABLE_500
244: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 261: , p5_a30 JTF_VARCHAR2_TABLE_100

257: , p5_a26 JTF_DATE_TABLE
258: , p5_a27 JTF_NUMBER_TABLE
259: , p5_a28 JTF_DATE_TABLE
260: , p5_a29 JTF_NUMBER_TABLE
261: , p5_a30 JTF_VARCHAR2_TABLE_100
262: , p5_a31 JTF_VARCHAR2_TABLE_100
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 262: , p5_a31 JTF_VARCHAR2_TABLE_100

258: , p5_a27 JTF_NUMBER_TABLE
259: , p5_a28 JTF_DATE_TABLE
260: , p5_a29 JTF_NUMBER_TABLE
261: , p5_a30 JTF_VARCHAR2_TABLE_100
262: , p5_a31 JTF_VARCHAR2_TABLE_100
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
266: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 265: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

261: , p5_a30 JTF_VARCHAR2_TABLE_100
262: , p5_a31 JTF_VARCHAR2_TABLE_100
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
266: , p6_a3 out nocopy JTF_NUMBER_TABLE
267: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a6 out nocopy JTF_DATE_TABLE

Line 267: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
266: , p6_a3 out nocopy JTF_NUMBER_TABLE
267: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a6 out nocopy JTF_DATE_TABLE
270: , p6_a7 out nocopy JTF_DATE_TABLE
271: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

264: , p6_a1 out nocopy JTF_NUMBER_TABLE
265: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
266: , p6_a3 out nocopy JTF_NUMBER_TABLE
267: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a6 out nocopy JTF_DATE_TABLE
270: , p6_a7 out nocopy JTF_DATE_TABLE
271: , p6_a8 out nocopy JTF_NUMBER_TABLE
272: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 272: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a6 out nocopy JTF_DATE_TABLE
270: , p6_a7 out nocopy JTF_DATE_TABLE
271: , p6_a8 out nocopy JTF_NUMBER_TABLE
272: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
273: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
274: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
275: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
276: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 293: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

289: , p6_a26 out nocopy JTF_DATE_TABLE
290: , p6_a27 out nocopy JTF_NUMBER_TABLE
291: , p6_a28 out nocopy JTF_DATE_TABLE
292: , p6_a29 out nocopy JTF_NUMBER_TABLE
293: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
294: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
295: );
296: procedure lock_row(p_api_version NUMBER
297: , p_init_msg_list VARCHAR2

Line 294: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100

290: , p6_a27 out nocopy JTF_NUMBER_TABLE
291: , p6_a28 out nocopy JTF_DATE_TABLE
292: , p6_a29 out nocopy JTF_NUMBER_TABLE
293: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
294: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
295: );
296: procedure lock_row(p_api_version NUMBER
297: , p_init_msg_list VARCHAR2
298: , x_return_status out nocopy VARCHAR2

Line 341: , p5_a2 JTF_VARCHAR2_TABLE_100

337: , x_msg_count out nocopy NUMBER
338: , x_msg_data out nocopy VARCHAR2
339: , p5_a0 JTF_NUMBER_TABLE
340: , p5_a1 JTF_NUMBER_TABLE
341: , p5_a2 JTF_VARCHAR2_TABLE_100
342: , p5_a3 JTF_NUMBER_TABLE
343: , p5_a4 JTF_VARCHAR2_TABLE_100
344: , p5_a5 JTF_VARCHAR2_TABLE_100
345: , p5_a6 JTF_DATE_TABLE

Line 343: , p5_a4 JTF_VARCHAR2_TABLE_100

339: , p5_a0 JTF_NUMBER_TABLE
340: , p5_a1 JTF_NUMBER_TABLE
341: , p5_a2 JTF_VARCHAR2_TABLE_100
342: , p5_a3 JTF_NUMBER_TABLE
343: , p5_a4 JTF_VARCHAR2_TABLE_100
344: , p5_a5 JTF_VARCHAR2_TABLE_100
345: , p5_a6 JTF_DATE_TABLE
346: , p5_a7 JTF_DATE_TABLE
347: , p5_a8 JTF_NUMBER_TABLE

Line 344: , p5_a5 JTF_VARCHAR2_TABLE_100

340: , p5_a1 JTF_NUMBER_TABLE
341: , p5_a2 JTF_VARCHAR2_TABLE_100
342: , p5_a3 JTF_NUMBER_TABLE
343: , p5_a4 JTF_VARCHAR2_TABLE_100
344: , p5_a5 JTF_VARCHAR2_TABLE_100
345: , p5_a6 JTF_DATE_TABLE
346: , p5_a7 JTF_DATE_TABLE
347: , p5_a8 JTF_NUMBER_TABLE
348: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 348: , p5_a9 JTF_VARCHAR2_TABLE_100

344: , p5_a5 JTF_VARCHAR2_TABLE_100
345: , p5_a6 JTF_DATE_TABLE
346: , p5_a7 JTF_DATE_TABLE
347: , p5_a8 JTF_NUMBER_TABLE
348: , p5_a9 JTF_VARCHAR2_TABLE_100
349: , p5_a10 JTF_VARCHAR2_TABLE_500
350: , p5_a11 JTF_VARCHAR2_TABLE_500
351: , p5_a12 JTF_VARCHAR2_TABLE_500
352: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 369: , p5_a30 JTF_VARCHAR2_TABLE_100

365: , p5_a26 JTF_DATE_TABLE
366: , p5_a27 JTF_NUMBER_TABLE
367: , p5_a28 JTF_DATE_TABLE
368: , p5_a29 JTF_NUMBER_TABLE
369: , p5_a30 JTF_VARCHAR2_TABLE_100
370: , p5_a31 JTF_VARCHAR2_TABLE_100
371: );
372: procedure update_row(p_api_version NUMBER
373: , p_init_msg_list VARCHAR2

Line 370: , p5_a31 JTF_VARCHAR2_TABLE_100

366: , p5_a27 JTF_NUMBER_TABLE
367: , p5_a28 JTF_DATE_TABLE
368: , p5_a29 JTF_NUMBER_TABLE
369: , p5_a30 JTF_VARCHAR2_TABLE_100
370: , p5_a31 JTF_VARCHAR2_TABLE_100
371: );
372: procedure update_row(p_api_version NUMBER
373: , p_init_msg_list VARCHAR2
374: , x_return_status out nocopy VARCHAR2

Line 449: , p5_a2 JTF_VARCHAR2_TABLE_100

445: , x_msg_count out nocopy NUMBER
446: , x_msg_data out nocopy VARCHAR2
447: , p5_a0 JTF_NUMBER_TABLE
448: , p5_a1 JTF_NUMBER_TABLE
449: , p5_a2 JTF_VARCHAR2_TABLE_100
450: , p5_a3 JTF_NUMBER_TABLE
451: , p5_a4 JTF_VARCHAR2_TABLE_100
452: , p5_a5 JTF_VARCHAR2_TABLE_100
453: , p5_a6 JTF_DATE_TABLE

Line 451: , p5_a4 JTF_VARCHAR2_TABLE_100

447: , p5_a0 JTF_NUMBER_TABLE
448: , p5_a1 JTF_NUMBER_TABLE
449: , p5_a2 JTF_VARCHAR2_TABLE_100
450: , p5_a3 JTF_NUMBER_TABLE
451: , p5_a4 JTF_VARCHAR2_TABLE_100
452: , p5_a5 JTF_VARCHAR2_TABLE_100
453: , p5_a6 JTF_DATE_TABLE
454: , p5_a7 JTF_DATE_TABLE
455: , p5_a8 JTF_NUMBER_TABLE

Line 452: , p5_a5 JTF_VARCHAR2_TABLE_100

448: , p5_a1 JTF_NUMBER_TABLE
449: , p5_a2 JTF_VARCHAR2_TABLE_100
450: , p5_a3 JTF_NUMBER_TABLE
451: , p5_a4 JTF_VARCHAR2_TABLE_100
452: , p5_a5 JTF_VARCHAR2_TABLE_100
453: , p5_a6 JTF_DATE_TABLE
454: , p5_a7 JTF_DATE_TABLE
455: , p5_a8 JTF_NUMBER_TABLE
456: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 456: , p5_a9 JTF_VARCHAR2_TABLE_100

452: , p5_a5 JTF_VARCHAR2_TABLE_100
453: , p5_a6 JTF_DATE_TABLE
454: , p5_a7 JTF_DATE_TABLE
455: , p5_a8 JTF_NUMBER_TABLE
456: , p5_a9 JTF_VARCHAR2_TABLE_100
457: , p5_a10 JTF_VARCHAR2_TABLE_500
458: , p5_a11 JTF_VARCHAR2_TABLE_500
459: , p5_a12 JTF_VARCHAR2_TABLE_500
460: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 477: , p5_a30 JTF_VARCHAR2_TABLE_100

473: , p5_a26 JTF_DATE_TABLE
474: , p5_a27 JTF_NUMBER_TABLE
475: , p5_a28 JTF_DATE_TABLE
476: , p5_a29 JTF_NUMBER_TABLE
477: , p5_a30 JTF_VARCHAR2_TABLE_100
478: , p5_a31 JTF_VARCHAR2_TABLE_100
479: , p6_a0 out nocopy JTF_NUMBER_TABLE
480: , p6_a1 out nocopy JTF_NUMBER_TABLE
481: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 478: , p5_a31 JTF_VARCHAR2_TABLE_100

474: , p5_a27 JTF_NUMBER_TABLE
475: , p5_a28 JTF_DATE_TABLE
476: , p5_a29 JTF_NUMBER_TABLE
477: , p5_a30 JTF_VARCHAR2_TABLE_100
478: , p5_a31 JTF_VARCHAR2_TABLE_100
479: , p6_a0 out nocopy JTF_NUMBER_TABLE
480: , p6_a1 out nocopy JTF_NUMBER_TABLE
481: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
482: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 481: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

477: , p5_a30 JTF_VARCHAR2_TABLE_100
478: , p5_a31 JTF_VARCHAR2_TABLE_100
479: , p6_a0 out nocopy JTF_NUMBER_TABLE
480: , p6_a1 out nocopy JTF_NUMBER_TABLE
481: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
482: , p6_a3 out nocopy JTF_NUMBER_TABLE
483: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
485: , p6_a6 out nocopy JTF_DATE_TABLE

Line 483: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

479: , p6_a0 out nocopy JTF_NUMBER_TABLE
480: , p6_a1 out nocopy JTF_NUMBER_TABLE
481: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
482: , p6_a3 out nocopy JTF_NUMBER_TABLE
483: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
485: , p6_a6 out nocopy JTF_DATE_TABLE
486: , p6_a7 out nocopy JTF_DATE_TABLE
487: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 484: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

480: , p6_a1 out nocopy JTF_NUMBER_TABLE
481: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
482: , p6_a3 out nocopy JTF_NUMBER_TABLE
483: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
485: , p6_a6 out nocopy JTF_DATE_TABLE
486: , p6_a7 out nocopy JTF_DATE_TABLE
487: , p6_a8 out nocopy JTF_NUMBER_TABLE
488: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 488: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

484: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
485: , p6_a6 out nocopy JTF_DATE_TABLE
486: , p6_a7 out nocopy JTF_DATE_TABLE
487: , p6_a8 out nocopy JTF_NUMBER_TABLE
488: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
490: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
491: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
492: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 509: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100

505: , p6_a26 out nocopy JTF_DATE_TABLE
506: , p6_a27 out nocopy JTF_NUMBER_TABLE
507: , p6_a28 out nocopy JTF_DATE_TABLE
508: , p6_a29 out nocopy JTF_NUMBER_TABLE
509: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
510: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
511: );
512: procedure delete_row(p_api_version NUMBER
513: , p_init_msg_list VARCHAR2

Line 510: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100

506: , p6_a27 out nocopy JTF_NUMBER_TABLE
507: , p6_a28 out nocopy JTF_DATE_TABLE
508: , p6_a29 out nocopy JTF_NUMBER_TABLE
509: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
510: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
511: );
512: procedure delete_row(p_api_version NUMBER
513: , p_init_msg_list VARCHAR2
514: , x_return_status out nocopy VARCHAR2

Line 557: , p5_a2 JTF_VARCHAR2_TABLE_100

553: , x_msg_count out nocopy NUMBER
554: , x_msg_data out nocopy VARCHAR2
555: , p5_a0 JTF_NUMBER_TABLE
556: , p5_a1 JTF_NUMBER_TABLE
557: , p5_a2 JTF_VARCHAR2_TABLE_100
558: , p5_a3 JTF_NUMBER_TABLE
559: , p5_a4 JTF_VARCHAR2_TABLE_100
560: , p5_a5 JTF_VARCHAR2_TABLE_100
561: , p5_a6 JTF_DATE_TABLE

Line 559: , p5_a4 JTF_VARCHAR2_TABLE_100

555: , p5_a0 JTF_NUMBER_TABLE
556: , p5_a1 JTF_NUMBER_TABLE
557: , p5_a2 JTF_VARCHAR2_TABLE_100
558: , p5_a3 JTF_NUMBER_TABLE
559: , p5_a4 JTF_VARCHAR2_TABLE_100
560: , p5_a5 JTF_VARCHAR2_TABLE_100
561: , p5_a6 JTF_DATE_TABLE
562: , p5_a7 JTF_DATE_TABLE
563: , p5_a8 JTF_NUMBER_TABLE

Line 560: , p5_a5 JTF_VARCHAR2_TABLE_100

556: , p5_a1 JTF_NUMBER_TABLE
557: , p5_a2 JTF_VARCHAR2_TABLE_100
558: , p5_a3 JTF_NUMBER_TABLE
559: , p5_a4 JTF_VARCHAR2_TABLE_100
560: , p5_a5 JTF_VARCHAR2_TABLE_100
561: , p5_a6 JTF_DATE_TABLE
562: , p5_a7 JTF_DATE_TABLE
563: , p5_a8 JTF_NUMBER_TABLE
564: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 564: , p5_a9 JTF_VARCHAR2_TABLE_100

560: , p5_a5 JTF_VARCHAR2_TABLE_100
561: , p5_a6 JTF_DATE_TABLE
562: , p5_a7 JTF_DATE_TABLE
563: , p5_a8 JTF_NUMBER_TABLE
564: , p5_a9 JTF_VARCHAR2_TABLE_100
565: , p5_a10 JTF_VARCHAR2_TABLE_500
566: , p5_a11 JTF_VARCHAR2_TABLE_500
567: , p5_a12 JTF_VARCHAR2_TABLE_500
568: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 585: , p5_a30 JTF_VARCHAR2_TABLE_100

581: , p5_a26 JTF_DATE_TABLE
582: , p5_a27 JTF_NUMBER_TABLE
583: , p5_a28 JTF_DATE_TABLE
584: , p5_a29 JTF_NUMBER_TABLE
585: , p5_a30 JTF_VARCHAR2_TABLE_100
586: , p5_a31 JTF_VARCHAR2_TABLE_100
587: );
588: procedure validate_row(p_api_version NUMBER
589: , p_init_msg_list VARCHAR2

Line 586: , p5_a31 JTF_VARCHAR2_TABLE_100

582: , p5_a27 JTF_NUMBER_TABLE
583: , p5_a28 JTF_DATE_TABLE
584: , p5_a29 JTF_NUMBER_TABLE
585: , p5_a30 JTF_VARCHAR2_TABLE_100
586: , p5_a31 JTF_VARCHAR2_TABLE_100
587: );
588: procedure validate_row(p_api_version NUMBER
589: , p_init_msg_list VARCHAR2
590: , x_return_status out nocopy VARCHAR2

Line 633: , p5_a2 JTF_VARCHAR2_TABLE_100

629: , x_msg_count out nocopy NUMBER
630: , x_msg_data out nocopy VARCHAR2
631: , p5_a0 JTF_NUMBER_TABLE
632: , p5_a1 JTF_NUMBER_TABLE
633: , p5_a2 JTF_VARCHAR2_TABLE_100
634: , p5_a3 JTF_NUMBER_TABLE
635: , p5_a4 JTF_VARCHAR2_TABLE_100
636: , p5_a5 JTF_VARCHAR2_TABLE_100
637: , p5_a6 JTF_DATE_TABLE

Line 635: , p5_a4 JTF_VARCHAR2_TABLE_100

631: , p5_a0 JTF_NUMBER_TABLE
632: , p5_a1 JTF_NUMBER_TABLE
633: , p5_a2 JTF_VARCHAR2_TABLE_100
634: , p5_a3 JTF_NUMBER_TABLE
635: , p5_a4 JTF_VARCHAR2_TABLE_100
636: , p5_a5 JTF_VARCHAR2_TABLE_100
637: , p5_a6 JTF_DATE_TABLE
638: , p5_a7 JTF_DATE_TABLE
639: , p5_a8 JTF_NUMBER_TABLE

Line 636: , p5_a5 JTF_VARCHAR2_TABLE_100

632: , p5_a1 JTF_NUMBER_TABLE
633: , p5_a2 JTF_VARCHAR2_TABLE_100
634: , p5_a3 JTF_NUMBER_TABLE
635: , p5_a4 JTF_VARCHAR2_TABLE_100
636: , p5_a5 JTF_VARCHAR2_TABLE_100
637: , p5_a6 JTF_DATE_TABLE
638: , p5_a7 JTF_DATE_TABLE
639: , p5_a8 JTF_NUMBER_TABLE
640: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 640: , p5_a9 JTF_VARCHAR2_TABLE_100

636: , p5_a5 JTF_VARCHAR2_TABLE_100
637: , p5_a6 JTF_DATE_TABLE
638: , p5_a7 JTF_DATE_TABLE
639: , p5_a8 JTF_NUMBER_TABLE
640: , p5_a9 JTF_VARCHAR2_TABLE_100
641: , p5_a10 JTF_VARCHAR2_TABLE_500
642: , p5_a11 JTF_VARCHAR2_TABLE_500
643: , p5_a12 JTF_VARCHAR2_TABLE_500
644: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 661: , p5_a30 JTF_VARCHAR2_TABLE_100

657: , p5_a26 JTF_DATE_TABLE
658: , p5_a27 JTF_NUMBER_TABLE
659: , p5_a28 JTF_DATE_TABLE
660: , p5_a29 JTF_NUMBER_TABLE
661: , p5_a30 JTF_VARCHAR2_TABLE_100
662: , p5_a31 JTF_VARCHAR2_TABLE_100
663: );
664: end okl_ptm_pvt_w;

Line 662: , p5_a31 JTF_VARCHAR2_TABLE_100

658: , p5_a27 JTF_NUMBER_TABLE
659: , p5_a28 JTF_DATE_TABLE
660: , p5_a29 JTF_NUMBER_TABLE
661: , p5_a30 JTF_VARCHAR2_TABLE_100
662: , p5_a31 JTF_VARCHAR2_TABLE_100
663: );
664: end okl_ptm_pvt_w;