eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VLD_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p23(t out nocopy okl_vld_pvt.vldv_tbl_type, a0 JTF_NUMBER_TABLE

1: package body okl_vld_pvt_w as
2: /* $Header: OKLIVLDB.pls 120.0 2005/09/20 12:39:04 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_vld_pvt.vldv_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_vld_pvt_w as
2: /* $Header: OKLIVLDB.pls 120.0 2005/09/20 12:39:04 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_vld_pvt.vldv_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_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_300
25: , a22 JTF_VARCHAR2_TABLE_2000

Line 22: , a19 JTF_NUMBER_TABLE

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_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_300
25: , a22 JTF_VARCHAR2_TABLE_2000
26: , a23 JTF_VARCHAR2_TABLE_2000

Line 68: procedure rosetta_table_copy_out_p23(t okl_vld_pvt.vldv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

64: end loop;
65: end if;
66: end if;
67: end rosetta_table_copy_in_p23;
68: procedure rosetta_table_copy_out_p23(t okl_vld_pvt.vldv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_500
72: , a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 69: , a1 out nocopy JTF_NUMBER_TABLE

65: end if;
66: end if;
67: end rosetta_table_copy_in_p23;
68: procedure rosetta_table_copy_out_p23(t okl_vld_pvt.vldv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_500
72: , a4 out nocopy JTF_VARCHAR2_TABLE_500
73: , a5 out nocopy JTF_VARCHAR2_TABLE_500

Line 86: , a18 out nocopy JTF_NUMBER_TABLE

82: , a14 out nocopy JTF_VARCHAR2_TABLE_500
83: , a15 out nocopy JTF_VARCHAR2_TABLE_500
84: , a16 out nocopy JTF_VARCHAR2_TABLE_500
85: , a17 out nocopy JTF_VARCHAR2_TABLE_500
86: , a18 out nocopy JTF_NUMBER_TABLE
87: , a19 out nocopy JTF_NUMBER_TABLE
88: , a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , a21 out nocopy JTF_VARCHAR2_TABLE_300
90: , a22 out nocopy JTF_VARCHAR2_TABLE_2000

Line 87: , a19 out nocopy JTF_NUMBER_TABLE

83: , a15 out nocopy JTF_VARCHAR2_TABLE_500
84: , a16 out nocopy JTF_VARCHAR2_TABLE_500
85: , a17 out nocopy JTF_VARCHAR2_TABLE_500
86: , a18 out nocopy JTF_NUMBER_TABLE
87: , a19 out nocopy JTF_NUMBER_TABLE
88: , a20 out nocopy JTF_VARCHAR2_TABLE_100
89: , a21 out nocopy JTF_VARCHAR2_TABLE_300
90: , a22 out nocopy JTF_VARCHAR2_TABLE_2000
91: , a23 out nocopy JTF_VARCHAR2_TABLE_2000

Line 96: a0 := JTF_NUMBER_TABLE();

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

Line 97: a1 := JTF_NUMBER_TABLE();

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

Line 114: a18 := JTF_NUMBER_TABLE();

110: a14 := JTF_VARCHAR2_TABLE_500();
111: a15 := JTF_VARCHAR2_TABLE_500();
112: a16 := JTF_VARCHAR2_TABLE_500();
113: a17 := JTF_VARCHAR2_TABLE_500();
114: a18 := JTF_NUMBER_TABLE();
115: a19 := JTF_NUMBER_TABLE();
116: a20 := JTF_VARCHAR2_TABLE_100();
117: a21 := JTF_VARCHAR2_TABLE_300();
118: a22 := JTF_VARCHAR2_TABLE_2000();

Line 115: a19 := JTF_NUMBER_TABLE();

111: a15 := JTF_VARCHAR2_TABLE_500();
112: a16 := JTF_VARCHAR2_TABLE_500();
113: a17 := JTF_VARCHAR2_TABLE_500();
114: a18 := JTF_NUMBER_TABLE();
115: a19 := JTF_NUMBER_TABLE();
116: a20 := JTF_VARCHAR2_TABLE_100();
117: a21 := JTF_VARCHAR2_TABLE_300();
118: a22 := JTF_VARCHAR2_TABLE_2000();
119: a23 := JTF_VARCHAR2_TABLE_2000();

Line 121: a0 := JTF_NUMBER_TABLE();

117: a21 := JTF_VARCHAR2_TABLE_300();
118: a22 := JTF_VARCHAR2_TABLE_2000();
119: a23 := JTF_VARCHAR2_TABLE_2000();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_VARCHAR2_TABLE_500();
125: a4 := JTF_VARCHAR2_TABLE_500();

Line 122: a1 := JTF_NUMBER_TABLE();

118: a22 := JTF_VARCHAR2_TABLE_2000();
119: a23 := JTF_VARCHAR2_TABLE_2000();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_VARCHAR2_TABLE_500();
125: a4 := JTF_VARCHAR2_TABLE_500();
126: a5 := JTF_VARCHAR2_TABLE_500();

Line 139: a18 := JTF_NUMBER_TABLE();

135: a14 := JTF_VARCHAR2_TABLE_500();
136: a15 := JTF_VARCHAR2_TABLE_500();
137: a16 := JTF_VARCHAR2_TABLE_500();
138: a17 := JTF_VARCHAR2_TABLE_500();
139: a18 := JTF_NUMBER_TABLE();
140: a19 := JTF_NUMBER_TABLE();
141: a20 := JTF_VARCHAR2_TABLE_100();
142: a21 := JTF_VARCHAR2_TABLE_300();
143: a22 := JTF_VARCHAR2_TABLE_2000();

Line 140: a19 := JTF_NUMBER_TABLE();

136: a15 := JTF_VARCHAR2_TABLE_500();
137: a16 := JTF_VARCHAR2_TABLE_500();
138: a17 := JTF_VARCHAR2_TABLE_500();
139: a18 := JTF_NUMBER_TABLE();
140: a19 := JTF_NUMBER_TABLE();
141: a20 := JTF_VARCHAR2_TABLE_100();
142: a21 := JTF_VARCHAR2_TABLE_300();
143: a22 := JTF_VARCHAR2_TABLE_2000();
144: a23 := JTF_VARCHAR2_TABLE_2000();

Line 212: , p5_a0 JTF_NUMBER_TABLE

208: , p_init_msg_list VARCHAR2
209: , x_return_status out nocopy VARCHAR2
210: , x_msg_count out nocopy NUMBER
211: , x_msg_data out nocopy VARCHAR2
212: , p5_a0 JTF_NUMBER_TABLE
213: , p5_a1 JTF_NUMBER_TABLE
214: , p5_a2 JTF_VARCHAR2_TABLE_100
215: , p5_a3 JTF_VARCHAR2_TABLE_500
216: , p5_a4 JTF_VARCHAR2_TABLE_500

Line 213: , p5_a1 JTF_NUMBER_TABLE

209: , x_return_status out nocopy VARCHAR2
210: , x_msg_count out nocopy NUMBER
211: , x_msg_data out nocopy VARCHAR2
212: , p5_a0 JTF_NUMBER_TABLE
213: , p5_a1 JTF_NUMBER_TABLE
214: , p5_a2 JTF_VARCHAR2_TABLE_100
215: , p5_a3 JTF_VARCHAR2_TABLE_500
216: , p5_a4 JTF_VARCHAR2_TABLE_500
217: , p5_a5 JTF_VARCHAR2_TABLE_500

Line 230: , p5_a18 JTF_NUMBER_TABLE

226: , p5_a14 JTF_VARCHAR2_TABLE_500
227: , p5_a15 JTF_VARCHAR2_TABLE_500
228: , p5_a16 JTF_VARCHAR2_TABLE_500
229: , p5_a17 JTF_VARCHAR2_TABLE_500
230: , p5_a18 JTF_NUMBER_TABLE
231: , p5_a19 JTF_NUMBER_TABLE
232: , p5_a20 JTF_VARCHAR2_TABLE_100
233: , p5_a21 JTF_VARCHAR2_TABLE_300
234: , p5_a22 JTF_VARCHAR2_TABLE_2000

Line 231: , p5_a19 JTF_NUMBER_TABLE

227: , p5_a15 JTF_VARCHAR2_TABLE_500
228: , p5_a16 JTF_VARCHAR2_TABLE_500
229: , p5_a17 JTF_VARCHAR2_TABLE_500
230: , p5_a18 JTF_NUMBER_TABLE
231: , p5_a19 JTF_NUMBER_TABLE
232: , p5_a20 JTF_VARCHAR2_TABLE_100
233: , p5_a21 JTF_VARCHAR2_TABLE_300
234: , p5_a22 JTF_VARCHAR2_TABLE_2000
235: , p5_a23 JTF_VARCHAR2_TABLE_2000

Line 236: , p6_a0 out nocopy JTF_NUMBER_TABLE

232: , p5_a20 JTF_VARCHAR2_TABLE_100
233: , p5_a21 JTF_VARCHAR2_TABLE_300
234: , p5_a22 JTF_VARCHAR2_TABLE_2000
235: , p5_a23 JTF_VARCHAR2_TABLE_2000
236: , p6_a0 out nocopy JTF_NUMBER_TABLE
237: , p6_a1 out nocopy JTF_NUMBER_TABLE
238: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
240: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 237: , p6_a1 out nocopy JTF_NUMBER_TABLE

233: , p5_a21 JTF_VARCHAR2_TABLE_300
234: , p5_a22 JTF_VARCHAR2_TABLE_2000
235: , p5_a23 JTF_VARCHAR2_TABLE_2000
236: , p6_a0 out nocopy JTF_NUMBER_TABLE
237: , p6_a1 out nocopy JTF_NUMBER_TABLE
238: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
240: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
241: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500

Line 254: , p6_a18 out nocopy JTF_NUMBER_TABLE

250: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
251: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
252: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
253: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
254: , p6_a18 out nocopy JTF_NUMBER_TABLE
255: , p6_a19 out nocopy JTF_NUMBER_TABLE
256: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
257: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
258: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_2000

Line 255: , p6_a19 out nocopy JTF_NUMBER_TABLE

251: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
252: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
253: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
254: , p6_a18 out nocopy JTF_NUMBER_TABLE
255: , p6_a19 out nocopy JTF_NUMBER_TABLE
256: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
257: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
258: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_2000
259: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_2000

Line 349: , p5_a0 JTF_NUMBER_TABLE

345: , p_init_msg_list VARCHAR2
346: , x_return_status out nocopy VARCHAR2
347: , x_msg_count out nocopy NUMBER
348: , x_msg_data out nocopy VARCHAR2
349: , p5_a0 JTF_NUMBER_TABLE
350: , p5_a1 JTF_NUMBER_TABLE
351: , p5_a2 JTF_VARCHAR2_TABLE_100
352: , p5_a3 JTF_VARCHAR2_TABLE_500
353: , p5_a4 JTF_VARCHAR2_TABLE_500

Line 350: , p5_a1 JTF_NUMBER_TABLE

346: , x_return_status out nocopy VARCHAR2
347: , x_msg_count out nocopy NUMBER
348: , x_msg_data out nocopy VARCHAR2
349: , p5_a0 JTF_NUMBER_TABLE
350: , p5_a1 JTF_NUMBER_TABLE
351: , p5_a2 JTF_VARCHAR2_TABLE_100
352: , p5_a3 JTF_VARCHAR2_TABLE_500
353: , p5_a4 JTF_VARCHAR2_TABLE_500
354: , p5_a5 JTF_VARCHAR2_TABLE_500

Line 367: , p5_a18 JTF_NUMBER_TABLE

363: , p5_a14 JTF_VARCHAR2_TABLE_500
364: , p5_a15 JTF_VARCHAR2_TABLE_500
365: , p5_a16 JTF_VARCHAR2_TABLE_500
366: , p5_a17 JTF_VARCHAR2_TABLE_500
367: , p5_a18 JTF_NUMBER_TABLE
368: , p5_a19 JTF_NUMBER_TABLE
369: , p5_a20 JTF_VARCHAR2_TABLE_100
370: , p5_a21 JTF_VARCHAR2_TABLE_300
371: , p5_a22 JTF_VARCHAR2_TABLE_2000

Line 368: , p5_a19 JTF_NUMBER_TABLE

364: , p5_a15 JTF_VARCHAR2_TABLE_500
365: , p5_a16 JTF_VARCHAR2_TABLE_500
366: , p5_a17 JTF_VARCHAR2_TABLE_500
367: , p5_a18 JTF_NUMBER_TABLE
368: , p5_a19 JTF_NUMBER_TABLE
369: , p5_a20 JTF_VARCHAR2_TABLE_100
370: , p5_a21 JTF_VARCHAR2_TABLE_300
371: , p5_a22 JTF_VARCHAR2_TABLE_2000
372: , p5_a23 JTF_VARCHAR2_TABLE_2000

Line 373: , p6_a0 out nocopy JTF_NUMBER_TABLE

369: , p5_a20 JTF_VARCHAR2_TABLE_100
370: , p5_a21 JTF_VARCHAR2_TABLE_300
371: , p5_a22 JTF_VARCHAR2_TABLE_2000
372: , p5_a23 JTF_VARCHAR2_TABLE_2000
373: , p6_a0 out nocopy JTF_NUMBER_TABLE
374: , p6_a1 out nocopy JTF_NUMBER_TABLE
375: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
376: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
377: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 374: , p6_a1 out nocopy JTF_NUMBER_TABLE

370: , p5_a21 JTF_VARCHAR2_TABLE_300
371: , p5_a22 JTF_VARCHAR2_TABLE_2000
372: , p5_a23 JTF_VARCHAR2_TABLE_2000
373: , p6_a0 out nocopy JTF_NUMBER_TABLE
374: , p6_a1 out nocopy JTF_NUMBER_TABLE
375: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
376: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
377: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
378: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500

Line 391: , p6_a18 out nocopy JTF_NUMBER_TABLE

387: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
388: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
389: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
390: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
391: , p6_a18 out nocopy JTF_NUMBER_TABLE
392: , p6_a19 out nocopy JTF_NUMBER_TABLE
393: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
394: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
395: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_2000

Line 392: , p6_a19 out nocopy JTF_NUMBER_TABLE

388: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
389: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
390: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
391: , p6_a18 out nocopy JTF_NUMBER_TABLE
392: , p6_a19 out nocopy JTF_NUMBER_TABLE
393: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
394: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
395: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_2000
396: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_2000

Line 486: , p5_a0 JTF_NUMBER_TABLE

482: , p_init_msg_list VARCHAR2
483: , x_return_status out nocopy VARCHAR2
484: , x_msg_count out nocopy NUMBER
485: , x_msg_data out nocopy VARCHAR2
486: , p5_a0 JTF_NUMBER_TABLE
487: , p5_a1 JTF_NUMBER_TABLE
488: , p5_a2 JTF_VARCHAR2_TABLE_100
489: , p5_a3 JTF_VARCHAR2_TABLE_500
490: , p5_a4 JTF_VARCHAR2_TABLE_500

Line 487: , p5_a1 JTF_NUMBER_TABLE

483: , x_return_status out nocopy VARCHAR2
484: , x_msg_count out nocopy NUMBER
485: , x_msg_data out nocopy VARCHAR2
486: , p5_a0 JTF_NUMBER_TABLE
487: , p5_a1 JTF_NUMBER_TABLE
488: , p5_a2 JTF_VARCHAR2_TABLE_100
489: , p5_a3 JTF_VARCHAR2_TABLE_500
490: , p5_a4 JTF_VARCHAR2_TABLE_500
491: , p5_a5 JTF_VARCHAR2_TABLE_500

Line 504: , p5_a18 JTF_NUMBER_TABLE

500: , p5_a14 JTF_VARCHAR2_TABLE_500
501: , p5_a15 JTF_VARCHAR2_TABLE_500
502: , p5_a16 JTF_VARCHAR2_TABLE_500
503: , p5_a17 JTF_VARCHAR2_TABLE_500
504: , p5_a18 JTF_NUMBER_TABLE
505: , p5_a19 JTF_NUMBER_TABLE
506: , p5_a20 JTF_VARCHAR2_TABLE_100
507: , p5_a21 JTF_VARCHAR2_TABLE_300
508: , p5_a22 JTF_VARCHAR2_TABLE_2000

Line 505: , p5_a19 JTF_NUMBER_TABLE

501: , p5_a15 JTF_VARCHAR2_TABLE_500
502: , p5_a16 JTF_VARCHAR2_TABLE_500
503: , p5_a17 JTF_VARCHAR2_TABLE_500
504: , p5_a18 JTF_NUMBER_TABLE
505: , p5_a19 JTF_NUMBER_TABLE
506: , p5_a20 JTF_VARCHAR2_TABLE_100
507: , p5_a21 JTF_VARCHAR2_TABLE_300
508: , p5_a22 JTF_VARCHAR2_TABLE_2000
509: , p5_a23 JTF_VARCHAR2_TABLE_2000