DBA Data[Home] [Help]

APPS.OKL_GTS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 29: , a4 JTF_VARCHAR2_TABLE_100

25: procedure rosetta_table_copy_in_p2(t out nocopy okl_gts_pvt.gts_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_VARCHAR2_TABLE_2000
29: , a4 JTF_VARCHAR2_TABLE_100
30: , a5 JTF_VARCHAR2_TABLE_100
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_NUMBER_TABLE

Line 30: , a5 JTF_VARCHAR2_TABLE_100

26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_VARCHAR2_TABLE_2000
29: , a4 JTF_VARCHAR2_TABLE_100
30: , a5 JTF_VARCHAR2_TABLE_100
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_NUMBER_TABLE
34: , a9 JTF_NUMBER_TABLE

Line 31: , a6 JTF_VARCHAR2_TABLE_100

27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_VARCHAR2_TABLE_2000
29: , a4 JTF_VARCHAR2_TABLE_100
30: , a5 JTF_VARCHAR2_TABLE_100
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_NUMBER_TABLE
34: , a9 JTF_NUMBER_TABLE
35: , a10 JTF_DATE_TABLE

Line 32: , a7 JTF_VARCHAR2_TABLE_100

28: , a3 JTF_VARCHAR2_TABLE_2000
29: , a4 JTF_VARCHAR2_TABLE_100
30: , a5 JTF_VARCHAR2_TABLE_100
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_NUMBER_TABLE
34: , a9 JTF_NUMBER_TABLE
35: , a10 JTF_DATE_TABLE
36: , a11 JTF_NUMBER_TABLE

Line 39: , a14 JTF_VARCHAR2_TABLE_100

35: , a10 JTF_DATE_TABLE
36: , a11 JTF_NUMBER_TABLE
37: , a12 JTF_DATE_TABLE
38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_VARCHAR2_TABLE_100
40: , a15 JTF_VARCHAR2_TABLE_100
41: , a16 JTF_VARCHAR2_TABLE_100
42: , a17 JTF_VARCHAR2_TABLE_100
43: , a18 JTF_VARCHAR2_TABLE_100

Line 40: , a15 JTF_VARCHAR2_TABLE_100

36: , a11 JTF_NUMBER_TABLE
37: , a12 JTF_DATE_TABLE
38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_VARCHAR2_TABLE_100
40: , a15 JTF_VARCHAR2_TABLE_100
41: , a16 JTF_VARCHAR2_TABLE_100
42: , a17 JTF_VARCHAR2_TABLE_100
43: , a18 JTF_VARCHAR2_TABLE_100
44: ) as

Line 41: , a16 JTF_VARCHAR2_TABLE_100

37: , a12 JTF_DATE_TABLE
38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_VARCHAR2_TABLE_100
40: , a15 JTF_VARCHAR2_TABLE_100
41: , a16 JTF_VARCHAR2_TABLE_100
42: , a17 JTF_VARCHAR2_TABLE_100
43: , a18 JTF_VARCHAR2_TABLE_100
44: ) as
45: ddindx binary_integer; indx binary_integer;

Line 42: , a17 JTF_VARCHAR2_TABLE_100

38: , a13 JTF_NUMBER_TABLE
39: , a14 JTF_VARCHAR2_TABLE_100
40: , a15 JTF_VARCHAR2_TABLE_100
41: , a16 JTF_VARCHAR2_TABLE_100
42: , a17 JTF_VARCHAR2_TABLE_100
43: , a18 JTF_VARCHAR2_TABLE_100
44: ) as
45: ddindx binary_integer; indx binary_integer;
46: begin

Line 43: , a18 JTF_VARCHAR2_TABLE_100

39: , a14 JTF_VARCHAR2_TABLE_100
40: , a15 JTF_VARCHAR2_TABLE_100
41: , a16 JTF_VARCHAR2_TABLE_100
42: , a17 JTF_VARCHAR2_TABLE_100
43: , a18 JTF_VARCHAR2_TABLE_100
44: ) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if a0 is not null and a0.count > 0 then

Line 84: , a4 out nocopy JTF_VARCHAR2_TABLE_100

80: procedure rosetta_table_copy_out_p2(t okl_gts_pvt.gts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
84: , a4 out nocopy JTF_VARCHAR2_TABLE_100
85: , a5 out nocopy JTF_VARCHAR2_TABLE_100
86: , a6 out nocopy JTF_VARCHAR2_TABLE_100
87: , a7 out nocopy JTF_VARCHAR2_TABLE_100
88: , a8 out nocopy JTF_NUMBER_TABLE

Line 85: , a5 out nocopy JTF_VARCHAR2_TABLE_100

81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
84: , a4 out nocopy JTF_VARCHAR2_TABLE_100
85: , a5 out nocopy JTF_VARCHAR2_TABLE_100
86: , a6 out nocopy JTF_VARCHAR2_TABLE_100
87: , a7 out nocopy JTF_VARCHAR2_TABLE_100
88: , a8 out nocopy JTF_NUMBER_TABLE
89: , a9 out nocopy JTF_NUMBER_TABLE

Line 86: , a6 out nocopy JTF_VARCHAR2_TABLE_100

82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
84: , a4 out nocopy JTF_VARCHAR2_TABLE_100
85: , a5 out nocopy JTF_VARCHAR2_TABLE_100
86: , a6 out nocopy JTF_VARCHAR2_TABLE_100
87: , a7 out nocopy JTF_VARCHAR2_TABLE_100
88: , a8 out nocopy JTF_NUMBER_TABLE
89: , a9 out nocopy JTF_NUMBER_TABLE
90: , a10 out nocopy JTF_DATE_TABLE

Line 87: , a7 out nocopy JTF_VARCHAR2_TABLE_100

83: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
84: , a4 out nocopy JTF_VARCHAR2_TABLE_100
85: , a5 out nocopy JTF_VARCHAR2_TABLE_100
86: , a6 out nocopy JTF_VARCHAR2_TABLE_100
87: , a7 out nocopy JTF_VARCHAR2_TABLE_100
88: , a8 out nocopy JTF_NUMBER_TABLE
89: , a9 out nocopy JTF_NUMBER_TABLE
90: , a10 out nocopy JTF_DATE_TABLE
91: , a11 out nocopy JTF_NUMBER_TABLE

Line 94: , a14 out nocopy JTF_VARCHAR2_TABLE_100

90: , a10 out nocopy JTF_DATE_TABLE
91: , a11 out nocopy JTF_NUMBER_TABLE
92: , a12 out nocopy JTF_DATE_TABLE
93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_VARCHAR2_TABLE_100
98: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 95: , a15 out nocopy JTF_VARCHAR2_TABLE_100

91: , a11 out nocopy JTF_NUMBER_TABLE
92: , a12 out nocopy JTF_DATE_TABLE
93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_VARCHAR2_TABLE_100
98: , a18 out nocopy JTF_VARCHAR2_TABLE_100
99: ) as

Line 96: , a16 out nocopy JTF_VARCHAR2_TABLE_100

92: , a12 out nocopy JTF_DATE_TABLE
93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_VARCHAR2_TABLE_100
98: , a18 out nocopy JTF_VARCHAR2_TABLE_100
99: ) as
100: ddindx binary_integer; indx binary_integer;

Line 97: , a17 out nocopy JTF_VARCHAR2_TABLE_100

93: , a13 out nocopy JTF_NUMBER_TABLE
94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_VARCHAR2_TABLE_100
98: , a18 out nocopy JTF_VARCHAR2_TABLE_100
99: ) as
100: ddindx binary_integer; indx binary_integer;
101: begin

Line 98: , a18 out nocopy JTF_VARCHAR2_TABLE_100

94: , a14 out nocopy JTF_VARCHAR2_TABLE_100
95: , a15 out nocopy JTF_VARCHAR2_TABLE_100
96: , a16 out nocopy JTF_VARCHAR2_TABLE_100
97: , a17 out nocopy JTF_VARCHAR2_TABLE_100
98: , a18 out nocopy JTF_VARCHAR2_TABLE_100
99: ) as
100: ddindx binary_integer; indx binary_integer;
101: begin
102: if t is null or t.count = 0 then

Line 107: a4 := JTF_VARCHAR2_TABLE_100();

103: a0 := JTF_NUMBER_TABLE();
104: a1 := JTF_NUMBER_TABLE();
105: a2 := JTF_VARCHAR2_TABLE_200();
106: a3 := JTF_VARCHAR2_TABLE_2000();
107: a4 := JTF_VARCHAR2_TABLE_100();
108: a5 := JTF_VARCHAR2_TABLE_100();
109: a6 := JTF_VARCHAR2_TABLE_100();
110: a7 := JTF_VARCHAR2_TABLE_100();
111: a8 := JTF_NUMBER_TABLE();

Line 108: a5 := JTF_VARCHAR2_TABLE_100();

104: a1 := JTF_NUMBER_TABLE();
105: a2 := JTF_VARCHAR2_TABLE_200();
106: a3 := JTF_VARCHAR2_TABLE_2000();
107: a4 := JTF_VARCHAR2_TABLE_100();
108: a5 := JTF_VARCHAR2_TABLE_100();
109: a6 := JTF_VARCHAR2_TABLE_100();
110: a7 := JTF_VARCHAR2_TABLE_100();
111: a8 := JTF_NUMBER_TABLE();
112: a9 := JTF_NUMBER_TABLE();

Line 109: a6 := JTF_VARCHAR2_TABLE_100();

105: a2 := JTF_VARCHAR2_TABLE_200();
106: a3 := JTF_VARCHAR2_TABLE_2000();
107: a4 := JTF_VARCHAR2_TABLE_100();
108: a5 := JTF_VARCHAR2_TABLE_100();
109: a6 := JTF_VARCHAR2_TABLE_100();
110: a7 := JTF_VARCHAR2_TABLE_100();
111: a8 := JTF_NUMBER_TABLE();
112: a9 := JTF_NUMBER_TABLE();
113: a10 := JTF_DATE_TABLE();

Line 110: a7 := JTF_VARCHAR2_TABLE_100();

106: a3 := JTF_VARCHAR2_TABLE_2000();
107: a4 := JTF_VARCHAR2_TABLE_100();
108: a5 := JTF_VARCHAR2_TABLE_100();
109: a6 := JTF_VARCHAR2_TABLE_100();
110: a7 := JTF_VARCHAR2_TABLE_100();
111: a8 := JTF_NUMBER_TABLE();
112: a9 := JTF_NUMBER_TABLE();
113: a10 := JTF_DATE_TABLE();
114: a11 := JTF_NUMBER_TABLE();

Line 117: a14 := JTF_VARCHAR2_TABLE_100();

113: a10 := JTF_DATE_TABLE();
114: a11 := JTF_NUMBER_TABLE();
115: a12 := JTF_DATE_TABLE();
116: a13 := JTF_NUMBER_TABLE();
117: a14 := JTF_VARCHAR2_TABLE_100();
118: a15 := JTF_VARCHAR2_TABLE_100();
119: a16 := JTF_VARCHAR2_TABLE_100();
120: a17 := JTF_VARCHAR2_TABLE_100();
121: a18 := JTF_VARCHAR2_TABLE_100();

Line 118: a15 := JTF_VARCHAR2_TABLE_100();

114: a11 := JTF_NUMBER_TABLE();
115: a12 := JTF_DATE_TABLE();
116: a13 := JTF_NUMBER_TABLE();
117: a14 := JTF_VARCHAR2_TABLE_100();
118: a15 := JTF_VARCHAR2_TABLE_100();
119: a16 := JTF_VARCHAR2_TABLE_100();
120: a17 := JTF_VARCHAR2_TABLE_100();
121: a18 := JTF_VARCHAR2_TABLE_100();
122: else

Line 119: a16 := JTF_VARCHAR2_TABLE_100();

115: a12 := JTF_DATE_TABLE();
116: a13 := JTF_NUMBER_TABLE();
117: a14 := JTF_VARCHAR2_TABLE_100();
118: a15 := JTF_VARCHAR2_TABLE_100();
119: a16 := JTF_VARCHAR2_TABLE_100();
120: a17 := JTF_VARCHAR2_TABLE_100();
121: a18 := JTF_VARCHAR2_TABLE_100();
122: else
123: a0 := JTF_NUMBER_TABLE();

Line 120: a17 := JTF_VARCHAR2_TABLE_100();

116: a13 := JTF_NUMBER_TABLE();
117: a14 := JTF_VARCHAR2_TABLE_100();
118: a15 := JTF_VARCHAR2_TABLE_100();
119: a16 := JTF_VARCHAR2_TABLE_100();
120: a17 := JTF_VARCHAR2_TABLE_100();
121: a18 := JTF_VARCHAR2_TABLE_100();
122: else
123: a0 := JTF_NUMBER_TABLE();
124: a1 := JTF_NUMBER_TABLE();

Line 121: a18 := JTF_VARCHAR2_TABLE_100();

117: a14 := JTF_VARCHAR2_TABLE_100();
118: a15 := JTF_VARCHAR2_TABLE_100();
119: a16 := JTF_VARCHAR2_TABLE_100();
120: a17 := JTF_VARCHAR2_TABLE_100();
121: a18 := JTF_VARCHAR2_TABLE_100();
122: else
123: a0 := JTF_NUMBER_TABLE();
124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_VARCHAR2_TABLE_200();

Line 127: a4 := JTF_VARCHAR2_TABLE_100();

123: a0 := JTF_NUMBER_TABLE();
124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_VARCHAR2_TABLE_200();
126: a3 := JTF_VARCHAR2_TABLE_2000();
127: a4 := JTF_VARCHAR2_TABLE_100();
128: a5 := JTF_VARCHAR2_TABLE_100();
129: a6 := JTF_VARCHAR2_TABLE_100();
130: a7 := JTF_VARCHAR2_TABLE_100();
131: a8 := JTF_NUMBER_TABLE();

Line 128: a5 := JTF_VARCHAR2_TABLE_100();

124: a1 := JTF_NUMBER_TABLE();
125: a2 := JTF_VARCHAR2_TABLE_200();
126: a3 := JTF_VARCHAR2_TABLE_2000();
127: a4 := JTF_VARCHAR2_TABLE_100();
128: a5 := JTF_VARCHAR2_TABLE_100();
129: a6 := JTF_VARCHAR2_TABLE_100();
130: a7 := JTF_VARCHAR2_TABLE_100();
131: a8 := JTF_NUMBER_TABLE();
132: a9 := JTF_NUMBER_TABLE();

Line 129: a6 := JTF_VARCHAR2_TABLE_100();

125: a2 := JTF_VARCHAR2_TABLE_200();
126: a3 := JTF_VARCHAR2_TABLE_2000();
127: a4 := JTF_VARCHAR2_TABLE_100();
128: a5 := JTF_VARCHAR2_TABLE_100();
129: a6 := JTF_VARCHAR2_TABLE_100();
130: a7 := JTF_VARCHAR2_TABLE_100();
131: a8 := JTF_NUMBER_TABLE();
132: a9 := JTF_NUMBER_TABLE();
133: a10 := JTF_DATE_TABLE();

Line 130: a7 := JTF_VARCHAR2_TABLE_100();

126: a3 := JTF_VARCHAR2_TABLE_2000();
127: a4 := JTF_VARCHAR2_TABLE_100();
128: a5 := JTF_VARCHAR2_TABLE_100();
129: a6 := JTF_VARCHAR2_TABLE_100();
130: a7 := JTF_VARCHAR2_TABLE_100();
131: a8 := JTF_NUMBER_TABLE();
132: a9 := JTF_NUMBER_TABLE();
133: a10 := JTF_DATE_TABLE();
134: a11 := JTF_NUMBER_TABLE();

Line 137: a14 := JTF_VARCHAR2_TABLE_100();

133: a10 := JTF_DATE_TABLE();
134: a11 := JTF_NUMBER_TABLE();
135: a12 := JTF_DATE_TABLE();
136: a13 := JTF_NUMBER_TABLE();
137: a14 := JTF_VARCHAR2_TABLE_100();
138: a15 := JTF_VARCHAR2_TABLE_100();
139: a16 := JTF_VARCHAR2_TABLE_100();
140: a17 := JTF_VARCHAR2_TABLE_100();
141: a18 := JTF_VARCHAR2_TABLE_100();

Line 138: a15 := JTF_VARCHAR2_TABLE_100();

134: a11 := JTF_NUMBER_TABLE();
135: a12 := JTF_DATE_TABLE();
136: a13 := JTF_NUMBER_TABLE();
137: a14 := JTF_VARCHAR2_TABLE_100();
138: a15 := JTF_VARCHAR2_TABLE_100();
139: a16 := JTF_VARCHAR2_TABLE_100();
140: a17 := JTF_VARCHAR2_TABLE_100();
141: a18 := JTF_VARCHAR2_TABLE_100();
142: if t.count > 0 then

Line 139: a16 := JTF_VARCHAR2_TABLE_100();

135: a12 := JTF_DATE_TABLE();
136: a13 := JTF_NUMBER_TABLE();
137: a14 := JTF_VARCHAR2_TABLE_100();
138: a15 := JTF_VARCHAR2_TABLE_100();
139: a16 := JTF_VARCHAR2_TABLE_100();
140: a17 := JTF_VARCHAR2_TABLE_100();
141: a18 := JTF_VARCHAR2_TABLE_100();
142: if t.count > 0 then
143: a0.extend(t.count);

Line 140: a17 := JTF_VARCHAR2_TABLE_100();

136: a13 := JTF_NUMBER_TABLE();
137: a14 := JTF_VARCHAR2_TABLE_100();
138: a15 := JTF_VARCHAR2_TABLE_100();
139: a16 := JTF_VARCHAR2_TABLE_100();
140: a17 := JTF_VARCHAR2_TABLE_100();
141: a18 := JTF_VARCHAR2_TABLE_100();
142: if t.count > 0 then
143: a0.extend(t.count);
144: a1.extend(t.count);

Line 141: a18 := JTF_VARCHAR2_TABLE_100();

137: a14 := JTF_VARCHAR2_TABLE_100();
138: a15 := JTF_VARCHAR2_TABLE_100();
139: a16 := JTF_VARCHAR2_TABLE_100();
140: a17 := JTF_VARCHAR2_TABLE_100();
141: a18 := JTF_VARCHAR2_TABLE_100();
142: if t.count > 0 then
143: a0.extend(t.count);
144: a1.extend(t.count);
145: a2.extend(t.count);

Line 198: , a4 JTF_VARCHAR2_TABLE_100

194: procedure rosetta_table_copy_in_p5(t out nocopy okl_gts_pvt.gtsv_tbl_type, a0 JTF_NUMBER_TABLE
195: , a1 JTF_NUMBER_TABLE
196: , a2 JTF_VARCHAR2_TABLE_200
197: , a3 JTF_VARCHAR2_TABLE_2000
198: , a4 JTF_VARCHAR2_TABLE_100
199: , a5 JTF_VARCHAR2_TABLE_100
200: , a6 JTF_VARCHAR2_TABLE_100
201: , a7 JTF_VARCHAR2_TABLE_100
202: , a8 JTF_NUMBER_TABLE

Line 199: , a5 JTF_VARCHAR2_TABLE_100

195: , a1 JTF_NUMBER_TABLE
196: , a2 JTF_VARCHAR2_TABLE_200
197: , a3 JTF_VARCHAR2_TABLE_2000
198: , a4 JTF_VARCHAR2_TABLE_100
199: , a5 JTF_VARCHAR2_TABLE_100
200: , a6 JTF_VARCHAR2_TABLE_100
201: , a7 JTF_VARCHAR2_TABLE_100
202: , a8 JTF_NUMBER_TABLE
203: , a9 JTF_NUMBER_TABLE

Line 200: , a6 JTF_VARCHAR2_TABLE_100

196: , a2 JTF_VARCHAR2_TABLE_200
197: , a3 JTF_VARCHAR2_TABLE_2000
198: , a4 JTF_VARCHAR2_TABLE_100
199: , a5 JTF_VARCHAR2_TABLE_100
200: , a6 JTF_VARCHAR2_TABLE_100
201: , a7 JTF_VARCHAR2_TABLE_100
202: , a8 JTF_NUMBER_TABLE
203: , a9 JTF_NUMBER_TABLE
204: , a10 JTF_DATE_TABLE

Line 201: , a7 JTF_VARCHAR2_TABLE_100

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

Line 208: , a14 JTF_VARCHAR2_TABLE_100

204: , a10 JTF_DATE_TABLE
205: , a11 JTF_NUMBER_TABLE
206: , a12 JTF_DATE_TABLE
207: , a13 JTF_NUMBER_TABLE
208: , a14 JTF_VARCHAR2_TABLE_100
209: , a15 JTF_VARCHAR2_TABLE_100
210: , a16 JTF_VARCHAR2_TABLE_100
211: , a17 JTF_VARCHAR2_TABLE_100
212: , a18 JTF_VARCHAR2_TABLE_100

Line 209: , a15 JTF_VARCHAR2_TABLE_100

205: , a11 JTF_NUMBER_TABLE
206: , a12 JTF_DATE_TABLE
207: , a13 JTF_NUMBER_TABLE
208: , a14 JTF_VARCHAR2_TABLE_100
209: , a15 JTF_VARCHAR2_TABLE_100
210: , a16 JTF_VARCHAR2_TABLE_100
211: , a17 JTF_VARCHAR2_TABLE_100
212: , a18 JTF_VARCHAR2_TABLE_100
213: ) as

Line 210: , a16 JTF_VARCHAR2_TABLE_100

206: , a12 JTF_DATE_TABLE
207: , a13 JTF_NUMBER_TABLE
208: , a14 JTF_VARCHAR2_TABLE_100
209: , a15 JTF_VARCHAR2_TABLE_100
210: , a16 JTF_VARCHAR2_TABLE_100
211: , a17 JTF_VARCHAR2_TABLE_100
212: , a18 JTF_VARCHAR2_TABLE_100
213: ) as
214: ddindx binary_integer; indx binary_integer;

Line 211: , a17 JTF_VARCHAR2_TABLE_100

207: , a13 JTF_NUMBER_TABLE
208: , a14 JTF_VARCHAR2_TABLE_100
209: , a15 JTF_VARCHAR2_TABLE_100
210: , a16 JTF_VARCHAR2_TABLE_100
211: , a17 JTF_VARCHAR2_TABLE_100
212: , a18 JTF_VARCHAR2_TABLE_100
213: ) as
214: ddindx binary_integer; indx binary_integer;
215: begin

Line 212: , a18 JTF_VARCHAR2_TABLE_100

208: , a14 JTF_VARCHAR2_TABLE_100
209: , a15 JTF_VARCHAR2_TABLE_100
210: , a16 JTF_VARCHAR2_TABLE_100
211: , a17 JTF_VARCHAR2_TABLE_100
212: , a18 JTF_VARCHAR2_TABLE_100
213: ) as
214: ddindx binary_integer; indx binary_integer;
215: begin
216: if a0 is not null and a0.count > 0 then

Line 253: , a4 out nocopy JTF_VARCHAR2_TABLE_100

249: procedure rosetta_table_copy_out_p5(t okl_gts_pvt.gtsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
250: , a1 out nocopy JTF_NUMBER_TABLE
251: , a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
253: , a4 out nocopy JTF_VARCHAR2_TABLE_100
254: , a5 out nocopy JTF_VARCHAR2_TABLE_100
255: , a6 out nocopy JTF_VARCHAR2_TABLE_100
256: , a7 out nocopy JTF_VARCHAR2_TABLE_100
257: , a8 out nocopy JTF_NUMBER_TABLE

Line 254: , a5 out nocopy JTF_VARCHAR2_TABLE_100

250: , a1 out nocopy JTF_NUMBER_TABLE
251: , a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
253: , a4 out nocopy JTF_VARCHAR2_TABLE_100
254: , a5 out nocopy JTF_VARCHAR2_TABLE_100
255: , a6 out nocopy JTF_VARCHAR2_TABLE_100
256: , a7 out nocopy JTF_VARCHAR2_TABLE_100
257: , a8 out nocopy JTF_NUMBER_TABLE
258: , a9 out nocopy JTF_NUMBER_TABLE

Line 255: , a6 out nocopy JTF_VARCHAR2_TABLE_100

251: , a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
253: , a4 out nocopy JTF_VARCHAR2_TABLE_100
254: , a5 out nocopy JTF_VARCHAR2_TABLE_100
255: , a6 out nocopy JTF_VARCHAR2_TABLE_100
256: , a7 out nocopy JTF_VARCHAR2_TABLE_100
257: , a8 out nocopy JTF_NUMBER_TABLE
258: , a9 out nocopy JTF_NUMBER_TABLE
259: , a10 out nocopy JTF_DATE_TABLE

Line 256: , a7 out nocopy JTF_VARCHAR2_TABLE_100

252: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
253: , a4 out nocopy JTF_VARCHAR2_TABLE_100
254: , a5 out nocopy JTF_VARCHAR2_TABLE_100
255: , a6 out nocopy JTF_VARCHAR2_TABLE_100
256: , a7 out nocopy JTF_VARCHAR2_TABLE_100
257: , a8 out nocopy JTF_NUMBER_TABLE
258: , a9 out nocopy JTF_NUMBER_TABLE
259: , a10 out nocopy JTF_DATE_TABLE
260: , a11 out nocopy JTF_NUMBER_TABLE

Line 263: , a14 out nocopy JTF_VARCHAR2_TABLE_100

259: , a10 out nocopy JTF_DATE_TABLE
260: , a11 out nocopy JTF_NUMBER_TABLE
261: , a12 out nocopy JTF_DATE_TABLE
262: , a13 out nocopy JTF_NUMBER_TABLE
263: , a14 out nocopy JTF_VARCHAR2_TABLE_100
264: , a15 out nocopy JTF_VARCHAR2_TABLE_100
265: , a16 out nocopy JTF_VARCHAR2_TABLE_100
266: , a17 out nocopy JTF_VARCHAR2_TABLE_100
267: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 264: , a15 out nocopy JTF_VARCHAR2_TABLE_100

260: , a11 out nocopy JTF_NUMBER_TABLE
261: , a12 out nocopy JTF_DATE_TABLE
262: , a13 out nocopy JTF_NUMBER_TABLE
263: , a14 out nocopy JTF_VARCHAR2_TABLE_100
264: , a15 out nocopy JTF_VARCHAR2_TABLE_100
265: , a16 out nocopy JTF_VARCHAR2_TABLE_100
266: , a17 out nocopy JTF_VARCHAR2_TABLE_100
267: , a18 out nocopy JTF_VARCHAR2_TABLE_100
268: ) as

Line 265: , a16 out nocopy JTF_VARCHAR2_TABLE_100

261: , a12 out nocopy JTF_DATE_TABLE
262: , a13 out nocopy JTF_NUMBER_TABLE
263: , a14 out nocopy JTF_VARCHAR2_TABLE_100
264: , a15 out nocopy JTF_VARCHAR2_TABLE_100
265: , a16 out nocopy JTF_VARCHAR2_TABLE_100
266: , a17 out nocopy JTF_VARCHAR2_TABLE_100
267: , a18 out nocopy JTF_VARCHAR2_TABLE_100
268: ) as
269: ddindx binary_integer; indx binary_integer;

Line 266: , a17 out nocopy JTF_VARCHAR2_TABLE_100

262: , a13 out nocopy JTF_NUMBER_TABLE
263: , a14 out nocopy JTF_VARCHAR2_TABLE_100
264: , a15 out nocopy JTF_VARCHAR2_TABLE_100
265: , a16 out nocopy JTF_VARCHAR2_TABLE_100
266: , a17 out nocopy JTF_VARCHAR2_TABLE_100
267: , a18 out nocopy JTF_VARCHAR2_TABLE_100
268: ) as
269: ddindx binary_integer; indx binary_integer;
270: begin

Line 267: , a18 out nocopy JTF_VARCHAR2_TABLE_100

263: , a14 out nocopy JTF_VARCHAR2_TABLE_100
264: , a15 out nocopy JTF_VARCHAR2_TABLE_100
265: , a16 out nocopy JTF_VARCHAR2_TABLE_100
266: , a17 out nocopy JTF_VARCHAR2_TABLE_100
267: , a18 out nocopy JTF_VARCHAR2_TABLE_100
268: ) as
269: ddindx binary_integer; indx binary_integer;
270: begin
271: if t is null or t.count = 0 then

Line 276: a4 := JTF_VARCHAR2_TABLE_100();

272: a0 := JTF_NUMBER_TABLE();
273: a1 := JTF_NUMBER_TABLE();
274: a2 := JTF_VARCHAR2_TABLE_200();
275: a3 := JTF_VARCHAR2_TABLE_2000();
276: a4 := JTF_VARCHAR2_TABLE_100();
277: a5 := JTF_VARCHAR2_TABLE_100();
278: a6 := JTF_VARCHAR2_TABLE_100();
279: a7 := JTF_VARCHAR2_TABLE_100();
280: a8 := JTF_NUMBER_TABLE();

Line 277: a5 := JTF_VARCHAR2_TABLE_100();

273: a1 := JTF_NUMBER_TABLE();
274: a2 := JTF_VARCHAR2_TABLE_200();
275: a3 := JTF_VARCHAR2_TABLE_2000();
276: a4 := JTF_VARCHAR2_TABLE_100();
277: a5 := JTF_VARCHAR2_TABLE_100();
278: a6 := JTF_VARCHAR2_TABLE_100();
279: a7 := JTF_VARCHAR2_TABLE_100();
280: a8 := JTF_NUMBER_TABLE();
281: a9 := JTF_NUMBER_TABLE();

Line 278: a6 := JTF_VARCHAR2_TABLE_100();

274: a2 := JTF_VARCHAR2_TABLE_200();
275: a3 := JTF_VARCHAR2_TABLE_2000();
276: a4 := JTF_VARCHAR2_TABLE_100();
277: a5 := JTF_VARCHAR2_TABLE_100();
278: a6 := JTF_VARCHAR2_TABLE_100();
279: a7 := JTF_VARCHAR2_TABLE_100();
280: a8 := JTF_NUMBER_TABLE();
281: a9 := JTF_NUMBER_TABLE();
282: a10 := JTF_DATE_TABLE();

Line 279: a7 := JTF_VARCHAR2_TABLE_100();

275: a3 := JTF_VARCHAR2_TABLE_2000();
276: a4 := JTF_VARCHAR2_TABLE_100();
277: a5 := JTF_VARCHAR2_TABLE_100();
278: a6 := JTF_VARCHAR2_TABLE_100();
279: a7 := JTF_VARCHAR2_TABLE_100();
280: a8 := JTF_NUMBER_TABLE();
281: a9 := JTF_NUMBER_TABLE();
282: a10 := JTF_DATE_TABLE();
283: a11 := JTF_NUMBER_TABLE();

Line 286: a14 := JTF_VARCHAR2_TABLE_100();

282: a10 := JTF_DATE_TABLE();
283: a11 := JTF_NUMBER_TABLE();
284: a12 := JTF_DATE_TABLE();
285: a13 := JTF_NUMBER_TABLE();
286: a14 := JTF_VARCHAR2_TABLE_100();
287: a15 := JTF_VARCHAR2_TABLE_100();
288: a16 := JTF_VARCHAR2_TABLE_100();
289: a17 := JTF_VARCHAR2_TABLE_100();
290: a18 := JTF_VARCHAR2_TABLE_100();

Line 287: a15 := JTF_VARCHAR2_TABLE_100();

283: a11 := JTF_NUMBER_TABLE();
284: a12 := JTF_DATE_TABLE();
285: a13 := JTF_NUMBER_TABLE();
286: a14 := JTF_VARCHAR2_TABLE_100();
287: a15 := JTF_VARCHAR2_TABLE_100();
288: a16 := JTF_VARCHAR2_TABLE_100();
289: a17 := JTF_VARCHAR2_TABLE_100();
290: a18 := JTF_VARCHAR2_TABLE_100();
291: else

Line 288: a16 := JTF_VARCHAR2_TABLE_100();

284: a12 := JTF_DATE_TABLE();
285: a13 := JTF_NUMBER_TABLE();
286: a14 := JTF_VARCHAR2_TABLE_100();
287: a15 := JTF_VARCHAR2_TABLE_100();
288: a16 := JTF_VARCHAR2_TABLE_100();
289: a17 := JTF_VARCHAR2_TABLE_100();
290: a18 := JTF_VARCHAR2_TABLE_100();
291: else
292: a0 := JTF_NUMBER_TABLE();

Line 289: a17 := JTF_VARCHAR2_TABLE_100();

285: a13 := JTF_NUMBER_TABLE();
286: a14 := JTF_VARCHAR2_TABLE_100();
287: a15 := JTF_VARCHAR2_TABLE_100();
288: a16 := JTF_VARCHAR2_TABLE_100();
289: a17 := JTF_VARCHAR2_TABLE_100();
290: a18 := JTF_VARCHAR2_TABLE_100();
291: else
292: a0 := JTF_NUMBER_TABLE();
293: a1 := JTF_NUMBER_TABLE();

Line 290: a18 := JTF_VARCHAR2_TABLE_100();

286: a14 := JTF_VARCHAR2_TABLE_100();
287: a15 := JTF_VARCHAR2_TABLE_100();
288: a16 := JTF_VARCHAR2_TABLE_100();
289: a17 := JTF_VARCHAR2_TABLE_100();
290: a18 := JTF_VARCHAR2_TABLE_100();
291: else
292: a0 := JTF_NUMBER_TABLE();
293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_VARCHAR2_TABLE_200();

Line 296: a4 := JTF_VARCHAR2_TABLE_100();

292: a0 := JTF_NUMBER_TABLE();
293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_VARCHAR2_TABLE_200();
295: a3 := JTF_VARCHAR2_TABLE_2000();
296: a4 := JTF_VARCHAR2_TABLE_100();
297: a5 := JTF_VARCHAR2_TABLE_100();
298: a6 := JTF_VARCHAR2_TABLE_100();
299: a7 := JTF_VARCHAR2_TABLE_100();
300: a8 := JTF_NUMBER_TABLE();

Line 297: a5 := JTF_VARCHAR2_TABLE_100();

293: a1 := JTF_NUMBER_TABLE();
294: a2 := JTF_VARCHAR2_TABLE_200();
295: a3 := JTF_VARCHAR2_TABLE_2000();
296: a4 := JTF_VARCHAR2_TABLE_100();
297: a5 := JTF_VARCHAR2_TABLE_100();
298: a6 := JTF_VARCHAR2_TABLE_100();
299: a7 := JTF_VARCHAR2_TABLE_100();
300: a8 := JTF_NUMBER_TABLE();
301: a9 := JTF_NUMBER_TABLE();

Line 298: a6 := JTF_VARCHAR2_TABLE_100();

294: a2 := JTF_VARCHAR2_TABLE_200();
295: a3 := JTF_VARCHAR2_TABLE_2000();
296: a4 := JTF_VARCHAR2_TABLE_100();
297: a5 := JTF_VARCHAR2_TABLE_100();
298: a6 := JTF_VARCHAR2_TABLE_100();
299: a7 := JTF_VARCHAR2_TABLE_100();
300: a8 := JTF_NUMBER_TABLE();
301: a9 := JTF_NUMBER_TABLE();
302: a10 := JTF_DATE_TABLE();

Line 299: a7 := JTF_VARCHAR2_TABLE_100();

295: a3 := JTF_VARCHAR2_TABLE_2000();
296: a4 := JTF_VARCHAR2_TABLE_100();
297: a5 := JTF_VARCHAR2_TABLE_100();
298: a6 := JTF_VARCHAR2_TABLE_100();
299: a7 := JTF_VARCHAR2_TABLE_100();
300: a8 := JTF_NUMBER_TABLE();
301: a9 := JTF_NUMBER_TABLE();
302: a10 := JTF_DATE_TABLE();
303: a11 := JTF_NUMBER_TABLE();

Line 306: a14 := JTF_VARCHAR2_TABLE_100();

302: a10 := JTF_DATE_TABLE();
303: a11 := JTF_NUMBER_TABLE();
304: a12 := JTF_DATE_TABLE();
305: a13 := JTF_NUMBER_TABLE();
306: a14 := JTF_VARCHAR2_TABLE_100();
307: a15 := JTF_VARCHAR2_TABLE_100();
308: a16 := JTF_VARCHAR2_TABLE_100();
309: a17 := JTF_VARCHAR2_TABLE_100();
310: a18 := JTF_VARCHAR2_TABLE_100();

Line 307: a15 := JTF_VARCHAR2_TABLE_100();

303: a11 := JTF_NUMBER_TABLE();
304: a12 := JTF_DATE_TABLE();
305: a13 := JTF_NUMBER_TABLE();
306: a14 := JTF_VARCHAR2_TABLE_100();
307: a15 := JTF_VARCHAR2_TABLE_100();
308: a16 := JTF_VARCHAR2_TABLE_100();
309: a17 := JTF_VARCHAR2_TABLE_100();
310: a18 := JTF_VARCHAR2_TABLE_100();
311: if t.count > 0 then

Line 308: a16 := JTF_VARCHAR2_TABLE_100();

304: a12 := JTF_DATE_TABLE();
305: a13 := JTF_NUMBER_TABLE();
306: a14 := JTF_VARCHAR2_TABLE_100();
307: a15 := JTF_VARCHAR2_TABLE_100();
308: a16 := JTF_VARCHAR2_TABLE_100();
309: a17 := JTF_VARCHAR2_TABLE_100();
310: a18 := JTF_VARCHAR2_TABLE_100();
311: if t.count > 0 then
312: a0.extend(t.count);

Line 309: a17 := JTF_VARCHAR2_TABLE_100();

305: a13 := JTF_NUMBER_TABLE();
306: a14 := JTF_VARCHAR2_TABLE_100();
307: a15 := JTF_VARCHAR2_TABLE_100();
308: a16 := JTF_VARCHAR2_TABLE_100();
309: a17 := JTF_VARCHAR2_TABLE_100();
310: a18 := JTF_VARCHAR2_TABLE_100();
311: if t.count > 0 then
312: a0.extend(t.count);
313: a1.extend(t.count);

Line 310: a18 := JTF_VARCHAR2_TABLE_100();

306: a14 := JTF_VARCHAR2_TABLE_100();
307: a15 := JTF_VARCHAR2_TABLE_100();
308: a16 := JTF_VARCHAR2_TABLE_100();
309: a17 := JTF_VARCHAR2_TABLE_100();
310: a18 := JTF_VARCHAR2_TABLE_100();
311: if t.count > 0 then
312: a0.extend(t.count);
313: a1.extend(t.count);
314: a2.extend(t.count);

Line 487: , p5_a4 JTF_VARCHAR2_TABLE_100

483: , p5_a0 JTF_NUMBER_TABLE
484: , p5_a1 JTF_NUMBER_TABLE
485: , p5_a2 JTF_VARCHAR2_TABLE_200
486: , p5_a3 JTF_VARCHAR2_TABLE_2000
487: , p5_a4 JTF_VARCHAR2_TABLE_100
488: , p5_a5 JTF_VARCHAR2_TABLE_100
489: , p5_a6 JTF_VARCHAR2_TABLE_100
490: , p5_a7 JTF_VARCHAR2_TABLE_100
491: , p5_a8 JTF_NUMBER_TABLE

Line 488: , p5_a5 JTF_VARCHAR2_TABLE_100

484: , p5_a1 JTF_NUMBER_TABLE
485: , p5_a2 JTF_VARCHAR2_TABLE_200
486: , p5_a3 JTF_VARCHAR2_TABLE_2000
487: , p5_a4 JTF_VARCHAR2_TABLE_100
488: , p5_a5 JTF_VARCHAR2_TABLE_100
489: , p5_a6 JTF_VARCHAR2_TABLE_100
490: , p5_a7 JTF_VARCHAR2_TABLE_100
491: , p5_a8 JTF_NUMBER_TABLE
492: , p5_a9 JTF_NUMBER_TABLE

Line 489: , p5_a6 JTF_VARCHAR2_TABLE_100

485: , p5_a2 JTF_VARCHAR2_TABLE_200
486: , p5_a3 JTF_VARCHAR2_TABLE_2000
487: , p5_a4 JTF_VARCHAR2_TABLE_100
488: , p5_a5 JTF_VARCHAR2_TABLE_100
489: , p5_a6 JTF_VARCHAR2_TABLE_100
490: , p5_a7 JTF_VARCHAR2_TABLE_100
491: , p5_a8 JTF_NUMBER_TABLE
492: , p5_a9 JTF_NUMBER_TABLE
493: , p5_a10 JTF_DATE_TABLE

Line 490: , p5_a7 JTF_VARCHAR2_TABLE_100

486: , p5_a3 JTF_VARCHAR2_TABLE_2000
487: , p5_a4 JTF_VARCHAR2_TABLE_100
488: , p5_a5 JTF_VARCHAR2_TABLE_100
489: , p5_a6 JTF_VARCHAR2_TABLE_100
490: , p5_a7 JTF_VARCHAR2_TABLE_100
491: , p5_a8 JTF_NUMBER_TABLE
492: , p5_a9 JTF_NUMBER_TABLE
493: , p5_a10 JTF_DATE_TABLE
494: , p5_a11 JTF_NUMBER_TABLE

Line 497: , p5_a14 JTF_VARCHAR2_TABLE_100

493: , p5_a10 JTF_DATE_TABLE
494: , p5_a11 JTF_NUMBER_TABLE
495: , p5_a12 JTF_DATE_TABLE
496: , p5_a13 JTF_NUMBER_TABLE
497: , p5_a14 JTF_VARCHAR2_TABLE_100
498: , p5_a15 JTF_VARCHAR2_TABLE_100
499: , p5_a16 JTF_VARCHAR2_TABLE_100
500: , p5_a17 JTF_VARCHAR2_TABLE_100
501: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 498: , p5_a15 JTF_VARCHAR2_TABLE_100

494: , p5_a11 JTF_NUMBER_TABLE
495: , p5_a12 JTF_DATE_TABLE
496: , p5_a13 JTF_NUMBER_TABLE
497: , p5_a14 JTF_VARCHAR2_TABLE_100
498: , p5_a15 JTF_VARCHAR2_TABLE_100
499: , p5_a16 JTF_VARCHAR2_TABLE_100
500: , p5_a17 JTF_VARCHAR2_TABLE_100
501: , p5_a18 JTF_VARCHAR2_TABLE_100
502: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 499: , p5_a16 JTF_VARCHAR2_TABLE_100

495: , p5_a12 JTF_DATE_TABLE
496: , p5_a13 JTF_NUMBER_TABLE
497: , p5_a14 JTF_VARCHAR2_TABLE_100
498: , p5_a15 JTF_VARCHAR2_TABLE_100
499: , p5_a16 JTF_VARCHAR2_TABLE_100
500: , p5_a17 JTF_VARCHAR2_TABLE_100
501: , p5_a18 JTF_VARCHAR2_TABLE_100
502: , p6_a0 out nocopy JTF_NUMBER_TABLE
503: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 500: , p5_a17 JTF_VARCHAR2_TABLE_100

496: , p5_a13 JTF_NUMBER_TABLE
497: , p5_a14 JTF_VARCHAR2_TABLE_100
498: , p5_a15 JTF_VARCHAR2_TABLE_100
499: , p5_a16 JTF_VARCHAR2_TABLE_100
500: , p5_a17 JTF_VARCHAR2_TABLE_100
501: , p5_a18 JTF_VARCHAR2_TABLE_100
502: , p6_a0 out nocopy JTF_NUMBER_TABLE
503: , p6_a1 out nocopy JTF_NUMBER_TABLE
504: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 501: , p5_a18 JTF_VARCHAR2_TABLE_100

497: , p5_a14 JTF_VARCHAR2_TABLE_100
498: , p5_a15 JTF_VARCHAR2_TABLE_100
499: , p5_a16 JTF_VARCHAR2_TABLE_100
500: , p5_a17 JTF_VARCHAR2_TABLE_100
501: , p5_a18 JTF_VARCHAR2_TABLE_100
502: , p6_a0 out nocopy JTF_NUMBER_TABLE
503: , p6_a1 out nocopy JTF_NUMBER_TABLE
504: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
505: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

Line 506: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

502: , p6_a0 out nocopy JTF_NUMBER_TABLE
503: , p6_a1 out nocopy JTF_NUMBER_TABLE
504: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
505: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
506: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
507: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
508: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
509: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
510: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 507: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

503: , p6_a1 out nocopy JTF_NUMBER_TABLE
504: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
505: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
506: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
507: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
508: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
509: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
510: , p6_a8 out nocopy JTF_NUMBER_TABLE
511: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 508: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

504: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
505: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
506: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
507: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
508: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
509: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
510: , p6_a8 out nocopy JTF_NUMBER_TABLE
511: , p6_a9 out nocopy JTF_NUMBER_TABLE
512: , p6_a10 out nocopy JTF_DATE_TABLE

Line 509: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

505: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
506: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
507: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
508: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
509: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
510: , p6_a8 out nocopy JTF_NUMBER_TABLE
511: , p6_a9 out nocopy JTF_NUMBER_TABLE
512: , p6_a10 out nocopy JTF_DATE_TABLE
513: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 516: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

512: , p6_a10 out nocopy JTF_DATE_TABLE
513: , p6_a11 out nocopy JTF_NUMBER_TABLE
514: , p6_a12 out nocopy JTF_DATE_TABLE
515: , p6_a13 out nocopy JTF_NUMBER_TABLE
516: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
517: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
518: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
519: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
520: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 517: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

513: , p6_a11 out nocopy JTF_NUMBER_TABLE
514: , p6_a12 out nocopy JTF_DATE_TABLE
515: , p6_a13 out nocopy JTF_NUMBER_TABLE
516: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
517: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
518: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
519: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
520: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
521: )

Line 518: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

514: , p6_a12 out nocopy JTF_DATE_TABLE
515: , p6_a13 out nocopy JTF_NUMBER_TABLE
516: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
517: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
518: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
519: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
520: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
521: )
522:

Line 519: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

515: , p6_a13 out nocopy JTF_NUMBER_TABLE
516: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
517: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
518: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
519: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
520: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
521: )
522:
523: as

Line 520: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

516: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
517: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
518: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
519: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
520: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
521: )
522:
523: as
524: ddp_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;

Line 719: , p5_a4 JTF_VARCHAR2_TABLE_100

715: , p5_a0 JTF_NUMBER_TABLE
716: , p5_a1 JTF_NUMBER_TABLE
717: , p5_a2 JTF_VARCHAR2_TABLE_200
718: , p5_a3 JTF_VARCHAR2_TABLE_2000
719: , p5_a4 JTF_VARCHAR2_TABLE_100
720: , p5_a5 JTF_VARCHAR2_TABLE_100
721: , p5_a6 JTF_VARCHAR2_TABLE_100
722: , p5_a7 JTF_VARCHAR2_TABLE_100
723: , p5_a8 JTF_NUMBER_TABLE

Line 720: , p5_a5 JTF_VARCHAR2_TABLE_100

716: , p5_a1 JTF_NUMBER_TABLE
717: , p5_a2 JTF_VARCHAR2_TABLE_200
718: , p5_a3 JTF_VARCHAR2_TABLE_2000
719: , p5_a4 JTF_VARCHAR2_TABLE_100
720: , p5_a5 JTF_VARCHAR2_TABLE_100
721: , p5_a6 JTF_VARCHAR2_TABLE_100
722: , p5_a7 JTF_VARCHAR2_TABLE_100
723: , p5_a8 JTF_NUMBER_TABLE
724: , p5_a9 JTF_NUMBER_TABLE

Line 721: , p5_a6 JTF_VARCHAR2_TABLE_100

717: , p5_a2 JTF_VARCHAR2_TABLE_200
718: , p5_a3 JTF_VARCHAR2_TABLE_2000
719: , p5_a4 JTF_VARCHAR2_TABLE_100
720: , p5_a5 JTF_VARCHAR2_TABLE_100
721: , p5_a6 JTF_VARCHAR2_TABLE_100
722: , p5_a7 JTF_VARCHAR2_TABLE_100
723: , p5_a8 JTF_NUMBER_TABLE
724: , p5_a9 JTF_NUMBER_TABLE
725: , p5_a10 JTF_DATE_TABLE

Line 722: , p5_a7 JTF_VARCHAR2_TABLE_100

718: , p5_a3 JTF_VARCHAR2_TABLE_2000
719: , p5_a4 JTF_VARCHAR2_TABLE_100
720: , p5_a5 JTF_VARCHAR2_TABLE_100
721: , p5_a6 JTF_VARCHAR2_TABLE_100
722: , p5_a7 JTF_VARCHAR2_TABLE_100
723: , p5_a8 JTF_NUMBER_TABLE
724: , p5_a9 JTF_NUMBER_TABLE
725: , p5_a10 JTF_DATE_TABLE
726: , p5_a11 JTF_NUMBER_TABLE

Line 729: , p5_a14 JTF_VARCHAR2_TABLE_100

725: , p5_a10 JTF_DATE_TABLE
726: , p5_a11 JTF_NUMBER_TABLE
727: , p5_a12 JTF_DATE_TABLE
728: , p5_a13 JTF_NUMBER_TABLE
729: , p5_a14 JTF_VARCHAR2_TABLE_100
730: , p5_a15 JTF_VARCHAR2_TABLE_100
731: , p5_a16 JTF_VARCHAR2_TABLE_100
732: , p5_a17 JTF_VARCHAR2_TABLE_100
733: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 730: , p5_a15 JTF_VARCHAR2_TABLE_100

726: , p5_a11 JTF_NUMBER_TABLE
727: , p5_a12 JTF_DATE_TABLE
728: , p5_a13 JTF_NUMBER_TABLE
729: , p5_a14 JTF_VARCHAR2_TABLE_100
730: , p5_a15 JTF_VARCHAR2_TABLE_100
731: , p5_a16 JTF_VARCHAR2_TABLE_100
732: , p5_a17 JTF_VARCHAR2_TABLE_100
733: , p5_a18 JTF_VARCHAR2_TABLE_100
734: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 731: , p5_a16 JTF_VARCHAR2_TABLE_100

727: , p5_a12 JTF_DATE_TABLE
728: , p5_a13 JTF_NUMBER_TABLE
729: , p5_a14 JTF_VARCHAR2_TABLE_100
730: , p5_a15 JTF_VARCHAR2_TABLE_100
731: , p5_a16 JTF_VARCHAR2_TABLE_100
732: , p5_a17 JTF_VARCHAR2_TABLE_100
733: , p5_a18 JTF_VARCHAR2_TABLE_100
734: , p6_a0 out nocopy JTF_NUMBER_TABLE
735: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 732: , p5_a17 JTF_VARCHAR2_TABLE_100

728: , p5_a13 JTF_NUMBER_TABLE
729: , p5_a14 JTF_VARCHAR2_TABLE_100
730: , p5_a15 JTF_VARCHAR2_TABLE_100
731: , p5_a16 JTF_VARCHAR2_TABLE_100
732: , p5_a17 JTF_VARCHAR2_TABLE_100
733: , p5_a18 JTF_VARCHAR2_TABLE_100
734: , p6_a0 out nocopy JTF_NUMBER_TABLE
735: , p6_a1 out nocopy JTF_NUMBER_TABLE
736: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 733: , p5_a18 JTF_VARCHAR2_TABLE_100

729: , p5_a14 JTF_VARCHAR2_TABLE_100
730: , p5_a15 JTF_VARCHAR2_TABLE_100
731: , p5_a16 JTF_VARCHAR2_TABLE_100
732: , p5_a17 JTF_VARCHAR2_TABLE_100
733: , p5_a18 JTF_VARCHAR2_TABLE_100
734: , p6_a0 out nocopy JTF_NUMBER_TABLE
735: , p6_a1 out nocopy JTF_NUMBER_TABLE
736: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
737: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

Line 738: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

734: , p6_a0 out nocopy JTF_NUMBER_TABLE
735: , p6_a1 out nocopy JTF_NUMBER_TABLE
736: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
737: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
738: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
739: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
740: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
742: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 739: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

735: , p6_a1 out nocopy JTF_NUMBER_TABLE
736: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
737: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
738: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
739: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
740: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
742: , p6_a8 out nocopy JTF_NUMBER_TABLE
743: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 740: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

736: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
737: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
738: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
739: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
740: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
742: , p6_a8 out nocopy JTF_NUMBER_TABLE
743: , p6_a9 out nocopy JTF_NUMBER_TABLE
744: , p6_a10 out nocopy JTF_DATE_TABLE

Line 741: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

737: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
738: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
739: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
740: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
741: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
742: , p6_a8 out nocopy JTF_NUMBER_TABLE
743: , p6_a9 out nocopy JTF_NUMBER_TABLE
744: , p6_a10 out nocopy JTF_DATE_TABLE
745: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 748: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

744: , p6_a10 out nocopy JTF_DATE_TABLE
745: , p6_a11 out nocopy JTF_NUMBER_TABLE
746: , p6_a12 out nocopy JTF_DATE_TABLE
747: , p6_a13 out nocopy JTF_NUMBER_TABLE
748: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
749: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
750: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
751: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
752: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 749: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

745: , p6_a11 out nocopy JTF_NUMBER_TABLE
746: , p6_a12 out nocopy JTF_DATE_TABLE
747: , p6_a13 out nocopy JTF_NUMBER_TABLE
748: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
749: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
750: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
751: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
752: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
753: )

Line 750: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

746: , p6_a12 out nocopy JTF_DATE_TABLE
747: , p6_a13 out nocopy JTF_NUMBER_TABLE
748: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
749: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
750: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
751: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
752: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
753: )
754:

Line 751: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

747: , p6_a13 out nocopy JTF_NUMBER_TABLE
748: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
749: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
750: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
751: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
752: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
753: )
754:
755: as

Line 752: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

748: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
749: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
750: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
751: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
752: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
753: )
754:
755: as
756: ddp_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;

Line 909: , p5_a4 JTF_VARCHAR2_TABLE_100

905: , p5_a0 JTF_NUMBER_TABLE
906: , p5_a1 JTF_NUMBER_TABLE
907: , p5_a2 JTF_VARCHAR2_TABLE_200
908: , p5_a3 JTF_VARCHAR2_TABLE_2000
909: , p5_a4 JTF_VARCHAR2_TABLE_100
910: , p5_a5 JTF_VARCHAR2_TABLE_100
911: , p5_a6 JTF_VARCHAR2_TABLE_100
912: , p5_a7 JTF_VARCHAR2_TABLE_100
913: , p5_a8 JTF_NUMBER_TABLE

Line 910: , p5_a5 JTF_VARCHAR2_TABLE_100

906: , p5_a1 JTF_NUMBER_TABLE
907: , p5_a2 JTF_VARCHAR2_TABLE_200
908: , p5_a3 JTF_VARCHAR2_TABLE_2000
909: , p5_a4 JTF_VARCHAR2_TABLE_100
910: , p5_a5 JTF_VARCHAR2_TABLE_100
911: , p5_a6 JTF_VARCHAR2_TABLE_100
912: , p5_a7 JTF_VARCHAR2_TABLE_100
913: , p5_a8 JTF_NUMBER_TABLE
914: , p5_a9 JTF_NUMBER_TABLE

Line 911: , p5_a6 JTF_VARCHAR2_TABLE_100

907: , p5_a2 JTF_VARCHAR2_TABLE_200
908: , p5_a3 JTF_VARCHAR2_TABLE_2000
909: , p5_a4 JTF_VARCHAR2_TABLE_100
910: , p5_a5 JTF_VARCHAR2_TABLE_100
911: , p5_a6 JTF_VARCHAR2_TABLE_100
912: , p5_a7 JTF_VARCHAR2_TABLE_100
913: , p5_a8 JTF_NUMBER_TABLE
914: , p5_a9 JTF_NUMBER_TABLE
915: , p5_a10 JTF_DATE_TABLE

Line 912: , p5_a7 JTF_VARCHAR2_TABLE_100

908: , p5_a3 JTF_VARCHAR2_TABLE_2000
909: , p5_a4 JTF_VARCHAR2_TABLE_100
910: , p5_a5 JTF_VARCHAR2_TABLE_100
911: , p5_a6 JTF_VARCHAR2_TABLE_100
912: , p5_a7 JTF_VARCHAR2_TABLE_100
913: , p5_a8 JTF_NUMBER_TABLE
914: , p5_a9 JTF_NUMBER_TABLE
915: , p5_a10 JTF_DATE_TABLE
916: , p5_a11 JTF_NUMBER_TABLE

Line 919: , p5_a14 JTF_VARCHAR2_TABLE_100

915: , p5_a10 JTF_DATE_TABLE
916: , p5_a11 JTF_NUMBER_TABLE
917: , p5_a12 JTF_DATE_TABLE
918: , p5_a13 JTF_NUMBER_TABLE
919: , p5_a14 JTF_VARCHAR2_TABLE_100
920: , p5_a15 JTF_VARCHAR2_TABLE_100
921: , p5_a16 JTF_VARCHAR2_TABLE_100
922: , p5_a17 JTF_VARCHAR2_TABLE_100
923: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 920: , p5_a15 JTF_VARCHAR2_TABLE_100

916: , p5_a11 JTF_NUMBER_TABLE
917: , p5_a12 JTF_DATE_TABLE
918: , p5_a13 JTF_NUMBER_TABLE
919: , p5_a14 JTF_VARCHAR2_TABLE_100
920: , p5_a15 JTF_VARCHAR2_TABLE_100
921: , p5_a16 JTF_VARCHAR2_TABLE_100
922: , p5_a17 JTF_VARCHAR2_TABLE_100
923: , p5_a18 JTF_VARCHAR2_TABLE_100
924: )

Line 921: , p5_a16 JTF_VARCHAR2_TABLE_100

917: , p5_a12 JTF_DATE_TABLE
918: , p5_a13 JTF_NUMBER_TABLE
919: , p5_a14 JTF_VARCHAR2_TABLE_100
920: , p5_a15 JTF_VARCHAR2_TABLE_100
921: , p5_a16 JTF_VARCHAR2_TABLE_100
922: , p5_a17 JTF_VARCHAR2_TABLE_100
923: , p5_a18 JTF_VARCHAR2_TABLE_100
924: )
925:

Line 922: , p5_a17 JTF_VARCHAR2_TABLE_100

918: , p5_a13 JTF_NUMBER_TABLE
919: , p5_a14 JTF_VARCHAR2_TABLE_100
920: , p5_a15 JTF_VARCHAR2_TABLE_100
921: , p5_a16 JTF_VARCHAR2_TABLE_100
922: , p5_a17 JTF_VARCHAR2_TABLE_100
923: , p5_a18 JTF_VARCHAR2_TABLE_100
924: )
925:
926: as

Line 923: , p5_a18 JTF_VARCHAR2_TABLE_100

919: , p5_a14 JTF_VARCHAR2_TABLE_100
920: , p5_a15 JTF_VARCHAR2_TABLE_100
921: , p5_a16 JTF_VARCHAR2_TABLE_100
922: , p5_a17 JTF_VARCHAR2_TABLE_100
923: , p5_a18 JTF_VARCHAR2_TABLE_100
924: )
925:
926: as
927: ddp_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;