DBA Data[Home] [Help]

APPS.OZF_REASON_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 20: , a4 JTF_VARCHAR2_TABLE_100

16: procedure rosetta_table_copy_in_p3(t out nocopy ozf_reason_pvt.action_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100
22: ) as
23: ddindx binary_integer; indx binary_integer;
24: begin

Line 21: , a5 JTF_VARCHAR2_TABLE_100

17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100
22: ) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count=0 then

Line 53: , a4 out nocopy JTF_VARCHAR2_TABLE_100

49: procedure rosetta_table_copy_out_p3(t ozf_reason_pvt.action_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_100
54: , a5 out nocopy JTF_VARCHAR2_TABLE_100
55: ) as
56: ddindx binary_integer; indx binary_integer;
57: begin

Line 54: , a5 out nocopy JTF_VARCHAR2_TABLE_100

50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_100
54: , a5 out nocopy JTF_VARCHAR2_TABLE_100
55: ) as
56: ddindx binary_integer; indx binary_integer;
57: begin
58: if t is null then

Line 70: a4 := JTF_VARCHAR2_TABLE_100();

66: a0 := JTF_NUMBER_TABLE();
67: a1 := JTF_NUMBER_TABLE();
68: a2 := JTF_NUMBER_TABLE();
69: a3 := JTF_NUMBER_TABLE();
70: a4 := JTF_VARCHAR2_TABLE_100();
71: a5 := JTF_VARCHAR2_TABLE_100();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();

Line 71: a5 := JTF_VARCHAR2_TABLE_100();

67: a1 := JTF_NUMBER_TABLE();
68: a2 := JTF_NUMBER_TABLE();
69: a3 := JTF_NUMBER_TABLE();
70: a4 := JTF_VARCHAR2_TABLE_100();
71: a5 := JTF_VARCHAR2_TABLE_100();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();

Line 77: a4 := JTF_VARCHAR2_TABLE_100();

73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: if t.count > 0 then
80: a0.extend(t.count);
81: a1.extend(t.count);

Line 78: a5 := JTF_VARCHAR2_TABLE_100();

74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: if t.count > 0 then
80: a0.extend(t.count);
81: a1.extend(t.count);
82: a2.extend(t.count);

Line 112: , a7 JTF_VARCHAR2_TABLE_100

108: , a3 JTF_NUMBER_TABLE
109: , a4 JTF_DATE_TABLE
110: , a5 JTF_NUMBER_TABLE
111: , a6 JTF_NUMBER_TABLE
112: , a7 JTF_VARCHAR2_TABLE_100
113: , a8 JTF_DATE_TABLE
114: , a9 JTF_DATE_TABLE
115: , a10 JTF_VARCHAR2_TABLE_100
116: , a11 JTF_VARCHAR2_TABLE_200

Line 115: , a10 JTF_VARCHAR2_TABLE_100

111: , a6 JTF_NUMBER_TABLE
112: , a7 JTF_VARCHAR2_TABLE_100
113: , a8 JTF_DATE_TABLE
114: , a9 JTF_DATE_TABLE
115: , a10 JTF_VARCHAR2_TABLE_100
116: , a11 JTF_VARCHAR2_TABLE_200
117: , a12 JTF_VARCHAR2_TABLE_200
118: , a13 JTF_VARCHAR2_TABLE_200
119: , a14 JTF_VARCHAR2_TABLE_200

Line 131: , a26 JTF_VARCHAR2_TABLE_100

127: , a22 JTF_VARCHAR2_TABLE_200
128: , a23 JTF_VARCHAR2_TABLE_200
129: , a24 JTF_VARCHAR2_TABLE_200
130: , a25 JTF_VARCHAR2_TABLE_200
131: , a26 JTF_VARCHAR2_TABLE_100
132: , a27 JTF_VARCHAR2_TABLE_2000
133: , a28 JTF_NUMBER_TABLE
134: , a29 JTF_VARCHAR2_TABLE_100
135: , a30 JTF_VARCHAR2_TABLE_100

Line 134: , a29 JTF_VARCHAR2_TABLE_100

130: , a25 JTF_VARCHAR2_TABLE_200
131: , a26 JTF_VARCHAR2_TABLE_100
132: , a27 JTF_VARCHAR2_TABLE_2000
133: , a28 JTF_NUMBER_TABLE
134: , a29 JTF_VARCHAR2_TABLE_100
135: , a30 JTF_VARCHAR2_TABLE_100
136: , a31 JTF_VARCHAR2_TABLE_100
137: , a32 JTF_NUMBER_TABLE
138: , a33 JTF_VARCHAR2_TABLE_100

Line 135: , a30 JTF_VARCHAR2_TABLE_100

131: , a26 JTF_VARCHAR2_TABLE_100
132: , a27 JTF_VARCHAR2_TABLE_2000
133: , a28 JTF_NUMBER_TABLE
134: , a29 JTF_VARCHAR2_TABLE_100
135: , a30 JTF_VARCHAR2_TABLE_100
136: , a31 JTF_VARCHAR2_TABLE_100
137: , a32 JTF_NUMBER_TABLE
138: , a33 JTF_VARCHAR2_TABLE_100
139: ) as

Line 136: , a31 JTF_VARCHAR2_TABLE_100

132: , a27 JTF_VARCHAR2_TABLE_2000
133: , a28 JTF_NUMBER_TABLE
134: , a29 JTF_VARCHAR2_TABLE_100
135: , a30 JTF_VARCHAR2_TABLE_100
136: , a31 JTF_VARCHAR2_TABLE_100
137: , a32 JTF_NUMBER_TABLE
138: , a33 JTF_VARCHAR2_TABLE_100
139: ) as
140: ddindx binary_integer; indx binary_integer;

Line 138: , a33 JTF_VARCHAR2_TABLE_100

134: , a29 JTF_VARCHAR2_TABLE_100
135: , a30 JTF_VARCHAR2_TABLE_100
136: , a31 JTF_VARCHAR2_TABLE_100
137: , a32 JTF_NUMBER_TABLE
138: , a33 JTF_VARCHAR2_TABLE_100
139: ) as
140: ddindx binary_integer; indx binary_integer;
141: begin
142: if a0 is not null and a0.count=0 then

Line 201: , a7 out nocopy JTF_VARCHAR2_TABLE_100

197: , a3 out nocopy JTF_NUMBER_TABLE
198: , a4 out nocopy JTF_DATE_TABLE
199: , a5 out nocopy JTF_NUMBER_TABLE
200: , a6 out nocopy JTF_NUMBER_TABLE
201: , a7 out nocopy JTF_VARCHAR2_TABLE_100
202: , a8 out nocopy JTF_DATE_TABLE
203: , a9 out nocopy JTF_DATE_TABLE
204: , a10 out nocopy JTF_VARCHAR2_TABLE_100
205: , a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 204: , a10 out nocopy JTF_VARCHAR2_TABLE_100

200: , a6 out nocopy JTF_NUMBER_TABLE
201: , a7 out nocopy JTF_VARCHAR2_TABLE_100
202: , a8 out nocopy JTF_DATE_TABLE
203: , a9 out nocopy JTF_DATE_TABLE
204: , a10 out nocopy JTF_VARCHAR2_TABLE_100
205: , a11 out nocopy JTF_VARCHAR2_TABLE_200
206: , a12 out nocopy JTF_VARCHAR2_TABLE_200
207: , a13 out nocopy JTF_VARCHAR2_TABLE_200
208: , a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 220: , a26 out nocopy JTF_VARCHAR2_TABLE_100

216: , a22 out nocopy JTF_VARCHAR2_TABLE_200
217: , a23 out nocopy JTF_VARCHAR2_TABLE_200
218: , a24 out nocopy JTF_VARCHAR2_TABLE_200
219: , a25 out nocopy JTF_VARCHAR2_TABLE_200
220: , a26 out nocopy JTF_VARCHAR2_TABLE_100
221: , a27 out nocopy JTF_VARCHAR2_TABLE_2000
222: , a28 out nocopy JTF_NUMBER_TABLE
223: , a29 out nocopy JTF_VARCHAR2_TABLE_100
224: , a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 223: , a29 out nocopy JTF_VARCHAR2_TABLE_100

219: , a25 out nocopy JTF_VARCHAR2_TABLE_200
220: , a26 out nocopy JTF_VARCHAR2_TABLE_100
221: , a27 out nocopy JTF_VARCHAR2_TABLE_2000
222: , a28 out nocopy JTF_NUMBER_TABLE
223: , a29 out nocopy JTF_VARCHAR2_TABLE_100
224: , a30 out nocopy JTF_VARCHAR2_TABLE_100
225: , a31 out nocopy JTF_VARCHAR2_TABLE_100
226: , a32 out nocopy JTF_NUMBER_TABLE
227: , a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 224: , a30 out nocopy JTF_VARCHAR2_TABLE_100

220: , a26 out nocopy JTF_VARCHAR2_TABLE_100
221: , a27 out nocopy JTF_VARCHAR2_TABLE_2000
222: , a28 out nocopy JTF_NUMBER_TABLE
223: , a29 out nocopy JTF_VARCHAR2_TABLE_100
224: , a30 out nocopy JTF_VARCHAR2_TABLE_100
225: , a31 out nocopy JTF_VARCHAR2_TABLE_100
226: , a32 out nocopy JTF_NUMBER_TABLE
227: , a33 out nocopy JTF_VARCHAR2_TABLE_100
228: ) as

Line 225: , a31 out nocopy JTF_VARCHAR2_TABLE_100

221: , a27 out nocopy JTF_VARCHAR2_TABLE_2000
222: , a28 out nocopy JTF_NUMBER_TABLE
223: , a29 out nocopy JTF_VARCHAR2_TABLE_100
224: , a30 out nocopy JTF_VARCHAR2_TABLE_100
225: , a31 out nocopy JTF_VARCHAR2_TABLE_100
226: , a32 out nocopy JTF_NUMBER_TABLE
227: , a33 out nocopy JTF_VARCHAR2_TABLE_100
228: ) as
229: ddindx binary_integer; indx binary_integer;

Line 227: , a33 out nocopy JTF_VARCHAR2_TABLE_100

223: , a29 out nocopy JTF_VARCHAR2_TABLE_100
224: , a30 out nocopy JTF_VARCHAR2_TABLE_100
225: , a31 out nocopy JTF_VARCHAR2_TABLE_100
226: , a32 out nocopy JTF_NUMBER_TABLE
227: , a33 out nocopy JTF_VARCHAR2_TABLE_100
228: ) as
229: ddindx binary_integer; indx binary_integer;
230: begin
231: if t is null then

Line 274: a7 := JTF_VARCHAR2_TABLE_100();

270: a3 := JTF_NUMBER_TABLE();
271: a4 := JTF_DATE_TABLE();
272: a5 := JTF_NUMBER_TABLE();
273: a6 := JTF_NUMBER_TABLE();
274: a7 := JTF_VARCHAR2_TABLE_100();
275: a8 := JTF_DATE_TABLE();
276: a9 := JTF_DATE_TABLE();
277: a10 := JTF_VARCHAR2_TABLE_100();
278: a11 := JTF_VARCHAR2_TABLE_200();

Line 277: a10 := JTF_VARCHAR2_TABLE_100();

273: a6 := JTF_NUMBER_TABLE();
274: a7 := JTF_VARCHAR2_TABLE_100();
275: a8 := JTF_DATE_TABLE();
276: a9 := JTF_DATE_TABLE();
277: a10 := JTF_VARCHAR2_TABLE_100();
278: a11 := JTF_VARCHAR2_TABLE_200();
279: a12 := JTF_VARCHAR2_TABLE_200();
280: a13 := JTF_VARCHAR2_TABLE_200();
281: a14 := JTF_VARCHAR2_TABLE_200();

Line 293: a26 := JTF_VARCHAR2_TABLE_100();

289: a22 := JTF_VARCHAR2_TABLE_200();
290: a23 := JTF_VARCHAR2_TABLE_200();
291: a24 := JTF_VARCHAR2_TABLE_200();
292: a25 := JTF_VARCHAR2_TABLE_200();
293: a26 := JTF_VARCHAR2_TABLE_100();
294: a27 := JTF_VARCHAR2_TABLE_2000();
295: a28 := JTF_NUMBER_TABLE();
296: a29 := JTF_VARCHAR2_TABLE_100();
297: a30 := JTF_VARCHAR2_TABLE_100();

Line 296: a29 := JTF_VARCHAR2_TABLE_100();

292: a25 := JTF_VARCHAR2_TABLE_200();
293: a26 := JTF_VARCHAR2_TABLE_100();
294: a27 := JTF_VARCHAR2_TABLE_2000();
295: a28 := JTF_NUMBER_TABLE();
296: a29 := JTF_VARCHAR2_TABLE_100();
297: a30 := JTF_VARCHAR2_TABLE_100();
298: a31 := JTF_VARCHAR2_TABLE_100();
299: a32 := JTF_NUMBER_TABLE();
300: a33 := JTF_VARCHAR2_TABLE_100();

Line 297: a30 := JTF_VARCHAR2_TABLE_100();

293: a26 := JTF_VARCHAR2_TABLE_100();
294: a27 := JTF_VARCHAR2_TABLE_2000();
295: a28 := JTF_NUMBER_TABLE();
296: a29 := JTF_VARCHAR2_TABLE_100();
297: a30 := JTF_VARCHAR2_TABLE_100();
298: a31 := JTF_VARCHAR2_TABLE_100();
299: a32 := JTF_NUMBER_TABLE();
300: a33 := JTF_VARCHAR2_TABLE_100();
301: else

Line 298: a31 := JTF_VARCHAR2_TABLE_100();

294: a27 := JTF_VARCHAR2_TABLE_2000();
295: a28 := JTF_NUMBER_TABLE();
296: a29 := JTF_VARCHAR2_TABLE_100();
297: a30 := JTF_VARCHAR2_TABLE_100();
298: a31 := JTF_VARCHAR2_TABLE_100();
299: a32 := JTF_NUMBER_TABLE();
300: a33 := JTF_VARCHAR2_TABLE_100();
301: else
302: a0 := JTF_NUMBER_TABLE();

Line 300: a33 := JTF_VARCHAR2_TABLE_100();

296: a29 := JTF_VARCHAR2_TABLE_100();
297: a30 := JTF_VARCHAR2_TABLE_100();
298: a31 := JTF_VARCHAR2_TABLE_100();
299: a32 := JTF_NUMBER_TABLE();
300: a33 := JTF_VARCHAR2_TABLE_100();
301: else
302: a0 := JTF_NUMBER_TABLE();
303: a1 := JTF_NUMBER_TABLE();
304: a2 := JTF_DATE_TABLE();

Line 309: a7 := JTF_VARCHAR2_TABLE_100();

305: a3 := JTF_NUMBER_TABLE();
306: a4 := JTF_DATE_TABLE();
307: a5 := JTF_NUMBER_TABLE();
308: a6 := JTF_NUMBER_TABLE();
309: a7 := JTF_VARCHAR2_TABLE_100();
310: a8 := JTF_DATE_TABLE();
311: a9 := JTF_DATE_TABLE();
312: a10 := JTF_VARCHAR2_TABLE_100();
313: a11 := JTF_VARCHAR2_TABLE_200();

Line 312: a10 := JTF_VARCHAR2_TABLE_100();

308: a6 := JTF_NUMBER_TABLE();
309: a7 := JTF_VARCHAR2_TABLE_100();
310: a8 := JTF_DATE_TABLE();
311: a9 := JTF_DATE_TABLE();
312: a10 := JTF_VARCHAR2_TABLE_100();
313: a11 := JTF_VARCHAR2_TABLE_200();
314: a12 := JTF_VARCHAR2_TABLE_200();
315: a13 := JTF_VARCHAR2_TABLE_200();
316: a14 := JTF_VARCHAR2_TABLE_200();

Line 328: a26 := JTF_VARCHAR2_TABLE_100();

324: a22 := JTF_VARCHAR2_TABLE_200();
325: a23 := JTF_VARCHAR2_TABLE_200();
326: a24 := JTF_VARCHAR2_TABLE_200();
327: a25 := JTF_VARCHAR2_TABLE_200();
328: a26 := JTF_VARCHAR2_TABLE_100();
329: a27 := JTF_VARCHAR2_TABLE_2000();
330: a28 := JTF_NUMBER_TABLE();
331: a29 := JTF_VARCHAR2_TABLE_100();
332: a30 := JTF_VARCHAR2_TABLE_100();

Line 331: a29 := JTF_VARCHAR2_TABLE_100();

327: a25 := JTF_VARCHAR2_TABLE_200();
328: a26 := JTF_VARCHAR2_TABLE_100();
329: a27 := JTF_VARCHAR2_TABLE_2000();
330: a28 := JTF_NUMBER_TABLE();
331: a29 := JTF_VARCHAR2_TABLE_100();
332: a30 := JTF_VARCHAR2_TABLE_100();
333: a31 := JTF_VARCHAR2_TABLE_100();
334: a32 := JTF_NUMBER_TABLE();
335: a33 := JTF_VARCHAR2_TABLE_100();

Line 332: a30 := JTF_VARCHAR2_TABLE_100();

328: a26 := JTF_VARCHAR2_TABLE_100();
329: a27 := JTF_VARCHAR2_TABLE_2000();
330: a28 := JTF_NUMBER_TABLE();
331: a29 := JTF_VARCHAR2_TABLE_100();
332: a30 := JTF_VARCHAR2_TABLE_100();
333: a31 := JTF_VARCHAR2_TABLE_100();
334: a32 := JTF_NUMBER_TABLE();
335: a33 := JTF_VARCHAR2_TABLE_100();
336: if t.count > 0 then

Line 333: a31 := JTF_VARCHAR2_TABLE_100();

329: a27 := JTF_VARCHAR2_TABLE_2000();
330: a28 := JTF_NUMBER_TABLE();
331: a29 := JTF_VARCHAR2_TABLE_100();
332: a30 := JTF_VARCHAR2_TABLE_100();
333: a31 := JTF_VARCHAR2_TABLE_100();
334: a32 := JTF_NUMBER_TABLE();
335: a33 := JTF_VARCHAR2_TABLE_100();
336: if t.count > 0 then
337: a0.extend(t.count);

Line 335: a33 := JTF_VARCHAR2_TABLE_100();

331: a29 := JTF_VARCHAR2_TABLE_100();
332: a30 := JTF_VARCHAR2_TABLE_100();
333: a31 := JTF_VARCHAR2_TABLE_100();
334: a32 := JTF_NUMBER_TABLE();
335: a33 := JTF_VARCHAR2_TABLE_100();
336: if t.count > 0 then
337: a0.extend(t.count);
338: a1.extend(t.count);
339: a2.extend(t.count);

Line 659: , p7_a4 JTF_VARCHAR2_TABLE_100

655: , p7_a0 JTF_NUMBER_TABLE
656: , p7_a1 JTF_NUMBER_TABLE
657: , p7_a2 JTF_NUMBER_TABLE
658: , p7_a3 JTF_NUMBER_TABLE
659: , p7_a4 JTF_VARCHAR2_TABLE_100
660: , p7_a5 JTF_VARCHAR2_TABLE_100
661: )
662:
663: as

Line 660: , p7_a5 JTF_VARCHAR2_TABLE_100

656: , p7_a1 JTF_NUMBER_TABLE
657: , p7_a2 JTF_NUMBER_TABLE
658: , p7_a3 JTF_NUMBER_TABLE
659: , p7_a4 JTF_VARCHAR2_TABLE_100
660: , p7_a5 JTF_VARCHAR2_TABLE_100
661: )
662:
663: as
664: ddp_action_tbl ozf_reason_pvt.action_tbl_type;