APPS.OKL_DRS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_drs_pvt.drs_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_drs_pvt_w as
2: /* $Header: OKLIDRSS.pls 120.0 2007/04/27 09:21:02 gkhuntet noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_drs_pvt.drs_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_drs_pvt_w as
2: /* $Header: OKLIDRSS.pls 120.0 2007/04/27 09:21:02 gkhuntet noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_drs_pvt.drs_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_500

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_drs_pvt_w as
2: /* $Header: OKLIDRSS.pls 120.0 2007/04/27 09:21:02 gkhuntet noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_drs_pvt.drs_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_500
9: , a6 JTF_VARCHAR2_TABLE_500

Line 23: , a20 JTF_NUMBER_TABLE

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

Line 25: , a22 JTF_NUMBER_TABLE

21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: );
29: procedure rosetta_table_copy_out_p2(t okl_drs_pvt.drs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 27: , a24 JTF_NUMBER_TABLE

23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: );
29: procedure rosetta_table_copy_out_p2(t okl_drs_pvt.drs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
30: , a1 out nocopy JTF_NUMBER_TABLE
31: , a2 out nocopy JTF_NUMBER_TABLE

Line 29: procedure rosetta_table_copy_out_p2(t okl_drs_pvt.drs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: );
29: procedure rosetta_table_copy_out_p2(t okl_drs_pvt.drs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
30: , a1 out nocopy JTF_NUMBER_TABLE
31: , a2 out nocopy JTF_NUMBER_TABLE
32: , a3 out nocopy JTF_VARCHAR2_TABLE_100
33: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 30: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 31: , a2 out nocopy JTF_NUMBER_TABLE

27: , a24 JTF_NUMBER_TABLE
28: );
29: procedure rosetta_table_copy_out_p2(t okl_drs_pvt.drs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
30: , a1 out nocopy JTF_NUMBER_TABLE
31: , a2 out nocopy JTF_NUMBER_TABLE
32: , a3 out nocopy JTF_VARCHAR2_TABLE_100
33: , a4 out nocopy JTF_VARCHAR2_TABLE_100
34: , a5 out nocopy JTF_VARCHAR2_TABLE_500
35: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 49: , a20 out nocopy JTF_NUMBER_TABLE

45: , a16 out nocopy JTF_VARCHAR2_TABLE_500
46: , a17 out nocopy JTF_VARCHAR2_TABLE_500
47: , a18 out nocopy JTF_VARCHAR2_TABLE_500
48: , a19 out nocopy JTF_VARCHAR2_TABLE_500
49: , a20 out nocopy JTF_NUMBER_TABLE
50: , a21 out nocopy JTF_DATE_TABLE
51: , a22 out nocopy JTF_NUMBER_TABLE
52: , a23 out nocopy JTF_DATE_TABLE
53: , a24 out nocopy JTF_NUMBER_TABLE

Line 51: , a22 out nocopy JTF_NUMBER_TABLE

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

Line 53: , a24 out nocopy JTF_NUMBER_TABLE

49: , a20 out nocopy JTF_NUMBER_TABLE
50: , a21 out nocopy JTF_DATE_TABLE
51: , a22 out nocopy JTF_NUMBER_TABLE
52: , a23 out nocopy JTF_DATE_TABLE
53: , a24 out nocopy JTF_NUMBER_TABLE
54: );
55:
56: procedure insert_row(p_api_version NUMBER
57: , p_init_msg_list VARCHAR2

Line 117: , p5_a0 JTF_NUMBER_TABLE

113: , p_init_msg_list VARCHAR2
114: , x_return_status out nocopy VARCHAR2
115: , x_msg_count out nocopy NUMBER
116: , x_msg_data out nocopy VARCHAR2
117: , p5_a0 JTF_NUMBER_TABLE
118: , p5_a1 JTF_NUMBER_TABLE
119: , p5_a2 JTF_NUMBER_TABLE
120: , p5_a3 JTF_VARCHAR2_TABLE_100
121: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 118: , p5_a1 JTF_NUMBER_TABLE

114: , x_return_status out nocopy VARCHAR2
115: , x_msg_count out nocopy NUMBER
116: , x_msg_data out nocopy VARCHAR2
117: , p5_a0 JTF_NUMBER_TABLE
118: , p5_a1 JTF_NUMBER_TABLE
119: , p5_a2 JTF_NUMBER_TABLE
120: , p5_a3 JTF_VARCHAR2_TABLE_100
121: , p5_a4 JTF_VARCHAR2_TABLE_100
122: , p5_a5 JTF_VARCHAR2_TABLE_500

Line 119: , p5_a2 JTF_NUMBER_TABLE

115: , x_msg_count out nocopy NUMBER
116: , x_msg_data out nocopy VARCHAR2
117: , p5_a0 JTF_NUMBER_TABLE
118: , p5_a1 JTF_NUMBER_TABLE
119: , p5_a2 JTF_NUMBER_TABLE
120: , p5_a3 JTF_VARCHAR2_TABLE_100
121: , p5_a4 JTF_VARCHAR2_TABLE_100
122: , p5_a5 JTF_VARCHAR2_TABLE_500
123: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 137: , p5_a20 JTF_NUMBER_TABLE

133: , p5_a16 JTF_VARCHAR2_TABLE_500
134: , p5_a17 JTF_VARCHAR2_TABLE_500
135: , p5_a18 JTF_VARCHAR2_TABLE_500
136: , p5_a19 JTF_VARCHAR2_TABLE_500
137: , p5_a20 JTF_NUMBER_TABLE
138: , p5_a21 JTF_DATE_TABLE
139: , p5_a22 JTF_NUMBER_TABLE
140: , p5_a23 JTF_DATE_TABLE
141: , p5_a24 JTF_NUMBER_TABLE

Line 139: , p5_a22 JTF_NUMBER_TABLE

135: , p5_a18 JTF_VARCHAR2_TABLE_500
136: , p5_a19 JTF_VARCHAR2_TABLE_500
137: , p5_a20 JTF_NUMBER_TABLE
138: , p5_a21 JTF_DATE_TABLE
139: , p5_a22 JTF_NUMBER_TABLE
140: , p5_a23 JTF_DATE_TABLE
141: , p5_a24 JTF_NUMBER_TABLE
142: , p6_a0 out nocopy JTF_NUMBER_TABLE
143: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 141: , p5_a24 JTF_NUMBER_TABLE

137: , p5_a20 JTF_NUMBER_TABLE
138: , p5_a21 JTF_DATE_TABLE
139: , p5_a22 JTF_NUMBER_TABLE
140: , p5_a23 JTF_DATE_TABLE
141: , p5_a24 JTF_NUMBER_TABLE
142: , p6_a0 out nocopy JTF_NUMBER_TABLE
143: , p6_a1 out nocopy JTF_NUMBER_TABLE
144: , p6_a2 out nocopy JTF_NUMBER_TABLE
145: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 142: , p6_a0 out nocopy JTF_NUMBER_TABLE

138: , p5_a21 JTF_DATE_TABLE
139: , p5_a22 JTF_NUMBER_TABLE
140: , p5_a23 JTF_DATE_TABLE
141: , p5_a24 JTF_NUMBER_TABLE
142: , p6_a0 out nocopy JTF_NUMBER_TABLE
143: , p6_a1 out nocopy JTF_NUMBER_TABLE
144: , p6_a2 out nocopy JTF_NUMBER_TABLE
145: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
146: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 143: , p6_a1 out nocopy JTF_NUMBER_TABLE

139: , p5_a22 JTF_NUMBER_TABLE
140: , p5_a23 JTF_DATE_TABLE
141: , p5_a24 JTF_NUMBER_TABLE
142: , p6_a0 out nocopy JTF_NUMBER_TABLE
143: , p6_a1 out nocopy JTF_NUMBER_TABLE
144: , p6_a2 out nocopy JTF_NUMBER_TABLE
145: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
146: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
147: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500

Line 144: , p6_a2 out nocopy JTF_NUMBER_TABLE

140: , p5_a23 JTF_DATE_TABLE
141: , p5_a24 JTF_NUMBER_TABLE
142: , p6_a0 out nocopy JTF_NUMBER_TABLE
143: , p6_a1 out nocopy JTF_NUMBER_TABLE
144: , p6_a2 out nocopy JTF_NUMBER_TABLE
145: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
146: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
147: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
148: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 162: , p6_a20 out nocopy JTF_NUMBER_TABLE

158: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
159: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
160: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
161: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
162: , p6_a20 out nocopy JTF_NUMBER_TABLE
163: , p6_a21 out nocopy JTF_DATE_TABLE
164: , p6_a22 out nocopy JTF_NUMBER_TABLE
165: , p6_a23 out nocopy JTF_DATE_TABLE
166: , p6_a24 out nocopy JTF_NUMBER_TABLE

Line 164: , p6_a22 out nocopy JTF_NUMBER_TABLE

160: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
161: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
162: , p6_a20 out nocopy JTF_NUMBER_TABLE
163: , p6_a21 out nocopy JTF_DATE_TABLE
164: , p6_a22 out nocopy JTF_NUMBER_TABLE
165: , p6_a23 out nocopy JTF_DATE_TABLE
166: , p6_a24 out nocopy JTF_NUMBER_TABLE
167: );
168: procedure lock_row(p_api_version NUMBER

Line 166: , p6_a24 out nocopy JTF_NUMBER_TABLE

162: , p6_a20 out nocopy JTF_NUMBER_TABLE
163: , p6_a21 out nocopy JTF_DATE_TABLE
164: , p6_a22 out nocopy JTF_NUMBER_TABLE
165: , p6_a23 out nocopy JTF_DATE_TABLE
166: , p6_a24 out nocopy JTF_NUMBER_TABLE
167: );
168: procedure lock_row(p_api_version NUMBER
169: , p_init_msg_list VARCHAR2
170: , x_return_status out nocopy VARCHAR2

Line 204: , p5_a0 JTF_NUMBER_TABLE

200: , p_init_msg_list VARCHAR2
201: , x_return_status out nocopy VARCHAR2
202: , x_msg_count out nocopy NUMBER
203: , x_msg_data out nocopy VARCHAR2
204: , p5_a0 JTF_NUMBER_TABLE
205: , p5_a1 JTF_NUMBER_TABLE
206: , p5_a2 JTF_NUMBER_TABLE
207: , p5_a3 JTF_VARCHAR2_TABLE_100
208: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 205: , p5_a1 JTF_NUMBER_TABLE

201: , x_return_status out nocopy VARCHAR2
202: , x_msg_count out nocopy NUMBER
203: , x_msg_data out nocopy VARCHAR2
204: , p5_a0 JTF_NUMBER_TABLE
205: , p5_a1 JTF_NUMBER_TABLE
206: , p5_a2 JTF_NUMBER_TABLE
207: , p5_a3 JTF_VARCHAR2_TABLE_100
208: , p5_a4 JTF_VARCHAR2_TABLE_100
209: , p5_a5 JTF_VARCHAR2_TABLE_500

Line 206: , p5_a2 JTF_NUMBER_TABLE

202: , x_msg_count out nocopy NUMBER
203: , x_msg_data out nocopy VARCHAR2
204: , p5_a0 JTF_NUMBER_TABLE
205: , p5_a1 JTF_NUMBER_TABLE
206: , p5_a2 JTF_NUMBER_TABLE
207: , p5_a3 JTF_VARCHAR2_TABLE_100
208: , p5_a4 JTF_VARCHAR2_TABLE_100
209: , p5_a5 JTF_VARCHAR2_TABLE_500
210: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 224: , p5_a20 JTF_NUMBER_TABLE

220: , p5_a16 JTF_VARCHAR2_TABLE_500
221: , p5_a17 JTF_VARCHAR2_TABLE_500
222: , p5_a18 JTF_VARCHAR2_TABLE_500
223: , p5_a19 JTF_VARCHAR2_TABLE_500
224: , p5_a20 JTF_NUMBER_TABLE
225: , p5_a21 JTF_DATE_TABLE
226: , p5_a22 JTF_NUMBER_TABLE
227: , p5_a23 JTF_DATE_TABLE
228: , p5_a24 JTF_NUMBER_TABLE

Line 226: , p5_a22 JTF_NUMBER_TABLE

222: , p5_a18 JTF_VARCHAR2_TABLE_500
223: , p5_a19 JTF_VARCHAR2_TABLE_500
224: , p5_a20 JTF_NUMBER_TABLE
225: , p5_a21 JTF_DATE_TABLE
226: , p5_a22 JTF_NUMBER_TABLE
227: , p5_a23 JTF_DATE_TABLE
228: , p5_a24 JTF_NUMBER_TABLE
229: );
230: procedure update_row(p_api_version NUMBER

Line 228: , p5_a24 JTF_NUMBER_TABLE

224: , p5_a20 JTF_NUMBER_TABLE
225: , p5_a21 JTF_DATE_TABLE
226: , p5_a22 JTF_NUMBER_TABLE
227: , p5_a23 JTF_DATE_TABLE
228: , p5_a24 JTF_NUMBER_TABLE
229: );
230: procedure update_row(p_api_version NUMBER
231: , p_init_msg_list VARCHAR2
232: , x_return_status out nocopy VARCHAR2

Line 291: , p5_a0 JTF_NUMBER_TABLE

287: , p_init_msg_list VARCHAR2
288: , x_return_status out nocopy VARCHAR2
289: , x_msg_count out nocopy NUMBER
290: , x_msg_data out nocopy VARCHAR2
291: , p5_a0 JTF_NUMBER_TABLE
292: , p5_a1 JTF_NUMBER_TABLE
293: , p5_a2 JTF_NUMBER_TABLE
294: , p5_a3 JTF_VARCHAR2_TABLE_100
295: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 292: , p5_a1 JTF_NUMBER_TABLE

288: , x_return_status out nocopy VARCHAR2
289: , x_msg_count out nocopy NUMBER
290: , x_msg_data out nocopy VARCHAR2
291: , p5_a0 JTF_NUMBER_TABLE
292: , p5_a1 JTF_NUMBER_TABLE
293: , p5_a2 JTF_NUMBER_TABLE
294: , p5_a3 JTF_VARCHAR2_TABLE_100
295: , p5_a4 JTF_VARCHAR2_TABLE_100
296: , p5_a5 JTF_VARCHAR2_TABLE_500

Line 293: , p5_a2 JTF_NUMBER_TABLE

289: , x_msg_count out nocopy NUMBER
290: , x_msg_data out nocopy VARCHAR2
291: , p5_a0 JTF_NUMBER_TABLE
292: , p5_a1 JTF_NUMBER_TABLE
293: , p5_a2 JTF_NUMBER_TABLE
294: , p5_a3 JTF_VARCHAR2_TABLE_100
295: , p5_a4 JTF_VARCHAR2_TABLE_100
296: , p5_a5 JTF_VARCHAR2_TABLE_500
297: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 311: , p5_a20 JTF_NUMBER_TABLE

307: , p5_a16 JTF_VARCHAR2_TABLE_500
308: , p5_a17 JTF_VARCHAR2_TABLE_500
309: , p5_a18 JTF_VARCHAR2_TABLE_500
310: , p5_a19 JTF_VARCHAR2_TABLE_500
311: , p5_a20 JTF_NUMBER_TABLE
312: , p5_a21 JTF_DATE_TABLE
313: , p5_a22 JTF_NUMBER_TABLE
314: , p5_a23 JTF_DATE_TABLE
315: , p5_a24 JTF_NUMBER_TABLE

Line 313: , p5_a22 JTF_NUMBER_TABLE

309: , p5_a18 JTF_VARCHAR2_TABLE_500
310: , p5_a19 JTF_VARCHAR2_TABLE_500
311: , p5_a20 JTF_NUMBER_TABLE
312: , p5_a21 JTF_DATE_TABLE
313: , p5_a22 JTF_NUMBER_TABLE
314: , p5_a23 JTF_DATE_TABLE
315: , p5_a24 JTF_NUMBER_TABLE
316: , p6_a0 out nocopy JTF_NUMBER_TABLE
317: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 315: , p5_a24 JTF_NUMBER_TABLE

311: , p5_a20 JTF_NUMBER_TABLE
312: , p5_a21 JTF_DATE_TABLE
313: , p5_a22 JTF_NUMBER_TABLE
314: , p5_a23 JTF_DATE_TABLE
315: , p5_a24 JTF_NUMBER_TABLE
316: , p6_a0 out nocopy JTF_NUMBER_TABLE
317: , p6_a1 out nocopy JTF_NUMBER_TABLE
318: , p6_a2 out nocopy JTF_NUMBER_TABLE
319: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 316: , p6_a0 out nocopy JTF_NUMBER_TABLE

312: , p5_a21 JTF_DATE_TABLE
313: , p5_a22 JTF_NUMBER_TABLE
314: , p5_a23 JTF_DATE_TABLE
315: , p5_a24 JTF_NUMBER_TABLE
316: , p6_a0 out nocopy JTF_NUMBER_TABLE
317: , p6_a1 out nocopy JTF_NUMBER_TABLE
318: , p6_a2 out nocopy JTF_NUMBER_TABLE
319: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
320: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 317: , p6_a1 out nocopy JTF_NUMBER_TABLE

313: , p5_a22 JTF_NUMBER_TABLE
314: , p5_a23 JTF_DATE_TABLE
315: , p5_a24 JTF_NUMBER_TABLE
316: , p6_a0 out nocopy JTF_NUMBER_TABLE
317: , p6_a1 out nocopy JTF_NUMBER_TABLE
318: , p6_a2 out nocopy JTF_NUMBER_TABLE
319: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
320: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
321: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500

Line 318: , p6_a2 out nocopy JTF_NUMBER_TABLE

314: , p5_a23 JTF_DATE_TABLE
315: , p5_a24 JTF_NUMBER_TABLE
316: , p6_a0 out nocopy JTF_NUMBER_TABLE
317: , p6_a1 out nocopy JTF_NUMBER_TABLE
318: , p6_a2 out nocopy JTF_NUMBER_TABLE
319: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
320: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
321: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
322: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 336: , p6_a20 out nocopy JTF_NUMBER_TABLE

332: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
333: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
334: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
335: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
336: , p6_a20 out nocopy JTF_NUMBER_TABLE
337: , p6_a21 out nocopy JTF_DATE_TABLE
338: , p6_a22 out nocopy JTF_NUMBER_TABLE
339: , p6_a23 out nocopy JTF_DATE_TABLE
340: , p6_a24 out nocopy JTF_NUMBER_TABLE

Line 338: , p6_a22 out nocopy JTF_NUMBER_TABLE

334: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
335: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
336: , p6_a20 out nocopy JTF_NUMBER_TABLE
337: , p6_a21 out nocopy JTF_DATE_TABLE
338: , p6_a22 out nocopy JTF_NUMBER_TABLE
339: , p6_a23 out nocopy JTF_DATE_TABLE
340: , p6_a24 out nocopy JTF_NUMBER_TABLE
341: );
342: procedure delete_row(p_api_version NUMBER

Line 340: , p6_a24 out nocopy JTF_NUMBER_TABLE

336: , p6_a20 out nocopy JTF_NUMBER_TABLE
337: , p6_a21 out nocopy JTF_DATE_TABLE
338: , p6_a22 out nocopy JTF_NUMBER_TABLE
339: , p6_a23 out nocopy JTF_DATE_TABLE
340: , p6_a24 out nocopy JTF_NUMBER_TABLE
341: );
342: procedure delete_row(p_api_version NUMBER
343: , p_init_msg_list VARCHAR2
344: , x_return_status out nocopy VARCHAR2

Line 378: , p5_a0 JTF_NUMBER_TABLE

374: , p_init_msg_list VARCHAR2
375: , x_return_status out nocopy VARCHAR2
376: , x_msg_count out nocopy NUMBER
377: , x_msg_data out nocopy VARCHAR2
378: , p5_a0 JTF_NUMBER_TABLE
379: , p5_a1 JTF_NUMBER_TABLE
380: , p5_a2 JTF_NUMBER_TABLE
381: , p5_a3 JTF_VARCHAR2_TABLE_100
382: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 379: , p5_a1 JTF_NUMBER_TABLE

375: , x_return_status out nocopy VARCHAR2
376: , x_msg_count out nocopy NUMBER
377: , x_msg_data out nocopy VARCHAR2
378: , p5_a0 JTF_NUMBER_TABLE
379: , p5_a1 JTF_NUMBER_TABLE
380: , p5_a2 JTF_NUMBER_TABLE
381: , p5_a3 JTF_VARCHAR2_TABLE_100
382: , p5_a4 JTF_VARCHAR2_TABLE_100
383: , p5_a5 JTF_VARCHAR2_TABLE_500

Line 380: , p5_a2 JTF_NUMBER_TABLE

376: , x_msg_count out nocopy NUMBER
377: , x_msg_data out nocopy VARCHAR2
378: , p5_a0 JTF_NUMBER_TABLE
379: , p5_a1 JTF_NUMBER_TABLE
380: , p5_a2 JTF_NUMBER_TABLE
381: , p5_a3 JTF_VARCHAR2_TABLE_100
382: , p5_a4 JTF_VARCHAR2_TABLE_100
383: , p5_a5 JTF_VARCHAR2_TABLE_500
384: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 398: , p5_a20 JTF_NUMBER_TABLE

394: , p5_a16 JTF_VARCHAR2_TABLE_500
395: , p5_a17 JTF_VARCHAR2_TABLE_500
396: , p5_a18 JTF_VARCHAR2_TABLE_500
397: , p5_a19 JTF_VARCHAR2_TABLE_500
398: , p5_a20 JTF_NUMBER_TABLE
399: , p5_a21 JTF_DATE_TABLE
400: , p5_a22 JTF_NUMBER_TABLE
401: , p5_a23 JTF_DATE_TABLE
402: , p5_a24 JTF_NUMBER_TABLE

Line 400: , p5_a22 JTF_NUMBER_TABLE

396: , p5_a18 JTF_VARCHAR2_TABLE_500
397: , p5_a19 JTF_VARCHAR2_TABLE_500
398: , p5_a20 JTF_NUMBER_TABLE
399: , p5_a21 JTF_DATE_TABLE
400: , p5_a22 JTF_NUMBER_TABLE
401: , p5_a23 JTF_DATE_TABLE
402: , p5_a24 JTF_NUMBER_TABLE
403: );
404: procedure validate_row(p_api_version NUMBER

Line 402: , p5_a24 JTF_NUMBER_TABLE

398: , p5_a20 JTF_NUMBER_TABLE
399: , p5_a21 JTF_DATE_TABLE
400: , p5_a22 JTF_NUMBER_TABLE
401: , p5_a23 JTF_DATE_TABLE
402: , p5_a24 JTF_NUMBER_TABLE
403: );
404: procedure validate_row(p_api_version NUMBER
405: , p_init_msg_list VARCHAR2
406: , x_return_status out nocopy VARCHAR2

Line 440: , p5_a0 JTF_NUMBER_TABLE

436: , p_init_msg_list VARCHAR2
437: , x_return_status out nocopy VARCHAR2
438: , x_msg_count out nocopy NUMBER
439: , x_msg_data out nocopy VARCHAR2
440: , p5_a0 JTF_NUMBER_TABLE
441: , p5_a1 JTF_NUMBER_TABLE
442: , p5_a2 JTF_NUMBER_TABLE
443: , p5_a3 JTF_VARCHAR2_TABLE_100
444: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 441: , p5_a1 JTF_NUMBER_TABLE

437: , x_return_status out nocopy VARCHAR2
438: , x_msg_count out nocopy NUMBER
439: , x_msg_data out nocopy VARCHAR2
440: , p5_a0 JTF_NUMBER_TABLE
441: , p5_a1 JTF_NUMBER_TABLE
442: , p5_a2 JTF_NUMBER_TABLE
443: , p5_a3 JTF_VARCHAR2_TABLE_100
444: , p5_a4 JTF_VARCHAR2_TABLE_100
445: , p5_a5 JTF_VARCHAR2_TABLE_500

Line 442: , p5_a2 JTF_NUMBER_TABLE

438: , x_msg_count out nocopy NUMBER
439: , x_msg_data out nocopy VARCHAR2
440: , p5_a0 JTF_NUMBER_TABLE
441: , p5_a1 JTF_NUMBER_TABLE
442: , p5_a2 JTF_NUMBER_TABLE
443: , p5_a3 JTF_VARCHAR2_TABLE_100
444: , p5_a4 JTF_VARCHAR2_TABLE_100
445: , p5_a5 JTF_VARCHAR2_TABLE_500
446: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 460: , p5_a20 JTF_NUMBER_TABLE

456: , p5_a16 JTF_VARCHAR2_TABLE_500
457: , p5_a17 JTF_VARCHAR2_TABLE_500
458: , p5_a18 JTF_VARCHAR2_TABLE_500
459: , p5_a19 JTF_VARCHAR2_TABLE_500
460: , p5_a20 JTF_NUMBER_TABLE
461: , p5_a21 JTF_DATE_TABLE
462: , p5_a22 JTF_NUMBER_TABLE
463: , p5_a23 JTF_DATE_TABLE
464: , p5_a24 JTF_NUMBER_TABLE

Line 462: , p5_a22 JTF_NUMBER_TABLE

458: , p5_a18 JTF_VARCHAR2_TABLE_500
459: , p5_a19 JTF_VARCHAR2_TABLE_500
460: , p5_a20 JTF_NUMBER_TABLE
461: , p5_a21 JTF_DATE_TABLE
462: , p5_a22 JTF_NUMBER_TABLE
463: , p5_a23 JTF_DATE_TABLE
464: , p5_a24 JTF_NUMBER_TABLE
465: );
466: end okl_drs_pvt_w;

Line 464: , p5_a24 JTF_NUMBER_TABLE

460: , p5_a20 JTF_NUMBER_TABLE
461: , p5_a21 JTF_DATE_TABLE
462: , p5_a22 JTF_NUMBER_TABLE
463: , p5_a23 JTF_DATE_TABLE
464: , p5_a24 JTF_NUMBER_TABLE
465: );
466: end okl_drs_pvt_w;