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_MASS_REBOOK_PUB_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p16(t out nocopy okl_mass_rebook_pub.crit_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p16(t out nocopy okl_mass_rebook_pub.crit_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_200

Line 51: procedure rosetta_table_copy_out_p16(t okl_mass_rebook_pub.crit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

47: end loop;
48: end if;
49: end if;
50: end rosetta_table_copy_in_p16;
51: procedure rosetta_table_copy_out_p16(t okl_mass_rebook_pub.crit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_200
54: , a3 out nocopy JTF_VARCHAR2_TABLE_200
55: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 61: a0 := JTF_NUMBER_TABLE();

57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin
60: if t is null or t.count = 0 then
61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_VARCHAR2_TABLE_100();
63: a2 := JTF_VARCHAR2_TABLE_200();
64: a3 := JTF_VARCHAR2_TABLE_200();
65: a4 := JTF_VARCHAR2_TABLE_200();

Line 68: a0 := JTF_NUMBER_TABLE();

64: a3 := JTF_VARCHAR2_TABLE_200();
65: a4 := JTF_VARCHAR2_TABLE_200();
66: a5 := JTF_VARCHAR2_TABLE_200();
67: else
68: a0 := JTF_NUMBER_TABLE();
69: a1 := JTF_VARCHAR2_TABLE_100();
70: a2 := JTF_VARCHAR2_TABLE_200();
71: a3 := JTF_VARCHAR2_TABLE_200();
72: a4 := JTF_VARCHAR2_TABLE_200();

Line 106: , p6_a0 JTF_NUMBER_TABLE

102: , x_return_status out nocopy VARCHAR2
103: , x_msg_count out nocopy NUMBER
104: , x_msg_data out nocopy VARCHAR2
105: , p_request_name VARCHAR2
106: , p6_a0 JTF_NUMBER_TABLE
107: , p6_a1 JTF_VARCHAR2_TABLE_600
108: , p6_a2 JTF_NUMBER_TABLE
109: , p6_a3 JTF_VARCHAR2_TABLE_100
110: , p6_a4 JTF_VARCHAR2_TABLE_100

Line 108: , p6_a2 JTF_NUMBER_TABLE

104: , x_msg_data out nocopy VARCHAR2
105: , p_request_name VARCHAR2
106: , p6_a0 JTF_NUMBER_TABLE
107: , p6_a1 JTF_VARCHAR2_TABLE_600
108: , p6_a2 JTF_NUMBER_TABLE
109: , p6_a3 JTF_VARCHAR2_TABLE_100
110: , p6_a4 JTF_VARCHAR2_TABLE_100
111: , p6_a5 JTF_VARCHAR2_TABLE_100
112: , p6_a6 JTF_VARCHAR2_TABLE_600

Line 133: , p6_a27 JTF_NUMBER_TABLE

129: , p6_a23 JTF_VARCHAR2_TABLE_500
130: , p6_a24 JTF_VARCHAR2_TABLE_500
131: , p6_a25 JTF_VARCHAR2_TABLE_500
132: , p6_a26 JTF_VARCHAR2_TABLE_500
133: , p6_a27 JTF_NUMBER_TABLE
134: , p6_a28 JTF_DATE_TABLE
135: , p6_a29 JTF_NUMBER_TABLE
136: , p6_a30 JTF_DATE_TABLE
137: , p6_a31 JTF_NUMBER_TABLE

Line 135: , p6_a29 JTF_NUMBER_TABLE

131: , p6_a25 JTF_VARCHAR2_TABLE_500
132: , p6_a26 JTF_VARCHAR2_TABLE_500
133: , p6_a27 JTF_NUMBER_TABLE
134: , p6_a28 JTF_DATE_TABLE
135: , p6_a29 JTF_NUMBER_TABLE
136: , p6_a30 JTF_DATE_TABLE
137: , p6_a31 JTF_NUMBER_TABLE
138: , p7_a0 out nocopy JTF_NUMBER_TABLE
139: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 137: , p6_a31 JTF_NUMBER_TABLE

133: , p6_a27 JTF_NUMBER_TABLE
134: , p6_a28 JTF_DATE_TABLE
135: , p6_a29 JTF_NUMBER_TABLE
136: , p6_a30 JTF_DATE_TABLE
137: , p6_a31 JTF_NUMBER_TABLE
138: , p7_a0 out nocopy JTF_NUMBER_TABLE
139: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
140: , p7_a2 out nocopy JTF_NUMBER_TABLE
141: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 138: , p7_a0 out nocopy JTF_NUMBER_TABLE

134: , p6_a28 JTF_DATE_TABLE
135: , p6_a29 JTF_NUMBER_TABLE
136: , p6_a30 JTF_DATE_TABLE
137: , p6_a31 JTF_NUMBER_TABLE
138: , p7_a0 out nocopy JTF_NUMBER_TABLE
139: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
140: , p7_a2 out nocopy JTF_NUMBER_TABLE
141: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
142: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 140: , p7_a2 out nocopy JTF_NUMBER_TABLE

136: , p6_a30 JTF_DATE_TABLE
137: , p6_a31 JTF_NUMBER_TABLE
138: , p7_a0 out nocopy JTF_NUMBER_TABLE
139: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
140: , p7_a2 out nocopy JTF_NUMBER_TABLE
141: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
142: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
143: , p7_a5 out nocopy JTF_NUMBER_TABLE
144: , p7_a6 out nocopy JTF_NUMBER_TABLE

Line 143: , p7_a5 out nocopy JTF_NUMBER_TABLE

139: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
140: , p7_a2 out nocopy JTF_NUMBER_TABLE
141: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
142: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
143: , p7_a5 out nocopy JTF_NUMBER_TABLE
144: , p7_a6 out nocopy JTF_NUMBER_TABLE
145: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
146: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
147: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 144: , p7_a6 out nocopy JTF_NUMBER_TABLE

140: , p7_a2 out nocopy JTF_NUMBER_TABLE
141: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
142: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
143: , p7_a5 out nocopy JTF_NUMBER_TABLE
144: , p7_a6 out nocopy JTF_NUMBER_TABLE
145: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
146: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
147: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
148: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 163: , p7_a25 out nocopy JTF_NUMBER_TABLE

159: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_500
160: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_500
161: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
162: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_500
163: , p7_a25 out nocopy JTF_NUMBER_TABLE
164: , p7_a26 out nocopy JTF_DATE_TABLE
165: , p7_a27 out nocopy JTF_NUMBER_TABLE
166: , p7_a28 out nocopy JTF_DATE_TABLE
167: , p7_a29 out nocopy JTF_NUMBER_TABLE

Line 165: , p7_a27 out nocopy JTF_NUMBER_TABLE

161: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
162: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_500
163: , p7_a25 out nocopy JTF_NUMBER_TABLE
164: , p7_a26 out nocopy JTF_DATE_TABLE
165: , p7_a27 out nocopy JTF_NUMBER_TABLE
166: , p7_a28 out nocopy JTF_DATE_TABLE
167: , p7_a29 out nocopy JTF_NUMBER_TABLE
168: , p7_a30 out nocopy JTF_DATE_TABLE
169: , x_rbk_count out nocopy NUMBER

Line 167: , p7_a29 out nocopy JTF_NUMBER_TABLE

163: , p7_a25 out nocopy JTF_NUMBER_TABLE
164: , p7_a26 out nocopy JTF_DATE_TABLE
165: , p7_a27 out nocopy JTF_NUMBER_TABLE
166: , p7_a28 out nocopy JTF_DATE_TABLE
167: , p7_a29 out nocopy JTF_NUMBER_TABLE
168: , p7_a30 out nocopy JTF_DATE_TABLE
169: , x_rbk_count out nocopy NUMBER
170: )
171:

Line 280: , p5_a0 JTF_NUMBER_TABLE

276: , p_init_msg_list VARCHAR2
277: , x_return_status out nocopy VARCHAR2
278: , x_msg_count out nocopy NUMBER
279: , x_msg_data out nocopy VARCHAR2
280: , p5_a0 JTF_NUMBER_TABLE
281: , p5_a1 JTF_VARCHAR2_TABLE_200
282: , p5_a2 JTF_NUMBER_TABLE
283: , p5_a3 JTF_VARCHAR2_TABLE_600
284: , p_deprn_method_code VARCHAR2

Line 282: , p5_a2 JTF_NUMBER_TABLE

278: , x_msg_count out nocopy NUMBER
279: , x_msg_data out nocopy VARCHAR2
280: , p5_a0 JTF_NUMBER_TABLE
281: , p5_a1 JTF_VARCHAR2_TABLE_200
282: , p5_a2 JTF_NUMBER_TABLE
283: , p5_a3 JTF_VARCHAR2_TABLE_600
284: , p_deprn_method_code VARCHAR2
285: , p_in_service_date date
286: , p_life_in_months NUMBER

Line 290: , p12_a0 JTF_NUMBER_TABLE

286: , p_life_in_months NUMBER
287: , p_basic_rate NUMBER
288: , p_adjusted_rate NUMBER
289: , p_residual_value NUMBER
290: , p12_a0 JTF_NUMBER_TABLE
291: , p12_a1 JTF_NUMBER_TABLE
292: , p12_a2 JTF_VARCHAR2_TABLE_500
293: , p12_a3 JTF_VARCHAR2_TABLE_500
294: , p12_a4 JTF_VARCHAR2_TABLE_500

Line 291: , p12_a1 JTF_NUMBER_TABLE

287: , p_basic_rate NUMBER
288: , p_adjusted_rate NUMBER
289: , p_residual_value NUMBER
290: , p12_a0 JTF_NUMBER_TABLE
291: , p12_a1 JTF_NUMBER_TABLE
292: , p12_a2 JTF_VARCHAR2_TABLE_500
293: , p12_a3 JTF_VARCHAR2_TABLE_500
294: , p12_a4 JTF_VARCHAR2_TABLE_500
295: , p12_a5 JTF_VARCHAR2_TABLE_500

Line 409: , p5_a0 JTF_NUMBER_TABLE

405: , p_init_msg_list VARCHAR2
406: , x_return_status out nocopy VARCHAR2
407: , x_msg_count out nocopy NUMBER
408: , x_msg_data out nocopy VARCHAR2
409: , p5_a0 JTF_NUMBER_TABLE
410: , p5_a1 JTF_VARCHAR2_TABLE_200
411: , p5_a2 JTF_NUMBER_TABLE
412: , p5_a3 JTF_VARCHAR2_TABLE_200
413: , p5_a4 JTF_VARCHAR2_TABLE_600

Line 411: , p5_a2 JTF_NUMBER_TABLE

407: , x_msg_count out nocopy NUMBER
408: , x_msg_data out nocopy VARCHAR2
409: , p5_a0 JTF_NUMBER_TABLE
410: , p5_a1 JTF_VARCHAR2_TABLE_200
411: , p5_a2 JTF_NUMBER_TABLE
412: , p5_a3 JTF_VARCHAR2_TABLE_200
413: , p5_a4 JTF_VARCHAR2_TABLE_600
414: , p5_a5 JTF_NUMBER_TABLE
415: , p5_a6 JTF_NUMBER_TABLE

Line 414: , p5_a5 JTF_NUMBER_TABLE

410: , p5_a1 JTF_VARCHAR2_TABLE_200
411: , p5_a2 JTF_NUMBER_TABLE
412: , p5_a3 JTF_VARCHAR2_TABLE_200
413: , p5_a4 JTF_VARCHAR2_TABLE_600
414: , p5_a5 JTF_NUMBER_TABLE
415: , p5_a6 JTF_NUMBER_TABLE
416: , p5_a7 JTF_VARCHAR2_TABLE_100
417: , p5_a8 JTF_VARCHAR2_TABLE_100
418: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 415: , p5_a6 JTF_NUMBER_TABLE

411: , p5_a2 JTF_NUMBER_TABLE
412: , p5_a3 JTF_VARCHAR2_TABLE_200
413: , p5_a4 JTF_VARCHAR2_TABLE_600
414: , p5_a5 JTF_NUMBER_TABLE
415: , p5_a6 JTF_NUMBER_TABLE
416: , p5_a7 JTF_VARCHAR2_TABLE_100
417: , p5_a8 JTF_VARCHAR2_TABLE_100
418: , p5_a9 JTF_VARCHAR2_TABLE_100
419: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 434: , p5_a25 JTF_NUMBER_TABLE

430: , p5_a21 JTF_VARCHAR2_TABLE_500
431: , p5_a22 JTF_VARCHAR2_TABLE_500
432: , p5_a23 JTF_VARCHAR2_TABLE_500
433: , p5_a24 JTF_VARCHAR2_TABLE_500
434: , p5_a25 JTF_NUMBER_TABLE
435: , p5_a26 JTF_DATE_TABLE
436: , p5_a27 JTF_NUMBER_TABLE
437: , p5_a28 JTF_DATE_TABLE
438: , p5_a29 JTF_NUMBER_TABLE

Line 436: , p5_a27 JTF_NUMBER_TABLE

432: , p5_a23 JTF_VARCHAR2_TABLE_500
433: , p5_a24 JTF_VARCHAR2_TABLE_500
434: , p5_a25 JTF_NUMBER_TABLE
435: , p5_a26 JTF_DATE_TABLE
436: , p5_a27 JTF_NUMBER_TABLE
437: , p5_a28 JTF_DATE_TABLE
438: , p5_a29 JTF_NUMBER_TABLE
439: , p5_a30 JTF_DATE_TABLE
440: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 438: , p5_a29 JTF_NUMBER_TABLE

434: , p5_a25 JTF_NUMBER_TABLE
435: , p5_a26 JTF_DATE_TABLE
436: , p5_a27 JTF_NUMBER_TABLE
437: , p5_a28 JTF_DATE_TABLE
438: , p5_a29 JTF_NUMBER_TABLE
439: , p5_a30 JTF_DATE_TABLE
440: , p6_a0 out nocopy JTF_NUMBER_TABLE
441: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
442: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 440: , p6_a0 out nocopy JTF_NUMBER_TABLE

436: , p5_a27 JTF_NUMBER_TABLE
437: , p5_a28 JTF_DATE_TABLE
438: , p5_a29 JTF_NUMBER_TABLE
439: , p5_a30 JTF_DATE_TABLE
440: , p6_a0 out nocopy JTF_NUMBER_TABLE
441: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
442: , p6_a2 out nocopy JTF_NUMBER_TABLE
443: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
444: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 442: , p6_a2 out nocopy JTF_NUMBER_TABLE

438: , p5_a29 JTF_NUMBER_TABLE
439: , p5_a30 JTF_DATE_TABLE
440: , p6_a0 out nocopy JTF_NUMBER_TABLE
441: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
442: , p6_a2 out nocopy JTF_NUMBER_TABLE
443: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
444: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
445: , p6_a5 out nocopy JTF_NUMBER_TABLE
446: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 445: , p6_a5 out nocopy JTF_NUMBER_TABLE

441: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
442: , p6_a2 out nocopy JTF_NUMBER_TABLE
443: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
444: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
445: , p6_a5 out nocopy JTF_NUMBER_TABLE
446: , p6_a6 out nocopy JTF_NUMBER_TABLE
447: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
448: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
449: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 446: , p6_a6 out nocopy JTF_NUMBER_TABLE

442: , p6_a2 out nocopy JTF_NUMBER_TABLE
443: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
444: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
445: , p6_a5 out nocopy JTF_NUMBER_TABLE
446: , p6_a6 out nocopy JTF_NUMBER_TABLE
447: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
448: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
449: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
450: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 465: , p6_a25 out nocopy JTF_NUMBER_TABLE

461: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
462: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
463: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
464: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
465: , p6_a25 out nocopy JTF_NUMBER_TABLE
466: , p6_a26 out nocopy JTF_DATE_TABLE
467: , p6_a27 out nocopy JTF_NUMBER_TABLE
468: , p6_a28 out nocopy JTF_DATE_TABLE
469: , p6_a29 out nocopy JTF_NUMBER_TABLE

Line 467: , p6_a27 out nocopy JTF_NUMBER_TABLE

463: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
464: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
465: , p6_a25 out nocopy JTF_NUMBER_TABLE
466: , p6_a26 out nocopy JTF_DATE_TABLE
467: , p6_a27 out nocopy JTF_NUMBER_TABLE
468: , p6_a28 out nocopy JTF_DATE_TABLE
469: , p6_a29 out nocopy JTF_NUMBER_TABLE
470: , p6_a30 out nocopy JTF_DATE_TABLE
471: )

Line 469: , p6_a29 out nocopy JTF_NUMBER_TABLE

465: , p6_a25 out nocopy JTF_NUMBER_TABLE
466: , p6_a26 out nocopy JTF_DATE_TABLE
467: , p6_a27 out nocopy JTF_NUMBER_TABLE
468: , p6_a28 out nocopy JTF_DATE_TABLE
469: , p6_a29 out nocopy JTF_NUMBER_TABLE
470: , p6_a30 out nocopy JTF_DATE_TABLE
471: )
472:
473: as