DBA Data[Home] [Help]

APPS.CSP_EXCESS_LISTS_PKG_W dependencies on JTF_VARCHAR2_TABLE_100

Line 20: , a4 JTF_VARCHAR2_TABLE_100

16: procedure rosetta_table_copy_in_p2(t out nocopy csp_excess_lists_pkg.excess_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_NUMBER_TABLE
22: , a6 JTF_DATE_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_DATE_TABLE

Line 26: , a10 JTF_VARCHAR2_TABLE_100

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

Line 30: , a14 JTF_VARCHAR2_TABLE_100

26: , a10 JTF_VARCHAR2_TABLE_100
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_VARCHAR2_TABLE_200
33: , a17 JTF_VARCHAR2_TABLE_200
34: , a18 JTF_VARCHAR2_TABLE_200

Line 31: , a15 JTF_VARCHAR2_TABLE_100

27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_VARCHAR2_TABLE_200
33: , a17 JTF_VARCHAR2_TABLE_200
34: , a18 JTF_VARCHAR2_TABLE_200
35: , a19 JTF_VARCHAR2_TABLE_200

Line 50: , a34 JTF_VARCHAR2_TABLE_100

46: , a30 JTF_VARCHAR2_TABLE_200
47: , a31 JTF_NUMBER_TABLE
48: , a32 JTF_VARCHAR2_TABLE_300
49: , a33 JTF_NUMBER_TABLE
50: , a34 JTF_VARCHAR2_TABLE_100
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if a0 is not null and a0.count > 0 then

Line 107: , a4 out nocopy JTF_VARCHAR2_TABLE_100

103: procedure rosetta_table_copy_out_p2(t csp_excess_lists_pkg.excess_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_NUMBER_TABLE
107: , a4 out nocopy JTF_VARCHAR2_TABLE_100
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_DATE_TABLE
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_DATE_TABLE

Line 113: , a10 out nocopy JTF_VARCHAR2_TABLE_100

109: , a6 out nocopy JTF_DATE_TABLE
110: , a7 out nocopy JTF_NUMBER_TABLE
111: , a8 out nocopy JTF_DATE_TABLE
112: , a9 out nocopy JTF_NUMBER_TABLE
113: , a10 out nocopy JTF_VARCHAR2_TABLE_100
114: , a11 out nocopy JTF_NUMBER_TABLE
115: , a12 out nocopy JTF_NUMBER_TABLE
116: , a13 out nocopy JTF_NUMBER_TABLE
117: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 117: , a14 out nocopy JTF_VARCHAR2_TABLE_100

113: , a10 out nocopy JTF_VARCHAR2_TABLE_100
114: , a11 out nocopy JTF_NUMBER_TABLE
115: , a12 out nocopy JTF_NUMBER_TABLE
116: , a13 out nocopy JTF_NUMBER_TABLE
117: , a14 out nocopy JTF_VARCHAR2_TABLE_100
118: , a15 out nocopy JTF_VARCHAR2_TABLE_100
119: , a16 out nocopy JTF_VARCHAR2_TABLE_200
120: , a17 out nocopy JTF_VARCHAR2_TABLE_200
121: , a18 out nocopy JTF_VARCHAR2_TABLE_200

Line 118: , a15 out nocopy JTF_VARCHAR2_TABLE_100

114: , a11 out nocopy JTF_NUMBER_TABLE
115: , a12 out nocopy JTF_NUMBER_TABLE
116: , a13 out nocopy JTF_NUMBER_TABLE
117: , a14 out nocopy JTF_VARCHAR2_TABLE_100
118: , a15 out nocopy JTF_VARCHAR2_TABLE_100
119: , a16 out nocopy JTF_VARCHAR2_TABLE_200
120: , a17 out nocopy JTF_VARCHAR2_TABLE_200
121: , a18 out nocopy JTF_VARCHAR2_TABLE_200
122: , a19 out nocopy JTF_VARCHAR2_TABLE_200

Line 137: , a34 out nocopy JTF_VARCHAR2_TABLE_100

133: , a30 out nocopy JTF_VARCHAR2_TABLE_200
134: , a31 out nocopy JTF_NUMBER_TABLE
135: , a32 out nocopy JTF_VARCHAR2_TABLE_300
136: , a33 out nocopy JTF_NUMBER_TABLE
137: , a34 out nocopy JTF_VARCHAR2_TABLE_100
138: ) as
139: ddindx binary_integer; indx binary_integer;
140: begin
141: if t is null or t.count = 0 then

Line 146: a4 := JTF_VARCHAR2_TABLE_100();

142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_NUMBER_TABLE();
144: a2 := JTF_NUMBER_TABLE();
145: a3 := JTF_NUMBER_TABLE();
146: a4 := JTF_VARCHAR2_TABLE_100();
147: a5 := JTF_NUMBER_TABLE();
148: a6 := JTF_DATE_TABLE();
149: a7 := JTF_NUMBER_TABLE();
150: a8 := JTF_DATE_TABLE();

Line 152: a10 := JTF_VARCHAR2_TABLE_100();

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

Line 156: a14 := JTF_VARCHAR2_TABLE_100();

152: a10 := JTF_VARCHAR2_TABLE_100();
153: a11 := JTF_NUMBER_TABLE();
154: a12 := JTF_NUMBER_TABLE();
155: a13 := JTF_NUMBER_TABLE();
156: a14 := JTF_VARCHAR2_TABLE_100();
157: a15 := JTF_VARCHAR2_TABLE_100();
158: a16 := JTF_VARCHAR2_TABLE_200();
159: a17 := JTF_VARCHAR2_TABLE_200();
160: a18 := JTF_VARCHAR2_TABLE_200();

Line 157: a15 := JTF_VARCHAR2_TABLE_100();

153: a11 := JTF_NUMBER_TABLE();
154: a12 := JTF_NUMBER_TABLE();
155: a13 := JTF_NUMBER_TABLE();
156: a14 := JTF_VARCHAR2_TABLE_100();
157: a15 := JTF_VARCHAR2_TABLE_100();
158: a16 := JTF_VARCHAR2_TABLE_200();
159: a17 := JTF_VARCHAR2_TABLE_200();
160: a18 := JTF_VARCHAR2_TABLE_200();
161: a19 := JTF_VARCHAR2_TABLE_200();

Line 176: a34 := JTF_VARCHAR2_TABLE_100();

172: a30 := JTF_VARCHAR2_TABLE_200();
173: a31 := JTF_NUMBER_TABLE();
174: a32 := JTF_VARCHAR2_TABLE_300();
175: a33 := JTF_NUMBER_TABLE();
176: a34 := JTF_VARCHAR2_TABLE_100();
177: else
178: a0 := JTF_NUMBER_TABLE();
179: a1 := JTF_NUMBER_TABLE();
180: a2 := JTF_NUMBER_TABLE();

Line 182: a4 := JTF_VARCHAR2_TABLE_100();

178: a0 := JTF_NUMBER_TABLE();
179: a1 := JTF_NUMBER_TABLE();
180: a2 := JTF_NUMBER_TABLE();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_VARCHAR2_TABLE_100();
183: a5 := JTF_NUMBER_TABLE();
184: a6 := JTF_DATE_TABLE();
185: a7 := JTF_NUMBER_TABLE();
186: a8 := JTF_DATE_TABLE();

Line 188: a10 := JTF_VARCHAR2_TABLE_100();

184: a6 := JTF_DATE_TABLE();
185: a7 := JTF_NUMBER_TABLE();
186: a8 := JTF_DATE_TABLE();
187: a9 := JTF_NUMBER_TABLE();
188: a10 := JTF_VARCHAR2_TABLE_100();
189: a11 := JTF_NUMBER_TABLE();
190: a12 := JTF_NUMBER_TABLE();
191: a13 := JTF_NUMBER_TABLE();
192: a14 := JTF_VARCHAR2_TABLE_100();

Line 192: a14 := JTF_VARCHAR2_TABLE_100();

188: a10 := JTF_VARCHAR2_TABLE_100();
189: a11 := JTF_NUMBER_TABLE();
190: a12 := JTF_NUMBER_TABLE();
191: a13 := JTF_NUMBER_TABLE();
192: a14 := JTF_VARCHAR2_TABLE_100();
193: a15 := JTF_VARCHAR2_TABLE_100();
194: a16 := JTF_VARCHAR2_TABLE_200();
195: a17 := JTF_VARCHAR2_TABLE_200();
196: a18 := JTF_VARCHAR2_TABLE_200();

Line 193: a15 := JTF_VARCHAR2_TABLE_100();

189: a11 := JTF_NUMBER_TABLE();
190: a12 := JTF_NUMBER_TABLE();
191: a13 := JTF_NUMBER_TABLE();
192: a14 := JTF_VARCHAR2_TABLE_100();
193: a15 := JTF_VARCHAR2_TABLE_100();
194: a16 := JTF_VARCHAR2_TABLE_200();
195: a17 := JTF_VARCHAR2_TABLE_200();
196: a18 := JTF_VARCHAR2_TABLE_200();
197: a19 := JTF_VARCHAR2_TABLE_200();

Line 212: a34 := JTF_VARCHAR2_TABLE_100();

208: a30 := JTF_VARCHAR2_TABLE_200();
209: a31 := JTF_NUMBER_TABLE();
210: a32 := JTF_VARCHAR2_TABLE_300();
211: a33 := JTF_NUMBER_TABLE();
212: a34 := JTF_VARCHAR2_TABLE_100();
213: if t.count > 0 then
214: a0.extend(t.count);
215: a1.extend(t.count);
216: a2.extend(t.count);