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_LEASE_QUOTE_SERVICE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body okl_lease_quote_service_pvt_w as
2: /* $Header: OKLEQUSB.pls 120.2 2006/02/13 07:28:44 asawanka noship $ */
3: procedure rosetta_table_copy_in_p17(t out nocopy okl_lease_quote_service_pvt.line_relation_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p17(t out nocopy okl_lease_quote_service_pvt.line_relation_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_VARCHAR2_TABLE_2000

Line 13: , a10 JTF_VARCHAR2_TABLE_100

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as
15: ddindx binary_integer; indx binary_integer;
16: begin
17: if a0 is not null and a0.count > 0 then

Line 44: , a2 out nocopy JTF_VARCHAR2_TABLE_100

40: end if;
41: end rosetta_table_copy_in_p17;
42: procedure rosetta_table_copy_out_p17(t okl_lease_quote_service_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE

Line 46: , a4 out nocopy JTF_VARCHAR2_TABLE_100

42: procedure rosetta_table_copy_out_p17(t okl_lease_quote_service_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_300
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000

Line 52: , a10 out nocopy JTF_VARCHAR2_TABLE_100

48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_300
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
51: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if t is null or t.count = 0 then

Line 59: a2 := JTF_VARCHAR2_TABLE_100();

55: begin
56: if t is null or t.count = 0 then
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_NUMBER_TABLE();

Line 61: a4 := JTF_VARCHAR2_TABLE_100();

57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_VARCHAR2_TABLE_300();
65: a8 := JTF_VARCHAR2_TABLE_2000();

Line 67: a10 := JTF_VARCHAR2_TABLE_100();

63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_VARCHAR2_TABLE_300();
65: a8 := JTF_VARCHAR2_TABLE_2000();
66: a9 := JTF_VARCHAR2_TABLE_2000();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_VARCHAR2_TABLE_100();

Line 71: a2 := JTF_VARCHAR2_TABLE_100();

67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_NUMBER_TABLE();
75: a6 := JTF_NUMBER_TABLE();

Line 73: a4 := JTF_VARCHAR2_TABLE_100();

69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_NUMBER_TABLE();
75: a6 := JTF_NUMBER_TABLE();
76: a7 := JTF_VARCHAR2_TABLE_300();
77: a8 := JTF_VARCHAR2_TABLE_2000();

Line 79: a10 := JTF_VARCHAR2_TABLE_100();

75: a6 := JTF_NUMBER_TABLE();
76: a7 := JTF_VARCHAR2_TABLE_300();
77: a8 := JTF_VARCHAR2_TABLE_2000();
78: a9 := JTF_VARCHAR2_TABLE_2000();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);
83: a2.extend(t.count);

Line 147: , p4_a2 JTF_VARCHAR2_TABLE_100

143: , p3_a24 VARCHAR2
144: , p3_a25 VARCHAR2
145: , p4_a0 JTF_NUMBER_TABLE
146: , p4_a1 JTF_NUMBER_TABLE
147: , p4_a2 JTF_VARCHAR2_TABLE_100
148: , p4_a3 JTF_NUMBER_TABLE
149: , p4_a4 JTF_VARCHAR2_TABLE_100
150: , p4_a5 JTF_NUMBER_TABLE
151: , p4_a6 JTF_NUMBER_TABLE

Line 149: , p4_a4 JTF_VARCHAR2_TABLE_100

145: , p4_a0 JTF_NUMBER_TABLE
146: , p4_a1 JTF_NUMBER_TABLE
147: , p4_a2 JTF_VARCHAR2_TABLE_100
148: , p4_a3 JTF_NUMBER_TABLE
149: , p4_a4 JTF_VARCHAR2_TABLE_100
150: , p4_a5 JTF_NUMBER_TABLE
151: , p4_a6 JTF_NUMBER_TABLE
152: , p4_a7 JTF_VARCHAR2_TABLE_300
153: , p4_a8 JTF_VARCHAR2_TABLE_2000

Line 155: , p4_a10 JTF_VARCHAR2_TABLE_100

151: , p4_a6 JTF_NUMBER_TABLE
152: , p4_a7 JTF_VARCHAR2_TABLE_300
153: , p4_a8 JTF_VARCHAR2_TABLE_2000
154: , p4_a9 JTF_VARCHAR2_TABLE_2000
155: , p4_a10 JTF_VARCHAR2_TABLE_100
156: , p5_a0 VARCHAR2
157: , p5_a1 NUMBER
158: , p5_a2 VARCHAR2
159: , p5_a3 VARCHAR2

Line 178: , p6_a8 JTF_VARCHAR2_TABLE_100

174: , p6_a4 JTF_NUMBER_TABLE
175: , p6_a5 JTF_NUMBER_TABLE
176: , p6_a6 JTF_NUMBER_TABLE
177: , p6_a7 JTF_NUMBER_TABLE
178: , p6_a8 JTF_VARCHAR2_TABLE_100
179: , p6_a9 JTF_VARCHAR2_TABLE_100
180: , p7_a0 VARCHAR2
181: , p7_a1 NUMBER
182: , p7_a2 VARCHAR2

Line 179: , p6_a9 JTF_VARCHAR2_TABLE_100

175: , p6_a5 JTF_NUMBER_TABLE
176: , p6_a6 JTF_NUMBER_TABLE
177: , p6_a7 JTF_NUMBER_TABLE
178: , p6_a8 JTF_VARCHAR2_TABLE_100
179: , p6_a9 JTF_VARCHAR2_TABLE_100
180: , p7_a0 VARCHAR2
181: , p7_a1 NUMBER
182: , p7_a2 VARCHAR2
183: , p7_a3 VARCHAR2

Line 202: , p8_a8 JTF_VARCHAR2_TABLE_100

198: , p8_a4 JTF_NUMBER_TABLE
199: , p8_a5 JTF_NUMBER_TABLE
200: , p8_a6 JTF_NUMBER_TABLE
201: , p8_a7 JTF_NUMBER_TABLE
202: , p8_a8 JTF_VARCHAR2_TABLE_100
203: , p8_a9 JTF_VARCHAR2_TABLE_100
204: , x_service_id out nocopy NUMBER
205: , x_return_status out nocopy VARCHAR2
206: , x_msg_count out nocopy NUMBER

Line 203: , p8_a9 JTF_VARCHAR2_TABLE_100

199: , p8_a5 JTF_NUMBER_TABLE
200: , p8_a6 JTF_NUMBER_TABLE
201: , p8_a7 JTF_NUMBER_TABLE
202: , p8_a8 JTF_VARCHAR2_TABLE_100
203: , p8_a9 JTF_VARCHAR2_TABLE_100
204: , x_service_id out nocopy NUMBER
205: , x_return_status out nocopy VARCHAR2
206: , x_msg_count out nocopy NUMBER
207: , x_msg_data out nocopy VARCHAR2

Line 383: , p4_a2 JTF_VARCHAR2_TABLE_100

379: , p3_a24 VARCHAR2
380: , p3_a25 VARCHAR2
381: , p4_a0 JTF_NUMBER_TABLE
382: , p4_a1 JTF_NUMBER_TABLE
383: , p4_a2 JTF_VARCHAR2_TABLE_100
384: , p4_a3 JTF_NUMBER_TABLE
385: , p4_a4 JTF_VARCHAR2_TABLE_100
386: , p4_a5 JTF_NUMBER_TABLE
387: , p4_a6 JTF_NUMBER_TABLE

Line 385: , p4_a4 JTF_VARCHAR2_TABLE_100

381: , p4_a0 JTF_NUMBER_TABLE
382: , p4_a1 JTF_NUMBER_TABLE
383: , p4_a2 JTF_VARCHAR2_TABLE_100
384: , p4_a3 JTF_NUMBER_TABLE
385: , p4_a4 JTF_VARCHAR2_TABLE_100
386: , p4_a5 JTF_NUMBER_TABLE
387: , p4_a6 JTF_NUMBER_TABLE
388: , p4_a7 JTF_VARCHAR2_TABLE_300
389: , p4_a8 JTF_VARCHAR2_TABLE_2000

Line 391: , p4_a10 JTF_VARCHAR2_TABLE_100

387: , p4_a6 JTF_NUMBER_TABLE
388: , p4_a7 JTF_VARCHAR2_TABLE_300
389: , p4_a8 JTF_VARCHAR2_TABLE_2000
390: , p4_a9 JTF_VARCHAR2_TABLE_2000
391: , p4_a10 JTF_VARCHAR2_TABLE_100
392: , p5_a0 VARCHAR2
393: , p5_a1 NUMBER
394: , p5_a2 VARCHAR2
395: , p5_a3 VARCHAR2

Line 414: , p6_a8 JTF_VARCHAR2_TABLE_100

410: , p6_a4 JTF_NUMBER_TABLE
411: , p6_a5 JTF_NUMBER_TABLE
412: , p6_a6 JTF_NUMBER_TABLE
413: , p6_a7 JTF_NUMBER_TABLE
414: , p6_a8 JTF_VARCHAR2_TABLE_100
415: , p6_a9 JTF_VARCHAR2_TABLE_100
416: , p7_a0 VARCHAR2
417: , p7_a1 NUMBER
418: , p7_a2 VARCHAR2

Line 415: , p6_a9 JTF_VARCHAR2_TABLE_100

411: , p6_a5 JTF_NUMBER_TABLE
412: , p6_a6 JTF_NUMBER_TABLE
413: , p6_a7 JTF_NUMBER_TABLE
414: , p6_a8 JTF_VARCHAR2_TABLE_100
415: , p6_a9 JTF_VARCHAR2_TABLE_100
416: , p7_a0 VARCHAR2
417: , p7_a1 NUMBER
418: , p7_a2 VARCHAR2
419: , p7_a3 VARCHAR2

Line 438: , p8_a8 JTF_VARCHAR2_TABLE_100

434: , p8_a4 JTF_NUMBER_TABLE
435: , p8_a5 JTF_NUMBER_TABLE
436: , p8_a6 JTF_NUMBER_TABLE
437: , p8_a7 JTF_NUMBER_TABLE
438: , p8_a8 JTF_VARCHAR2_TABLE_100
439: , p8_a9 JTF_VARCHAR2_TABLE_100
440: , x_return_status out nocopy VARCHAR2
441: , x_msg_count out nocopy NUMBER
442: , x_msg_data out nocopy VARCHAR2

Line 439: , p8_a9 JTF_VARCHAR2_TABLE_100

435: , p8_a5 JTF_NUMBER_TABLE
436: , p8_a6 JTF_NUMBER_TABLE
437: , p8_a7 JTF_NUMBER_TABLE
438: , p8_a8 JTF_VARCHAR2_TABLE_100
439: , p8_a9 JTF_VARCHAR2_TABLE_100
440: , x_return_status out nocopy VARCHAR2
441: , x_msg_count out nocopy NUMBER
442: , x_msg_data out nocopy VARCHAR2
443: )

Line 616: , p5_a2 JTF_VARCHAR2_TABLE_100

612: , p4_a24 VARCHAR2
613: , p4_a25 VARCHAR2
614: , p5_a0 JTF_NUMBER_TABLE
615: , p5_a1 JTF_NUMBER_TABLE
616: , p5_a2 JTF_VARCHAR2_TABLE_100
617: , p5_a3 JTF_NUMBER_TABLE
618: , p5_a4 JTF_VARCHAR2_TABLE_100
619: , p5_a5 JTF_NUMBER_TABLE
620: , p5_a6 JTF_NUMBER_TABLE

Line 618: , p5_a4 JTF_VARCHAR2_TABLE_100

614: , p5_a0 JTF_NUMBER_TABLE
615: , p5_a1 JTF_NUMBER_TABLE
616: , p5_a2 JTF_VARCHAR2_TABLE_100
617: , p5_a3 JTF_NUMBER_TABLE
618: , p5_a4 JTF_VARCHAR2_TABLE_100
619: , p5_a5 JTF_NUMBER_TABLE
620: , p5_a6 JTF_NUMBER_TABLE
621: , p5_a7 JTF_VARCHAR2_TABLE_300
622: , p5_a8 JTF_VARCHAR2_TABLE_2000

Line 624: , p5_a10 JTF_VARCHAR2_TABLE_100

620: , p5_a6 JTF_NUMBER_TABLE
621: , p5_a7 JTF_VARCHAR2_TABLE_300
622: , p5_a8 JTF_VARCHAR2_TABLE_2000
623: , p5_a9 JTF_VARCHAR2_TABLE_2000
624: , p5_a10 JTF_VARCHAR2_TABLE_100
625: , p6_a0 VARCHAR2
626: , p6_a1 NUMBER
627: , p6_a2 VARCHAR2
628: , p6_a3 VARCHAR2

Line 647: , p7_a8 JTF_VARCHAR2_TABLE_100

643: , p7_a4 JTF_NUMBER_TABLE
644: , p7_a5 JTF_NUMBER_TABLE
645: , p7_a6 JTF_NUMBER_TABLE
646: , p7_a7 JTF_NUMBER_TABLE
647: , p7_a8 JTF_VARCHAR2_TABLE_100
648: , p7_a9 JTF_VARCHAR2_TABLE_100
649: , p8_a0 VARCHAR2
650: , p8_a1 NUMBER
651: , p8_a2 VARCHAR2

Line 648: , p7_a9 JTF_VARCHAR2_TABLE_100

644: , p7_a5 JTF_NUMBER_TABLE
645: , p7_a6 JTF_NUMBER_TABLE
646: , p7_a7 JTF_NUMBER_TABLE
647: , p7_a8 JTF_VARCHAR2_TABLE_100
648: , p7_a9 JTF_VARCHAR2_TABLE_100
649: , p8_a0 VARCHAR2
650: , p8_a1 NUMBER
651: , p8_a2 VARCHAR2
652: , p8_a3 VARCHAR2

Line 671: , p9_a8 JTF_VARCHAR2_TABLE_100

667: , p9_a4 JTF_NUMBER_TABLE
668: , p9_a5 JTF_NUMBER_TABLE
669: , p9_a6 JTF_NUMBER_TABLE
670: , p9_a7 JTF_NUMBER_TABLE
671: , p9_a8 JTF_VARCHAR2_TABLE_100
672: , p9_a9 JTF_VARCHAR2_TABLE_100
673: , x_service_id out nocopy NUMBER
674: , x_return_status out nocopy VARCHAR2
675: , x_msg_count out nocopy NUMBER

Line 672: , p9_a9 JTF_VARCHAR2_TABLE_100

668: , p9_a5 JTF_NUMBER_TABLE
669: , p9_a6 JTF_NUMBER_TABLE
670: , p9_a7 JTF_NUMBER_TABLE
671: , p9_a8 JTF_VARCHAR2_TABLE_100
672: , p9_a9 JTF_VARCHAR2_TABLE_100
673: , x_service_id out nocopy NUMBER
674: , x_return_status out nocopy VARCHAR2
675: , x_msg_count out nocopy NUMBER
676: , x_msg_data out nocopy VARCHAR2