APPS.OKL_SST_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sst_pvt.sst_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_sst_pvt_w as
2: /* $Header: OKLISSTS.pls 120.1 2005/08/11 11:05:46 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sst_pvt.sst_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_sst_pvt_w as
2: /* $Header: OKLISSTS.pls 120.1 2005/08/11 11:05:46 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sst_pvt.sst_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_sst_pvt_w as
2: /* $Header: OKLISSTS.pls 120.1 2005/08/11 11:05:46 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sst_pvt.sst_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_500

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLISSTS.pls 120.1 2005/08/11 11:05:46 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sst_pvt.sst_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_VARCHAR2_TABLE_500

Line 24: , a21 JTF_NUMBER_TABLE

20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE

Line 26: , a23 JTF_NUMBER_TABLE

22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_sst_pvt.sst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 28: , a25 JTF_NUMBER_TABLE

24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_sst_pvt.sst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE

Line 30: procedure rosetta_table_copy_out_p2(t okl_sst_pvt.sst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_sst_pvt.sst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 31: , a1 out nocopy JTF_NUMBER_TABLE

27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_sst_pvt.sst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 32: , a2 out nocopy JTF_NUMBER_TABLE

28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_sst_pvt.sst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100
36: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 33: , a3 out nocopy JTF_NUMBER_TABLE

29: );
30: procedure rosetta_table_copy_out_p2(t okl_sst_pvt.sst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100
36: , a6 out nocopy JTF_VARCHAR2_TABLE_500
37: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 51: , a21 out nocopy JTF_NUMBER_TABLE

47: , a17 out nocopy JTF_VARCHAR2_TABLE_500
48: , a18 out nocopy JTF_VARCHAR2_TABLE_500
49: , a19 out nocopy JTF_VARCHAR2_TABLE_500
50: , a20 out nocopy JTF_VARCHAR2_TABLE_500
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE

Line 53: , a23 out nocopy JTF_NUMBER_TABLE

49: , a19 out nocopy JTF_VARCHAR2_TABLE_500
50: , a20 out nocopy JTF_VARCHAR2_TABLE_500
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:

Line 55: , a25 out nocopy JTF_NUMBER_TABLE

51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:
58: procedure rosetta_table_copy_in_p5(t out nocopy okl_sst_pvt.sstv_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_NUMBER_TABLE

Line 58: procedure rosetta_table_copy_in_p5(t out nocopy okl_sst_pvt.sstv_tbl_type, a0 JTF_NUMBER_TABLE

54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:
58: procedure rosetta_table_copy_in_p5(t out nocopy okl_sst_pvt.sstv_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_NUMBER_TABLE
60: , a2 JTF_NUMBER_TABLE
61: , a3 JTF_NUMBER_TABLE
62: , a4 JTF_VARCHAR2_TABLE_100

Line 59: , a1 JTF_NUMBER_TABLE

55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:
58: procedure rosetta_table_copy_in_p5(t out nocopy okl_sst_pvt.sstv_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_NUMBER_TABLE
60: , a2 JTF_NUMBER_TABLE
61: , a3 JTF_NUMBER_TABLE
62: , a4 JTF_VARCHAR2_TABLE_100
63: , a5 JTF_VARCHAR2_TABLE_100

Line 60: , a2 JTF_NUMBER_TABLE

56: );
57:
58: procedure rosetta_table_copy_in_p5(t out nocopy okl_sst_pvt.sstv_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_NUMBER_TABLE
60: , a2 JTF_NUMBER_TABLE
61: , a3 JTF_NUMBER_TABLE
62: , a4 JTF_VARCHAR2_TABLE_100
63: , a5 JTF_VARCHAR2_TABLE_100
64: , a6 JTF_VARCHAR2_TABLE_500

Line 61: , a3 JTF_NUMBER_TABLE

57:
58: procedure rosetta_table_copy_in_p5(t out nocopy okl_sst_pvt.sstv_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_NUMBER_TABLE
60: , a2 JTF_NUMBER_TABLE
61: , a3 JTF_NUMBER_TABLE
62: , a4 JTF_VARCHAR2_TABLE_100
63: , a5 JTF_VARCHAR2_TABLE_100
64: , a6 JTF_VARCHAR2_TABLE_500
65: , a7 JTF_VARCHAR2_TABLE_500

Line 79: , a21 JTF_NUMBER_TABLE

75: , a17 JTF_VARCHAR2_TABLE_500
76: , a18 JTF_VARCHAR2_TABLE_500
77: , a19 JTF_VARCHAR2_TABLE_500
78: , a20 JTF_VARCHAR2_TABLE_500
79: , a21 JTF_NUMBER_TABLE
80: , a22 JTF_DATE_TABLE
81: , a23 JTF_NUMBER_TABLE
82: , a24 JTF_DATE_TABLE
83: , a25 JTF_NUMBER_TABLE

Line 81: , a23 JTF_NUMBER_TABLE

77: , a19 JTF_VARCHAR2_TABLE_500
78: , a20 JTF_VARCHAR2_TABLE_500
79: , a21 JTF_NUMBER_TABLE
80: , a22 JTF_DATE_TABLE
81: , a23 JTF_NUMBER_TABLE
82: , a24 JTF_DATE_TABLE
83: , a25 JTF_NUMBER_TABLE
84: );
85: procedure rosetta_table_copy_out_p5(t okl_sst_pvt.sstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 83: , a25 JTF_NUMBER_TABLE

79: , a21 JTF_NUMBER_TABLE
80: , a22 JTF_DATE_TABLE
81: , a23 JTF_NUMBER_TABLE
82: , a24 JTF_DATE_TABLE
83: , a25 JTF_NUMBER_TABLE
84: );
85: procedure rosetta_table_copy_out_p5(t okl_sst_pvt.sstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_NUMBER_TABLE

Line 85: procedure rosetta_table_copy_out_p5(t okl_sst_pvt.sstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

81: , a23 JTF_NUMBER_TABLE
82: , a24 JTF_DATE_TABLE
83: , a25 JTF_NUMBER_TABLE
84: );
85: procedure rosetta_table_copy_out_p5(t okl_sst_pvt.sstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_NUMBER_TABLE
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 86: , a1 out nocopy JTF_NUMBER_TABLE

82: , a24 JTF_DATE_TABLE
83: , a25 JTF_NUMBER_TABLE
84: );
85: procedure rosetta_table_copy_out_p5(t okl_sst_pvt.sstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_NUMBER_TABLE
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_VARCHAR2_TABLE_100
90: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 87: , a2 out nocopy JTF_NUMBER_TABLE

83: , a25 JTF_NUMBER_TABLE
84: );
85: procedure rosetta_table_copy_out_p5(t okl_sst_pvt.sstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_NUMBER_TABLE
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_VARCHAR2_TABLE_100
90: , a5 out nocopy JTF_VARCHAR2_TABLE_100
91: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 88: , a3 out nocopy JTF_NUMBER_TABLE

84: );
85: procedure rosetta_table_copy_out_p5(t okl_sst_pvt.sstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_NUMBER_TABLE
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_VARCHAR2_TABLE_100
90: , a5 out nocopy JTF_VARCHAR2_TABLE_100
91: , a6 out nocopy JTF_VARCHAR2_TABLE_500
92: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 106: , a21 out nocopy JTF_NUMBER_TABLE

102: , a17 out nocopy JTF_VARCHAR2_TABLE_500
103: , a18 out nocopy JTF_VARCHAR2_TABLE_500
104: , a19 out nocopy JTF_VARCHAR2_TABLE_500
105: , a20 out nocopy JTF_VARCHAR2_TABLE_500
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_DATE_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE
109: , a24 out nocopy JTF_DATE_TABLE
110: , a25 out nocopy JTF_NUMBER_TABLE

Line 108: , a23 out nocopy JTF_NUMBER_TABLE

104: , a19 out nocopy JTF_VARCHAR2_TABLE_500
105: , a20 out nocopy JTF_VARCHAR2_TABLE_500
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_DATE_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE
109: , a24 out nocopy JTF_DATE_TABLE
110: , a25 out nocopy JTF_NUMBER_TABLE
111: );
112:

Line 110: , a25 out nocopy JTF_NUMBER_TABLE

106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_DATE_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE
109: , a24 out nocopy JTF_DATE_TABLE
110: , a25 out nocopy JTF_NUMBER_TABLE
111: );
112:
113: procedure insert_row(p_api_version NUMBER
114: , p_init_msg_list VARCHAR2

Line 176: , p5_a0 JTF_NUMBER_TABLE

172: , p_init_msg_list VARCHAR2
173: , x_return_status out nocopy VARCHAR2
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_NUMBER_TABLE
179: , p5_a3 JTF_NUMBER_TABLE
180: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 177: , p5_a1 JTF_NUMBER_TABLE

173: , x_return_status out nocopy VARCHAR2
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_NUMBER_TABLE
179: , p5_a3 JTF_NUMBER_TABLE
180: , p5_a4 JTF_VARCHAR2_TABLE_100
181: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 178: , p5_a2 JTF_NUMBER_TABLE

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_NUMBER_TABLE
179: , p5_a3 JTF_NUMBER_TABLE
180: , p5_a4 JTF_VARCHAR2_TABLE_100
181: , p5_a5 JTF_VARCHAR2_TABLE_100
182: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 179: , p5_a3 JTF_NUMBER_TABLE

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

Line 197: , p5_a21 JTF_NUMBER_TABLE

193: , p5_a17 JTF_VARCHAR2_TABLE_500
194: , p5_a18 JTF_VARCHAR2_TABLE_500
195: , p5_a19 JTF_VARCHAR2_TABLE_500
196: , p5_a20 JTF_VARCHAR2_TABLE_500
197: , p5_a21 JTF_NUMBER_TABLE
198: , p5_a22 JTF_DATE_TABLE
199: , p5_a23 JTF_NUMBER_TABLE
200: , p5_a24 JTF_DATE_TABLE
201: , p5_a25 JTF_NUMBER_TABLE

Line 199: , p5_a23 JTF_NUMBER_TABLE

195: , p5_a19 JTF_VARCHAR2_TABLE_500
196: , p5_a20 JTF_VARCHAR2_TABLE_500
197: , p5_a21 JTF_NUMBER_TABLE
198: , p5_a22 JTF_DATE_TABLE
199: , p5_a23 JTF_NUMBER_TABLE
200: , p5_a24 JTF_DATE_TABLE
201: , p5_a25 JTF_NUMBER_TABLE
202: , p6_a0 out nocopy JTF_NUMBER_TABLE
203: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 201: , p5_a25 JTF_NUMBER_TABLE

197: , p5_a21 JTF_NUMBER_TABLE
198: , p5_a22 JTF_DATE_TABLE
199: , p5_a23 JTF_NUMBER_TABLE
200: , p5_a24 JTF_DATE_TABLE
201: , p5_a25 JTF_NUMBER_TABLE
202: , p6_a0 out nocopy JTF_NUMBER_TABLE
203: , p6_a1 out nocopy JTF_NUMBER_TABLE
204: , p6_a2 out nocopy JTF_NUMBER_TABLE
205: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 202: , p6_a0 out nocopy JTF_NUMBER_TABLE

198: , p5_a22 JTF_DATE_TABLE
199: , p5_a23 JTF_NUMBER_TABLE
200: , p5_a24 JTF_DATE_TABLE
201: , p5_a25 JTF_NUMBER_TABLE
202: , p6_a0 out nocopy JTF_NUMBER_TABLE
203: , p6_a1 out nocopy JTF_NUMBER_TABLE
204: , p6_a2 out nocopy JTF_NUMBER_TABLE
205: , p6_a3 out nocopy JTF_NUMBER_TABLE
206: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 203: , p6_a1 out nocopy JTF_NUMBER_TABLE

199: , p5_a23 JTF_NUMBER_TABLE
200: , p5_a24 JTF_DATE_TABLE
201: , p5_a25 JTF_NUMBER_TABLE
202: , p6_a0 out nocopy JTF_NUMBER_TABLE
203: , p6_a1 out nocopy JTF_NUMBER_TABLE
204: , p6_a2 out nocopy JTF_NUMBER_TABLE
205: , p6_a3 out nocopy JTF_NUMBER_TABLE
206: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
207: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 204: , p6_a2 out nocopy JTF_NUMBER_TABLE

200: , p5_a24 JTF_DATE_TABLE
201: , p5_a25 JTF_NUMBER_TABLE
202: , p6_a0 out nocopy JTF_NUMBER_TABLE
203: , p6_a1 out nocopy JTF_NUMBER_TABLE
204: , p6_a2 out nocopy JTF_NUMBER_TABLE
205: , p6_a3 out nocopy JTF_NUMBER_TABLE
206: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
207: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
208: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 205: , p6_a3 out nocopy JTF_NUMBER_TABLE

201: , p5_a25 JTF_NUMBER_TABLE
202: , p6_a0 out nocopy JTF_NUMBER_TABLE
203: , p6_a1 out nocopy JTF_NUMBER_TABLE
204: , p6_a2 out nocopy JTF_NUMBER_TABLE
205: , p6_a3 out nocopy JTF_NUMBER_TABLE
206: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
207: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
208: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
209: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 223: , p6_a21 out nocopy JTF_NUMBER_TABLE

219: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
220: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
221: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
222: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
223: , p6_a21 out nocopy JTF_NUMBER_TABLE
224: , p6_a22 out nocopy JTF_DATE_TABLE
225: , p6_a23 out nocopy JTF_NUMBER_TABLE
226: , p6_a24 out nocopy JTF_DATE_TABLE
227: , p6_a25 out nocopy JTF_NUMBER_TABLE

Line 225: , p6_a23 out nocopy JTF_NUMBER_TABLE

221: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
222: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
223: , p6_a21 out nocopy JTF_NUMBER_TABLE
224: , p6_a22 out nocopy JTF_DATE_TABLE
225: , p6_a23 out nocopy JTF_NUMBER_TABLE
226: , p6_a24 out nocopy JTF_DATE_TABLE
227: , p6_a25 out nocopy JTF_NUMBER_TABLE
228: );
229: procedure lock_row(p_api_version NUMBER

Line 227: , p6_a25 out nocopy JTF_NUMBER_TABLE

223: , p6_a21 out nocopy JTF_NUMBER_TABLE
224: , p6_a22 out nocopy JTF_DATE_TABLE
225: , p6_a23 out nocopy JTF_NUMBER_TABLE
226: , p6_a24 out nocopy JTF_DATE_TABLE
227: , p6_a25 out nocopy JTF_NUMBER_TABLE
228: );
229: procedure lock_row(p_api_version NUMBER
230: , p_init_msg_list VARCHAR2
231: , x_return_status out nocopy VARCHAR2

Line 266: , p5_a0 JTF_NUMBER_TABLE

262: , p_init_msg_list VARCHAR2
263: , x_return_status out nocopy VARCHAR2
264: , x_msg_count out nocopy NUMBER
265: , x_msg_data out nocopy VARCHAR2
266: , p5_a0 JTF_NUMBER_TABLE
267: , p5_a1 JTF_NUMBER_TABLE
268: , p5_a2 JTF_NUMBER_TABLE
269: , p5_a3 JTF_NUMBER_TABLE
270: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 267: , p5_a1 JTF_NUMBER_TABLE

263: , x_return_status out nocopy VARCHAR2
264: , x_msg_count out nocopy NUMBER
265: , x_msg_data out nocopy VARCHAR2
266: , p5_a0 JTF_NUMBER_TABLE
267: , p5_a1 JTF_NUMBER_TABLE
268: , p5_a2 JTF_NUMBER_TABLE
269: , p5_a3 JTF_NUMBER_TABLE
270: , p5_a4 JTF_VARCHAR2_TABLE_100
271: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 268: , p5_a2 JTF_NUMBER_TABLE

264: , x_msg_count out nocopy NUMBER
265: , x_msg_data out nocopy VARCHAR2
266: , p5_a0 JTF_NUMBER_TABLE
267: , p5_a1 JTF_NUMBER_TABLE
268: , p5_a2 JTF_NUMBER_TABLE
269: , p5_a3 JTF_NUMBER_TABLE
270: , p5_a4 JTF_VARCHAR2_TABLE_100
271: , p5_a5 JTF_VARCHAR2_TABLE_100
272: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 269: , p5_a3 JTF_NUMBER_TABLE

265: , x_msg_data out nocopy VARCHAR2
266: , p5_a0 JTF_NUMBER_TABLE
267: , p5_a1 JTF_NUMBER_TABLE
268: , p5_a2 JTF_NUMBER_TABLE
269: , p5_a3 JTF_NUMBER_TABLE
270: , p5_a4 JTF_VARCHAR2_TABLE_100
271: , p5_a5 JTF_VARCHAR2_TABLE_100
272: , p5_a6 JTF_VARCHAR2_TABLE_500
273: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 287: , p5_a21 JTF_NUMBER_TABLE

283: , p5_a17 JTF_VARCHAR2_TABLE_500
284: , p5_a18 JTF_VARCHAR2_TABLE_500
285: , p5_a19 JTF_VARCHAR2_TABLE_500
286: , p5_a20 JTF_VARCHAR2_TABLE_500
287: , p5_a21 JTF_NUMBER_TABLE
288: , p5_a22 JTF_DATE_TABLE
289: , p5_a23 JTF_NUMBER_TABLE
290: , p5_a24 JTF_DATE_TABLE
291: , p5_a25 JTF_NUMBER_TABLE

Line 289: , p5_a23 JTF_NUMBER_TABLE

285: , p5_a19 JTF_VARCHAR2_TABLE_500
286: , p5_a20 JTF_VARCHAR2_TABLE_500
287: , p5_a21 JTF_NUMBER_TABLE
288: , p5_a22 JTF_DATE_TABLE
289: , p5_a23 JTF_NUMBER_TABLE
290: , p5_a24 JTF_DATE_TABLE
291: , p5_a25 JTF_NUMBER_TABLE
292: );
293: procedure update_row(p_api_version NUMBER

Line 291: , p5_a25 JTF_NUMBER_TABLE

287: , p5_a21 JTF_NUMBER_TABLE
288: , p5_a22 JTF_DATE_TABLE
289: , p5_a23 JTF_NUMBER_TABLE
290: , p5_a24 JTF_DATE_TABLE
291: , p5_a25 JTF_NUMBER_TABLE
292: );
293: procedure update_row(p_api_version NUMBER
294: , p_init_msg_list VARCHAR2
295: , x_return_status out nocopy VARCHAR2

Line 356: , p5_a0 JTF_NUMBER_TABLE

352: , p_init_msg_list VARCHAR2
353: , x_return_status out nocopy VARCHAR2
354: , x_msg_count out nocopy NUMBER
355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_NUMBER_TABLE
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 357: , p5_a1 JTF_NUMBER_TABLE

353: , x_return_status out nocopy VARCHAR2
354: , x_msg_count out nocopy NUMBER
355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_NUMBER_TABLE
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_VARCHAR2_TABLE_100
361: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 358: , p5_a2 JTF_NUMBER_TABLE

354: , x_msg_count out nocopy NUMBER
355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_NUMBER_TABLE
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_VARCHAR2_TABLE_100
361: , p5_a5 JTF_VARCHAR2_TABLE_100
362: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 359: , p5_a3 JTF_NUMBER_TABLE

355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_NUMBER_TABLE
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_VARCHAR2_TABLE_100
361: , p5_a5 JTF_VARCHAR2_TABLE_100
362: , p5_a6 JTF_VARCHAR2_TABLE_500
363: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 377: , p5_a21 JTF_NUMBER_TABLE

373: , p5_a17 JTF_VARCHAR2_TABLE_500
374: , p5_a18 JTF_VARCHAR2_TABLE_500
375: , p5_a19 JTF_VARCHAR2_TABLE_500
376: , p5_a20 JTF_VARCHAR2_TABLE_500
377: , p5_a21 JTF_NUMBER_TABLE
378: , p5_a22 JTF_DATE_TABLE
379: , p5_a23 JTF_NUMBER_TABLE
380: , p5_a24 JTF_DATE_TABLE
381: , p5_a25 JTF_NUMBER_TABLE

Line 379: , p5_a23 JTF_NUMBER_TABLE

375: , p5_a19 JTF_VARCHAR2_TABLE_500
376: , p5_a20 JTF_VARCHAR2_TABLE_500
377: , p5_a21 JTF_NUMBER_TABLE
378: , p5_a22 JTF_DATE_TABLE
379: , p5_a23 JTF_NUMBER_TABLE
380: , p5_a24 JTF_DATE_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p6_a0 out nocopy JTF_NUMBER_TABLE
383: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 381: , p5_a25 JTF_NUMBER_TABLE

377: , p5_a21 JTF_NUMBER_TABLE
378: , p5_a22 JTF_DATE_TABLE
379: , p5_a23 JTF_NUMBER_TABLE
380: , p5_a24 JTF_DATE_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p6_a0 out nocopy JTF_NUMBER_TABLE
383: , p6_a1 out nocopy JTF_NUMBER_TABLE
384: , p6_a2 out nocopy JTF_NUMBER_TABLE
385: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 382: , p6_a0 out nocopy JTF_NUMBER_TABLE

378: , p5_a22 JTF_DATE_TABLE
379: , p5_a23 JTF_NUMBER_TABLE
380: , p5_a24 JTF_DATE_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p6_a0 out nocopy JTF_NUMBER_TABLE
383: , p6_a1 out nocopy JTF_NUMBER_TABLE
384: , p6_a2 out nocopy JTF_NUMBER_TABLE
385: , p6_a3 out nocopy JTF_NUMBER_TABLE
386: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 383: , p6_a1 out nocopy JTF_NUMBER_TABLE

379: , p5_a23 JTF_NUMBER_TABLE
380: , p5_a24 JTF_DATE_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p6_a0 out nocopy JTF_NUMBER_TABLE
383: , p6_a1 out nocopy JTF_NUMBER_TABLE
384: , p6_a2 out nocopy JTF_NUMBER_TABLE
385: , p6_a3 out nocopy JTF_NUMBER_TABLE
386: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
387: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 384: , p6_a2 out nocopy JTF_NUMBER_TABLE

380: , p5_a24 JTF_DATE_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p6_a0 out nocopy JTF_NUMBER_TABLE
383: , p6_a1 out nocopy JTF_NUMBER_TABLE
384: , p6_a2 out nocopy JTF_NUMBER_TABLE
385: , p6_a3 out nocopy JTF_NUMBER_TABLE
386: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
387: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
388: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 385: , p6_a3 out nocopy JTF_NUMBER_TABLE

381: , p5_a25 JTF_NUMBER_TABLE
382: , p6_a0 out nocopy JTF_NUMBER_TABLE
383: , p6_a1 out nocopy JTF_NUMBER_TABLE
384: , p6_a2 out nocopy JTF_NUMBER_TABLE
385: , p6_a3 out nocopy JTF_NUMBER_TABLE
386: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
387: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
388: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
389: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 403: , p6_a21 out nocopy JTF_NUMBER_TABLE

399: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
400: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
401: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
402: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
403: , p6_a21 out nocopy JTF_NUMBER_TABLE
404: , p6_a22 out nocopy JTF_DATE_TABLE
405: , p6_a23 out nocopy JTF_NUMBER_TABLE
406: , p6_a24 out nocopy JTF_DATE_TABLE
407: , p6_a25 out nocopy JTF_NUMBER_TABLE

Line 405: , p6_a23 out nocopy JTF_NUMBER_TABLE

401: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
402: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
403: , p6_a21 out nocopy JTF_NUMBER_TABLE
404: , p6_a22 out nocopy JTF_DATE_TABLE
405: , p6_a23 out nocopy JTF_NUMBER_TABLE
406: , p6_a24 out nocopy JTF_DATE_TABLE
407: , p6_a25 out nocopy JTF_NUMBER_TABLE
408: );
409: procedure delete_row(p_api_version NUMBER

Line 407: , p6_a25 out nocopy JTF_NUMBER_TABLE

403: , p6_a21 out nocopy JTF_NUMBER_TABLE
404: , p6_a22 out nocopy JTF_DATE_TABLE
405: , p6_a23 out nocopy JTF_NUMBER_TABLE
406: , p6_a24 out nocopy JTF_DATE_TABLE
407: , p6_a25 out nocopy JTF_NUMBER_TABLE
408: );
409: procedure delete_row(p_api_version NUMBER
410: , p_init_msg_list VARCHAR2
411: , x_return_status out nocopy VARCHAR2

Line 446: , p5_a0 JTF_NUMBER_TABLE

442: , p_init_msg_list VARCHAR2
443: , x_return_status out nocopy VARCHAR2
444: , x_msg_count out nocopy NUMBER
445: , x_msg_data out nocopy VARCHAR2
446: , p5_a0 JTF_NUMBER_TABLE
447: , p5_a1 JTF_NUMBER_TABLE
448: , p5_a2 JTF_NUMBER_TABLE
449: , p5_a3 JTF_NUMBER_TABLE
450: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 447: , p5_a1 JTF_NUMBER_TABLE

443: , x_return_status out nocopy VARCHAR2
444: , x_msg_count out nocopy NUMBER
445: , x_msg_data out nocopy VARCHAR2
446: , p5_a0 JTF_NUMBER_TABLE
447: , p5_a1 JTF_NUMBER_TABLE
448: , p5_a2 JTF_NUMBER_TABLE
449: , p5_a3 JTF_NUMBER_TABLE
450: , p5_a4 JTF_VARCHAR2_TABLE_100
451: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 448: , p5_a2 JTF_NUMBER_TABLE

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

Line 449: , p5_a3 JTF_NUMBER_TABLE

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

Line 467: , p5_a21 JTF_NUMBER_TABLE

463: , p5_a17 JTF_VARCHAR2_TABLE_500
464: , p5_a18 JTF_VARCHAR2_TABLE_500
465: , p5_a19 JTF_VARCHAR2_TABLE_500
466: , p5_a20 JTF_VARCHAR2_TABLE_500
467: , p5_a21 JTF_NUMBER_TABLE
468: , p5_a22 JTF_DATE_TABLE
469: , p5_a23 JTF_NUMBER_TABLE
470: , p5_a24 JTF_DATE_TABLE
471: , p5_a25 JTF_NUMBER_TABLE

Line 469: , p5_a23 JTF_NUMBER_TABLE

465: , p5_a19 JTF_VARCHAR2_TABLE_500
466: , p5_a20 JTF_VARCHAR2_TABLE_500
467: , p5_a21 JTF_NUMBER_TABLE
468: , p5_a22 JTF_DATE_TABLE
469: , p5_a23 JTF_NUMBER_TABLE
470: , p5_a24 JTF_DATE_TABLE
471: , p5_a25 JTF_NUMBER_TABLE
472: );
473: procedure validate_row(p_api_version NUMBER

Line 471: , p5_a25 JTF_NUMBER_TABLE

467: , p5_a21 JTF_NUMBER_TABLE
468: , p5_a22 JTF_DATE_TABLE
469: , p5_a23 JTF_NUMBER_TABLE
470: , p5_a24 JTF_DATE_TABLE
471: , p5_a25 JTF_NUMBER_TABLE
472: );
473: procedure validate_row(p_api_version NUMBER
474: , p_init_msg_list VARCHAR2
475: , x_return_status out nocopy VARCHAR2

Line 510: , p5_a0 JTF_NUMBER_TABLE

506: , p_init_msg_list VARCHAR2
507: , x_return_status out nocopy VARCHAR2
508: , x_msg_count out nocopy NUMBER
509: , x_msg_data out nocopy VARCHAR2
510: , p5_a0 JTF_NUMBER_TABLE
511: , p5_a1 JTF_NUMBER_TABLE
512: , p5_a2 JTF_NUMBER_TABLE
513: , p5_a3 JTF_NUMBER_TABLE
514: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 511: , p5_a1 JTF_NUMBER_TABLE

507: , x_return_status out nocopy VARCHAR2
508: , x_msg_count out nocopy NUMBER
509: , x_msg_data out nocopy VARCHAR2
510: , p5_a0 JTF_NUMBER_TABLE
511: , p5_a1 JTF_NUMBER_TABLE
512: , p5_a2 JTF_NUMBER_TABLE
513: , p5_a3 JTF_NUMBER_TABLE
514: , p5_a4 JTF_VARCHAR2_TABLE_100
515: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 512: , p5_a2 JTF_NUMBER_TABLE

508: , x_msg_count out nocopy NUMBER
509: , x_msg_data out nocopy VARCHAR2
510: , p5_a0 JTF_NUMBER_TABLE
511: , p5_a1 JTF_NUMBER_TABLE
512: , p5_a2 JTF_NUMBER_TABLE
513: , p5_a3 JTF_NUMBER_TABLE
514: , p5_a4 JTF_VARCHAR2_TABLE_100
515: , p5_a5 JTF_VARCHAR2_TABLE_100
516: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 513: , p5_a3 JTF_NUMBER_TABLE

509: , x_msg_data out nocopy VARCHAR2
510: , p5_a0 JTF_NUMBER_TABLE
511: , p5_a1 JTF_NUMBER_TABLE
512: , p5_a2 JTF_NUMBER_TABLE
513: , p5_a3 JTF_NUMBER_TABLE
514: , p5_a4 JTF_VARCHAR2_TABLE_100
515: , p5_a5 JTF_VARCHAR2_TABLE_100
516: , p5_a6 JTF_VARCHAR2_TABLE_500
517: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 531: , p5_a21 JTF_NUMBER_TABLE

527: , p5_a17 JTF_VARCHAR2_TABLE_500
528: , p5_a18 JTF_VARCHAR2_TABLE_500
529: , p5_a19 JTF_VARCHAR2_TABLE_500
530: , p5_a20 JTF_VARCHAR2_TABLE_500
531: , p5_a21 JTF_NUMBER_TABLE
532: , p5_a22 JTF_DATE_TABLE
533: , p5_a23 JTF_NUMBER_TABLE
534: , p5_a24 JTF_DATE_TABLE
535: , p5_a25 JTF_NUMBER_TABLE

Line 533: , p5_a23 JTF_NUMBER_TABLE

529: , p5_a19 JTF_VARCHAR2_TABLE_500
530: , p5_a20 JTF_VARCHAR2_TABLE_500
531: , p5_a21 JTF_NUMBER_TABLE
532: , p5_a22 JTF_DATE_TABLE
533: , p5_a23 JTF_NUMBER_TABLE
534: , p5_a24 JTF_DATE_TABLE
535: , p5_a25 JTF_NUMBER_TABLE
536: );
537: end okl_sst_pvt_w;

Line 535: , p5_a25 JTF_NUMBER_TABLE

531: , p5_a21 JTF_NUMBER_TABLE
532: , p5_a22 JTF_DATE_TABLE
533: , p5_a23 JTF_NUMBER_TABLE
534: , p5_a24 JTF_DATE_TABLE
535: , p5_a25 JTF_NUMBER_TABLE
536: );
537: end okl_sst_pvt_w;