APPS.OKL_DSF_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_dsf_pvt.dsf_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_dsf_pvt_w as
2: /* $Header: OKLIDSFS.pls 120.1 2005/07/08 10:35:31 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_dsf_pvt.dsf_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_800

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_dsf_pvt_w as
2: /* $Header: OKLIDSFS.pls 120.1 2005/07/08 10:35:31 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_dsf_pvt.dsf_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_800
8: , a5 JTF_NUMBER_TABLE

Line 8: , a5 JTF_NUMBER_TABLE

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

Line 28: , a25 JTF_NUMBER_TABLE

24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE

Line 30: , a27 JTF_NUMBER_TABLE

26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p2(t okl_dsf_pvt.dsf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 32: , a29 JTF_NUMBER_TABLE

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

Line 34: procedure rosetta_table_copy_out_p2(t okl_dsf_pvt.dsf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p2(t okl_dsf_pvt.dsf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_VARCHAR2_TABLE_200
37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_VARCHAR2_TABLE_800

Line 35: , a1 out nocopy JTF_NUMBER_TABLE

31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p2(t okl_dsf_pvt.dsf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_VARCHAR2_TABLE_200
37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_VARCHAR2_TABLE_800
39: , a5 out nocopy JTF_NUMBER_TABLE

Line 39: , a5 out nocopy JTF_NUMBER_TABLE

35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_VARCHAR2_TABLE_200
37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_VARCHAR2_TABLE_800
39: , a5 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_DATE_TABLE
41: , a7 out nocopy JTF_DATE_TABLE
42: , a8 out nocopy JTF_VARCHAR2_TABLE_100
43: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 59: , a25 out nocopy JTF_NUMBER_TABLE

55: , a21 out nocopy JTF_VARCHAR2_TABLE_500
56: , a22 out nocopy JTF_VARCHAR2_TABLE_500
57: , a23 out nocopy JTF_VARCHAR2_TABLE_500
58: , a24 out nocopy JTF_VARCHAR2_TABLE_500
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_DATE_TABLE
63: , a29 out nocopy JTF_NUMBER_TABLE

Line 61: , a27 out nocopy JTF_NUMBER_TABLE

57: , a23 out nocopy JTF_VARCHAR2_TABLE_500
58: , a24 out nocopy JTF_VARCHAR2_TABLE_500
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_DATE_TABLE
63: , a29 out nocopy JTF_NUMBER_TABLE
64: );
65:

Line 63: , a29 out nocopy JTF_NUMBER_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_DATE_TABLE
63: , a29 out nocopy JTF_NUMBER_TABLE
64: );
65:
66: procedure rosetta_table_copy_in_p5(t out nocopy okl_dsf_pvt.okldatasrcfnctnstltbltype, a0 JTF_NUMBER_TABLE
67: , a1 JTF_VARCHAR2_TABLE_100

Line 66: procedure rosetta_table_copy_in_p5(t out nocopy okl_dsf_pvt.okldatasrcfnctnstltbltype, a0 JTF_NUMBER_TABLE

62: , a28 out nocopy JTF_DATE_TABLE
63: , a29 out nocopy JTF_NUMBER_TABLE
64: );
65:
66: procedure rosetta_table_copy_in_p5(t out nocopy okl_dsf_pvt.okldatasrcfnctnstltbltype, 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_2000

Line 71: , a5 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_2000
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_DATE_TABLE
73: , a7 JTF_NUMBER_TABLE
74: , a8 JTF_DATE_TABLE
75: , a9 JTF_NUMBER_TABLE

Line 73: , a7 JTF_NUMBER_TABLE

69: , a3 JTF_VARCHAR2_TABLE_100
70: , a4 JTF_VARCHAR2_TABLE_2000
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_DATE_TABLE
73: , a7 JTF_NUMBER_TABLE
74: , a8 JTF_DATE_TABLE
75: , a9 JTF_NUMBER_TABLE
76: );
77: procedure rosetta_table_copy_out_p5(t okl_dsf_pvt.okldatasrcfnctnstltbltype, a0 out nocopy JTF_NUMBER_TABLE

Line 75: , a9 JTF_NUMBER_TABLE

71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_DATE_TABLE
73: , a7 JTF_NUMBER_TABLE
74: , a8 JTF_DATE_TABLE
75: , a9 JTF_NUMBER_TABLE
76: );
77: procedure rosetta_table_copy_out_p5(t okl_dsf_pvt.okldatasrcfnctnstltbltype, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_VARCHAR2_TABLE_100
79: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 77: procedure rosetta_table_copy_out_p5(t okl_dsf_pvt.okldatasrcfnctnstltbltype, a0 out nocopy JTF_NUMBER_TABLE

73: , a7 JTF_NUMBER_TABLE
74: , a8 JTF_DATE_TABLE
75: , a9 JTF_NUMBER_TABLE
76: );
77: procedure rosetta_table_copy_out_p5(t okl_dsf_pvt.okldatasrcfnctnstltbltype, 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_2000

Line 82: , a5 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_2000
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
86: , a9 out nocopy JTF_NUMBER_TABLE

Line 84: , a7 out nocopy JTF_NUMBER_TABLE

80: , a3 out nocopy JTF_VARCHAR2_TABLE_100
81: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
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
86: , a9 out nocopy JTF_NUMBER_TABLE
87: );
88:

Line 86: , a9 out nocopy JTF_NUMBER_TABLE

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
86: , a9 out nocopy JTF_NUMBER_TABLE
87: );
88:
89: procedure rosetta_table_copy_in_p8(t out nocopy okl_dsf_pvt.dsfv_tbl_type, a0 JTF_NUMBER_TABLE
90: , a1 JTF_NUMBER_TABLE

Line 89: procedure rosetta_table_copy_in_p8(t out nocopy okl_dsf_pvt.dsfv_tbl_type, a0 JTF_NUMBER_TABLE

85: , a8 out nocopy JTF_DATE_TABLE
86: , a9 out nocopy JTF_NUMBER_TABLE
87: );
88:
89: procedure rosetta_table_copy_in_p8(t out nocopy okl_dsf_pvt.dsfv_tbl_type, a0 JTF_NUMBER_TABLE
90: , a1 JTF_NUMBER_TABLE
91: , a2 JTF_VARCHAR2_TABLE_100
92: , a3 JTF_VARCHAR2_TABLE_100
93: , a4 JTF_VARCHAR2_TABLE_200

Line 90: , a1 JTF_NUMBER_TABLE

86: , a9 out nocopy JTF_NUMBER_TABLE
87: );
88:
89: procedure rosetta_table_copy_in_p8(t out nocopy okl_dsf_pvt.dsfv_tbl_type, a0 JTF_NUMBER_TABLE
90: , a1 JTF_NUMBER_TABLE
91: , a2 JTF_VARCHAR2_TABLE_100
92: , a3 JTF_VARCHAR2_TABLE_100
93: , a4 JTF_VARCHAR2_TABLE_200
94: , a5 JTF_VARCHAR2_TABLE_2000

Line 115: , a26 JTF_NUMBER_TABLE

111: , a22 JTF_VARCHAR2_TABLE_500
112: , a23 JTF_VARCHAR2_TABLE_500
113: , a24 JTF_VARCHAR2_TABLE_500
114: , a25 JTF_VARCHAR2_TABLE_500
115: , a26 JTF_NUMBER_TABLE
116: , a27 JTF_NUMBER_TABLE
117: , a28 JTF_DATE_TABLE
118: , a29 JTF_NUMBER_TABLE
119: , a30 JTF_DATE_TABLE

Line 116: , a27 JTF_NUMBER_TABLE

112: , a23 JTF_VARCHAR2_TABLE_500
113: , a24 JTF_VARCHAR2_TABLE_500
114: , a25 JTF_VARCHAR2_TABLE_500
115: , a26 JTF_NUMBER_TABLE
116: , a27 JTF_NUMBER_TABLE
117: , a28 JTF_DATE_TABLE
118: , a29 JTF_NUMBER_TABLE
119: , a30 JTF_DATE_TABLE
120: , a31 JTF_NUMBER_TABLE

Line 118: , a29 JTF_NUMBER_TABLE

114: , a25 JTF_VARCHAR2_TABLE_500
115: , a26 JTF_NUMBER_TABLE
116: , a27 JTF_NUMBER_TABLE
117: , a28 JTF_DATE_TABLE
118: , a29 JTF_NUMBER_TABLE
119: , a30 JTF_DATE_TABLE
120: , a31 JTF_NUMBER_TABLE
121: );
122: procedure rosetta_table_copy_out_p8(t okl_dsf_pvt.dsfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 120: , a31 JTF_NUMBER_TABLE

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

Line 122: procedure rosetta_table_copy_out_p8(t okl_dsf_pvt.dsfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

118: , a29 JTF_NUMBER_TABLE
119: , a30 JTF_DATE_TABLE
120: , a31 JTF_NUMBER_TABLE
121: );
122: procedure rosetta_table_copy_out_p8(t okl_dsf_pvt.dsfv_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_VARCHAR2_TABLE_100
126: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 123: , a1 out nocopy JTF_NUMBER_TABLE

119: , a30 JTF_DATE_TABLE
120: , a31 JTF_NUMBER_TABLE
121: );
122: procedure rosetta_table_copy_out_p8(t okl_dsf_pvt.dsfv_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_VARCHAR2_TABLE_100
126: , a4 out nocopy JTF_VARCHAR2_TABLE_200
127: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 148: , a26 out nocopy JTF_NUMBER_TABLE

144: , a22 out nocopy JTF_VARCHAR2_TABLE_500
145: , a23 out nocopy JTF_VARCHAR2_TABLE_500
146: , a24 out nocopy JTF_VARCHAR2_TABLE_500
147: , a25 out nocopy JTF_VARCHAR2_TABLE_500
148: , a26 out nocopy JTF_NUMBER_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_DATE_TABLE

Line 149: , a27 out nocopy JTF_NUMBER_TABLE

145: , a23 out nocopy JTF_VARCHAR2_TABLE_500
146: , a24 out nocopy JTF_VARCHAR2_TABLE_500
147: , a25 out nocopy JTF_VARCHAR2_TABLE_500
148: , a26 out nocopy JTF_NUMBER_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_DATE_TABLE
153: , a31 out nocopy JTF_NUMBER_TABLE

Line 151: , a29 out nocopy JTF_NUMBER_TABLE

147: , a25 out nocopy JTF_VARCHAR2_TABLE_500
148: , a26 out nocopy JTF_NUMBER_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_DATE_TABLE
153: , a31 out nocopy JTF_NUMBER_TABLE
154: );
155:

Line 153: , a31 out nocopy JTF_NUMBER_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_DATE_TABLE
153: , a31 out nocopy JTF_NUMBER_TABLE
154: );
155:
156: procedure insert_row(p_api_version NUMBER
157: , p_init_msg_list VARCHAR2

Line 231: , p5_a0 JTF_NUMBER_TABLE

227: , p_init_msg_list VARCHAR2
228: , x_return_status out nocopy VARCHAR2
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_VARCHAR2_TABLE_100
235: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 232: , p5_a1 JTF_NUMBER_TABLE

228: , x_return_status out nocopy VARCHAR2
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_VARCHAR2_TABLE_100
235: , p5_a4 JTF_VARCHAR2_TABLE_200
236: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 257: , p5_a26 JTF_NUMBER_TABLE

253: , p5_a22 JTF_VARCHAR2_TABLE_500
254: , p5_a23 JTF_VARCHAR2_TABLE_500
255: , p5_a24 JTF_VARCHAR2_TABLE_500
256: , p5_a25 JTF_VARCHAR2_TABLE_500
257: , p5_a26 JTF_NUMBER_TABLE
258: , p5_a27 JTF_NUMBER_TABLE
259: , p5_a28 JTF_DATE_TABLE
260: , p5_a29 JTF_NUMBER_TABLE
261: , p5_a30 JTF_DATE_TABLE

Line 258: , p5_a27 JTF_NUMBER_TABLE

254: , p5_a23 JTF_VARCHAR2_TABLE_500
255: , p5_a24 JTF_VARCHAR2_TABLE_500
256: , p5_a25 JTF_VARCHAR2_TABLE_500
257: , p5_a26 JTF_NUMBER_TABLE
258: , p5_a27 JTF_NUMBER_TABLE
259: , p5_a28 JTF_DATE_TABLE
260: , p5_a29 JTF_NUMBER_TABLE
261: , p5_a30 JTF_DATE_TABLE
262: , p5_a31 JTF_NUMBER_TABLE

Line 260: , p5_a29 JTF_NUMBER_TABLE

256: , p5_a25 JTF_VARCHAR2_TABLE_500
257: , p5_a26 JTF_NUMBER_TABLE
258: , p5_a27 JTF_NUMBER_TABLE
259: , p5_a28 JTF_DATE_TABLE
260: , p5_a29 JTF_NUMBER_TABLE
261: , p5_a30 JTF_DATE_TABLE
262: , p5_a31 JTF_NUMBER_TABLE
263: , p6_a0 out nocopy JTF_NUMBER_TABLE
264: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 262: , p5_a31 JTF_NUMBER_TABLE

258: , p5_a27 JTF_NUMBER_TABLE
259: , p5_a28 JTF_DATE_TABLE
260: , p5_a29 JTF_NUMBER_TABLE
261: , p5_a30 JTF_DATE_TABLE
262: , p5_a31 JTF_NUMBER_TABLE
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_VARCHAR2_TABLE_100

Line 263: , p6_a0 out nocopy JTF_NUMBER_TABLE

259: , p5_a28 JTF_DATE_TABLE
260: , p5_a29 JTF_NUMBER_TABLE
261: , p5_a30 JTF_DATE_TABLE
262: , p5_a31 JTF_NUMBER_TABLE
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_VARCHAR2_TABLE_100
267: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 264: , p6_a1 out nocopy JTF_NUMBER_TABLE

260: , p5_a29 JTF_NUMBER_TABLE
261: , p5_a30 JTF_DATE_TABLE
262: , p5_a31 JTF_NUMBER_TABLE
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_VARCHAR2_TABLE_100
267: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
268: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 289: , p6_a26 out nocopy JTF_NUMBER_TABLE

285: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
286: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
287: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
288: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
289: , p6_a26 out nocopy JTF_NUMBER_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_DATE_TABLE

Line 290: , p6_a27 out nocopy JTF_NUMBER_TABLE

286: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
287: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
288: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
289: , p6_a26 out nocopy JTF_NUMBER_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_DATE_TABLE
294: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 292: , p6_a29 out nocopy JTF_NUMBER_TABLE

288: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
289: , p6_a26 out nocopy JTF_NUMBER_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_DATE_TABLE
294: , p6_a31 out nocopy JTF_NUMBER_TABLE
295: );
296: procedure lock_row(p_api_version NUMBER

Line 294: , p6_a31 out nocopy JTF_NUMBER_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_DATE_TABLE
294: , p6_a31 out nocopy JTF_NUMBER_TABLE
295: );
296: procedure lock_row(p_api_version NUMBER
297: , p_init_msg_list VARCHAR2
298: , x_return_status out nocopy VARCHAR2

Line 339: , p5_a0 JTF_NUMBER_TABLE

335: , p_init_msg_list VARCHAR2
336: , x_return_status out nocopy VARCHAR2
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_VARCHAR2_TABLE_100
343: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 340: , p5_a1 JTF_NUMBER_TABLE

336: , x_return_status out nocopy VARCHAR2
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_VARCHAR2_TABLE_100
343: , p5_a4 JTF_VARCHAR2_TABLE_200
344: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 365: , p5_a26 JTF_NUMBER_TABLE

361: , p5_a22 JTF_VARCHAR2_TABLE_500
362: , p5_a23 JTF_VARCHAR2_TABLE_500
363: , p5_a24 JTF_VARCHAR2_TABLE_500
364: , p5_a25 JTF_VARCHAR2_TABLE_500
365: , p5_a26 JTF_NUMBER_TABLE
366: , p5_a27 JTF_NUMBER_TABLE
367: , p5_a28 JTF_DATE_TABLE
368: , p5_a29 JTF_NUMBER_TABLE
369: , p5_a30 JTF_DATE_TABLE

Line 366: , p5_a27 JTF_NUMBER_TABLE

362: , p5_a23 JTF_VARCHAR2_TABLE_500
363: , p5_a24 JTF_VARCHAR2_TABLE_500
364: , p5_a25 JTF_VARCHAR2_TABLE_500
365: , p5_a26 JTF_NUMBER_TABLE
366: , p5_a27 JTF_NUMBER_TABLE
367: , p5_a28 JTF_DATE_TABLE
368: , p5_a29 JTF_NUMBER_TABLE
369: , p5_a30 JTF_DATE_TABLE
370: , p5_a31 JTF_NUMBER_TABLE

Line 368: , p5_a29 JTF_NUMBER_TABLE

364: , p5_a25 JTF_VARCHAR2_TABLE_500
365: , p5_a26 JTF_NUMBER_TABLE
366: , p5_a27 JTF_NUMBER_TABLE
367: , p5_a28 JTF_DATE_TABLE
368: , p5_a29 JTF_NUMBER_TABLE
369: , p5_a30 JTF_DATE_TABLE
370: , p5_a31 JTF_NUMBER_TABLE
371: );
372: procedure update_row(p_api_version NUMBER

Line 370: , p5_a31 JTF_NUMBER_TABLE

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

Line 447: , p5_a0 JTF_NUMBER_TABLE

443: , p_init_msg_list VARCHAR2
444: , x_return_status out nocopy VARCHAR2
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_VARCHAR2_TABLE_100
451: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 448: , p5_a1 JTF_NUMBER_TABLE

444: , x_return_status out nocopy VARCHAR2
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_VARCHAR2_TABLE_100
451: , p5_a4 JTF_VARCHAR2_TABLE_200
452: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 473: , p5_a26 JTF_NUMBER_TABLE

469: , p5_a22 JTF_VARCHAR2_TABLE_500
470: , p5_a23 JTF_VARCHAR2_TABLE_500
471: , p5_a24 JTF_VARCHAR2_TABLE_500
472: , p5_a25 JTF_VARCHAR2_TABLE_500
473: , p5_a26 JTF_NUMBER_TABLE
474: , p5_a27 JTF_NUMBER_TABLE
475: , p5_a28 JTF_DATE_TABLE
476: , p5_a29 JTF_NUMBER_TABLE
477: , p5_a30 JTF_DATE_TABLE

Line 474: , p5_a27 JTF_NUMBER_TABLE

470: , p5_a23 JTF_VARCHAR2_TABLE_500
471: , p5_a24 JTF_VARCHAR2_TABLE_500
472: , p5_a25 JTF_VARCHAR2_TABLE_500
473: , p5_a26 JTF_NUMBER_TABLE
474: , p5_a27 JTF_NUMBER_TABLE
475: , p5_a28 JTF_DATE_TABLE
476: , p5_a29 JTF_NUMBER_TABLE
477: , p5_a30 JTF_DATE_TABLE
478: , p5_a31 JTF_NUMBER_TABLE

Line 476: , p5_a29 JTF_NUMBER_TABLE

472: , p5_a25 JTF_VARCHAR2_TABLE_500
473: , p5_a26 JTF_NUMBER_TABLE
474: , p5_a27 JTF_NUMBER_TABLE
475: , p5_a28 JTF_DATE_TABLE
476: , p5_a29 JTF_NUMBER_TABLE
477: , p5_a30 JTF_DATE_TABLE
478: , p5_a31 JTF_NUMBER_TABLE
479: , p6_a0 out nocopy JTF_NUMBER_TABLE
480: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 478: , p5_a31 JTF_NUMBER_TABLE

474: , p5_a27 JTF_NUMBER_TABLE
475: , p5_a28 JTF_DATE_TABLE
476: , p5_a29 JTF_NUMBER_TABLE
477: , p5_a30 JTF_DATE_TABLE
478: , p5_a31 JTF_NUMBER_TABLE
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_VARCHAR2_TABLE_100

Line 479: , p6_a0 out nocopy JTF_NUMBER_TABLE

475: , p5_a28 JTF_DATE_TABLE
476: , p5_a29 JTF_NUMBER_TABLE
477: , p5_a30 JTF_DATE_TABLE
478: , p5_a31 JTF_NUMBER_TABLE
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_VARCHAR2_TABLE_100
483: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 480: , p6_a1 out nocopy JTF_NUMBER_TABLE

476: , p5_a29 JTF_NUMBER_TABLE
477: , p5_a30 JTF_DATE_TABLE
478: , p5_a31 JTF_NUMBER_TABLE
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_VARCHAR2_TABLE_100
483: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
484: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 505: , p6_a26 out nocopy JTF_NUMBER_TABLE

501: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
502: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
503: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
504: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
505: , p6_a26 out nocopy JTF_NUMBER_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_DATE_TABLE

Line 506: , p6_a27 out nocopy JTF_NUMBER_TABLE

502: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
503: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
504: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
505: , p6_a26 out nocopy JTF_NUMBER_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_DATE_TABLE
510: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 508: , p6_a29 out nocopy JTF_NUMBER_TABLE

504: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
505: , p6_a26 out nocopy JTF_NUMBER_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_DATE_TABLE
510: , p6_a31 out nocopy JTF_NUMBER_TABLE
511: );
512: procedure delete_row(p_api_version NUMBER

Line 510: , p6_a31 out nocopy JTF_NUMBER_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_DATE_TABLE
510: , p6_a31 out nocopy JTF_NUMBER_TABLE
511: );
512: procedure delete_row(p_api_version NUMBER
513: , p_init_msg_list VARCHAR2
514: , x_return_status out nocopy VARCHAR2

Line 555: , p5_a0 JTF_NUMBER_TABLE

551: , p_init_msg_list VARCHAR2
552: , x_return_status out nocopy VARCHAR2
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_VARCHAR2_TABLE_100
559: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 556: , p5_a1 JTF_NUMBER_TABLE

552: , x_return_status out nocopy VARCHAR2
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_VARCHAR2_TABLE_100
559: , p5_a4 JTF_VARCHAR2_TABLE_200
560: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 581: , p5_a26 JTF_NUMBER_TABLE

577: , p5_a22 JTF_VARCHAR2_TABLE_500
578: , p5_a23 JTF_VARCHAR2_TABLE_500
579: , p5_a24 JTF_VARCHAR2_TABLE_500
580: , p5_a25 JTF_VARCHAR2_TABLE_500
581: , p5_a26 JTF_NUMBER_TABLE
582: , p5_a27 JTF_NUMBER_TABLE
583: , p5_a28 JTF_DATE_TABLE
584: , p5_a29 JTF_NUMBER_TABLE
585: , p5_a30 JTF_DATE_TABLE

Line 582: , p5_a27 JTF_NUMBER_TABLE

578: , p5_a23 JTF_VARCHAR2_TABLE_500
579: , p5_a24 JTF_VARCHAR2_TABLE_500
580: , p5_a25 JTF_VARCHAR2_TABLE_500
581: , p5_a26 JTF_NUMBER_TABLE
582: , p5_a27 JTF_NUMBER_TABLE
583: , p5_a28 JTF_DATE_TABLE
584: , p5_a29 JTF_NUMBER_TABLE
585: , p5_a30 JTF_DATE_TABLE
586: , p5_a31 JTF_NUMBER_TABLE

Line 584: , p5_a29 JTF_NUMBER_TABLE

580: , p5_a25 JTF_VARCHAR2_TABLE_500
581: , p5_a26 JTF_NUMBER_TABLE
582: , p5_a27 JTF_NUMBER_TABLE
583: , p5_a28 JTF_DATE_TABLE
584: , p5_a29 JTF_NUMBER_TABLE
585: , p5_a30 JTF_DATE_TABLE
586: , p5_a31 JTF_NUMBER_TABLE
587: );
588: procedure validate_row(p_api_version NUMBER

Line 586: , p5_a31 JTF_NUMBER_TABLE

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

Line 631: , p5_a0 JTF_NUMBER_TABLE

627: , p_init_msg_list VARCHAR2
628: , x_return_status out nocopy VARCHAR2
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_VARCHAR2_TABLE_100
635: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 632: , p5_a1 JTF_NUMBER_TABLE

628: , x_return_status out nocopy VARCHAR2
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_VARCHAR2_TABLE_100
635: , p5_a4 JTF_VARCHAR2_TABLE_200
636: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 657: , p5_a26 JTF_NUMBER_TABLE

653: , p5_a22 JTF_VARCHAR2_TABLE_500
654: , p5_a23 JTF_VARCHAR2_TABLE_500
655: , p5_a24 JTF_VARCHAR2_TABLE_500
656: , p5_a25 JTF_VARCHAR2_TABLE_500
657: , p5_a26 JTF_NUMBER_TABLE
658: , p5_a27 JTF_NUMBER_TABLE
659: , p5_a28 JTF_DATE_TABLE
660: , p5_a29 JTF_NUMBER_TABLE
661: , p5_a30 JTF_DATE_TABLE

Line 658: , p5_a27 JTF_NUMBER_TABLE

654: , p5_a23 JTF_VARCHAR2_TABLE_500
655: , p5_a24 JTF_VARCHAR2_TABLE_500
656: , p5_a25 JTF_VARCHAR2_TABLE_500
657: , p5_a26 JTF_NUMBER_TABLE
658: , p5_a27 JTF_NUMBER_TABLE
659: , p5_a28 JTF_DATE_TABLE
660: , p5_a29 JTF_NUMBER_TABLE
661: , p5_a30 JTF_DATE_TABLE
662: , p5_a31 JTF_NUMBER_TABLE

Line 660: , p5_a29 JTF_NUMBER_TABLE

656: , p5_a25 JTF_VARCHAR2_TABLE_500
657: , p5_a26 JTF_NUMBER_TABLE
658: , p5_a27 JTF_NUMBER_TABLE
659: , p5_a28 JTF_DATE_TABLE
660: , p5_a29 JTF_NUMBER_TABLE
661: , p5_a30 JTF_DATE_TABLE
662: , p5_a31 JTF_NUMBER_TABLE
663: );
664: end okl_dsf_pvt_w;

Line 662: , p5_a31 JTF_NUMBER_TABLE

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