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_DEAL_ASSET_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 16: , a13 JTF_VARCHAR2_TABLE_200

12: , a9 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_VARCHAR2_TABLE_300
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_200
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_2000
19: ) as
20: ddindx binary_integer; indx binary_integer;

Line 18: , a15 JTF_VARCHAR2_TABLE_2000

14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_200
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_2000
19: ) as
20: ddindx binary_integer; indx binary_integer;
21: begin
22: if a0 is not null and a0.count > 0 then

Line 65: , a13 out nocopy JTF_VARCHAR2_TABLE_200

61: , a9 out nocopy JTF_VARCHAR2_TABLE_300
62: , a10 out nocopy JTF_VARCHAR2_TABLE_300
63: , a11 out nocopy JTF_NUMBER_TABLE
64: , a12 out nocopy JTF_VARCHAR2_TABLE_100
65: , a13 out nocopy JTF_VARCHAR2_TABLE_200
66: , a14 out nocopy JTF_VARCHAR2_TABLE_100
67: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
68: ) as
69: ddindx binary_integer; indx binary_integer;

Line 67: , a15 out nocopy JTF_VARCHAR2_TABLE_2000

63: , a11 out nocopy JTF_NUMBER_TABLE
64: , a12 out nocopy JTF_VARCHAR2_TABLE_100
65: , a13 out nocopy JTF_VARCHAR2_TABLE_200
66: , a14 out nocopy JTF_VARCHAR2_TABLE_100
67: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
68: ) as
69: ddindx binary_integer; indx binary_integer;
70: begin
71: if t is null or t.count = 0 then

Line 85: a13 := JTF_VARCHAR2_TABLE_200();

81: a9 := JTF_VARCHAR2_TABLE_300();
82: a10 := JTF_VARCHAR2_TABLE_300();
83: a11 := JTF_NUMBER_TABLE();
84: a12 := JTF_VARCHAR2_TABLE_100();
85: a13 := JTF_VARCHAR2_TABLE_200();
86: a14 := JTF_VARCHAR2_TABLE_100();
87: a15 := JTF_VARCHAR2_TABLE_2000();
88: else
89: a0 := JTF_NUMBER_TABLE();

Line 87: a15 := JTF_VARCHAR2_TABLE_2000();

83: a11 := JTF_NUMBER_TABLE();
84: a12 := JTF_VARCHAR2_TABLE_100();
85: a13 := JTF_VARCHAR2_TABLE_200();
86: a14 := JTF_VARCHAR2_TABLE_100();
87: a15 := JTF_VARCHAR2_TABLE_2000();
88: else
89: a0 := JTF_NUMBER_TABLE();
90: a1 := JTF_NUMBER_TABLE();
91: a2 := JTF_NUMBER_TABLE();

Line 102: a13 := JTF_VARCHAR2_TABLE_200();

98: a9 := JTF_VARCHAR2_TABLE_300();
99: a10 := JTF_VARCHAR2_TABLE_300();
100: a11 := JTF_NUMBER_TABLE();
101: a12 := JTF_VARCHAR2_TABLE_100();
102: a13 := JTF_VARCHAR2_TABLE_200();
103: a14 := JTF_VARCHAR2_TABLE_100();
104: a15 := JTF_VARCHAR2_TABLE_2000();
105: if t.count > 0 then
106: a0.extend(t.count);

Line 104: a15 := JTF_VARCHAR2_TABLE_2000();

100: a11 := JTF_NUMBER_TABLE();
101: a12 := JTF_VARCHAR2_TABLE_100();
102: a13 := JTF_VARCHAR2_TABLE_200();
103: a14 := JTF_VARCHAR2_TABLE_100();
104: a15 := JTF_VARCHAR2_TABLE_2000();
105: if t.count > 0 then
106: a0.extend(t.count);
107: a1.extend(t.count);
108: a2.extend(t.count);

Line 153: , a2 JTF_VARCHAR2_TABLE_200

149: end rosetta_table_copy_out_p2;
150:
151: procedure rosetta_table_copy_in_p4(t out nocopy okl_deal_asset_pvt.down_payment_tbl_type, a0 JTF_NUMBER_TABLE
152: , a1 JTF_NUMBER_TABLE
153: , a2 JTF_VARCHAR2_TABLE_200
154: , a3 JTF_NUMBER_TABLE
155: , a4 JTF_VARCHAR2_TABLE_2000
156: , a5 JTF_VARCHAR2_TABLE_100
157: , a6 JTF_NUMBER_TABLE

Line 155: , a4 JTF_VARCHAR2_TABLE_2000

151: procedure rosetta_table_copy_in_p4(t out nocopy okl_deal_asset_pvt.down_payment_tbl_type, a0 JTF_NUMBER_TABLE
152: , a1 JTF_NUMBER_TABLE
153: , a2 JTF_VARCHAR2_TABLE_200
154: , a3 JTF_NUMBER_TABLE
155: , a4 JTF_VARCHAR2_TABLE_2000
156: , a5 JTF_VARCHAR2_TABLE_100
157: , a6 JTF_NUMBER_TABLE
158: , a7 JTF_VARCHAR2_TABLE_100
159: , a8 JTF_VARCHAR2_TABLE_100

Line 188: , a2 out nocopy JTF_VARCHAR2_TABLE_200

184: end if;
185: end rosetta_table_copy_in_p4;
186: procedure rosetta_table_copy_out_p4(t okl_deal_asset_pvt.down_payment_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
187: , a1 out nocopy JTF_NUMBER_TABLE
188: , a2 out nocopy JTF_VARCHAR2_TABLE_200
189: , a3 out nocopy JTF_NUMBER_TABLE
190: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
191: , a5 out nocopy JTF_VARCHAR2_TABLE_100
192: , a6 out nocopy JTF_NUMBER_TABLE

Line 190: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

186: procedure rosetta_table_copy_out_p4(t okl_deal_asset_pvt.down_payment_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
187: , a1 out nocopy JTF_NUMBER_TABLE
188: , a2 out nocopy JTF_VARCHAR2_TABLE_200
189: , a3 out nocopy JTF_NUMBER_TABLE
190: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
191: , a5 out nocopy JTF_VARCHAR2_TABLE_100
192: , a6 out nocopy JTF_NUMBER_TABLE
193: , a7 out nocopy JTF_VARCHAR2_TABLE_100
194: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 201: a2 := JTF_VARCHAR2_TABLE_200();

197: begin
198: if t is null or t.count = 0 then
199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_VARCHAR2_TABLE_200();
202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_VARCHAR2_TABLE_2000();
204: a5 := JTF_VARCHAR2_TABLE_100();
205: a6 := JTF_NUMBER_TABLE();

Line 203: a4 := JTF_VARCHAR2_TABLE_2000();

199: a0 := JTF_NUMBER_TABLE();
200: a1 := JTF_NUMBER_TABLE();
201: a2 := JTF_VARCHAR2_TABLE_200();
202: a3 := JTF_NUMBER_TABLE();
203: a4 := JTF_VARCHAR2_TABLE_2000();
204: a5 := JTF_VARCHAR2_TABLE_100();
205: a6 := JTF_NUMBER_TABLE();
206: a7 := JTF_VARCHAR2_TABLE_100();
207: a8 := JTF_VARCHAR2_TABLE_100();

Line 211: a2 := JTF_VARCHAR2_TABLE_200();

207: a8 := JTF_VARCHAR2_TABLE_100();
208: else
209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_NUMBER_TABLE();
211: a2 := JTF_VARCHAR2_TABLE_200();
212: a3 := JTF_NUMBER_TABLE();
213: a4 := JTF_VARCHAR2_TABLE_2000();
214: a5 := JTF_VARCHAR2_TABLE_100();
215: a6 := JTF_NUMBER_TABLE();

Line 213: a4 := JTF_VARCHAR2_TABLE_2000();

209: a0 := JTF_NUMBER_TABLE();
210: a1 := JTF_NUMBER_TABLE();
211: a2 := JTF_VARCHAR2_TABLE_200();
212: a3 := JTF_NUMBER_TABLE();
213: a4 := JTF_VARCHAR2_TABLE_2000();
214: a5 := JTF_VARCHAR2_TABLE_100();
215: a6 := JTF_NUMBER_TABLE();
216: a7 := JTF_VARCHAR2_TABLE_100();
217: a8 := JTF_VARCHAR2_TABLE_100();

Line 252: , a2 JTF_VARCHAR2_TABLE_200

248: end rosetta_table_copy_out_p4;
249:
250: procedure rosetta_table_copy_in_p6(t out nocopy okl_deal_asset_pvt.tradein_tbl_type, a0 JTF_NUMBER_TABLE
251: , a1 JTF_NUMBER_TABLE
252: , a2 JTF_VARCHAR2_TABLE_200
253: , a3 JTF_NUMBER_TABLE
254: , a4 JTF_VARCHAR2_TABLE_2000
255: , a5 JTF_NUMBER_TABLE
256: ) as

Line 254: , a4 JTF_VARCHAR2_TABLE_2000

250: procedure rosetta_table_copy_in_p6(t out nocopy okl_deal_asset_pvt.tradein_tbl_type, a0 JTF_NUMBER_TABLE
251: , a1 JTF_NUMBER_TABLE
252: , a2 JTF_VARCHAR2_TABLE_200
253: , a3 JTF_NUMBER_TABLE
254: , a4 JTF_VARCHAR2_TABLE_2000
255: , a5 JTF_NUMBER_TABLE
256: ) as
257: ddindx binary_integer; indx binary_integer;
258: begin

Line 281: , a2 out nocopy JTF_VARCHAR2_TABLE_200

277: end if;
278: end rosetta_table_copy_in_p6;
279: procedure rosetta_table_copy_out_p6(t okl_deal_asset_pvt.tradein_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
280: , a1 out nocopy JTF_NUMBER_TABLE
281: , a2 out nocopy JTF_VARCHAR2_TABLE_200
282: , a3 out nocopy JTF_NUMBER_TABLE
283: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
284: , a5 out nocopy JTF_NUMBER_TABLE
285: ) as

Line 283: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

279: procedure rosetta_table_copy_out_p6(t okl_deal_asset_pvt.tradein_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
280: , a1 out nocopy JTF_NUMBER_TABLE
281: , a2 out nocopy JTF_VARCHAR2_TABLE_200
282: , a3 out nocopy JTF_NUMBER_TABLE
283: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
284: , a5 out nocopy JTF_NUMBER_TABLE
285: ) as
286: ddindx binary_integer; indx binary_integer;
287: begin

Line 291: a2 := JTF_VARCHAR2_TABLE_200();

287: begin
288: if t is null or t.count = 0 then
289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_VARCHAR2_TABLE_200();
292: a3 := JTF_NUMBER_TABLE();
293: a4 := JTF_VARCHAR2_TABLE_2000();
294: a5 := JTF_NUMBER_TABLE();
295: else

Line 293: a4 := JTF_VARCHAR2_TABLE_2000();

289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_VARCHAR2_TABLE_200();
292: a3 := JTF_NUMBER_TABLE();
293: a4 := JTF_VARCHAR2_TABLE_2000();
294: a5 := JTF_NUMBER_TABLE();
295: else
296: a0 := JTF_NUMBER_TABLE();
297: a1 := JTF_NUMBER_TABLE();

Line 298: a2 := JTF_VARCHAR2_TABLE_200();

294: a5 := JTF_NUMBER_TABLE();
295: else
296: a0 := JTF_NUMBER_TABLE();
297: a1 := JTF_NUMBER_TABLE();
298: a2 := JTF_VARCHAR2_TABLE_200();
299: a3 := JTF_NUMBER_TABLE();
300: a4 := JTF_VARCHAR2_TABLE_2000();
301: a5 := JTF_NUMBER_TABLE();
302: if t.count > 0 then

Line 300: a4 := JTF_VARCHAR2_TABLE_2000();

296: a0 := JTF_NUMBER_TABLE();
297: a1 := JTF_NUMBER_TABLE();
298: a2 := JTF_VARCHAR2_TABLE_200();
299: a3 := JTF_NUMBER_TABLE();
300: a4 := JTF_VARCHAR2_TABLE_2000();
301: a5 := JTF_NUMBER_TABLE();
302: if t.count > 0 then
303: a0.extend(t.count);
304: a1.extend(t.count);

Line 717: , p5_a13 JTF_VARCHAR2_TABLE_200

713: , p5_a9 JTF_VARCHAR2_TABLE_300
714: , p5_a10 JTF_VARCHAR2_TABLE_300
715: , p5_a11 JTF_NUMBER_TABLE
716: , p5_a12 JTF_VARCHAR2_TABLE_100
717: , p5_a13 JTF_VARCHAR2_TABLE_200
718: , p5_a14 JTF_VARCHAR2_TABLE_100
719: , p5_a15 JTF_VARCHAR2_TABLE_2000
720: , p6_a0 out nocopy JTF_NUMBER_TABLE
721: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 719: , p5_a15 JTF_VARCHAR2_TABLE_2000

715: , p5_a11 JTF_NUMBER_TABLE
716: , p5_a12 JTF_VARCHAR2_TABLE_100
717: , p5_a13 JTF_VARCHAR2_TABLE_200
718: , p5_a14 JTF_VARCHAR2_TABLE_100
719: , p5_a15 JTF_VARCHAR2_TABLE_2000
720: , p6_a0 out nocopy JTF_NUMBER_TABLE
721: , p6_a1 out nocopy JTF_NUMBER_TABLE
722: , p6_a2 out nocopy JTF_NUMBER_TABLE
723: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 733: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200

729: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
730: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
731: , p6_a11 out nocopy JTF_NUMBER_TABLE
732: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
733: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
734: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
735: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_2000
736: )
737:

Line 735: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_2000

731: , p6_a11 out nocopy JTF_NUMBER_TABLE
732: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
733: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
734: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
735: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_2000
736: )
737:
738: as
739: ddp_addon_tbl okl_deal_asset_pvt.addon_tbl_type;

Line 925: , p5_a13 JTF_VARCHAR2_TABLE_200

921: , p5_a9 JTF_VARCHAR2_TABLE_300
922: , p5_a10 JTF_VARCHAR2_TABLE_300
923: , p5_a11 JTF_NUMBER_TABLE
924: , p5_a12 JTF_VARCHAR2_TABLE_100
925: , p5_a13 JTF_VARCHAR2_TABLE_200
926: , p5_a14 JTF_VARCHAR2_TABLE_100
927: , p5_a15 JTF_VARCHAR2_TABLE_2000
928: , p6_a0 out nocopy JTF_NUMBER_TABLE
929: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 927: , p5_a15 JTF_VARCHAR2_TABLE_2000

923: , p5_a11 JTF_NUMBER_TABLE
924: , p5_a12 JTF_VARCHAR2_TABLE_100
925: , p5_a13 JTF_VARCHAR2_TABLE_200
926: , p5_a14 JTF_VARCHAR2_TABLE_100
927: , p5_a15 JTF_VARCHAR2_TABLE_2000
928: , p6_a0 out nocopy JTF_NUMBER_TABLE
929: , p6_a1 out nocopy JTF_NUMBER_TABLE
930: , p6_a2 out nocopy JTF_NUMBER_TABLE
931: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 941: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200

937: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
938: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
939: , p6_a11 out nocopy JTF_NUMBER_TABLE
940: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
942: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
943: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_2000
944: )
945:

Line 943: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_2000

939: , p6_a11 out nocopy JTF_NUMBER_TABLE
940: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
942: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
943: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_2000
944: )
945:
946: as
947: ddp_addon_tbl okl_deal_asset_pvt.addon_tbl_type;

Line 1678: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_200

1674: , p_tradein_amount NUMBER
1675: , p_mode VARCHAR2
1676: , p8_a0 out nocopy JTF_NUMBER_TABLE
1677: , p8_a1 out nocopy JTF_NUMBER_TABLE
1678: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_200
1679: , p8_a3 out nocopy JTF_NUMBER_TABLE
1680: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1681: , p8_a5 out nocopy JTF_NUMBER_TABLE
1682: )

Line 1680: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000

1676: , p8_a0 out nocopy JTF_NUMBER_TABLE
1677: , p8_a1 out nocopy JTF_NUMBER_TABLE
1678: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_200
1679: , p8_a3 out nocopy JTF_NUMBER_TABLE
1680: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1681: , p8_a5 out nocopy JTF_NUMBER_TABLE
1682: )
1683:
1684: as

Line 1739: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200

1735: , p_basis VARCHAR2
1736: , p_mode VARCHAR2
1737: , p9_a0 out nocopy JTF_NUMBER_TABLE
1738: , p9_a1 out nocopy JTF_NUMBER_TABLE
1739: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
1740: , p9_a3 out nocopy JTF_NUMBER_TABLE
1741: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1742: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
1743: , p9_a6 out nocopy JTF_NUMBER_TABLE

Line 1741: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000

1737: , p9_a0 out nocopy JTF_NUMBER_TABLE
1738: , p9_a1 out nocopy JTF_NUMBER_TABLE
1739: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
1740: , p9_a3 out nocopy JTF_NUMBER_TABLE
1741: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1742: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
1743: , p9_a6 out nocopy JTF_NUMBER_TABLE
1744: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
1745: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100