DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB_W dependencies on JTF_VARCHAR2_TABLE_300

Line 19: , a6 JTF_VARCHAR2_TABLE_300

15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_VARCHAR2_TABLE_300
20: , a7 JTF_VARCHAR2_TABLE_2000
21: , a8 JTF_DATE_TABLE
22: , a9 JTF_DATE_TABLE
23: , a10 JTF_DATE_TABLE

Line 62: , a6 out nocopy JTF_VARCHAR2_TABLE_300

58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_VARCHAR2_TABLE_100
60: , a4 out nocopy JTF_VARCHAR2_TABLE_100
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , a6 out nocopy JTF_VARCHAR2_TABLE_300
63: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
64: , a8 out nocopy JTF_DATE_TABLE
65: , a9 out nocopy JTF_DATE_TABLE
66: , a10 out nocopy JTF_DATE_TABLE

Line 79: a6 := JTF_VARCHAR2_TABLE_300();

75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_VARCHAR2_TABLE_300();
80: a7 := JTF_VARCHAR2_TABLE_2000();
81: a8 := JTF_DATE_TABLE();
82: a9 := JTF_DATE_TABLE();
83: a10 := JTF_DATE_TABLE();

Line 93: a6 := JTF_VARCHAR2_TABLE_300();

89: a2 := JTF_VARCHAR2_TABLE_100();
90: a3 := JTF_VARCHAR2_TABLE_100();
91: a4 := JTF_VARCHAR2_TABLE_100();
92: a5 := JTF_VARCHAR2_TABLE_100();
93: a6 := JTF_VARCHAR2_TABLE_300();
94: a7 := JTF_VARCHAR2_TABLE_2000();
95: a8 := JTF_DATE_TABLE();
96: a9 := JTF_DATE_TABLE();
97: a10 := JTF_DATE_TABLE();

Line 185: , a2 JTF_VARCHAR2_TABLE_300

181: end rosetta_table_copy_out_p21;
182:
183: procedure rosetta_table_copy_in_p23(t out nocopy oks_entitlements_web.party_sites_tbl_type, a0 JTF_NUMBER_TABLE
184: , a1 JTF_VARCHAR2_TABLE_100
185: , a2 JTF_VARCHAR2_TABLE_300
186: , a3 JTF_VARCHAR2_TABLE_300
187: ) as
188: ddindx binary_integer; indx binary_integer;
189: begin

Line 186: , a3 JTF_VARCHAR2_TABLE_300

182:
183: procedure rosetta_table_copy_in_p23(t out nocopy oks_entitlements_web.party_sites_tbl_type, a0 JTF_NUMBER_TABLE
184: , a1 JTF_VARCHAR2_TABLE_100
185: , a2 JTF_VARCHAR2_TABLE_300
186: , a3 JTF_VARCHAR2_TABLE_300
187: ) as
188: ddindx binary_integer; indx binary_integer;
189: begin
190: if a0 is not null and a0.count > 0 then

Line 210: , a2 out nocopy JTF_VARCHAR2_TABLE_300

206: end if;
207: end rosetta_table_copy_in_p23;
208: procedure rosetta_table_copy_out_p23(t oks_entitlements_web.party_sites_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
209: , a1 out nocopy JTF_VARCHAR2_TABLE_100
210: , a2 out nocopy JTF_VARCHAR2_TABLE_300
211: , a3 out nocopy JTF_VARCHAR2_TABLE_300
212: ) as
213: ddindx binary_integer; indx binary_integer;
214: begin

Line 211: , a3 out nocopy JTF_VARCHAR2_TABLE_300

207: end rosetta_table_copy_in_p23;
208: procedure rosetta_table_copy_out_p23(t oks_entitlements_web.party_sites_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
209: , a1 out nocopy JTF_VARCHAR2_TABLE_100
210: , a2 out nocopy JTF_VARCHAR2_TABLE_300
211: , a3 out nocopy JTF_VARCHAR2_TABLE_300
212: ) as
213: ddindx binary_integer; indx binary_integer;
214: begin
215: if t is null or t.count = 0 then

Line 218: a2 := JTF_VARCHAR2_TABLE_300();

214: begin
215: if t is null or t.count = 0 then
216: a0 := JTF_NUMBER_TABLE();
217: a1 := JTF_VARCHAR2_TABLE_100();
218: a2 := JTF_VARCHAR2_TABLE_300();
219: a3 := JTF_VARCHAR2_TABLE_300();
220: else
221: a0 := JTF_NUMBER_TABLE();
222: a1 := JTF_VARCHAR2_TABLE_100();

Line 219: a3 := JTF_VARCHAR2_TABLE_300();

215: if t is null or t.count = 0 then
216: a0 := JTF_NUMBER_TABLE();
217: a1 := JTF_VARCHAR2_TABLE_100();
218: a2 := JTF_VARCHAR2_TABLE_300();
219: a3 := JTF_VARCHAR2_TABLE_300();
220: else
221: a0 := JTF_NUMBER_TABLE();
222: a1 := JTF_VARCHAR2_TABLE_100();
223: a2 := JTF_VARCHAR2_TABLE_300();

Line 223: a2 := JTF_VARCHAR2_TABLE_300();

219: a3 := JTF_VARCHAR2_TABLE_300();
220: else
221: a0 := JTF_NUMBER_TABLE();
222: a1 := JTF_VARCHAR2_TABLE_100();
223: a2 := JTF_VARCHAR2_TABLE_300();
224: a3 := JTF_VARCHAR2_TABLE_300();
225: if t.count > 0 then
226: a0.extend(t.count);
227: a1.extend(t.count);

Line 224: a3 := JTF_VARCHAR2_TABLE_300();

220: else
221: a0 := JTF_NUMBER_TABLE();
222: a1 := JTF_VARCHAR2_TABLE_100();
223: a2 := JTF_VARCHAR2_TABLE_300();
224: a3 := JTF_VARCHAR2_TABLE_300();
225: if t.count > 0 then
226: a0.extend(t.count);
227: a1.extend(t.count);
228: a2.extend(t.count);

Line 249: , a2 JTF_VARCHAR2_TABLE_300

245: end rosetta_table_copy_out_p23;
246:
247: procedure rosetta_table_copy_in_p25(t out nocopy oks_entitlements_web.party_items_tbl_type, a0 JTF_NUMBER_TABLE
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_VARCHAR2_TABLE_300
250: , a3 JTF_VARCHAR2_TABLE_300
251: ) as
252: ddindx binary_integer; indx binary_integer;
253: begin

Line 250: , a3 JTF_VARCHAR2_TABLE_300

246:
247: procedure rosetta_table_copy_in_p25(t out nocopy oks_entitlements_web.party_items_tbl_type, a0 JTF_NUMBER_TABLE
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_VARCHAR2_TABLE_300
250: , a3 JTF_VARCHAR2_TABLE_300
251: ) as
252: ddindx binary_integer; indx binary_integer;
253: begin
254: if a0 is not null and a0.count > 0 then

Line 274: , a2 out nocopy JTF_VARCHAR2_TABLE_300

270: end if;
271: end rosetta_table_copy_in_p25;
272: procedure rosetta_table_copy_out_p25(t oks_entitlements_web.party_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
273: , a1 out nocopy JTF_NUMBER_TABLE
274: , a2 out nocopy JTF_VARCHAR2_TABLE_300
275: , a3 out nocopy JTF_VARCHAR2_TABLE_300
276: ) as
277: ddindx binary_integer; indx binary_integer;
278: begin

Line 275: , a3 out nocopy JTF_VARCHAR2_TABLE_300

271: end rosetta_table_copy_in_p25;
272: procedure rosetta_table_copy_out_p25(t oks_entitlements_web.party_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
273: , a1 out nocopy JTF_NUMBER_TABLE
274: , a2 out nocopy JTF_VARCHAR2_TABLE_300
275: , a3 out nocopy JTF_VARCHAR2_TABLE_300
276: ) as
277: ddindx binary_integer; indx binary_integer;
278: begin
279: if t is null or t.count = 0 then

Line 282: a2 := JTF_VARCHAR2_TABLE_300();

278: begin
279: if t is null or t.count = 0 then
280: a0 := JTF_NUMBER_TABLE();
281: a1 := JTF_NUMBER_TABLE();
282: a2 := JTF_VARCHAR2_TABLE_300();
283: a3 := JTF_VARCHAR2_TABLE_300();
284: else
285: a0 := JTF_NUMBER_TABLE();
286: a1 := JTF_NUMBER_TABLE();

Line 283: a3 := JTF_VARCHAR2_TABLE_300();

279: if t is null or t.count = 0 then
280: a0 := JTF_NUMBER_TABLE();
281: a1 := JTF_NUMBER_TABLE();
282: a2 := JTF_VARCHAR2_TABLE_300();
283: a3 := JTF_VARCHAR2_TABLE_300();
284: else
285: a0 := JTF_NUMBER_TABLE();
286: a1 := JTF_NUMBER_TABLE();
287: a2 := JTF_VARCHAR2_TABLE_300();

Line 287: a2 := JTF_VARCHAR2_TABLE_300();

283: a3 := JTF_VARCHAR2_TABLE_300();
284: else
285: a0 := JTF_NUMBER_TABLE();
286: a1 := JTF_NUMBER_TABLE();
287: a2 := JTF_VARCHAR2_TABLE_300();
288: a3 := JTF_VARCHAR2_TABLE_300();
289: if t.count > 0 then
290: a0.extend(t.count);
291: a1.extend(t.count);

Line 288: a3 := JTF_VARCHAR2_TABLE_300();

284: else
285: a0 := JTF_NUMBER_TABLE();
286: a1 := JTF_NUMBER_TABLE();
287: a2 := JTF_VARCHAR2_TABLE_300();
288: a3 := JTF_VARCHAR2_TABLE_300();
289: if t.count > 0 then
290: a0.extend(t.count);
291: a1.extend(t.count);
292: a2.extend(t.count);

Line 313: , a2 JTF_VARCHAR2_TABLE_300

309: end rosetta_table_copy_out_p25;
310:
311: procedure rosetta_table_copy_in_p27(t out nocopy oks_entitlements_web.party_systems_tbl_type, a0 JTF_NUMBER_TABLE
312: , a1 JTF_VARCHAR2_TABLE_100
313: , a2 JTF_VARCHAR2_TABLE_300
314: , a3 JTF_VARCHAR2_TABLE_300
315: ) as
316: ddindx binary_integer; indx binary_integer;
317: begin

Line 314: , a3 JTF_VARCHAR2_TABLE_300

310:
311: procedure rosetta_table_copy_in_p27(t out nocopy oks_entitlements_web.party_systems_tbl_type, a0 JTF_NUMBER_TABLE
312: , a1 JTF_VARCHAR2_TABLE_100
313: , a2 JTF_VARCHAR2_TABLE_300
314: , a3 JTF_VARCHAR2_TABLE_300
315: ) as
316: ddindx binary_integer; indx binary_integer;
317: begin
318: if a0 is not null and a0.count > 0 then

Line 338: , a2 out nocopy JTF_VARCHAR2_TABLE_300

334: end if;
335: end rosetta_table_copy_in_p27;
336: procedure rosetta_table_copy_out_p27(t oks_entitlements_web.party_systems_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
337: , a1 out nocopy JTF_VARCHAR2_TABLE_100
338: , a2 out nocopy JTF_VARCHAR2_TABLE_300
339: , a3 out nocopy JTF_VARCHAR2_TABLE_300
340: ) as
341: ddindx binary_integer; indx binary_integer;
342: begin

Line 339: , a3 out nocopy JTF_VARCHAR2_TABLE_300

335: end rosetta_table_copy_in_p27;
336: procedure rosetta_table_copy_out_p27(t oks_entitlements_web.party_systems_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
337: , a1 out nocopy JTF_VARCHAR2_TABLE_100
338: , a2 out nocopy JTF_VARCHAR2_TABLE_300
339: , a3 out nocopy JTF_VARCHAR2_TABLE_300
340: ) as
341: ddindx binary_integer; indx binary_integer;
342: begin
343: if t is null or t.count = 0 then

Line 346: a2 := JTF_VARCHAR2_TABLE_300();

342: begin
343: if t is null or t.count = 0 then
344: a0 := JTF_NUMBER_TABLE();
345: a1 := JTF_VARCHAR2_TABLE_100();
346: a2 := JTF_VARCHAR2_TABLE_300();
347: a3 := JTF_VARCHAR2_TABLE_300();
348: else
349: a0 := JTF_NUMBER_TABLE();
350: a1 := JTF_VARCHAR2_TABLE_100();

Line 347: a3 := JTF_VARCHAR2_TABLE_300();

343: if t is null or t.count = 0 then
344: a0 := JTF_NUMBER_TABLE();
345: a1 := JTF_VARCHAR2_TABLE_100();
346: a2 := JTF_VARCHAR2_TABLE_300();
347: a3 := JTF_VARCHAR2_TABLE_300();
348: else
349: a0 := JTF_NUMBER_TABLE();
350: a1 := JTF_VARCHAR2_TABLE_100();
351: a2 := JTF_VARCHAR2_TABLE_300();

Line 351: a2 := JTF_VARCHAR2_TABLE_300();

347: a3 := JTF_VARCHAR2_TABLE_300();
348: else
349: a0 := JTF_NUMBER_TABLE();
350: a1 := JTF_VARCHAR2_TABLE_100();
351: a2 := JTF_VARCHAR2_TABLE_300();
352: a3 := JTF_VARCHAR2_TABLE_300();
353: if t.count > 0 then
354: a0.extend(t.count);
355: a1.extend(t.count);

Line 352: a3 := JTF_VARCHAR2_TABLE_300();

348: else
349: a0 := JTF_NUMBER_TABLE();
350: a1 := JTF_VARCHAR2_TABLE_100();
351: a2 := JTF_VARCHAR2_TABLE_300();
352: a3 := JTF_VARCHAR2_TABLE_300();
353: if t.count > 0 then
354: a0.extend(t.count);
355: a1.extend(t.count);
356: a2.extend(t.count);

Line 377: , a2 JTF_VARCHAR2_TABLE_300

373: end rosetta_table_copy_out_p27;
374:
375: procedure rosetta_table_copy_in_p29(t out nocopy oks_entitlements_web.party_products_tbl_type, a0 JTF_NUMBER_TABLE
376: , a1 JTF_VARCHAR2_TABLE_100
377: , a2 JTF_VARCHAR2_TABLE_300
378: , a3 JTF_VARCHAR2_TABLE_300
379: ) as
380: ddindx binary_integer; indx binary_integer;
381: begin

Line 378: , a3 JTF_VARCHAR2_TABLE_300

374:
375: procedure rosetta_table_copy_in_p29(t out nocopy oks_entitlements_web.party_products_tbl_type, a0 JTF_NUMBER_TABLE
376: , a1 JTF_VARCHAR2_TABLE_100
377: , a2 JTF_VARCHAR2_TABLE_300
378: , a3 JTF_VARCHAR2_TABLE_300
379: ) as
380: ddindx binary_integer; indx binary_integer;
381: begin
382: if a0 is not null and a0.count > 0 then

Line 402: , a2 out nocopy JTF_VARCHAR2_TABLE_300

398: end if;
399: end rosetta_table_copy_in_p29;
400: procedure rosetta_table_copy_out_p29(t oks_entitlements_web.party_products_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
401: , a1 out nocopy JTF_VARCHAR2_TABLE_100
402: , a2 out nocopy JTF_VARCHAR2_TABLE_300
403: , a3 out nocopy JTF_VARCHAR2_TABLE_300
404: ) as
405: ddindx binary_integer; indx binary_integer;
406: begin

Line 403: , a3 out nocopy JTF_VARCHAR2_TABLE_300

399: end rosetta_table_copy_in_p29;
400: procedure rosetta_table_copy_out_p29(t oks_entitlements_web.party_products_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
401: , a1 out nocopy JTF_VARCHAR2_TABLE_100
402: , a2 out nocopy JTF_VARCHAR2_TABLE_300
403: , a3 out nocopy JTF_VARCHAR2_TABLE_300
404: ) as
405: ddindx binary_integer; indx binary_integer;
406: begin
407: if t is null or t.count = 0 then

Line 410: a2 := JTF_VARCHAR2_TABLE_300();

406: begin
407: if t is null or t.count = 0 then
408: a0 := JTF_NUMBER_TABLE();
409: a1 := JTF_VARCHAR2_TABLE_100();
410: a2 := JTF_VARCHAR2_TABLE_300();
411: a3 := JTF_VARCHAR2_TABLE_300();
412: else
413: a0 := JTF_NUMBER_TABLE();
414: a1 := JTF_VARCHAR2_TABLE_100();

Line 411: a3 := JTF_VARCHAR2_TABLE_300();

407: if t is null or t.count = 0 then
408: a0 := JTF_NUMBER_TABLE();
409: a1 := JTF_VARCHAR2_TABLE_100();
410: a2 := JTF_VARCHAR2_TABLE_300();
411: a3 := JTF_VARCHAR2_TABLE_300();
412: else
413: a0 := JTF_NUMBER_TABLE();
414: a1 := JTF_VARCHAR2_TABLE_100();
415: a2 := JTF_VARCHAR2_TABLE_300();

Line 415: a2 := JTF_VARCHAR2_TABLE_300();

411: a3 := JTF_VARCHAR2_TABLE_300();
412: else
413: a0 := JTF_NUMBER_TABLE();
414: a1 := JTF_VARCHAR2_TABLE_100();
415: a2 := JTF_VARCHAR2_TABLE_300();
416: a3 := JTF_VARCHAR2_TABLE_300();
417: if t.count > 0 then
418: a0.extend(t.count);
419: a1.extend(t.count);

Line 416: a3 := JTF_VARCHAR2_TABLE_300();

412: else
413: a0 := JTF_NUMBER_TABLE();
414: a1 := JTF_VARCHAR2_TABLE_100();
415: a2 := JTF_VARCHAR2_TABLE_300();
416: a3 := JTF_VARCHAR2_TABLE_300();
417: if t.count > 0 then
418: a0.extend(t.count);
419: a1.extend(t.count);
420: a2.extend(t.count);

Line 631: , a7 JTF_VARCHAR2_TABLE_300

627: , a3 JTF_DATE_TABLE
628: , a4 JTF_VARCHAR2_TABLE_100
629: , a5 JTF_VARCHAR2_TABLE_100
630: , a6 JTF_VARCHAR2_TABLE_200
631: , a7 JTF_VARCHAR2_TABLE_300
632: , a8 JTF_VARCHAR2_TABLE_500
633: , a9 JTF_VARCHAR2_TABLE_500
634: , a10 JTF_VARCHAR2_TABLE_2000
635: , a11 JTF_VARCHAR2_TABLE_400

Line 642: , a18 JTF_VARCHAR2_TABLE_300

638: , a14 JTF_NUMBER_TABLE
639: , a15 JTF_VARCHAR2_TABLE_200
640: , a16 JTF_VARCHAR2_TABLE_100
641: , a17 JTF_VARCHAR2_TABLE_400
642: , a18 JTF_VARCHAR2_TABLE_300
643: , a19 JTF_VARCHAR2_TABLE_100
644: , a20 JTF_VARCHAR2_TABLE_100
645: , a21 JTF_VARCHAR2_TABLE_400
646: , a22 JTF_VARCHAR2_TABLE_300

Line 646: , a22 JTF_VARCHAR2_TABLE_300

642: , a18 JTF_VARCHAR2_TABLE_300
643: , a19 JTF_VARCHAR2_TABLE_100
644: , a20 JTF_VARCHAR2_TABLE_100
645: , a21 JTF_VARCHAR2_TABLE_400
646: , a22 JTF_VARCHAR2_TABLE_300
647: , a23 JTF_VARCHAR2_TABLE_100
648: ) as
649: ddindx binary_integer; indx binary_integer;
650: begin

Line 696: , a7 out nocopy JTF_VARCHAR2_TABLE_300

692: , a3 out nocopy JTF_DATE_TABLE
693: , a4 out nocopy JTF_VARCHAR2_TABLE_100
694: , a5 out nocopy JTF_VARCHAR2_TABLE_100
695: , a6 out nocopy JTF_VARCHAR2_TABLE_200
696: , a7 out nocopy JTF_VARCHAR2_TABLE_300
697: , a8 out nocopy JTF_VARCHAR2_TABLE_500
698: , a9 out nocopy JTF_VARCHAR2_TABLE_500
699: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
700: , a11 out nocopy JTF_VARCHAR2_TABLE_400

Line 707: , a18 out nocopy JTF_VARCHAR2_TABLE_300

703: , a14 out nocopy JTF_NUMBER_TABLE
704: , a15 out nocopy JTF_VARCHAR2_TABLE_200
705: , a16 out nocopy JTF_VARCHAR2_TABLE_100
706: , a17 out nocopy JTF_VARCHAR2_TABLE_400
707: , a18 out nocopy JTF_VARCHAR2_TABLE_300
708: , a19 out nocopy JTF_VARCHAR2_TABLE_100
709: , a20 out nocopy JTF_VARCHAR2_TABLE_100
710: , a21 out nocopy JTF_VARCHAR2_TABLE_400
711: , a22 out nocopy JTF_VARCHAR2_TABLE_300

Line 711: , a22 out nocopy JTF_VARCHAR2_TABLE_300

707: , a18 out nocopy JTF_VARCHAR2_TABLE_300
708: , a19 out nocopy JTF_VARCHAR2_TABLE_100
709: , a20 out nocopy JTF_VARCHAR2_TABLE_100
710: , a21 out nocopy JTF_VARCHAR2_TABLE_400
711: , a22 out nocopy JTF_VARCHAR2_TABLE_300
712: , a23 out nocopy JTF_VARCHAR2_TABLE_100
713: ) as
714: ddindx binary_integer; indx binary_integer;
715: begin

Line 724: a7 := JTF_VARCHAR2_TABLE_300();

720: a3 := JTF_DATE_TABLE();
721: a4 := JTF_VARCHAR2_TABLE_100();
722: a5 := JTF_VARCHAR2_TABLE_100();
723: a6 := JTF_VARCHAR2_TABLE_200();
724: a7 := JTF_VARCHAR2_TABLE_300();
725: a8 := JTF_VARCHAR2_TABLE_500();
726: a9 := JTF_VARCHAR2_TABLE_500();
727: a10 := JTF_VARCHAR2_TABLE_2000();
728: a11 := JTF_VARCHAR2_TABLE_400();

Line 735: a18 := JTF_VARCHAR2_TABLE_300();

731: a14 := JTF_NUMBER_TABLE();
732: a15 := JTF_VARCHAR2_TABLE_200();
733: a16 := JTF_VARCHAR2_TABLE_100();
734: a17 := JTF_VARCHAR2_TABLE_400();
735: a18 := JTF_VARCHAR2_TABLE_300();
736: a19 := JTF_VARCHAR2_TABLE_100();
737: a20 := JTF_VARCHAR2_TABLE_100();
738: a21 := JTF_VARCHAR2_TABLE_400();
739: a22 := JTF_VARCHAR2_TABLE_300();

Line 739: a22 := JTF_VARCHAR2_TABLE_300();

735: a18 := JTF_VARCHAR2_TABLE_300();
736: a19 := JTF_VARCHAR2_TABLE_100();
737: a20 := JTF_VARCHAR2_TABLE_100();
738: a21 := JTF_VARCHAR2_TABLE_400();
739: a22 := JTF_VARCHAR2_TABLE_300();
740: a23 := JTF_VARCHAR2_TABLE_100();
741: else
742: a0 := JTF_NUMBER_TABLE();
743: a1 := JTF_NUMBER_TABLE();

Line 749: a7 := JTF_VARCHAR2_TABLE_300();

745: a3 := JTF_DATE_TABLE();
746: a4 := JTF_VARCHAR2_TABLE_100();
747: a5 := JTF_VARCHAR2_TABLE_100();
748: a6 := JTF_VARCHAR2_TABLE_200();
749: a7 := JTF_VARCHAR2_TABLE_300();
750: a8 := JTF_VARCHAR2_TABLE_500();
751: a9 := JTF_VARCHAR2_TABLE_500();
752: a10 := JTF_VARCHAR2_TABLE_2000();
753: a11 := JTF_VARCHAR2_TABLE_400();

Line 760: a18 := JTF_VARCHAR2_TABLE_300();

756: a14 := JTF_NUMBER_TABLE();
757: a15 := JTF_VARCHAR2_TABLE_200();
758: a16 := JTF_VARCHAR2_TABLE_100();
759: a17 := JTF_VARCHAR2_TABLE_400();
760: a18 := JTF_VARCHAR2_TABLE_300();
761: a19 := JTF_VARCHAR2_TABLE_100();
762: a20 := JTF_VARCHAR2_TABLE_100();
763: a21 := JTF_VARCHAR2_TABLE_400();
764: a22 := JTF_VARCHAR2_TABLE_300();

Line 764: a22 := JTF_VARCHAR2_TABLE_300();

760: a18 := JTF_VARCHAR2_TABLE_300();
761: a19 := JTF_VARCHAR2_TABLE_100();
762: a20 := JTF_VARCHAR2_TABLE_100();
763: a21 := JTF_VARCHAR2_TABLE_400();
764: a22 := JTF_VARCHAR2_TABLE_300();
765: a23 := JTF_VARCHAR2_TABLE_100();
766: if t.count > 0 then
767: a0.extend(t.count);
768: a1.extend(t.count);

Line 1922: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300

1918: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
1919: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
1920: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
1921: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
1922: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
1923: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1924: , p5_a8 out nocopy JTF_DATE_TABLE
1925: , p5_a9 out nocopy JTF_DATE_TABLE
1926: , p5_a10 out nocopy JTF_DATE_TABLE

Line 2004: , p25_a6 out nocopy JTF_VARCHAR2_TABLE_300

2000: , p25_a2 out nocopy JTF_VARCHAR2_TABLE_100
2001: , p25_a3 out nocopy JTF_VARCHAR2_TABLE_100
2002: , p25_a4 out nocopy JTF_VARCHAR2_TABLE_100
2003: , p25_a5 out nocopy JTF_VARCHAR2_TABLE_100
2004: , p25_a6 out nocopy JTF_VARCHAR2_TABLE_300
2005: , p25_a7 out nocopy JTF_VARCHAR2_TABLE_2000
2006: , p25_a8 out nocopy JTF_DATE_TABLE
2007: , p25_a9 out nocopy JTF_DATE_TABLE
2008: , p25_a10 out nocopy JTF_DATE_TABLE

Line 2135: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300

2131: , p_site_name_arg VARCHAR2
2132: , x_return_status out nocopy VARCHAR2
2133: , p3_a0 out nocopy JTF_NUMBER_TABLE
2134: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
2135: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
2136: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_300
2137: )
2138:
2139: as

Line 2136: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_300

2132: , x_return_status out nocopy VARCHAR2
2133: , p3_a0 out nocopy JTF_NUMBER_TABLE
2134: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
2135: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
2136: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_300
2137: )
2138:
2139: as
2140: ddx_party_sites_tbl_type oks_entitlements_web.party_sites_tbl_type;

Line 2223: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300

2219: , p_item_name_arg VARCHAR2
2220: , x_return_status out nocopy VARCHAR2
2221: , p3_a0 out nocopy JTF_NUMBER_TABLE
2222: , p3_a1 out nocopy JTF_NUMBER_TABLE
2223: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
2224: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_300
2225: )
2226:
2227: as

Line 2224: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_300

2220: , x_return_status out nocopy VARCHAR2
2221: , p3_a0 out nocopy JTF_NUMBER_TABLE
2222: , p3_a1 out nocopy JTF_NUMBER_TABLE
2223: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
2224: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_300
2225: )
2226:
2227: as
2228: ddx_party_items_tbl_type oks_entitlements_web.party_items_tbl_type;

Line 2260: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_300

2256: , p_system_name_arg VARCHAR2
2257: , x_return_status out nocopy VARCHAR2
2258: , p4_a0 out nocopy JTF_NUMBER_TABLE
2259: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2260: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_300
2261: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
2262: )
2263:
2264: as

Line 2261: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300

2257: , x_return_status out nocopy VARCHAR2
2258: , p4_a0 out nocopy JTF_NUMBER_TABLE
2259: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2260: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_300
2261: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
2262: )
2263:
2264: as
2265: ddp_account_id_all oks_entitlements_web.account_all_id_tbl_type;

Line 2303: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_300

2299: , p_product_name_arg VARCHAR2
2300: , x_return_status out nocopy VARCHAR2
2301: , p4_a0 out nocopy JTF_NUMBER_TABLE
2302: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2303: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_300
2304: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
2305: )
2306:
2307: as

Line 2304: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300

2300: , x_return_status out nocopy VARCHAR2
2301: , p4_a0 out nocopy JTF_NUMBER_TABLE
2302: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
2303: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_300
2304: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
2305: )
2306:
2307: as
2308: ddp_account_id_all oks_entitlements_web.account_all_id_tbl_type;

Line 2426: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300

2422: , p6_a3 out nocopy JTF_DATE_TABLE
2423: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
2424: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
2425: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_200
2426: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
2427: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
2428: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
2429: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
2430: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_400

Line 2437: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300

2433: , p6_a14 out nocopy JTF_NUMBER_TABLE
2434: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200
2435: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
2436: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_400
2437: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
2438: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
2439: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2440: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_400
2441: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300

Line 2441: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300

2437: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
2438: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
2439: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
2440: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_400
2441: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
2442: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
2443: )
2444:
2445: as

Line 2584: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_300

2580: , p5_a3 out nocopy JTF_DATE_TABLE
2581: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
2582: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
2583: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_200
2584: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_300
2585: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_500
2586: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_500
2587: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_2000
2588: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_400

Line 2595: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_300

2591: , p5_a14 out nocopy JTF_NUMBER_TABLE
2592: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_200
2593: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100
2594: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_400
2595: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_300
2596: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
2597: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
2598: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_400
2599: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_300

Line 2599: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_300

2595: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_300
2596: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
2597: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
2598: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_400
2599: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_300
2600: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
2601: )
2602:
2603: as