DBA Data[Home] [Help]

APPS.AHL_APPROVALS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_approvals_pvt.approvers_tbl, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
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

Line 17: , a1 JTF_NUMBER_TABLE

13: return d;
14: end;
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

Line 18: , a2 JTF_NUMBER_TABLE

14: end;
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

Line 20: , a4 JTF_NUMBER_TABLE

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
24: , a8 JTF_NUMBER_TABLE

Line 21: , a5 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
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_DATE_TABLE

Line 24: , a8 JTF_NUMBER_TABLE

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
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100

Line 26: , a10 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
27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_200
30: , a14 JTF_VARCHAR2_TABLE_200

Line 27: , a11 JTF_NUMBER_TABLE

23: , a7 JTF_DATE_TABLE
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

Line 91: procedure rosetta_table_copy_out_p2(t ahl_approvals_pvt.approvers_tbl, a0 out nocopy JTF_NUMBER_TABLE

87: end loop;
88: end if;
89: end if;
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

Line 92: , a1 out nocopy JTF_NUMBER_TABLE

88: end if;
89: end if;
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

Line 93: , a2 out nocopy JTF_NUMBER_TABLE

89: end if;
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

Line 95: , a4 out nocopy JTF_NUMBER_TABLE

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
99: , a8 out nocopy JTF_NUMBER_TABLE

Line 96: , a5 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
99: , a8 out nocopy JTF_NUMBER_TABLE
100: , a9 out nocopy JTF_DATE_TABLE

Line 99: , a8 out nocopy JTF_NUMBER_TABLE

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
102: , a11 out nocopy JTF_NUMBER_TABLE
103: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 101: , a10 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
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

Line 102: , a11 out nocopy JTF_NUMBER_TABLE

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
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

Line 124: a0 := JTF_NUMBER_TABLE();

120: ) as
121: ddindx binary_integer; indx binary_integer;
122: begin
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();

Line 125: a1 := JTF_NUMBER_TABLE();

121: ddindx binary_integer; indx binary_integer;
122: begin
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();

Line 126: a2 := JTF_NUMBER_TABLE();

122: begin
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();

Line 128: a4 := JTF_NUMBER_TABLE();

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();
132: a8 := JTF_NUMBER_TABLE();

Line 129: a5 := 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();
132: a8 := JTF_NUMBER_TABLE();
133: a9 := JTF_DATE_TABLE();

Line 132: a8 := JTF_NUMBER_TABLE();

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();
135: a11 := JTF_NUMBER_TABLE();
136: a12 := JTF_VARCHAR2_TABLE_100();

Line 134: a10 := 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();
135: a11 := JTF_NUMBER_TABLE();
136: a12 := JTF_VARCHAR2_TABLE_100();
137: a13 := JTF_VARCHAR2_TABLE_200();
138: a14 := JTF_VARCHAR2_TABLE_200();

Line 135: a11 := JTF_NUMBER_TABLE();

131: a7 := JTF_DATE_TABLE();
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();

Line 154: a0 := JTF_NUMBER_TABLE();

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();
157: a3 := JTF_VARCHAR2_TABLE_100();
158: a4 := JTF_NUMBER_TABLE();

Line 155: a1 := JTF_NUMBER_TABLE();

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();
157: a3 := JTF_VARCHAR2_TABLE_100();
158: a4 := JTF_NUMBER_TABLE();
159: a5 := JTF_NUMBER_TABLE();

Line 156: a2 := JTF_NUMBER_TABLE();

152: a28 := 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();

Line 158: a4 := JTF_NUMBER_TABLE();

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();
162: a8 := JTF_NUMBER_TABLE();

Line 159: a5 := 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();
162: a8 := JTF_NUMBER_TABLE();
163: a9 := JTF_DATE_TABLE();

Line 162: a8 := JTF_NUMBER_TABLE();

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();
165: a11 := JTF_NUMBER_TABLE();
166: a12 := JTF_VARCHAR2_TABLE_100();

Line 164: a10 := 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();
165: a11 := JTF_NUMBER_TABLE();
166: a12 := JTF_VARCHAR2_TABLE_100();
167: a13 := JTF_VARCHAR2_TABLE_200();
168: a14 := JTF_VARCHAR2_TABLE_200();

Line 165: a11 := JTF_NUMBER_TABLE();

161: a7 := JTF_DATE_TABLE();
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();

Line 296: , p5_a0 in out nocopy JTF_NUMBER_TABLE

292: , p4_a33 in out nocopy DATE
293: , p4_a34 in out nocopy NUMBER
294: , p4_a35 in out nocopy NUMBER
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

Line 297: , p5_a1 in out nocopy JTF_NUMBER_TABLE

293: , p4_a34 in out nocopy NUMBER
294: , p4_a35 in out nocopy NUMBER
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

Line 298: , p5_a2 in out nocopy JTF_NUMBER_TABLE

294: , p4_a35 in out nocopy NUMBER
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

Line 300: , p5_a4 in out nocopy JTF_NUMBER_TABLE

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
304: , p5_a8 in out nocopy JTF_NUMBER_TABLE

Line 301: , p5_a5 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
304: , p5_a8 in out nocopy JTF_NUMBER_TABLE
305: , p5_a9 in out nocopy JTF_DATE_TABLE

Line 304: , p5_a8 in out nocopy JTF_NUMBER_TABLE

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
307: , p5_a11 in out nocopy JTF_NUMBER_TABLE
308: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 306: , p5_a10 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
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

Line 307: , p5_a11 in out nocopy JTF_NUMBER_TABLE

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
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