DBA Data[Home] [Help]

APPS.OZF_CLAIM_ACCRUAL_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 26: , a10 JTF_VARCHAR2_TABLE_100

22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_DATE_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_NUMBER_TABLE

Line 27: , a11 JTF_VARCHAR2_TABLE_100

23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_DATE_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_NUMBER_TABLE

Line 35: , a19 JTF_VARCHAR2_TABLE_100

31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_NUMBER_TABLE
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE

Line 41: , a25 JTF_VARCHAR2_TABLE_100

37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_VARCHAR2_TABLE_100
42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
45: if a0 is not null and a0.count > 0 then

Line 95: , a10 out nocopy JTF_VARCHAR2_TABLE_100

91: , a6 out nocopy JTF_NUMBER_TABLE
92: , a7 out nocopy JTF_NUMBER_TABLE
93: , a8 out nocopy JTF_NUMBER_TABLE
94: , a9 out nocopy JTF_NUMBER_TABLE
95: , a10 out nocopy JTF_VARCHAR2_TABLE_100
96: , a11 out nocopy JTF_VARCHAR2_TABLE_100
97: , a12 out nocopy JTF_DATE_TABLE
98: , a13 out nocopy JTF_NUMBER_TABLE
99: , a14 out nocopy JTF_NUMBER_TABLE

Line 96: , a11 out nocopy JTF_VARCHAR2_TABLE_100

92: , a7 out nocopy JTF_NUMBER_TABLE
93: , a8 out nocopy JTF_NUMBER_TABLE
94: , a9 out nocopy JTF_NUMBER_TABLE
95: , a10 out nocopy JTF_VARCHAR2_TABLE_100
96: , a11 out nocopy JTF_VARCHAR2_TABLE_100
97: , a12 out nocopy JTF_DATE_TABLE
98: , a13 out nocopy JTF_NUMBER_TABLE
99: , a14 out nocopy JTF_NUMBER_TABLE
100: , a15 out nocopy JTF_NUMBER_TABLE

Line 104: , a19 out nocopy JTF_VARCHAR2_TABLE_100

100: , a15 out nocopy JTF_NUMBER_TABLE
101: , a16 out nocopy JTF_NUMBER_TABLE
102: , a17 out nocopy JTF_NUMBER_TABLE
103: , a18 out nocopy JTF_NUMBER_TABLE
104: , a19 out nocopy JTF_VARCHAR2_TABLE_100
105: , a20 out nocopy JTF_NUMBER_TABLE
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_NUMBER_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE

Line 110: , a25 out nocopy JTF_VARCHAR2_TABLE_100

106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_NUMBER_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE
109: , a24 out nocopy JTF_NUMBER_TABLE
110: , a25 out nocopy JTF_VARCHAR2_TABLE_100
111: ) as
112: ddindx binary_integer; indx binary_integer;
113: begin
114: if t is null or t.count = 0 then

Line 125: a10 := JTF_VARCHAR2_TABLE_100();

121: a6 := JTF_NUMBER_TABLE();
122: a7 := JTF_NUMBER_TABLE();
123: a8 := JTF_NUMBER_TABLE();
124: a9 := JTF_NUMBER_TABLE();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_DATE_TABLE();
128: a13 := JTF_NUMBER_TABLE();
129: a14 := JTF_NUMBER_TABLE();

Line 126: a11 := JTF_VARCHAR2_TABLE_100();

122: a7 := JTF_NUMBER_TABLE();
123: a8 := JTF_NUMBER_TABLE();
124: a9 := JTF_NUMBER_TABLE();
125: a10 := JTF_VARCHAR2_TABLE_100();
126: a11 := JTF_VARCHAR2_TABLE_100();
127: a12 := JTF_DATE_TABLE();
128: a13 := JTF_NUMBER_TABLE();
129: a14 := JTF_NUMBER_TABLE();
130: a15 := JTF_NUMBER_TABLE();

Line 134: a19 := JTF_VARCHAR2_TABLE_100();

130: a15 := JTF_NUMBER_TABLE();
131: a16 := JTF_NUMBER_TABLE();
132: a17 := JTF_NUMBER_TABLE();
133: a18 := JTF_NUMBER_TABLE();
134: a19 := JTF_VARCHAR2_TABLE_100();
135: a20 := JTF_NUMBER_TABLE();
136: a21 := JTF_NUMBER_TABLE();
137: a22 := JTF_NUMBER_TABLE();
138: a23 := JTF_NUMBER_TABLE();

Line 140: a25 := JTF_VARCHAR2_TABLE_100();

136: a21 := JTF_NUMBER_TABLE();
137: a22 := JTF_NUMBER_TABLE();
138: a23 := JTF_NUMBER_TABLE();
139: a24 := JTF_NUMBER_TABLE();
140: a25 := JTF_VARCHAR2_TABLE_100();
141: else
142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_NUMBER_TABLE();
144: a2 := JTF_DATE_TABLE();

Line 152: a10 := JTF_VARCHAR2_TABLE_100();

148: a6 := JTF_NUMBER_TABLE();
149: a7 := JTF_NUMBER_TABLE();
150: a8 := JTF_NUMBER_TABLE();
151: a9 := JTF_NUMBER_TABLE();
152: a10 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_DATE_TABLE();
155: a13 := JTF_NUMBER_TABLE();
156: a14 := JTF_NUMBER_TABLE();

Line 153: a11 := JTF_VARCHAR2_TABLE_100();

149: a7 := JTF_NUMBER_TABLE();
150: a8 := JTF_NUMBER_TABLE();
151: a9 := JTF_NUMBER_TABLE();
152: a10 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_DATE_TABLE();
155: a13 := JTF_NUMBER_TABLE();
156: a14 := JTF_NUMBER_TABLE();
157: a15 := JTF_NUMBER_TABLE();

Line 161: a19 := JTF_VARCHAR2_TABLE_100();

157: a15 := JTF_NUMBER_TABLE();
158: a16 := JTF_NUMBER_TABLE();
159: a17 := JTF_NUMBER_TABLE();
160: a18 := JTF_NUMBER_TABLE();
161: a19 := JTF_VARCHAR2_TABLE_100();
162: a20 := JTF_NUMBER_TABLE();
163: a21 := JTF_NUMBER_TABLE();
164: a22 := JTF_NUMBER_TABLE();
165: a23 := JTF_NUMBER_TABLE();

Line 167: a25 := JTF_VARCHAR2_TABLE_100();

163: a21 := JTF_NUMBER_TABLE();
164: a22 := JTF_NUMBER_TABLE();
165: a23 := JTF_NUMBER_TABLE();
166: a24 := JTF_NUMBER_TABLE();
167: a25 := JTF_VARCHAR2_TABLE_100();
168: if t.count > 0 then
169: a0.extend(t.count);
170: a1.extend(t.count);
171: a2.extend(t.count);

Line 236: , a2 JTF_VARCHAR2_TABLE_100

232: end rosetta_table_copy_out_p1;
233:
234: procedure rosetta_table_copy_in_p5(t out nocopy ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 JTF_NUMBER_TABLE
235: , a1 JTF_NUMBER_TABLE
236: , a2 JTF_VARCHAR2_TABLE_100
237: , a3 JTF_VARCHAR2_TABLE_300
238: , a4 JTF_DATE_TABLE
239: , a5 JTF_DATE_TABLE
240: , a6 JTF_VARCHAR2_TABLE_100

Line 240: , a6 JTF_VARCHAR2_TABLE_100

236: , a2 JTF_VARCHAR2_TABLE_100
237: , a3 JTF_VARCHAR2_TABLE_300
238: , a4 JTF_DATE_TABLE
239: , a5 JTF_DATE_TABLE
240: , a6 JTF_VARCHAR2_TABLE_100
241: , a7 JTF_NUMBER_TABLE
242: , a8 JTF_VARCHAR2_TABLE_100
243: ) as
244: ddindx binary_integer; indx binary_integer;

Line 242: , a8 JTF_VARCHAR2_TABLE_100

238: , a4 JTF_DATE_TABLE
239: , a5 JTF_DATE_TABLE
240: , a6 JTF_VARCHAR2_TABLE_100
241: , a7 JTF_NUMBER_TABLE
242: , a8 JTF_VARCHAR2_TABLE_100
243: ) as
244: ddindx binary_integer; indx binary_integer;
245: begin
246: if a0 is not null and a0.count > 0 then

Line 271: , a2 out nocopy JTF_VARCHAR2_TABLE_100

267: end if;
268: end rosetta_table_copy_in_p5;
269: procedure rosetta_table_copy_out_p5(t ozf_claim_accrual_pvt.offer_performance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
270: , a1 out nocopy JTF_NUMBER_TABLE
271: , a2 out nocopy JTF_VARCHAR2_TABLE_100
272: , a3 out nocopy JTF_VARCHAR2_TABLE_300
273: , a4 out nocopy JTF_DATE_TABLE
274: , a5 out nocopy JTF_DATE_TABLE
275: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 275: , a6 out nocopy JTF_VARCHAR2_TABLE_100

271: , a2 out nocopy JTF_VARCHAR2_TABLE_100
272: , a3 out nocopy JTF_VARCHAR2_TABLE_300
273: , a4 out nocopy JTF_DATE_TABLE
274: , a5 out nocopy JTF_DATE_TABLE
275: , a6 out nocopy JTF_VARCHAR2_TABLE_100
276: , a7 out nocopy JTF_NUMBER_TABLE
277: , a8 out nocopy JTF_VARCHAR2_TABLE_100
278: ) as
279: ddindx binary_integer; indx binary_integer;

Line 277: , a8 out nocopy JTF_VARCHAR2_TABLE_100

273: , a4 out nocopy JTF_DATE_TABLE
274: , a5 out nocopy JTF_DATE_TABLE
275: , a6 out nocopy JTF_VARCHAR2_TABLE_100
276: , a7 out nocopy JTF_NUMBER_TABLE
277: , a8 out nocopy JTF_VARCHAR2_TABLE_100
278: ) as
279: ddindx binary_integer; indx binary_integer;
280: begin
281: if t is null or t.count = 0 then

Line 284: a2 := JTF_VARCHAR2_TABLE_100();

280: begin
281: if t is null or t.count = 0 then
282: a0 := JTF_NUMBER_TABLE();
283: a1 := JTF_NUMBER_TABLE();
284: a2 := JTF_VARCHAR2_TABLE_100();
285: a3 := JTF_VARCHAR2_TABLE_300();
286: a4 := JTF_DATE_TABLE();
287: a5 := JTF_DATE_TABLE();
288: a6 := JTF_VARCHAR2_TABLE_100();

Line 288: a6 := JTF_VARCHAR2_TABLE_100();

284: a2 := JTF_VARCHAR2_TABLE_100();
285: a3 := JTF_VARCHAR2_TABLE_300();
286: a4 := JTF_DATE_TABLE();
287: a5 := JTF_DATE_TABLE();
288: a6 := JTF_VARCHAR2_TABLE_100();
289: a7 := JTF_NUMBER_TABLE();
290: a8 := JTF_VARCHAR2_TABLE_100();
291: else
292: a0 := JTF_NUMBER_TABLE();

Line 290: a8 := JTF_VARCHAR2_TABLE_100();

286: a4 := JTF_DATE_TABLE();
287: a5 := JTF_DATE_TABLE();
288: a6 := JTF_VARCHAR2_TABLE_100();
289: a7 := JTF_NUMBER_TABLE();
290: a8 := JTF_VARCHAR2_TABLE_100();
291: else
292: a0 := JTF_NUMBER_TABLE();
293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_VARCHAR2_TABLE_100();

Line 294: a2 := JTF_VARCHAR2_TABLE_100();

290: a8 := JTF_VARCHAR2_TABLE_100();
291: else
292: a0 := JTF_NUMBER_TABLE();
293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_VARCHAR2_TABLE_100();
295: a3 := JTF_VARCHAR2_TABLE_300();
296: a4 := JTF_DATE_TABLE();
297: a5 := JTF_DATE_TABLE();
298: a6 := JTF_VARCHAR2_TABLE_100();

Line 298: a6 := JTF_VARCHAR2_TABLE_100();

294: a2 := JTF_VARCHAR2_TABLE_100();
295: a3 := JTF_VARCHAR2_TABLE_300();
296: a4 := JTF_DATE_TABLE();
297: a5 := JTF_DATE_TABLE();
298: a6 := JTF_VARCHAR2_TABLE_100();
299: a7 := JTF_NUMBER_TABLE();
300: a8 := JTF_VARCHAR2_TABLE_100();
301: if t.count > 0 then
302: a0.extend(t.count);

Line 300: a8 := JTF_VARCHAR2_TABLE_100();

296: a4 := JTF_DATE_TABLE();
297: a5 := JTF_DATE_TABLE();
298: a6 := JTF_VARCHAR2_TABLE_100();
299: a7 := JTF_NUMBER_TABLE();
300: a8 := JTF_VARCHAR2_TABLE_100();
301: if t.count > 0 then
302: a0.extend(t.count);
303: a1.extend(t.count);
304: a2.extend(t.count);

Line 568: , p7_a10 JTF_VARCHAR2_TABLE_100

564: , p7_a6 JTF_NUMBER_TABLE
565: , p7_a7 JTF_NUMBER_TABLE
566: , p7_a8 JTF_NUMBER_TABLE
567: , p7_a9 JTF_NUMBER_TABLE
568: , p7_a10 JTF_VARCHAR2_TABLE_100
569: , p7_a11 JTF_VARCHAR2_TABLE_100
570: , p7_a12 JTF_DATE_TABLE
571: , p7_a13 JTF_NUMBER_TABLE
572: , p7_a14 JTF_NUMBER_TABLE

Line 569: , p7_a11 JTF_VARCHAR2_TABLE_100

565: , p7_a7 JTF_NUMBER_TABLE
566: , p7_a8 JTF_NUMBER_TABLE
567: , p7_a9 JTF_NUMBER_TABLE
568: , p7_a10 JTF_VARCHAR2_TABLE_100
569: , p7_a11 JTF_VARCHAR2_TABLE_100
570: , p7_a12 JTF_DATE_TABLE
571: , p7_a13 JTF_NUMBER_TABLE
572: , p7_a14 JTF_NUMBER_TABLE
573: , p7_a15 JTF_NUMBER_TABLE

Line 577: , p7_a19 JTF_VARCHAR2_TABLE_100

573: , p7_a15 JTF_NUMBER_TABLE
574: , p7_a16 JTF_NUMBER_TABLE
575: , p7_a17 JTF_NUMBER_TABLE
576: , p7_a18 JTF_NUMBER_TABLE
577: , p7_a19 JTF_VARCHAR2_TABLE_100
578: , p7_a20 JTF_NUMBER_TABLE
579: , p7_a21 JTF_NUMBER_TABLE
580: , p7_a22 JTF_NUMBER_TABLE
581: , p7_a23 JTF_NUMBER_TABLE

Line 583: , p7_a25 JTF_VARCHAR2_TABLE_100

579: , p7_a21 JTF_NUMBER_TABLE
580: , p7_a22 JTF_NUMBER_TABLE
581: , p7_a23 JTF_NUMBER_TABLE
582: , p7_a24 JTF_NUMBER_TABLE
583: , p7_a25 JTF_VARCHAR2_TABLE_100
584: , p_mode VARCHAR2
585: , x_error_index out nocopy NUMBER
586: )
587:

Line 672: , p7_a10 JTF_VARCHAR2_TABLE_100

668: , p7_a6 JTF_NUMBER_TABLE
669: , p7_a7 JTF_NUMBER_TABLE
670: , p7_a8 JTF_NUMBER_TABLE
671: , p7_a9 JTF_NUMBER_TABLE
672: , p7_a10 JTF_VARCHAR2_TABLE_100
673: , p7_a11 JTF_VARCHAR2_TABLE_100
674: , p7_a12 JTF_DATE_TABLE
675: , p7_a13 JTF_NUMBER_TABLE
676: , p7_a14 JTF_NUMBER_TABLE

Line 673: , p7_a11 JTF_VARCHAR2_TABLE_100

669: , p7_a7 JTF_NUMBER_TABLE
670: , p7_a8 JTF_NUMBER_TABLE
671: , p7_a9 JTF_NUMBER_TABLE
672: , p7_a10 JTF_VARCHAR2_TABLE_100
673: , p7_a11 JTF_VARCHAR2_TABLE_100
674: , p7_a12 JTF_DATE_TABLE
675: , p7_a13 JTF_NUMBER_TABLE
676: , p7_a14 JTF_NUMBER_TABLE
677: , p7_a15 JTF_NUMBER_TABLE

Line 681: , p7_a19 JTF_VARCHAR2_TABLE_100

677: , p7_a15 JTF_NUMBER_TABLE
678: , p7_a16 JTF_NUMBER_TABLE
679: , p7_a17 JTF_NUMBER_TABLE
680: , p7_a18 JTF_NUMBER_TABLE
681: , p7_a19 JTF_VARCHAR2_TABLE_100
682: , p7_a20 JTF_NUMBER_TABLE
683: , p7_a21 JTF_NUMBER_TABLE
684: , p7_a22 JTF_NUMBER_TABLE
685: , p7_a23 JTF_NUMBER_TABLE

Line 687: , p7_a25 JTF_VARCHAR2_TABLE_100

683: , p7_a21 JTF_NUMBER_TABLE
684: , p7_a22 JTF_NUMBER_TABLE
685: , p7_a23 JTF_NUMBER_TABLE
686: , p7_a24 JTF_NUMBER_TABLE
687: , p7_a25 JTF_VARCHAR2_TABLE_100
688: , p_mode VARCHAR2
689: , x_error_index out nocopy NUMBER
690: )
691:

Line 2692: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100

2688: , p_check_all_flag VARCHAR2
2689: , x_performance_flag out nocopy VARCHAR2
2690: , p5_a0 out nocopy JTF_NUMBER_TABLE
2691: , p5_a1 out nocopy JTF_NUMBER_TABLE
2692: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
2693: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_300
2694: , p5_a4 out nocopy JTF_DATE_TABLE
2695: , p5_a5 out nocopy JTF_DATE_TABLE
2696: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 2696: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100

2692: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
2693: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_300
2694: , p5_a4 out nocopy JTF_DATE_TABLE
2695: , p5_a5 out nocopy JTF_DATE_TABLE
2696: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
2697: , p5_a7 out nocopy JTF_NUMBER_TABLE
2698: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
2699: )
2700:

Line 2698: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100

2694: , p5_a4 out nocopy JTF_DATE_TABLE
2695: , p5_a5 out nocopy JTF_DATE_TABLE
2696: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
2697: , p5_a7 out nocopy JTF_NUMBER_TABLE
2698: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
2699: )
2700:
2701: as
2702: ddx_offer_perf_tbl ozf_claim_accrual_pvt.offer_performance_tbl_type;

Line 2742: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100

2738:
2739: procedure check_offer_performance_tbl(p_claim_id NUMBER
2740: , p1_a0 out nocopy JTF_NUMBER_TABLE
2741: , p1_a1 out nocopy JTF_NUMBER_TABLE
2742: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
2743: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300
2744: , p1_a4 out nocopy JTF_DATE_TABLE
2745: , p1_a5 out nocopy JTF_DATE_TABLE
2746: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 2746: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100

2742: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
2743: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_300
2744: , p1_a4 out nocopy JTF_DATE_TABLE
2745: , p1_a5 out nocopy JTF_DATE_TABLE
2746: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100
2747: , p1_a7 out nocopy JTF_NUMBER_TABLE
2748: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_100
2749: )
2750:

Line 2748: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_100

2744: , p1_a4 out nocopy JTF_DATE_TABLE
2745: , p1_a5 out nocopy JTF_DATE_TABLE
2746: , p1_a6 out nocopy JTF_VARCHAR2_TABLE_100
2747: , p1_a7 out nocopy JTF_NUMBER_TABLE
2748: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_100
2749: )
2750:
2751: as
2752: ddx_offer_perf_tbl ozf_claim_accrual_pvt.offer_performance_tbl_type;