DBA Data[Home] [Help]

APPS.OKL_VLS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p23(t out nocopy okl_vls_pvt.vlsv_tbl_type, a0 JTF_NUMBER_TABLE

1: package body okl_vls_pvt_w as
2: /* $Header: OKLIVLSB.pls 120.0 2005/09/20 12:37:56 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_vls_pvt.vlsv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_500
7: , a4 JTF_VARCHAR2_TABLE_500

Line 4: , a1 JTF_NUMBER_TABLE

1: package body okl_vls_pvt_w as
2: /* $Header: OKLIVLSB.pls 120.0 2005/09/20 12:37:56 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_vls_pvt.vlsv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_500
7: , a4 JTF_VARCHAR2_TABLE_500
8: , a5 JTF_VARCHAR2_TABLE_500

Line 21: , a18 JTF_NUMBER_TABLE

17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_200
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_VARCHAR2_TABLE_300

Line 70: procedure rosetta_table_copy_out_p23(t okl_vls_pvt.vlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

66: end loop;
67: end if;
68: end if;
69: end rosetta_table_copy_in_p23;
70: procedure rosetta_table_copy_out_p23(t okl_vls_pvt.vlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_NUMBER_TABLE
72: , a2 out nocopy JTF_VARCHAR2_TABLE_100
73: , a3 out nocopy JTF_VARCHAR2_TABLE_500
74: , a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 71: , a1 out nocopy JTF_NUMBER_TABLE

67: end if;
68: end if;
69: end rosetta_table_copy_in_p23;
70: procedure rosetta_table_copy_out_p23(t okl_vls_pvt.vlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_NUMBER_TABLE
72: , a2 out nocopy JTF_VARCHAR2_TABLE_100
73: , a3 out nocopy JTF_VARCHAR2_TABLE_500
74: , a4 out nocopy JTF_VARCHAR2_TABLE_500
75: , a5 out nocopy JTF_VARCHAR2_TABLE_500

Line 88: , a18 out nocopy JTF_NUMBER_TABLE

84: , a14 out nocopy JTF_VARCHAR2_TABLE_500
85: , a15 out nocopy JTF_VARCHAR2_TABLE_500
86: , a16 out nocopy JTF_VARCHAR2_TABLE_500
87: , a17 out nocopy JTF_VARCHAR2_TABLE_500
88: , a18 out nocopy JTF_NUMBER_TABLE
89: , a19 out nocopy JTF_VARCHAR2_TABLE_200
90: , a20 out nocopy JTF_DATE_TABLE
91: , a21 out nocopy JTF_DATE_TABLE
92: , a22 out nocopy JTF_VARCHAR2_TABLE_300

Line 99: a0 := JTF_NUMBER_TABLE();

95: ) as
96: ddindx binary_integer; indx binary_integer;
97: begin
98: if t is null or t.count = 0 then
99: a0 := JTF_NUMBER_TABLE();
100: a1 := JTF_NUMBER_TABLE();
101: a2 := JTF_VARCHAR2_TABLE_100();
102: a3 := JTF_VARCHAR2_TABLE_500();
103: a4 := JTF_VARCHAR2_TABLE_500();

Line 100: a1 := JTF_NUMBER_TABLE();

96: ddindx binary_integer; indx binary_integer;
97: begin
98: if t is null or t.count = 0 then
99: a0 := JTF_NUMBER_TABLE();
100: a1 := JTF_NUMBER_TABLE();
101: a2 := JTF_VARCHAR2_TABLE_100();
102: a3 := JTF_VARCHAR2_TABLE_500();
103: a4 := JTF_VARCHAR2_TABLE_500();
104: a5 := JTF_VARCHAR2_TABLE_500();

Line 117: a18 := JTF_NUMBER_TABLE();

113: a14 := JTF_VARCHAR2_TABLE_500();
114: a15 := JTF_VARCHAR2_TABLE_500();
115: a16 := JTF_VARCHAR2_TABLE_500();
116: a17 := JTF_VARCHAR2_TABLE_500();
117: a18 := JTF_NUMBER_TABLE();
118: a19 := JTF_VARCHAR2_TABLE_200();
119: a20 := JTF_DATE_TABLE();
120: a21 := JTF_DATE_TABLE();
121: a22 := JTF_VARCHAR2_TABLE_300();

Line 125: a0 := JTF_NUMBER_TABLE();

121: a22 := JTF_VARCHAR2_TABLE_300();
122: a23 := JTF_VARCHAR2_TABLE_2000();
123: a24 := JTF_VARCHAR2_TABLE_2000();
124: else
125: a0 := JTF_NUMBER_TABLE();
126: a1 := JTF_NUMBER_TABLE();
127: a2 := JTF_VARCHAR2_TABLE_100();
128: a3 := JTF_VARCHAR2_TABLE_500();
129: a4 := JTF_VARCHAR2_TABLE_500();

Line 126: a1 := JTF_NUMBER_TABLE();

122: a23 := JTF_VARCHAR2_TABLE_2000();
123: a24 := JTF_VARCHAR2_TABLE_2000();
124: else
125: a0 := JTF_NUMBER_TABLE();
126: a1 := JTF_NUMBER_TABLE();
127: a2 := JTF_VARCHAR2_TABLE_100();
128: a3 := JTF_VARCHAR2_TABLE_500();
129: a4 := JTF_VARCHAR2_TABLE_500();
130: a5 := JTF_VARCHAR2_TABLE_500();

Line 143: a18 := JTF_NUMBER_TABLE();

139: a14 := JTF_VARCHAR2_TABLE_500();
140: a15 := JTF_VARCHAR2_TABLE_500();
141: a16 := JTF_VARCHAR2_TABLE_500();
142: a17 := JTF_VARCHAR2_TABLE_500();
143: a18 := JTF_NUMBER_TABLE();
144: a19 := JTF_VARCHAR2_TABLE_200();
145: a20 := JTF_DATE_TABLE();
146: a21 := JTF_DATE_TABLE();
147: a22 := JTF_VARCHAR2_TABLE_300();

Line 219: , p5_a0 JTF_NUMBER_TABLE

215: , p_init_msg_list VARCHAR2
216: , x_return_status out nocopy VARCHAR2
217: , x_msg_count out nocopy NUMBER
218: , x_msg_data out nocopy VARCHAR2
219: , p5_a0 JTF_NUMBER_TABLE
220: , p5_a1 JTF_NUMBER_TABLE
221: , p5_a2 JTF_VARCHAR2_TABLE_100
222: , p5_a3 JTF_VARCHAR2_TABLE_500
223: , p5_a4 JTF_VARCHAR2_TABLE_500

Line 220: , p5_a1 JTF_NUMBER_TABLE

216: , x_return_status out nocopy VARCHAR2
217: , x_msg_count out nocopy NUMBER
218: , x_msg_data out nocopy VARCHAR2
219: , p5_a0 JTF_NUMBER_TABLE
220: , p5_a1 JTF_NUMBER_TABLE
221: , p5_a2 JTF_VARCHAR2_TABLE_100
222: , p5_a3 JTF_VARCHAR2_TABLE_500
223: , p5_a4 JTF_VARCHAR2_TABLE_500
224: , p5_a5 JTF_VARCHAR2_TABLE_500

Line 237: , p5_a18 JTF_NUMBER_TABLE

233: , p5_a14 JTF_VARCHAR2_TABLE_500
234: , p5_a15 JTF_VARCHAR2_TABLE_500
235: , p5_a16 JTF_VARCHAR2_TABLE_500
236: , p5_a17 JTF_VARCHAR2_TABLE_500
237: , p5_a18 JTF_NUMBER_TABLE
238: , p5_a19 JTF_VARCHAR2_TABLE_200
239: , p5_a20 JTF_DATE_TABLE
240: , p5_a21 JTF_DATE_TABLE
241: , p5_a22 JTF_VARCHAR2_TABLE_300

Line 244: , p6_a0 out nocopy JTF_NUMBER_TABLE

240: , p5_a21 JTF_DATE_TABLE
241: , p5_a22 JTF_VARCHAR2_TABLE_300
242: , p5_a23 JTF_VARCHAR2_TABLE_2000
243: , p5_a24 JTF_VARCHAR2_TABLE_2000
244: , p6_a0 out nocopy JTF_NUMBER_TABLE
245: , p6_a1 out nocopy JTF_NUMBER_TABLE
246: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
247: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
248: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 245: , p6_a1 out nocopy JTF_NUMBER_TABLE

241: , p5_a22 JTF_VARCHAR2_TABLE_300
242: , p5_a23 JTF_VARCHAR2_TABLE_2000
243: , p5_a24 JTF_VARCHAR2_TABLE_2000
244: , p6_a0 out nocopy JTF_NUMBER_TABLE
245: , p6_a1 out nocopy JTF_NUMBER_TABLE
246: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
247: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
248: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
249: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500

Line 262: , p6_a18 out nocopy JTF_NUMBER_TABLE

258: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
259: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
260: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
261: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
262: , p6_a18 out nocopy JTF_NUMBER_TABLE
263: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_200
264: , p6_a20 out nocopy JTF_DATE_TABLE
265: , p6_a21 out nocopy JTF_DATE_TABLE
266: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300

Line 360: , p5_a0 JTF_NUMBER_TABLE

356: , p_init_msg_list VARCHAR2
357: , x_return_status out nocopy VARCHAR2
358: , x_msg_count out nocopy NUMBER
359: , x_msg_data out nocopy VARCHAR2
360: , p5_a0 JTF_NUMBER_TABLE
361: , p5_a1 JTF_NUMBER_TABLE
362: , p5_a2 JTF_VARCHAR2_TABLE_100
363: , p5_a3 JTF_VARCHAR2_TABLE_500
364: , p5_a4 JTF_VARCHAR2_TABLE_500

Line 361: , p5_a1 JTF_NUMBER_TABLE

357: , x_return_status out nocopy VARCHAR2
358: , x_msg_count out nocopy NUMBER
359: , x_msg_data out nocopy VARCHAR2
360: , p5_a0 JTF_NUMBER_TABLE
361: , p5_a1 JTF_NUMBER_TABLE
362: , p5_a2 JTF_VARCHAR2_TABLE_100
363: , p5_a3 JTF_VARCHAR2_TABLE_500
364: , p5_a4 JTF_VARCHAR2_TABLE_500
365: , p5_a5 JTF_VARCHAR2_TABLE_500

Line 378: , p5_a18 JTF_NUMBER_TABLE

374: , p5_a14 JTF_VARCHAR2_TABLE_500
375: , p5_a15 JTF_VARCHAR2_TABLE_500
376: , p5_a16 JTF_VARCHAR2_TABLE_500
377: , p5_a17 JTF_VARCHAR2_TABLE_500
378: , p5_a18 JTF_NUMBER_TABLE
379: , p5_a19 JTF_VARCHAR2_TABLE_200
380: , p5_a20 JTF_DATE_TABLE
381: , p5_a21 JTF_DATE_TABLE
382: , p5_a22 JTF_VARCHAR2_TABLE_300

Line 385: , p6_a0 out nocopy JTF_NUMBER_TABLE

381: , p5_a21 JTF_DATE_TABLE
382: , p5_a22 JTF_VARCHAR2_TABLE_300
383: , p5_a23 JTF_VARCHAR2_TABLE_2000
384: , p5_a24 JTF_VARCHAR2_TABLE_2000
385: , p6_a0 out nocopy JTF_NUMBER_TABLE
386: , p6_a1 out nocopy JTF_NUMBER_TABLE
387: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
388: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
389: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 386: , p6_a1 out nocopy JTF_NUMBER_TABLE

382: , p5_a22 JTF_VARCHAR2_TABLE_300
383: , p5_a23 JTF_VARCHAR2_TABLE_2000
384: , p5_a24 JTF_VARCHAR2_TABLE_2000
385: , p6_a0 out nocopy JTF_NUMBER_TABLE
386: , p6_a1 out nocopy JTF_NUMBER_TABLE
387: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
388: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
389: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
390: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500

Line 403: , p6_a18 out nocopy JTF_NUMBER_TABLE

399: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
400: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
401: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
402: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
403: , p6_a18 out nocopy JTF_NUMBER_TABLE
404: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_200
405: , p6_a20 out nocopy JTF_DATE_TABLE
406: , p6_a21 out nocopy JTF_DATE_TABLE
407: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300

Line 501: , p5_a0 JTF_NUMBER_TABLE

497: , p_init_msg_list VARCHAR2
498: , x_return_status out nocopy VARCHAR2
499: , x_msg_count out nocopy NUMBER
500: , x_msg_data out nocopy VARCHAR2
501: , p5_a0 JTF_NUMBER_TABLE
502: , p5_a1 JTF_NUMBER_TABLE
503: , p5_a2 JTF_VARCHAR2_TABLE_100
504: , p5_a3 JTF_VARCHAR2_TABLE_500
505: , p5_a4 JTF_VARCHAR2_TABLE_500

Line 502: , p5_a1 JTF_NUMBER_TABLE

498: , x_return_status out nocopy VARCHAR2
499: , x_msg_count out nocopy NUMBER
500: , x_msg_data out nocopy VARCHAR2
501: , p5_a0 JTF_NUMBER_TABLE
502: , p5_a1 JTF_NUMBER_TABLE
503: , p5_a2 JTF_VARCHAR2_TABLE_100
504: , p5_a3 JTF_VARCHAR2_TABLE_500
505: , p5_a4 JTF_VARCHAR2_TABLE_500
506: , p5_a5 JTF_VARCHAR2_TABLE_500

Line 519: , p5_a18 JTF_NUMBER_TABLE

515: , p5_a14 JTF_VARCHAR2_TABLE_500
516: , p5_a15 JTF_VARCHAR2_TABLE_500
517: , p5_a16 JTF_VARCHAR2_TABLE_500
518: , p5_a17 JTF_VARCHAR2_TABLE_500
519: , p5_a18 JTF_NUMBER_TABLE
520: , p5_a19 JTF_VARCHAR2_TABLE_200
521: , p5_a20 JTF_DATE_TABLE
522: , p5_a21 JTF_DATE_TABLE
523: , p5_a22 JTF_VARCHAR2_TABLE_300