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

Line 3: procedure rosetta_table_copy_in_p18(t out nocopy okl_ec_uptake_pvt.okl_number_table_type, a0 JTF_NUMBER_TABLE) as

1: package body okl_ec_uptake_pvt_w as
2: /* $Header: OKLEECXB.pls 120.7 2006/03/08 11:34:39 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p18(t out nocopy okl_ec_uptake_pvt.okl_number_table_type, a0 JTF_NUMBER_TABLE) as
4: ddindx binary_integer; indx binary_integer;
5: begin
6: if a0 is not null and a0.count > 0 then
7: if a0.count > 0 then

Line 21: procedure rosetta_table_copy_out_p18(t okl_ec_uptake_pvt.okl_number_table_type, a0 out nocopy JTF_NUMBER_TABLE) as

17: end loop;
18: end if;
19: end if;
20: end rosetta_table_copy_in_p18;
21: procedure rosetta_table_copy_out_p18(t okl_ec_uptake_pvt.okl_number_table_type, a0 out nocopy JTF_NUMBER_TABLE) as
22: ddindx binary_integer; indx binary_integer;
23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_NUMBER_TABLE();

Line 25: a0 := JTF_NUMBER_TABLE();

21: procedure rosetta_table_copy_out_p18(t okl_ec_uptake_pvt.okl_number_table_type, a0 out nocopy JTF_NUMBER_TABLE) as
22: ddindx binary_integer; indx binary_integer;
23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_NUMBER_TABLE();
26: else
27: a0 := JTF_NUMBER_TABLE();
28: if t.count > 0 then
29: a0.extend(t.count);

Line 27: a0 := JTF_NUMBER_TABLE();

23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_NUMBER_TABLE();
26: else
27: a0 := JTF_NUMBER_TABLE();
28: if t.count > 0 then
29: a0.extend(t.count);
30: ddindx := t.first;
31: indx := 1;

Line 176: procedure rosetta_table_copy_in_p24(t out nocopy okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 JTF_NUMBER_TABLE

172: end if;
173: end if;
174: end rosetta_table_copy_out_p22;
175:
176: procedure rosetta_table_copy_in_p24(t out nocopy okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 JTF_NUMBER_TABLE
177: , a1 JTF_NUMBER_TABLE
178: , a2 JTF_NUMBER_TABLE
179: , a3 JTF_VARCHAR2_TABLE_200
180: , a4 JTF_VARCHAR2_TABLE_2000

Line 177: , a1 JTF_NUMBER_TABLE

173: end if;
174: end rosetta_table_copy_out_p22;
175:
176: procedure rosetta_table_copy_in_p24(t out nocopy okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 JTF_NUMBER_TABLE
177: , a1 JTF_NUMBER_TABLE
178: , a2 JTF_NUMBER_TABLE
179: , a3 JTF_VARCHAR2_TABLE_200
180: , a4 JTF_VARCHAR2_TABLE_2000
181: , a5 JTF_DATE_TABLE

Line 178: , a2 JTF_NUMBER_TABLE

174: end rosetta_table_copy_out_p22;
175:
176: procedure rosetta_table_copy_in_p24(t out nocopy okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 JTF_NUMBER_TABLE
177: , a1 JTF_NUMBER_TABLE
178: , a2 JTF_NUMBER_TABLE
179: , a3 JTF_VARCHAR2_TABLE_200
180: , a4 JTF_VARCHAR2_TABLE_2000
181: , a5 JTF_DATE_TABLE
182: , a6 JTF_DATE_TABLE

Line 183: , a7 JTF_NUMBER_TABLE

179: , a3 JTF_VARCHAR2_TABLE_200
180: , a4 JTF_VARCHAR2_TABLE_2000
181: , a5 JTF_DATE_TABLE
182: , a6 JTF_DATE_TABLE
183: , a7 JTF_NUMBER_TABLE
184: , a8 JTF_VARCHAR2_TABLE_100
185: , a9 JTF_VARCHAR2_TABLE_100
186: , a10 JTF_VARCHAR2_TABLE_300
187: ) as

Line 215: procedure rosetta_table_copy_out_p24(t okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

211: end loop;
212: end if;
213: end if;
214: end rosetta_table_copy_in_p24;
215: procedure rosetta_table_copy_out_p24(t okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
216: , a1 out nocopy JTF_NUMBER_TABLE
217: , a2 out nocopy JTF_NUMBER_TABLE
218: , a3 out nocopy JTF_VARCHAR2_TABLE_200
219: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 216: , a1 out nocopy JTF_NUMBER_TABLE

212: end if;
213: end if;
214: end rosetta_table_copy_in_p24;
215: procedure rosetta_table_copy_out_p24(t okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
216: , a1 out nocopy JTF_NUMBER_TABLE
217: , a2 out nocopy JTF_NUMBER_TABLE
218: , a3 out nocopy JTF_VARCHAR2_TABLE_200
219: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
220: , a5 out nocopy JTF_DATE_TABLE

Line 217: , a2 out nocopy JTF_NUMBER_TABLE

213: end if;
214: end rosetta_table_copy_in_p24;
215: procedure rosetta_table_copy_out_p24(t okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
216: , a1 out nocopy JTF_NUMBER_TABLE
217: , a2 out nocopy JTF_NUMBER_TABLE
218: , a3 out nocopy JTF_VARCHAR2_TABLE_200
219: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
220: , a5 out nocopy JTF_DATE_TABLE
221: , a6 out nocopy JTF_DATE_TABLE

Line 222: , a7 out nocopy JTF_NUMBER_TABLE

218: , a3 out nocopy JTF_VARCHAR2_TABLE_200
219: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
220: , a5 out nocopy JTF_DATE_TABLE
221: , a6 out nocopy JTF_DATE_TABLE
222: , a7 out nocopy JTF_NUMBER_TABLE
223: , a8 out nocopy JTF_VARCHAR2_TABLE_100
224: , a9 out nocopy JTF_VARCHAR2_TABLE_100
225: , a10 out nocopy JTF_VARCHAR2_TABLE_300
226: ) as

Line 230: a0 := JTF_NUMBER_TABLE();

226: ) as
227: ddindx binary_integer; indx binary_integer;
228: begin
229: if t is null or t.count = 0 then
230: a0 := JTF_NUMBER_TABLE();
231: a1 := JTF_NUMBER_TABLE();
232: a2 := JTF_NUMBER_TABLE();
233: a3 := JTF_VARCHAR2_TABLE_200();
234: a4 := JTF_VARCHAR2_TABLE_2000();

Line 231: a1 := JTF_NUMBER_TABLE();

227: ddindx binary_integer; indx binary_integer;
228: begin
229: if t is null or t.count = 0 then
230: a0 := JTF_NUMBER_TABLE();
231: a1 := JTF_NUMBER_TABLE();
232: a2 := JTF_NUMBER_TABLE();
233: a3 := JTF_VARCHAR2_TABLE_200();
234: a4 := JTF_VARCHAR2_TABLE_2000();
235: a5 := JTF_DATE_TABLE();

Line 232: a2 := JTF_NUMBER_TABLE();

228: begin
229: if t is null or t.count = 0 then
230: a0 := JTF_NUMBER_TABLE();
231: a1 := JTF_NUMBER_TABLE();
232: a2 := JTF_NUMBER_TABLE();
233: a3 := JTF_VARCHAR2_TABLE_200();
234: a4 := JTF_VARCHAR2_TABLE_2000();
235: a5 := JTF_DATE_TABLE();
236: a6 := JTF_DATE_TABLE();

Line 237: a7 := JTF_NUMBER_TABLE();

233: a3 := JTF_VARCHAR2_TABLE_200();
234: a4 := JTF_VARCHAR2_TABLE_2000();
235: a5 := JTF_DATE_TABLE();
236: a6 := JTF_DATE_TABLE();
237: a7 := JTF_NUMBER_TABLE();
238: a8 := JTF_VARCHAR2_TABLE_100();
239: a9 := JTF_VARCHAR2_TABLE_100();
240: a10 := JTF_VARCHAR2_TABLE_300();
241: else

Line 242: a0 := JTF_NUMBER_TABLE();

238: a8 := JTF_VARCHAR2_TABLE_100();
239: a9 := JTF_VARCHAR2_TABLE_100();
240: a10 := JTF_VARCHAR2_TABLE_300();
241: else
242: a0 := JTF_NUMBER_TABLE();
243: a1 := JTF_NUMBER_TABLE();
244: a2 := JTF_NUMBER_TABLE();
245: a3 := JTF_VARCHAR2_TABLE_200();
246: a4 := JTF_VARCHAR2_TABLE_2000();

Line 243: a1 := JTF_NUMBER_TABLE();

239: a9 := JTF_VARCHAR2_TABLE_100();
240: a10 := JTF_VARCHAR2_TABLE_300();
241: else
242: a0 := JTF_NUMBER_TABLE();
243: a1 := JTF_NUMBER_TABLE();
244: a2 := JTF_NUMBER_TABLE();
245: a3 := JTF_VARCHAR2_TABLE_200();
246: a4 := JTF_VARCHAR2_TABLE_2000();
247: a5 := JTF_DATE_TABLE();

Line 244: a2 := JTF_NUMBER_TABLE();

240: a10 := JTF_VARCHAR2_TABLE_300();
241: else
242: a0 := JTF_NUMBER_TABLE();
243: a1 := JTF_NUMBER_TABLE();
244: a2 := JTF_NUMBER_TABLE();
245: a3 := JTF_VARCHAR2_TABLE_200();
246: a4 := JTF_VARCHAR2_TABLE_2000();
247: a5 := JTF_DATE_TABLE();
248: a6 := JTF_DATE_TABLE();

Line 249: a7 := JTF_NUMBER_TABLE();

245: a3 := JTF_VARCHAR2_TABLE_200();
246: a4 := JTF_VARCHAR2_TABLE_2000();
247: a5 := JTF_DATE_TABLE();
248: a6 := JTF_DATE_TABLE();
249: a7 := JTF_NUMBER_TABLE();
250: a8 := JTF_VARCHAR2_TABLE_100();
251: a9 := JTF_VARCHAR2_TABLE_100();
252: a10 := JTF_VARCHAR2_TABLE_300();
253: if t.count > 0 then

Line 289: procedure rosetta_table_copy_in_p26(t out nocopy okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 JTF_NUMBER_TABLE

285: end if;
286: end if;
287: end rosetta_table_copy_out_p24;
288:
289: procedure rosetta_table_copy_in_p26(t out nocopy okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 JTF_NUMBER_TABLE
290: , a1 JTF_NUMBER_TABLE
291: , a2 JTF_NUMBER_TABLE
292: , a3 JTF_VARCHAR2_TABLE_300
293: , a4 JTF_VARCHAR2_TABLE_2000

Line 290: , a1 JTF_NUMBER_TABLE

286: end if;
287: end rosetta_table_copy_out_p24;
288:
289: procedure rosetta_table_copy_in_p26(t out nocopy okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 JTF_NUMBER_TABLE
290: , a1 JTF_NUMBER_TABLE
291: , a2 JTF_NUMBER_TABLE
292: , a3 JTF_VARCHAR2_TABLE_300
293: , a4 JTF_VARCHAR2_TABLE_2000
294: , a5 JTF_VARCHAR2_TABLE_100

Line 291: , a2 JTF_NUMBER_TABLE

287: end rosetta_table_copy_out_p24;
288:
289: procedure rosetta_table_copy_in_p26(t out nocopy okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 JTF_NUMBER_TABLE
290: , a1 JTF_NUMBER_TABLE
291: , a2 JTF_NUMBER_TABLE
292: , a3 JTF_VARCHAR2_TABLE_300
293: , a4 JTF_VARCHAR2_TABLE_2000
294: , a5 JTF_VARCHAR2_TABLE_100
295: , a6 JTF_DATE_TABLE

Line 297: , a8 JTF_NUMBER_TABLE

293: , a4 JTF_VARCHAR2_TABLE_2000
294: , a5 JTF_VARCHAR2_TABLE_100
295: , a6 JTF_DATE_TABLE
296: , a7 JTF_DATE_TABLE
297: , a8 JTF_NUMBER_TABLE
298: , a9 JTF_VARCHAR2_TABLE_100
299: , a10 JTF_VARCHAR2_TABLE_100
300: , a11 JTF_VARCHAR2_TABLE_300
301: ) as

Line 330: procedure rosetta_table_copy_out_p26(t okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

326: end loop;
327: end if;
328: end if;
329: end rosetta_table_copy_in_p26;
330: procedure rosetta_table_copy_out_p26(t okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
331: , a1 out nocopy JTF_NUMBER_TABLE
332: , a2 out nocopy JTF_NUMBER_TABLE
333: , a3 out nocopy JTF_VARCHAR2_TABLE_300
334: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 331: , a1 out nocopy JTF_NUMBER_TABLE

327: end if;
328: end if;
329: end rosetta_table_copy_in_p26;
330: procedure rosetta_table_copy_out_p26(t okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
331: , a1 out nocopy JTF_NUMBER_TABLE
332: , a2 out nocopy JTF_NUMBER_TABLE
333: , a3 out nocopy JTF_VARCHAR2_TABLE_300
334: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
335: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 332: , a2 out nocopy JTF_NUMBER_TABLE

328: end if;
329: end rosetta_table_copy_in_p26;
330: procedure rosetta_table_copy_out_p26(t okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
331: , a1 out nocopy JTF_NUMBER_TABLE
332: , a2 out nocopy JTF_NUMBER_TABLE
333: , a3 out nocopy JTF_VARCHAR2_TABLE_300
334: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
335: , a5 out nocopy JTF_VARCHAR2_TABLE_100
336: , a6 out nocopy JTF_DATE_TABLE

Line 338: , a8 out nocopy JTF_NUMBER_TABLE

334: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
335: , a5 out nocopy JTF_VARCHAR2_TABLE_100
336: , a6 out nocopy JTF_DATE_TABLE
337: , a7 out nocopy JTF_DATE_TABLE
338: , a8 out nocopy JTF_NUMBER_TABLE
339: , a9 out nocopy JTF_VARCHAR2_TABLE_100
340: , a10 out nocopy JTF_VARCHAR2_TABLE_100
341: , a11 out nocopy JTF_VARCHAR2_TABLE_300
342: ) as

Line 346: a0 := JTF_NUMBER_TABLE();

342: ) as
343: ddindx binary_integer; indx binary_integer;
344: begin
345: if t is null or t.count = 0 then
346: a0 := JTF_NUMBER_TABLE();
347: a1 := JTF_NUMBER_TABLE();
348: a2 := JTF_NUMBER_TABLE();
349: a3 := JTF_VARCHAR2_TABLE_300();
350: a4 := JTF_VARCHAR2_TABLE_2000();

Line 347: a1 := JTF_NUMBER_TABLE();

343: ddindx binary_integer; indx binary_integer;
344: begin
345: if t is null or t.count = 0 then
346: a0 := JTF_NUMBER_TABLE();
347: a1 := JTF_NUMBER_TABLE();
348: a2 := JTF_NUMBER_TABLE();
349: a3 := JTF_VARCHAR2_TABLE_300();
350: a4 := JTF_VARCHAR2_TABLE_2000();
351: a5 := JTF_VARCHAR2_TABLE_100();

Line 348: a2 := JTF_NUMBER_TABLE();

344: begin
345: if t is null or t.count = 0 then
346: a0 := JTF_NUMBER_TABLE();
347: a1 := JTF_NUMBER_TABLE();
348: a2 := JTF_NUMBER_TABLE();
349: a3 := JTF_VARCHAR2_TABLE_300();
350: a4 := JTF_VARCHAR2_TABLE_2000();
351: a5 := JTF_VARCHAR2_TABLE_100();
352: a6 := JTF_DATE_TABLE();

Line 354: a8 := JTF_NUMBER_TABLE();

350: a4 := JTF_VARCHAR2_TABLE_2000();
351: a5 := JTF_VARCHAR2_TABLE_100();
352: a6 := JTF_DATE_TABLE();
353: a7 := JTF_DATE_TABLE();
354: a8 := JTF_NUMBER_TABLE();
355: a9 := JTF_VARCHAR2_TABLE_100();
356: a10 := JTF_VARCHAR2_TABLE_100();
357: a11 := JTF_VARCHAR2_TABLE_300();
358: else

Line 359: a0 := JTF_NUMBER_TABLE();

355: a9 := JTF_VARCHAR2_TABLE_100();
356: a10 := JTF_VARCHAR2_TABLE_100();
357: a11 := JTF_VARCHAR2_TABLE_300();
358: else
359: a0 := JTF_NUMBER_TABLE();
360: a1 := JTF_NUMBER_TABLE();
361: a2 := JTF_NUMBER_TABLE();
362: a3 := JTF_VARCHAR2_TABLE_300();
363: a4 := JTF_VARCHAR2_TABLE_2000();

Line 360: a1 := JTF_NUMBER_TABLE();

356: a10 := JTF_VARCHAR2_TABLE_100();
357: a11 := JTF_VARCHAR2_TABLE_300();
358: else
359: a0 := JTF_NUMBER_TABLE();
360: a1 := JTF_NUMBER_TABLE();
361: a2 := JTF_NUMBER_TABLE();
362: a3 := JTF_VARCHAR2_TABLE_300();
363: a4 := JTF_VARCHAR2_TABLE_2000();
364: a5 := JTF_VARCHAR2_TABLE_100();

Line 361: a2 := JTF_NUMBER_TABLE();

357: a11 := JTF_VARCHAR2_TABLE_300();
358: else
359: a0 := JTF_NUMBER_TABLE();
360: a1 := JTF_NUMBER_TABLE();
361: a2 := JTF_NUMBER_TABLE();
362: a3 := JTF_VARCHAR2_TABLE_300();
363: a4 := JTF_VARCHAR2_TABLE_2000();
364: a5 := JTF_VARCHAR2_TABLE_100();
365: a6 := JTF_DATE_TABLE();

Line 367: a8 := JTF_NUMBER_TABLE();

363: a4 := JTF_VARCHAR2_TABLE_2000();
364: a5 := JTF_VARCHAR2_TABLE_100();
365: a6 := JTF_DATE_TABLE();
366: a7 := JTF_DATE_TABLE();
367: a8 := JTF_NUMBER_TABLE();
368: a9 := JTF_VARCHAR2_TABLE_100();
369: a10 := JTF_VARCHAR2_TABLE_100();
370: a11 := JTF_VARCHAR2_TABLE_300();
371: if t.count > 0 then

Line 409: procedure rosetta_table_copy_in_p28(t out nocopy okl_ec_uptake_pvt.okl_prod_tbl_type, a0 JTF_NUMBER_TABLE

405: end if;
406: end if;
407: end rosetta_table_copy_out_p26;
408:
409: procedure rosetta_table_copy_in_p28(t out nocopy okl_ec_uptake_pvt.okl_prod_tbl_type, a0 JTF_NUMBER_TABLE
410: , a1 JTF_VARCHAR2_TABLE_200
411: , a2 JTF_VARCHAR2_TABLE_200
412: , a3 JTF_NUMBER_TABLE
413: , a4 JTF_VARCHAR2_TABLE_2000

Line 412: , a3 JTF_NUMBER_TABLE

408:
409: procedure rosetta_table_copy_in_p28(t out nocopy okl_ec_uptake_pvt.okl_prod_tbl_type, a0 JTF_NUMBER_TABLE
410: , a1 JTF_VARCHAR2_TABLE_200
411: , a2 JTF_VARCHAR2_TABLE_200
412: , a3 JTF_NUMBER_TABLE
413: , a4 JTF_VARCHAR2_TABLE_2000
414: , a5 JTF_VARCHAR2_TABLE_100
415: , a6 JTF_VARCHAR2_TABLE_200
416: , a7 JTF_VARCHAR2_TABLE_4000

Line 442: procedure rosetta_table_copy_out_p28(t okl_ec_uptake_pvt.okl_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

438: end loop;
439: end if;
440: end if;
441: end rosetta_table_copy_in_p28;
442: procedure rosetta_table_copy_out_p28(t okl_ec_uptake_pvt.okl_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
443: , a1 out nocopy JTF_VARCHAR2_TABLE_200
444: , a2 out nocopy JTF_VARCHAR2_TABLE_200
445: , a3 out nocopy JTF_NUMBER_TABLE
446: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 445: , a3 out nocopy JTF_NUMBER_TABLE

441: end rosetta_table_copy_in_p28;
442: procedure rosetta_table_copy_out_p28(t okl_ec_uptake_pvt.okl_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
443: , a1 out nocopy JTF_VARCHAR2_TABLE_200
444: , a2 out nocopy JTF_VARCHAR2_TABLE_200
445: , a3 out nocopy JTF_NUMBER_TABLE
446: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
447: , a5 out nocopy JTF_VARCHAR2_TABLE_100
448: , a6 out nocopy JTF_VARCHAR2_TABLE_200
449: , a7 out nocopy JTF_VARCHAR2_TABLE_4000

Line 454: a0 := JTF_NUMBER_TABLE();

450: ) as
451: ddindx binary_integer; indx binary_integer;
452: begin
453: if t is null or t.count = 0 then
454: a0 := JTF_NUMBER_TABLE();
455: a1 := JTF_VARCHAR2_TABLE_200();
456: a2 := JTF_VARCHAR2_TABLE_200();
457: a3 := JTF_NUMBER_TABLE();
458: a4 := JTF_VARCHAR2_TABLE_2000();

Line 457: a3 := JTF_NUMBER_TABLE();

453: if t is null or t.count = 0 then
454: a0 := JTF_NUMBER_TABLE();
455: a1 := JTF_VARCHAR2_TABLE_200();
456: a2 := JTF_VARCHAR2_TABLE_200();
457: a3 := JTF_NUMBER_TABLE();
458: a4 := JTF_VARCHAR2_TABLE_2000();
459: a5 := JTF_VARCHAR2_TABLE_100();
460: a6 := JTF_VARCHAR2_TABLE_200();
461: a7 := JTF_VARCHAR2_TABLE_4000();

Line 463: a0 := JTF_NUMBER_TABLE();

459: a5 := JTF_VARCHAR2_TABLE_100();
460: a6 := JTF_VARCHAR2_TABLE_200();
461: a7 := JTF_VARCHAR2_TABLE_4000();
462: else
463: a0 := JTF_NUMBER_TABLE();
464: a1 := JTF_VARCHAR2_TABLE_200();
465: a2 := JTF_VARCHAR2_TABLE_200();
466: a3 := JTF_NUMBER_TABLE();
467: a4 := JTF_VARCHAR2_TABLE_2000();

Line 466: a3 := JTF_NUMBER_TABLE();

462: else
463: a0 := JTF_NUMBER_TABLE();
464: a1 := JTF_VARCHAR2_TABLE_200();
465: a2 := JTF_VARCHAR2_TABLE_200();
466: a3 := JTF_NUMBER_TABLE();
467: a4 := JTF_VARCHAR2_TABLE_2000();
468: a5 := JTF_VARCHAR2_TABLE_100();
469: a6 := JTF_VARCHAR2_TABLE_200();
470: a7 := JTF_VARCHAR2_TABLE_4000();

Line 501: procedure rosetta_table_copy_in_p30(t out nocopy okl_ec_uptake_pvt.okl_vp_tbl_type, a0 JTF_NUMBER_TABLE

497: end if;
498: end if;
499: end rosetta_table_copy_out_p28;
500:
501: procedure rosetta_table_copy_in_p30(t out nocopy okl_ec_uptake_pvt.okl_vp_tbl_type, a0 JTF_NUMBER_TABLE
502: , a1 JTF_VARCHAR2_TABLE_200
503: , a2 JTF_DATE_TABLE
504: , a3 JTF_DATE_TABLE
505: ) as

Line 526: procedure rosetta_table_copy_out_p30(t okl_ec_uptake_pvt.okl_vp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

522: end loop;
523: end if;
524: end if;
525: end rosetta_table_copy_in_p30;
526: procedure rosetta_table_copy_out_p30(t okl_ec_uptake_pvt.okl_vp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
527: , a1 out nocopy JTF_VARCHAR2_TABLE_200
528: , a2 out nocopy JTF_DATE_TABLE
529: , a3 out nocopy JTF_DATE_TABLE
530: ) as

Line 534: a0 := JTF_NUMBER_TABLE();

530: ) as
531: ddindx binary_integer; indx binary_integer;
532: begin
533: if t is null or t.count = 0 then
534: a0 := JTF_NUMBER_TABLE();
535: a1 := JTF_VARCHAR2_TABLE_200();
536: a2 := JTF_DATE_TABLE();
537: a3 := JTF_DATE_TABLE();
538: else

Line 539: a0 := JTF_NUMBER_TABLE();

535: a1 := JTF_VARCHAR2_TABLE_200();
536: a2 := JTF_DATE_TABLE();
537: a3 := JTF_DATE_TABLE();
538: else
539: a0 := JTF_NUMBER_TABLE();
540: a1 := JTF_VARCHAR2_TABLE_200();
541: a2 := JTF_DATE_TABLE();
542: a3 := JTF_DATE_TABLE();
543: if t.count > 0 then

Line 569: , p4_a0 out nocopy JTF_NUMBER_TABLE

565: procedure populate_lease_rate_set(p_api_version NUMBER
566: , p_init_msg_list VARCHAR2
567: , p_target_id NUMBER
568: , p_target_type VARCHAR2
569: , p4_a0 out nocopy JTF_NUMBER_TABLE
570: , p4_a1 out nocopy JTF_NUMBER_TABLE
571: , p4_a2 out nocopy JTF_NUMBER_TABLE
572: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_200
573: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 570: , p4_a1 out nocopy JTF_NUMBER_TABLE

566: , p_init_msg_list VARCHAR2
567: , p_target_id NUMBER
568: , p_target_type VARCHAR2
569: , p4_a0 out nocopy JTF_NUMBER_TABLE
570: , p4_a1 out nocopy JTF_NUMBER_TABLE
571: , p4_a2 out nocopy JTF_NUMBER_TABLE
572: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_200
573: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
574: , p4_a5 out nocopy JTF_DATE_TABLE

Line 571: , p4_a2 out nocopy JTF_NUMBER_TABLE

567: , p_target_id NUMBER
568: , p_target_type VARCHAR2
569: , p4_a0 out nocopy JTF_NUMBER_TABLE
570: , p4_a1 out nocopy JTF_NUMBER_TABLE
571: , p4_a2 out nocopy JTF_NUMBER_TABLE
572: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_200
573: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
574: , p4_a5 out nocopy JTF_DATE_TABLE
575: , p4_a6 out nocopy JTF_DATE_TABLE

Line 576: , p4_a7 out nocopy JTF_NUMBER_TABLE

572: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_200
573: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
574: , p4_a5 out nocopy JTF_DATE_TABLE
575: , p4_a6 out nocopy JTF_DATE_TABLE
576: , p4_a7 out nocopy JTF_NUMBER_TABLE
577: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
578: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
579: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_300
580: , x_return_status out nocopy VARCHAR2

Line 635: , p4_a0 out nocopy JTF_NUMBER_TABLE

631: procedure populate_std_rate_tmpl(p_api_version NUMBER
632: , p_init_msg_list VARCHAR2
633: , p_target_id NUMBER
634: , p_target_type VARCHAR2
635: , p4_a0 out nocopy JTF_NUMBER_TABLE
636: , p4_a1 out nocopy JTF_NUMBER_TABLE
637: , p4_a2 out nocopy JTF_NUMBER_TABLE
638: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
639: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 636: , p4_a1 out nocopy JTF_NUMBER_TABLE

632: , p_init_msg_list VARCHAR2
633: , p_target_id NUMBER
634: , p_target_type VARCHAR2
635: , p4_a0 out nocopy JTF_NUMBER_TABLE
636: , p4_a1 out nocopy JTF_NUMBER_TABLE
637: , p4_a2 out nocopy JTF_NUMBER_TABLE
638: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
639: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
640: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 637: , p4_a2 out nocopy JTF_NUMBER_TABLE

633: , p_target_id NUMBER
634: , p_target_type VARCHAR2
635: , p4_a0 out nocopy JTF_NUMBER_TABLE
636: , p4_a1 out nocopy JTF_NUMBER_TABLE
637: , p4_a2 out nocopy JTF_NUMBER_TABLE
638: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
639: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
640: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
641: , p4_a6 out nocopy JTF_DATE_TABLE

Line 643: , p4_a8 out nocopy JTF_NUMBER_TABLE

639: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
640: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
641: , p4_a6 out nocopy JTF_DATE_TABLE
642: , p4_a7 out nocopy JTF_DATE_TABLE
643: , p4_a8 out nocopy JTF_NUMBER_TABLE
644: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
645: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
646: , p4_a11 out nocopy JTF_VARCHAR2_TABLE_300
647: , x_return_status out nocopy VARCHAR2

Line 712: , p_item_table JTF_NUMBER_TABLE

708: , p_down_payment NUMBER
709: , p_advance_rent NUMBER
710: , p_trade_in_value NUMBER
711: , p_currency_code VARCHAR2
712: , p_item_table JTF_NUMBER_TABLE
713: , p_item_categories_table JTF_NUMBER_TABLE
714: , p15_a0 out nocopy JTF_NUMBER_TABLE
715: , p15_a1 out nocopy JTF_NUMBER_TABLE
716: , p15_a2 out nocopy JTF_NUMBER_TABLE

Line 713: , p_item_categories_table JTF_NUMBER_TABLE

709: , p_advance_rent NUMBER
710: , p_trade_in_value NUMBER
711: , p_currency_code VARCHAR2
712: , p_item_table JTF_NUMBER_TABLE
713: , p_item_categories_table JTF_NUMBER_TABLE
714: , p15_a0 out nocopy JTF_NUMBER_TABLE
715: , p15_a1 out nocopy JTF_NUMBER_TABLE
716: , p15_a2 out nocopy JTF_NUMBER_TABLE
717: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 714: , p15_a0 out nocopy JTF_NUMBER_TABLE

710: , p_trade_in_value NUMBER
711: , p_currency_code VARCHAR2
712: , p_item_table JTF_NUMBER_TABLE
713: , p_item_categories_table JTF_NUMBER_TABLE
714: , p15_a0 out nocopy JTF_NUMBER_TABLE
715: , p15_a1 out nocopy JTF_NUMBER_TABLE
716: , p15_a2 out nocopy JTF_NUMBER_TABLE
717: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_200
718: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 715: , p15_a1 out nocopy JTF_NUMBER_TABLE

711: , p_currency_code VARCHAR2
712: , p_item_table JTF_NUMBER_TABLE
713: , p_item_categories_table JTF_NUMBER_TABLE
714: , p15_a0 out nocopy JTF_NUMBER_TABLE
715: , p15_a1 out nocopy JTF_NUMBER_TABLE
716: , p15_a2 out nocopy JTF_NUMBER_TABLE
717: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_200
718: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000
719: , p15_a5 out nocopy JTF_DATE_TABLE

Line 716: , p15_a2 out nocopy JTF_NUMBER_TABLE

712: , p_item_table JTF_NUMBER_TABLE
713: , p_item_categories_table JTF_NUMBER_TABLE
714: , p15_a0 out nocopy JTF_NUMBER_TABLE
715: , p15_a1 out nocopy JTF_NUMBER_TABLE
716: , p15_a2 out nocopy JTF_NUMBER_TABLE
717: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_200
718: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000
719: , p15_a5 out nocopy JTF_DATE_TABLE
720: , p15_a6 out nocopy JTF_DATE_TABLE

Line 721: , p15_a7 out nocopy JTF_NUMBER_TABLE

717: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_200
718: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000
719: , p15_a5 out nocopy JTF_DATE_TABLE
720: , p15_a6 out nocopy JTF_DATE_TABLE
721: , p15_a7 out nocopy JTF_NUMBER_TABLE
722: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_100
723: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
724: , p15_a10 out nocopy JTF_VARCHAR2_TABLE_300
725: , x_return_status out nocopy VARCHAR2

Line 826: , p_item_table JTF_NUMBER_TABLE

822: , p_down_payment NUMBER
823: , p_advance_rent NUMBER
824: , p_trade_in_value NUMBER
825: , p_currency_code VARCHAR2
826: , p_item_table JTF_NUMBER_TABLE
827: , p_item_categories_table JTF_NUMBER_TABLE
828: , p15_a0 out nocopy JTF_NUMBER_TABLE
829: , p15_a1 out nocopy JTF_NUMBER_TABLE
830: , p15_a2 out nocopy JTF_NUMBER_TABLE

Line 827: , p_item_categories_table JTF_NUMBER_TABLE

823: , p_advance_rent NUMBER
824: , p_trade_in_value NUMBER
825: , p_currency_code VARCHAR2
826: , p_item_table JTF_NUMBER_TABLE
827: , p_item_categories_table JTF_NUMBER_TABLE
828: , p15_a0 out nocopy JTF_NUMBER_TABLE
829: , p15_a1 out nocopy JTF_NUMBER_TABLE
830: , p15_a2 out nocopy JTF_NUMBER_TABLE
831: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_300

Line 828: , p15_a0 out nocopy JTF_NUMBER_TABLE

824: , p_trade_in_value NUMBER
825: , p_currency_code VARCHAR2
826: , p_item_table JTF_NUMBER_TABLE
827: , p_item_categories_table JTF_NUMBER_TABLE
828: , p15_a0 out nocopy JTF_NUMBER_TABLE
829: , p15_a1 out nocopy JTF_NUMBER_TABLE
830: , p15_a2 out nocopy JTF_NUMBER_TABLE
831: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_300
832: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 829: , p15_a1 out nocopy JTF_NUMBER_TABLE

825: , p_currency_code VARCHAR2
826: , p_item_table JTF_NUMBER_TABLE
827: , p_item_categories_table JTF_NUMBER_TABLE
828: , p15_a0 out nocopy JTF_NUMBER_TABLE
829: , p15_a1 out nocopy JTF_NUMBER_TABLE
830: , p15_a2 out nocopy JTF_NUMBER_TABLE
831: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_300
832: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000
833: , p15_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 830: , p15_a2 out nocopy JTF_NUMBER_TABLE

826: , p_item_table JTF_NUMBER_TABLE
827: , p_item_categories_table JTF_NUMBER_TABLE
828: , p15_a0 out nocopy JTF_NUMBER_TABLE
829: , p15_a1 out nocopy JTF_NUMBER_TABLE
830: , p15_a2 out nocopy JTF_NUMBER_TABLE
831: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_300
832: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000
833: , p15_a5 out nocopy JTF_VARCHAR2_TABLE_100
834: , p15_a6 out nocopy JTF_DATE_TABLE

Line 836: , p15_a8 out nocopy JTF_NUMBER_TABLE

832: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000
833: , p15_a5 out nocopy JTF_VARCHAR2_TABLE_100
834: , p15_a6 out nocopy JTF_DATE_TABLE
835: , p15_a7 out nocopy JTF_DATE_TABLE
836: , p15_a8 out nocopy JTF_NUMBER_TABLE
837: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
838: , p15_a10 out nocopy JTF_VARCHAR2_TABLE_100
839: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_300
840: , x_return_status out nocopy VARCHAR2

Line 933: , p4_a0 out nocopy JTF_NUMBER_TABLE

929: procedure populate_product(p_api_version NUMBER
930: , p_init_msg_list VARCHAR2
931: , p_target_id NUMBER
932: , p_target_type VARCHAR2
933: , p4_a0 out nocopy JTF_NUMBER_TABLE
934: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_200
935: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200
936: , p4_a3 out nocopy JTF_NUMBER_TABLE
937: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 936: , p4_a3 out nocopy JTF_NUMBER_TABLE

932: , p_target_type VARCHAR2
933: , p4_a0 out nocopy JTF_NUMBER_TABLE
934: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_200
935: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200
936: , p4_a3 out nocopy JTF_NUMBER_TABLE
937: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
938: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
939: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_200
940: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_4000

Line 1001: , p_item_table JTF_NUMBER_TABLE

997: , p_customer_credit_class VARCHAR2
998: , p_down_payment NUMBER
999: , p_advance_rent NUMBER
1000: , p_trade_in_value NUMBER
1001: , p_item_table JTF_NUMBER_TABLE
1002: , p_item_categories_table JTF_NUMBER_TABLE
1003: , p14_a0 out nocopy JTF_NUMBER_TABLE
1004: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_200
1005: , p14_a2 out nocopy JTF_DATE_TABLE

Line 1002: , p_item_categories_table JTF_NUMBER_TABLE

998: , p_down_payment NUMBER
999: , p_advance_rent NUMBER
1000: , p_trade_in_value NUMBER
1001: , p_item_table JTF_NUMBER_TABLE
1002: , p_item_categories_table JTF_NUMBER_TABLE
1003: , p14_a0 out nocopy JTF_NUMBER_TABLE
1004: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_200
1005: , p14_a2 out nocopy JTF_DATE_TABLE
1006: , p14_a3 out nocopy JTF_DATE_TABLE

Line 1003: , p14_a0 out nocopy JTF_NUMBER_TABLE

999: , p_advance_rent NUMBER
1000: , p_trade_in_value NUMBER
1001: , p_item_table JTF_NUMBER_TABLE
1002: , p_item_categories_table JTF_NUMBER_TABLE
1003: , p14_a0 out nocopy JTF_NUMBER_TABLE
1004: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_200
1005: , p14_a2 out nocopy JTF_DATE_TABLE
1006: , p14_a3 out nocopy JTF_DATE_TABLE
1007: , x_return_status out nocopy VARCHAR2