DBA Data[Home] [Help]

APPS.AHL_APPROVALS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 19: , a3 JTF_VARCHAR2_TABLE_100

15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_approvals_pvt.approvers_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_DATE_TABLE

Line 22: , a6 JTF_VARCHAR2_TABLE_100

18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_DATE_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_DATE_TABLE
26: , a10 JTF_NUMBER_TABLE

Line 28: , a12 JTF_VARCHAR2_TABLE_100

24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_DATE_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_200
30: , a14 JTF_VARCHAR2_TABLE_200
31: , a15 JTF_VARCHAR2_TABLE_200
32: , a16 JTF_VARCHAR2_TABLE_200

Line 44: , a28 JTF_VARCHAR2_TABLE_100

40: , a24 JTF_VARCHAR2_TABLE_200
41: , a25 JTF_VARCHAR2_TABLE_200
42: , a26 JTF_VARCHAR2_TABLE_200
43: , a27 JTF_VARCHAR2_TABLE_200
44: , a28 JTF_VARCHAR2_TABLE_100
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if a0 is not null and a0.count > 0 then

Line 94: , a3 out nocopy JTF_VARCHAR2_TABLE_100

90: end rosetta_table_copy_in_p2;
91: procedure rosetta_table_copy_out_p2(t ahl_approvals_pvt.approvers_tbl, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_NUMBER_TABLE
97: , a6 out nocopy JTF_VARCHAR2_TABLE_100
98: , a7 out nocopy JTF_DATE_TABLE

Line 97: , a6 out nocopy JTF_VARCHAR2_TABLE_100

93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_NUMBER_TABLE
97: , a6 out nocopy JTF_VARCHAR2_TABLE_100
98: , a7 out nocopy JTF_DATE_TABLE
99: , a8 out nocopy JTF_NUMBER_TABLE
100: , a9 out nocopy JTF_DATE_TABLE
101: , a10 out nocopy JTF_NUMBER_TABLE

Line 103: , a12 out nocopy JTF_VARCHAR2_TABLE_100

99: , a8 out nocopy JTF_NUMBER_TABLE
100: , a9 out nocopy JTF_DATE_TABLE
101: , a10 out nocopy JTF_NUMBER_TABLE
102: , a11 out nocopy JTF_NUMBER_TABLE
103: , a12 out nocopy JTF_VARCHAR2_TABLE_100
104: , a13 out nocopy JTF_VARCHAR2_TABLE_200
105: , a14 out nocopy JTF_VARCHAR2_TABLE_200
106: , a15 out nocopy JTF_VARCHAR2_TABLE_200
107: , a16 out nocopy JTF_VARCHAR2_TABLE_200

Line 119: , a28 out nocopy JTF_VARCHAR2_TABLE_100

115: , a24 out nocopy JTF_VARCHAR2_TABLE_200
116: , a25 out nocopy JTF_VARCHAR2_TABLE_200
117: , a26 out nocopy JTF_VARCHAR2_TABLE_200
118: , a27 out nocopy JTF_VARCHAR2_TABLE_200
119: , a28 out nocopy JTF_VARCHAR2_TABLE_100
120: ) as
121: ddindx binary_integer; indx binary_integer;
122: begin
123: if t is null or t.count = 0 then

Line 127: a3 := JTF_VARCHAR2_TABLE_100();

123: if t is null or t.count = 0 then
124: a0 := JTF_NUMBER_TABLE();
125: a1 := JTF_NUMBER_TABLE();
126: a2 := JTF_NUMBER_TABLE();
127: a3 := JTF_VARCHAR2_TABLE_100();
128: a4 := JTF_NUMBER_TABLE();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_DATE_TABLE();

Line 130: a6 := JTF_VARCHAR2_TABLE_100();

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

Line 136: a12 := JTF_VARCHAR2_TABLE_100();

132: a8 := JTF_NUMBER_TABLE();
133: a9 := JTF_DATE_TABLE();
134: a10 := JTF_NUMBER_TABLE();
135: a11 := JTF_NUMBER_TABLE();
136: a12 := JTF_VARCHAR2_TABLE_100();
137: a13 := JTF_VARCHAR2_TABLE_200();
138: a14 := JTF_VARCHAR2_TABLE_200();
139: a15 := JTF_VARCHAR2_TABLE_200();
140: a16 := JTF_VARCHAR2_TABLE_200();

Line 152: a28 := JTF_VARCHAR2_TABLE_100();

148: a24 := JTF_VARCHAR2_TABLE_200();
149: a25 := JTF_VARCHAR2_TABLE_200();
150: a26 := JTF_VARCHAR2_TABLE_200();
151: a27 := JTF_VARCHAR2_TABLE_200();
152: a28 := JTF_VARCHAR2_TABLE_100();
153: else
154: a0 := JTF_NUMBER_TABLE();
155: a1 := JTF_NUMBER_TABLE();
156: a2 := JTF_NUMBER_TABLE();

Line 157: a3 := JTF_VARCHAR2_TABLE_100();

153: else
154: a0 := JTF_NUMBER_TABLE();
155: a1 := JTF_NUMBER_TABLE();
156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_VARCHAR2_TABLE_100();
158: a4 := JTF_NUMBER_TABLE();
159: a5 := JTF_NUMBER_TABLE();
160: a6 := JTF_VARCHAR2_TABLE_100();
161: a7 := JTF_DATE_TABLE();

Line 160: a6 := JTF_VARCHAR2_TABLE_100();

156: a2 := JTF_NUMBER_TABLE();
157: a3 := JTF_VARCHAR2_TABLE_100();
158: a4 := JTF_NUMBER_TABLE();
159: a5 := JTF_NUMBER_TABLE();
160: a6 := JTF_VARCHAR2_TABLE_100();
161: a7 := JTF_DATE_TABLE();
162: a8 := JTF_NUMBER_TABLE();
163: a9 := JTF_DATE_TABLE();
164: a10 := JTF_NUMBER_TABLE();

Line 166: a12 := JTF_VARCHAR2_TABLE_100();

162: a8 := JTF_NUMBER_TABLE();
163: a9 := JTF_DATE_TABLE();
164: a10 := JTF_NUMBER_TABLE();
165: a11 := JTF_NUMBER_TABLE();
166: a12 := JTF_VARCHAR2_TABLE_100();
167: a13 := JTF_VARCHAR2_TABLE_200();
168: a14 := JTF_VARCHAR2_TABLE_200();
169: a15 := JTF_VARCHAR2_TABLE_200();
170: a16 := JTF_VARCHAR2_TABLE_200();

Line 182: a28 := JTF_VARCHAR2_TABLE_100();

178: a24 := JTF_VARCHAR2_TABLE_200();
179: a25 := JTF_VARCHAR2_TABLE_200();
180: a26 := JTF_VARCHAR2_TABLE_200();
181: a27 := JTF_VARCHAR2_TABLE_200();
182: a28 := JTF_VARCHAR2_TABLE_100();
183: if t.count > 0 then
184: a0.extend(t.count);
185: a1.extend(t.count);
186: a2.extend(t.count);

Line 299: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100

295: , p4_a36 in out nocopy VARCHAR2
296: , p5_a0 in out nocopy JTF_NUMBER_TABLE
297: , p5_a1 in out nocopy JTF_NUMBER_TABLE
298: , p5_a2 in out nocopy JTF_NUMBER_TABLE
299: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p5_a4 in out nocopy JTF_NUMBER_TABLE
301: , p5_a5 in out nocopy JTF_NUMBER_TABLE
302: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
303: , p5_a7 in out nocopy JTF_DATE_TABLE

Line 302: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100

298: , p5_a2 in out nocopy JTF_NUMBER_TABLE
299: , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
300: , p5_a4 in out nocopy JTF_NUMBER_TABLE
301: , p5_a5 in out nocopy JTF_NUMBER_TABLE
302: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
303: , p5_a7 in out nocopy JTF_DATE_TABLE
304: , p5_a8 in out nocopy JTF_NUMBER_TABLE
305: , p5_a9 in out nocopy JTF_DATE_TABLE
306: , p5_a10 in out nocopy JTF_NUMBER_TABLE

Line 308: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100

304: , p5_a8 in out nocopy JTF_NUMBER_TABLE
305: , p5_a9 in out nocopy JTF_DATE_TABLE
306: , p5_a10 in out nocopy JTF_NUMBER_TABLE
307: , p5_a11 in out nocopy JTF_NUMBER_TABLE
308: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
309: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_200
310: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_200
311: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_200
312: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_200

Line 324: , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100

320: , p5_a24 in out nocopy JTF_VARCHAR2_TABLE_200
321: , p5_a25 in out nocopy JTF_VARCHAR2_TABLE_200
322: , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_200
323: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_200
324: , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100
325: , x_return_status out nocopy VARCHAR2
326: , x_msg_count out nocopy NUMBER
327: , x_msg_data out nocopy VARCHAR2
328: )