DBA Data[Home] [Help]

APPS.CN_GET_SRP_DATA_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 15: , a2 JTF_VARCHAR2_TABLE_100

11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_srp_data_pvt.srp_data_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_400
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE

Line 18: , a5 JTF_VARCHAR2_TABLE_100

14: , a1 JTF_VARCHAR2_TABLE_400
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_300
22: , a9 JTF_VARCHAR2_TABLE_300

Line 20: , a7 JTF_VARCHAR2_TABLE_100

16: , a3 JTF_DATE_TABLE
17: , a4 JTF_DATE_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_300
22: , a9 JTF_VARCHAR2_TABLE_300
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_NUMBER_TABLE

Line 23: , a10 JTF_VARCHAR2_TABLE_100

19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_VARCHAR2_TABLE_300
22: , a9 JTF_VARCHAR2_TABLE_300
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100
26: ) as
27: ddindx binary_integer; indx binary_integer;

Line 25: , a12 JTF_VARCHAR2_TABLE_100

21: , a8 JTF_VARCHAR2_TABLE_300
22: , a9 JTF_VARCHAR2_TABLE_300
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_NUMBER_TABLE
25: , a12 JTF_VARCHAR2_TABLE_100
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin
29: if a0 is not null and a0.count > 0 then

Line 58: , a2 out nocopy JTF_VARCHAR2_TABLE_100

54: end if;
55: end rosetta_table_copy_in_p1;
56: procedure rosetta_table_copy_out_p1(t cn_get_srp_data_pvt.srp_data_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_VARCHAR2_TABLE_400
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_DATE_TABLE
60: , a4 out nocopy JTF_DATE_TABLE
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , a6 out nocopy JTF_NUMBER_TABLE

Line 61: , a5 out nocopy JTF_VARCHAR2_TABLE_100

57: , a1 out nocopy JTF_VARCHAR2_TABLE_400
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_DATE_TABLE
60: , a4 out nocopy JTF_DATE_TABLE
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_VARCHAR2_TABLE_100
64: , a8 out nocopy JTF_VARCHAR2_TABLE_300
65: , a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 63: , a7 out nocopy JTF_VARCHAR2_TABLE_100

59: , a3 out nocopy JTF_DATE_TABLE
60: , a4 out nocopy JTF_DATE_TABLE
61: , a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_VARCHAR2_TABLE_100
64: , a8 out nocopy JTF_VARCHAR2_TABLE_300
65: , a9 out nocopy JTF_VARCHAR2_TABLE_300
66: , a10 out nocopy JTF_VARCHAR2_TABLE_100
67: , a11 out nocopy JTF_NUMBER_TABLE

Line 66: , a10 out nocopy JTF_VARCHAR2_TABLE_100

62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_VARCHAR2_TABLE_100
64: , a8 out nocopy JTF_VARCHAR2_TABLE_300
65: , a9 out nocopy JTF_VARCHAR2_TABLE_300
66: , a10 out nocopy JTF_VARCHAR2_TABLE_100
67: , a11 out nocopy JTF_NUMBER_TABLE
68: , a12 out nocopy JTF_VARCHAR2_TABLE_100
69: ) as
70: ddindx binary_integer; indx binary_integer;

Line 68: , a12 out nocopy JTF_VARCHAR2_TABLE_100

64: , a8 out nocopy JTF_VARCHAR2_TABLE_300
65: , a9 out nocopy JTF_VARCHAR2_TABLE_300
66: , a10 out nocopy JTF_VARCHAR2_TABLE_100
67: , a11 out nocopy JTF_NUMBER_TABLE
68: , a12 out nocopy JTF_VARCHAR2_TABLE_100
69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then

Line 75: a2 := JTF_VARCHAR2_TABLE_100();

71: begin
72: if t is null or t.count = 0 then
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_400();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_DATE_TABLE();
77: a4 := JTF_DATE_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();

Line 78: a5 := JTF_VARCHAR2_TABLE_100();

74: a1 := JTF_VARCHAR2_TABLE_400();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_DATE_TABLE();
77: a4 := JTF_DATE_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_100();
81: a8 := JTF_VARCHAR2_TABLE_300();
82: a9 := JTF_VARCHAR2_TABLE_300();

Line 80: a7 := JTF_VARCHAR2_TABLE_100();

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

Line 83: a10 := JTF_VARCHAR2_TABLE_100();

79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_100();
81: a8 := JTF_VARCHAR2_TABLE_300();
82: a9 := JTF_VARCHAR2_TABLE_300();
83: a10 := JTF_VARCHAR2_TABLE_100();
84: a11 := JTF_NUMBER_TABLE();
85: a12 := JTF_VARCHAR2_TABLE_100();
86: else
87: a0 := JTF_NUMBER_TABLE();

Line 85: a12 := JTF_VARCHAR2_TABLE_100();

81: a8 := JTF_VARCHAR2_TABLE_300();
82: a9 := JTF_VARCHAR2_TABLE_300();
83: a10 := JTF_VARCHAR2_TABLE_100();
84: a11 := JTF_NUMBER_TABLE();
85: a12 := JTF_VARCHAR2_TABLE_100();
86: else
87: a0 := JTF_NUMBER_TABLE();
88: a1 := JTF_VARCHAR2_TABLE_400();
89: a2 := JTF_VARCHAR2_TABLE_100();

Line 89: a2 := JTF_VARCHAR2_TABLE_100();

85: a12 := JTF_VARCHAR2_TABLE_100();
86: else
87: a0 := JTF_NUMBER_TABLE();
88: a1 := JTF_VARCHAR2_TABLE_400();
89: a2 := JTF_VARCHAR2_TABLE_100();
90: a3 := JTF_DATE_TABLE();
91: a4 := JTF_DATE_TABLE();
92: a5 := JTF_VARCHAR2_TABLE_100();
93: a6 := JTF_NUMBER_TABLE();

Line 92: a5 := JTF_VARCHAR2_TABLE_100();

88: a1 := JTF_VARCHAR2_TABLE_400();
89: a2 := JTF_VARCHAR2_TABLE_100();
90: a3 := JTF_DATE_TABLE();
91: a4 := JTF_DATE_TABLE();
92: a5 := JTF_VARCHAR2_TABLE_100();
93: a6 := JTF_NUMBER_TABLE();
94: a7 := JTF_VARCHAR2_TABLE_100();
95: a8 := JTF_VARCHAR2_TABLE_300();
96: a9 := JTF_VARCHAR2_TABLE_300();

Line 94: a7 := JTF_VARCHAR2_TABLE_100();

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

Line 97: a10 := JTF_VARCHAR2_TABLE_100();

93: a6 := JTF_NUMBER_TABLE();
94: a7 := JTF_VARCHAR2_TABLE_100();
95: a8 := JTF_VARCHAR2_TABLE_300();
96: a9 := JTF_VARCHAR2_TABLE_300();
97: a10 := JTF_VARCHAR2_TABLE_100();
98: a11 := JTF_NUMBER_TABLE();
99: a12 := JTF_VARCHAR2_TABLE_100();
100: if t.count > 0 then
101: a0.extend(t.count);

Line 99: a12 := JTF_VARCHAR2_TABLE_100();

95: a8 := JTF_VARCHAR2_TABLE_300();
96: a9 := JTF_VARCHAR2_TABLE_300();
97: a10 := JTF_VARCHAR2_TABLE_100();
98: a11 := JTF_NUMBER_TABLE();
99: a12 := JTF_VARCHAR2_TABLE_100();
100: if t.count > 0 then
101: a0.extend(t.count);
102: a1.extend(t.count);
103: a2.extend(t.count);

Line 142: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_100

138: end rosetta_table_copy_out_p1;
139:
140: procedure get_srp_list(p0_a0 out nocopy JTF_NUMBER_TABLE
141: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_400
142: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , p0_a3 out nocopy JTF_DATE_TABLE
144: , p0_a4 out nocopy JTF_DATE_TABLE
145: , p0_a5 out nocopy JTF_VARCHAR2_TABLE_100
146: , p0_a6 out nocopy JTF_NUMBER_TABLE

Line 145: , p0_a5 out nocopy JTF_VARCHAR2_TABLE_100

141: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_400
142: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , p0_a3 out nocopy JTF_DATE_TABLE
144: , p0_a4 out nocopy JTF_DATE_TABLE
145: , p0_a5 out nocopy JTF_VARCHAR2_TABLE_100
146: , p0_a6 out nocopy JTF_NUMBER_TABLE
147: , p0_a7 out nocopy JTF_VARCHAR2_TABLE_100
148: , p0_a8 out nocopy JTF_VARCHAR2_TABLE_300
149: , p0_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 147: , p0_a7 out nocopy JTF_VARCHAR2_TABLE_100

143: , p0_a3 out nocopy JTF_DATE_TABLE
144: , p0_a4 out nocopy JTF_DATE_TABLE
145: , p0_a5 out nocopy JTF_VARCHAR2_TABLE_100
146: , p0_a6 out nocopy JTF_NUMBER_TABLE
147: , p0_a7 out nocopy JTF_VARCHAR2_TABLE_100
148: , p0_a8 out nocopy JTF_VARCHAR2_TABLE_300
149: , p0_a9 out nocopy JTF_VARCHAR2_TABLE_300
150: , p0_a10 out nocopy JTF_VARCHAR2_TABLE_100
151: , p0_a11 out nocopy JTF_NUMBER_TABLE

Line 150: , p0_a10 out nocopy JTF_VARCHAR2_TABLE_100

146: , p0_a6 out nocopy JTF_NUMBER_TABLE
147: , p0_a7 out nocopy JTF_VARCHAR2_TABLE_100
148: , p0_a8 out nocopy JTF_VARCHAR2_TABLE_300
149: , p0_a9 out nocopy JTF_VARCHAR2_TABLE_300
150: , p0_a10 out nocopy JTF_VARCHAR2_TABLE_100
151: , p0_a11 out nocopy JTF_NUMBER_TABLE
152: , p0_a12 out nocopy JTF_VARCHAR2_TABLE_100
153: )
154:

Line 152: , p0_a12 out nocopy JTF_VARCHAR2_TABLE_100

148: , p0_a8 out nocopy JTF_VARCHAR2_TABLE_300
149: , p0_a9 out nocopy JTF_VARCHAR2_TABLE_300
150: , p0_a10 out nocopy JTF_VARCHAR2_TABLE_100
151: , p0_a11 out nocopy JTF_NUMBER_TABLE
152: , p0_a12 out nocopy JTF_VARCHAR2_TABLE_100
153: )
154:
155: as
156: ddx_srp_data cn_get_srp_data_pvt.srp_data_tbl_type;

Line 194: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100

190: , p_order_dir VARCHAR2
191: , x_total_rows out nocopy NUMBER
192: , p10_a0 out nocopy JTF_NUMBER_TABLE
193: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_400
194: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
195: , p10_a3 out nocopy JTF_DATE_TABLE
196: , p10_a4 out nocopy JTF_DATE_TABLE
197: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
198: , p10_a6 out nocopy JTF_NUMBER_TABLE

Line 197: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

193: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_400
194: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
195: , p10_a3 out nocopy JTF_DATE_TABLE
196: , p10_a4 out nocopy JTF_DATE_TABLE
197: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
198: , p10_a6 out nocopy JTF_NUMBER_TABLE
199: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
200: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
201: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 199: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100

195: , p10_a3 out nocopy JTF_DATE_TABLE
196: , p10_a4 out nocopy JTF_DATE_TABLE
197: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
198: , p10_a6 out nocopy JTF_NUMBER_TABLE
199: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
200: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
201: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
202: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
203: , p10_a11 out nocopy JTF_NUMBER_TABLE

Line 202: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100

198: , p10_a6 out nocopy JTF_NUMBER_TABLE
199: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
200: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
201: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
202: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
203: , p10_a11 out nocopy JTF_NUMBER_TABLE
204: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
205: )
206:

Line 204: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100

200: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
201: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
202: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
203: , p10_a11 out nocopy JTF_NUMBER_TABLE
204: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
205: )
206:
207: as
208: ddp_date date;

Line 269: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100

265:
266: procedure get_srp_data(p_srp_id NUMBER
267: , p1_a0 out nocopy JTF_NUMBER_TABLE
268: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_400
269: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
270: , p1_a3 out nocopy JTF_DATE_TABLE
271: , p1_a4 out nocopy JTF_DATE_TABLE
272: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
273: , p1_a6 out nocopy JTF_NUMBER_TABLE

Line 272: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100

268: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_400
269: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
270: , p1_a3 out nocopy JTF_DATE_TABLE
271: , p1_a4 out nocopy JTF_DATE_TABLE
272: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
273: , p1_a6 out nocopy JTF_NUMBER_TABLE
274: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
275: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_300
276: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 274: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100

270: , p1_a3 out nocopy JTF_DATE_TABLE
271: , p1_a4 out nocopy JTF_DATE_TABLE
272: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
273: , p1_a6 out nocopy JTF_NUMBER_TABLE
274: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
275: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_300
276: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_300
277: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_100
278: , p1_a11 out nocopy JTF_NUMBER_TABLE

Line 277: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_100

273: , p1_a6 out nocopy JTF_NUMBER_TABLE
274: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
275: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_300
276: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_300
277: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_100
278: , p1_a11 out nocopy JTF_NUMBER_TABLE
279: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_100
280: )
281:

Line 279: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_100

275: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_300
276: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_300
277: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_100
278: , p1_a11 out nocopy JTF_NUMBER_TABLE
279: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_100
280: )
281:
282: as
283: ddx_srp_data cn_get_srp_data_pvt.srp_data_tbl_type;

Line 317: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100

313: , p_date date
314: , p_comp_group_id NUMBER
315: , p3_a0 out nocopy JTF_NUMBER_TABLE
316: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_400
317: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
318: , p3_a3 out nocopy JTF_DATE_TABLE
319: , p3_a4 out nocopy JTF_DATE_TABLE
320: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
321: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 320: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100

316: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_400
317: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
318: , p3_a3 out nocopy JTF_DATE_TABLE
319: , p3_a4 out nocopy JTF_DATE_TABLE
320: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
321: , p3_a6 out nocopy JTF_NUMBER_TABLE
322: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
323: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_300
324: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 322: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

318: , p3_a3 out nocopy JTF_DATE_TABLE
319: , p3_a4 out nocopy JTF_DATE_TABLE
320: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
321: , p3_a6 out nocopy JTF_NUMBER_TABLE
322: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
323: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_300
324: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_300
325: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
326: , p3_a11 out nocopy JTF_NUMBER_TABLE

Line 325: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100

321: , p3_a6 out nocopy JTF_NUMBER_TABLE
322: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
323: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_300
324: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_300
325: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
326: , p3_a11 out nocopy JTF_NUMBER_TABLE
327: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
328: )
329:

Line 327: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

323: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_300
324: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_300
325: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
326: , p3_a11 out nocopy JTF_NUMBER_TABLE
327: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
328: )
329:
330: as
331: ddp_date date;