DBA Data[Home] [Help]

APPS.OKL_SEC_INVESTOR_REVENUE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_VARCHAR2_TABLE_100

20: end;
21:
22: procedure rosetta_table_copy_in_p20(t out nocopy okl_sec_investor_revenue_pvt.szr_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE

Line 32: , a10 JTF_VARCHAR2_TABLE_100

28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: ) as
35: ddindx binary_integer; indx binary_integer;
36: begin

Line 33: , a11 JTF_VARCHAR2_TABLE_100

29: , a7 JTF_DATE_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: ) as
35: ddindx binary_integer; indx binary_integer;
36: begin
37: if a0 is not null and a0.count > 0 then

Line 65: , a2 out nocopy JTF_VARCHAR2_TABLE_100

61: end if;
62: end rosetta_table_copy_in_p20;
63: procedure rosetta_table_copy_out_p20(t okl_sec_investor_revenue_pvt.szr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_NUMBER_TABLE
65: , a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , a3 out nocopy JTF_NUMBER_TABLE
67: , a4 out nocopy JTF_NUMBER_TABLE
68: , a5 out nocopy JTF_NUMBER_TABLE
69: , a6 out nocopy JTF_NUMBER_TABLE

Line 73: , a10 out nocopy JTF_VARCHAR2_TABLE_100

69: , a6 out nocopy JTF_NUMBER_TABLE
70: , a7 out nocopy JTF_DATE_TABLE
71: , a8 out nocopy JTF_DATE_TABLE
72: , a9 out nocopy JTF_DATE_TABLE
73: , a10 out nocopy JTF_VARCHAR2_TABLE_100
74: , a11 out nocopy JTF_VARCHAR2_TABLE_100
75: ) as
76: ddindx binary_integer; indx binary_integer;
77: begin

Line 74: , a11 out nocopy JTF_VARCHAR2_TABLE_100

70: , a7 out nocopy JTF_DATE_TABLE
71: , a8 out nocopy JTF_DATE_TABLE
72: , a9 out nocopy JTF_DATE_TABLE
73: , a10 out nocopy JTF_VARCHAR2_TABLE_100
74: , a11 out nocopy JTF_VARCHAR2_TABLE_100
75: ) as
76: ddindx binary_integer; indx binary_integer;
77: begin
78: if t is null or t.count = 0 then

Line 81: a2 := JTF_VARCHAR2_TABLE_100();

77: begin
78: if t is null or t.count = 0 then
79: a0 := JTF_NUMBER_TABLE();
80: a1 := JTF_NUMBER_TABLE();
81: a2 := JTF_VARCHAR2_TABLE_100();
82: a3 := JTF_NUMBER_TABLE();
83: a4 := JTF_NUMBER_TABLE();
84: a5 := JTF_NUMBER_TABLE();
85: a6 := JTF_NUMBER_TABLE();

Line 89: a10 := JTF_VARCHAR2_TABLE_100();

85: a6 := JTF_NUMBER_TABLE();
86: a7 := JTF_DATE_TABLE();
87: a8 := JTF_DATE_TABLE();
88: a9 := JTF_DATE_TABLE();
89: a10 := JTF_VARCHAR2_TABLE_100();
90: a11 := JTF_VARCHAR2_TABLE_100();
91: else
92: a0 := JTF_NUMBER_TABLE();
93: a1 := JTF_NUMBER_TABLE();

Line 90: a11 := JTF_VARCHAR2_TABLE_100();

86: a7 := JTF_DATE_TABLE();
87: a8 := JTF_DATE_TABLE();
88: a9 := JTF_DATE_TABLE();
89: a10 := JTF_VARCHAR2_TABLE_100();
90: a11 := JTF_VARCHAR2_TABLE_100();
91: else
92: a0 := JTF_NUMBER_TABLE();
93: a1 := JTF_NUMBER_TABLE();
94: a2 := JTF_VARCHAR2_TABLE_100();

Line 94: a2 := JTF_VARCHAR2_TABLE_100();

90: a11 := JTF_VARCHAR2_TABLE_100();
91: else
92: a0 := JTF_NUMBER_TABLE();
93: a1 := JTF_NUMBER_TABLE();
94: a2 := JTF_VARCHAR2_TABLE_100();
95: a3 := JTF_NUMBER_TABLE();
96: a4 := JTF_NUMBER_TABLE();
97: a5 := JTF_NUMBER_TABLE();
98: a6 := JTF_NUMBER_TABLE();

Line 102: a10 := JTF_VARCHAR2_TABLE_100();

98: a6 := JTF_NUMBER_TABLE();
99: a7 := JTF_DATE_TABLE();
100: a8 := JTF_DATE_TABLE();
101: a9 := JTF_DATE_TABLE();
102: a10 := JTF_VARCHAR2_TABLE_100();
103: a11 := JTF_VARCHAR2_TABLE_100();
104: if t.count > 0 then
105: a0.extend(t.count);
106: a1.extend(t.count);

Line 103: a11 := JTF_VARCHAR2_TABLE_100();

99: a7 := JTF_DATE_TABLE();
100: a8 := JTF_DATE_TABLE();
101: a9 := JTF_DATE_TABLE();
102: a10 := JTF_VARCHAR2_TABLE_100();
103: a11 := JTF_VARCHAR2_TABLE_100();
104: if t.count > 0 then
105: a0.extend(t.count);
106: a1.extend(t.count);
107: a2.extend(t.count);

Line 382: , p5_a2 JTF_VARCHAR2_TABLE_100

378: , x_msg_count out nocopy NUMBER
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_VARCHAR2_TABLE_100
383: , p5_a3 JTF_NUMBER_TABLE
384: , p5_a4 JTF_NUMBER_TABLE
385: , p5_a5 JTF_NUMBER_TABLE
386: , p5_a6 JTF_NUMBER_TABLE

Line 390: , p5_a10 JTF_VARCHAR2_TABLE_100

386: , p5_a6 JTF_NUMBER_TABLE
387: , p5_a7 JTF_DATE_TABLE
388: , p5_a8 JTF_DATE_TABLE
389: , p5_a9 JTF_DATE_TABLE
390: , p5_a10 JTF_VARCHAR2_TABLE_100
391: , p5_a11 JTF_VARCHAR2_TABLE_100
392: , p6_a0 out nocopy JTF_NUMBER_TABLE
393: , p6_a1 out nocopy JTF_NUMBER_TABLE
394: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 391: , p5_a11 JTF_VARCHAR2_TABLE_100

387: , p5_a7 JTF_DATE_TABLE
388: , p5_a8 JTF_DATE_TABLE
389: , p5_a9 JTF_DATE_TABLE
390: , p5_a10 JTF_VARCHAR2_TABLE_100
391: , p5_a11 JTF_VARCHAR2_TABLE_100
392: , p6_a0 out nocopy JTF_NUMBER_TABLE
393: , p6_a1 out nocopy JTF_NUMBER_TABLE
394: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
395: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 394: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

390: , p5_a10 JTF_VARCHAR2_TABLE_100
391: , p5_a11 JTF_VARCHAR2_TABLE_100
392: , p6_a0 out nocopy JTF_NUMBER_TABLE
393: , p6_a1 out nocopy JTF_NUMBER_TABLE
394: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
395: , p6_a3 out nocopy JTF_NUMBER_TABLE
396: , p6_a4 out nocopy JTF_NUMBER_TABLE
397: , p6_a5 out nocopy JTF_NUMBER_TABLE
398: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 402: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

398: , p6_a6 out nocopy JTF_NUMBER_TABLE
399: , p6_a7 out nocopy JTF_DATE_TABLE
400: , p6_a8 out nocopy JTF_DATE_TABLE
401: , p6_a9 out nocopy JTF_DATE_TABLE
402: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
403: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
404: )
405:
406: as

Line 403: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

399: , p6_a7 out nocopy JTF_DATE_TABLE
400: , p6_a8 out nocopy JTF_DATE_TABLE
401: , p6_a9 out nocopy JTF_DATE_TABLE
402: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
403: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
404: )
405:
406: as
407: ddp_szr_tbl okl_sec_investor_revenue_pvt.szr_tbl_type;

Line 471: , p5_a2 JTF_VARCHAR2_TABLE_100

467: , x_msg_count out nocopy NUMBER
468: , x_msg_data out nocopy VARCHAR2
469: , p5_a0 JTF_NUMBER_TABLE
470: , p5_a1 JTF_NUMBER_TABLE
471: , p5_a2 JTF_VARCHAR2_TABLE_100
472: , p5_a3 JTF_NUMBER_TABLE
473: , p5_a4 JTF_NUMBER_TABLE
474: , p5_a5 JTF_NUMBER_TABLE
475: , p5_a6 JTF_NUMBER_TABLE

Line 479: , p5_a10 JTF_VARCHAR2_TABLE_100

475: , p5_a6 JTF_NUMBER_TABLE
476: , p5_a7 JTF_DATE_TABLE
477: , p5_a8 JTF_DATE_TABLE
478: , p5_a9 JTF_DATE_TABLE
479: , p5_a10 JTF_VARCHAR2_TABLE_100
480: , p5_a11 JTF_VARCHAR2_TABLE_100
481: , p6_a0 out nocopy JTF_NUMBER_TABLE
482: , p6_a1 out nocopy JTF_NUMBER_TABLE
483: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 480: , p5_a11 JTF_VARCHAR2_TABLE_100

476: , p5_a7 JTF_DATE_TABLE
477: , p5_a8 JTF_DATE_TABLE
478: , p5_a9 JTF_DATE_TABLE
479: , p5_a10 JTF_VARCHAR2_TABLE_100
480: , p5_a11 JTF_VARCHAR2_TABLE_100
481: , p6_a0 out nocopy JTF_NUMBER_TABLE
482: , p6_a1 out nocopy JTF_NUMBER_TABLE
483: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 483: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

479: , p5_a10 JTF_VARCHAR2_TABLE_100
480: , p5_a11 JTF_VARCHAR2_TABLE_100
481: , p6_a0 out nocopy JTF_NUMBER_TABLE
482: , p6_a1 out nocopy JTF_NUMBER_TABLE
483: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a3 out nocopy JTF_NUMBER_TABLE
485: , p6_a4 out nocopy JTF_NUMBER_TABLE
486: , p6_a5 out nocopy JTF_NUMBER_TABLE
487: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 491: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

487: , p6_a6 out nocopy JTF_NUMBER_TABLE
488: , p6_a7 out nocopy JTF_DATE_TABLE
489: , p6_a8 out nocopy JTF_DATE_TABLE
490: , p6_a9 out nocopy JTF_DATE_TABLE
491: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
492: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
493: )
494:
495: as

Line 492: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

488: , p6_a7 out nocopy JTF_DATE_TABLE
489: , p6_a8 out nocopy JTF_DATE_TABLE
490: , p6_a9 out nocopy JTF_DATE_TABLE
491: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
492: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
493: )
494:
495: as
496: ddp_szr_tbl okl_sec_investor_revenue_pvt.szr_tbl_type;

Line 560: , p5_a2 JTF_VARCHAR2_TABLE_100

556: , x_msg_count out nocopy NUMBER
557: , x_msg_data out nocopy VARCHAR2
558: , p5_a0 JTF_NUMBER_TABLE
559: , p5_a1 JTF_NUMBER_TABLE
560: , p5_a2 JTF_VARCHAR2_TABLE_100
561: , p5_a3 JTF_NUMBER_TABLE
562: , p5_a4 JTF_NUMBER_TABLE
563: , p5_a5 JTF_NUMBER_TABLE
564: , p5_a6 JTF_NUMBER_TABLE

Line 568: , p5_a10 JTF_VARCHAR2_TABLE_100

564: , p5_a6 JTF_NUMBER_TABLE
565: , p5_a7 JTF_DATE_TABLE
566: , p5_a8 JTF_DATE_TABLE
567: , p5_a9 JTF_DATE_TABLE
568: , p5_a10 JTF_VARCHAR2_TABLE_100
569: , p5_a11 JTF_VARCHAR2_TABLE_100
570: )
571:
572: as

Line 569: , p5_a11 JTF_VARCHAR2_TABLE_100

565: , p5_a7 JTF_DATE_TABLE
566: , p5_a8 JTF_DATE_TABLE
567: , p5_a9 JTF_DATE_TABLE
568: , p5_a10 JTF_VARCHAR2_TABLE_100
569: , p5_a11 JTF_VARCHAR2_TABLE_100
570: )
571:
572: as
573: ddp_szr_tbl okl_sec_investor_revenue_pvt.szr_tbl_type;