DBA Data[Home] [Help]

APPS.IEM_SPV_MONITORING_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 24: , a11 JTF_VARCHAR2_TABLE_100

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

Line 25: , a12 JTF_VARCHAR2_TABLE_100

21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_VARCHAR2_TABLE_100
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 67: , a11 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 68: , a12 out nocopy JTF_VARCHAR2_TABLE_100

64: , a8 out nocopy JTF_NUMBER_TABLE
65: , a9 out nocopy JTF_NUMBER_TABLE
66: , a10 out nocopy JTF_NUMBER_TABLE
67: , a11 out nocopy JTF_VARCHAR2_TABLE_100
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 84: a11 := JTF_VARCHAR2_TABLE_100();

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

Line 85: a12 := JTF_VARCHAR2_TABLE_100();

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

Line 98: a11 := JTF_VARCHAR2_TABLE_100();

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

Line 99: a12 := JTF_VARCHAR2_TABLE_100();

95: a8 := JTF_NUMBER_TABLE();
96: a9 := JTF_NUMBER_TABLE();
97: a10 := JTF_NUMBER_TABLE();
98: a11 := JTF_VARCHAR2_TABLE_100();
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 149: , a9 JTF_VARCHAR2_TABLE_100

145: , a5 JTF_NUMBER_TABLE
146: , a6 JTF_NUMBER_TABLE
147: , a7 JTF_VARCHAR2_TABLE_500
148: , a8 JTF_NUMBER_TABLE
149: , a9 JTF_VARCHAR2_TABLE_100
150: , a10 JTF_VARCHAR2_TABLE_100
151: ) as
152: ddindx binary_integer; indx binary_integer;
153: begin

Line 150: , a10 JTF_VARCHAR2_TABLE_100

146: , a6 JTF_NUMBER_TABLE
147: , a7 JTF_VARCHAR2_TABLE_500
148: , a8 JTF_NUMBER_TABLE
149: , a9 JTF_VARCHAR2_TABLE_100
150: , a10 JTF_VARCHAR2_TABLE_100
151: ) as
152: ddindx binary_integer; indx binary_integer;
153: begin
154: if a0 is not null and a0.count > 0 then

Line 188: , a9 out nocopy JTF_VARCHAR2_TABLE_100

184: , a5 out nocopy JTF_NUMBER_TABLE
185: , a6 out nocopy JTF_NUMBER_TABLE
186: , a7 out nocopy JTF_VARCHAR2_TABLE_500
187: , a8 out nocopy JTF_NUMBER_TABLE
188: , a9 out nocopy JTF_VARCHAR2_TABLE_100
189: , a10 out nocopy JTF_VARCHAR2_TABLE_100
190: ) as
191: ddindx binary_integer; indx binary_integer;
192: begin

Line 189: , a10 out nocopy JTF_VARCHAR2_TABLE_100

185: , a6 out nocopy JTF_NUMBER_TABLE
186: , a7 out nocopy JTF_VARCHAR2_TABLE_500
187: , a8 out nocopy JTF_NUMBER_TABLE
188: , a9 out nocopy JTF_VARCHAR2_TABLE_100
189: , a10 out nocopy JTF_VARCHAR2_TABLE_100
190: ) as
191: ddindx binary_integer; indx binary_integer;
192: begin
193: if t is null or t.count = 0 then

Line 203: a9 := JTF_VARCHAR2_TABLE_100();

199: a5 := JTF_NUMBER_TABLE();
200: a6 := JTF_NUMBER_TABLE();
201: a7 := JTF_VARCHAR2_TABLE_500();
202: a8 := JTF_NUMBER_TABLE();
203: a9 := JTF_VARCHAR2_TABLE_100();
204: a10 := JTF_VARCHAR2_TABLE_100();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();

Line 204: a10 := JTF_VARCHAR2_TABLE_100();

200: a6 := JTF_NUMBER_TABLE();
201: a7 := JTF_VARCHAR2_TABLE_500();
202: a8 := JTF_NUMBER_TABLE();
203: a9 := JTF_VARCHAR2_TABLE_100();
204: a10 := JTF_VARCHAR2_TABLE_100();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_VARCHAR2_TABLE_800();

Line 215: a9 := JTF_VARCHAR2_TABLE_100();

211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_VARCHAR2_TABLE_500();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_VARCHAR2_TABLE_100();
216: a10 := JTF_VARCHAR2_TABLE_100();
217: if t.count > 0 then
218: a0.extend(t.count);
219: a1.extend(t.count);

Line 216: a10 := JTF_VARCHAR2_TABLE_100();

212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_VARCHAR2_TABLE_500();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_VARCHAR2_TABLE_100();
216: a10 := JTF_VARCHAR2_TABLE_100();
217: if t.count > 0 then
218: a0.extend(t.count);
219: a1.extend(t.count);
220: a2.extend(t.count);

Line 267: , p3_a11 out nocopy JTF_VARCHAR2_TABLE_100

263: , p3_a7 out nocopy JTF_NUMBER_TABLE
264: , p3_a8 out nocopy JTF_NUMBER_TABLE
265: , p3_a9 out nocopy JTF_NUMBER_TABLE
266: , p3_a10 out nocopy JTF_NUMBER_TABLE
267: , p3_a11 out nocopy JTF_VARCHAR2_TABLE_100
268: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
269: , x_return_status out nocopy VARCHAR2
270: , x_msg_count out nocopy NUMBER
271: , x_msg_data out nocopy VARCHAR2

Line 268: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

264: , p3_a8 out nocopy JTF_NUMBER_TABLE
265: , p3_a9 out nocopy JTF_NUMBER_TABLE
266: , p3_a10 out nocopy JTF_NUMBER_TABLE
267: , p3_a11 out nocopy JTF_VARCHAR2_TABLE_100
268: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
269: , x_return_status out nocopy VARCHAR2
270: , x_msg_count out nocopy NUMBER
271: , x_msg_data out nocopy VARCHAR2
272: )

Line 333: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100

329: , p5_a5 out nocopy JTF_NUMBER_TABLE
330: , p5_a6 out nocopy JTF_NUMBER_TABLE
331: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_500
332: , p5_a8 out nocopy JTF_NUMBER_TABLE
333: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
334: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
335: , x_return_status out nocopy VARCHAR2
336: , x_msg_count out nocopy NUMBER
337: , x_msg_data out nocopy VARCHAR2

Line 334: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100

330: , p5_a6 out nocopy JTF_NUMBER_TABLE
331: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_500
332: , p5_a8 out nocopy JTF_NUMBER_TABLE
333: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
334: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
335: , x_return_status out nocopy VARCHAR2
336: , x_msg_count out nocopy NUMBER
337: , x_msg_data out nocopy VARCHAR2
338: )