DBA Data[Home] [Help]

APPS.AHL_FMP_MR_RELATION_PVT_W dependencies on JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_mr_relation_pvt.mr_relation_tbl, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_mr_relation_pvt.mr_relation_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100

Line 14: , a1 JTF_NUMBER_TABLE

10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_mr_relation_pvt.mr_relation_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100

Line 16: , a3 JTF_NUMBER_TABLE

12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_mr_relation_pvt.mr_relation_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100

Line 19: , a6 JTF_NUMBER_TABLE

15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100

Line 21: , a8 JTF_NUMBER_TABLE

17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_VARCHAR2_TABLE_100
23: , a10 JTF_VARCHAR2_TABLE_100
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100

Line 42: , a29 JTF_NUMBER_TABLE

38: , a25 JTF_VARCHAR2_TABLE_200
39: , a26 JTF_VARCHAR2_TABLE_200
40: , a27 JTF_VARCHAR2_TABLE_200
41: , a28 JTF_DATE_TABLE
42: , a29 JTF_NUMBER_TABLE
43: , a30 JTF_DATE_TABLE
44: , a31 JTF_NUMBER_TABLE
45: , a32 JTF_NUMBER_TABLE
46: , a33 JTF_VARCHAR2_TABLE_100

Line 44: , a31 JTF_NUMBER_TABLE

40: , a27 JTF_VARCHAR2_TABLE_200
41: , a28 JTF_DATE_TABLE
42: , a29 JTF_NUMBER_TABLE
43: , a30 JTF_DATE_TABLE
44: , a31 JTF_NUMBER_TABLE
45: , a32 JTF_NUMBER_TABLE
46: , a33 JTF_VARCHAR2_TABLE_100
47: ) as
48: ddindx binary_integer; indx binary_integer;

Line 45: , a32 JTF_NUMBER_TABLE

41: , a28 JTF_DATE_TABLE
42: , a29 JTF_NUMBER_TABLE
43: , a30 JTF_DATE_TABLE
44: , a31 JTF_NUMBER_TABLE
45: , a32 JTF_NUMBER_TABLE
46: , a33 JTF_VARCHAR2_TABLE_100
47: ) as
48: ddindx binary_integer; indx binary_integer;
49: begin

Line 98: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_relation_pvt.mr_relation_tbl, a0 out nocopy JTF_NUMBER_TABLE

94: end loop;
95: end if;
96: end if;
97: end rosetta_table_copy_in_p1;
98: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_relation_pvt.mr_relation_tbl, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_NUMBER_TABLE
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_NUMBER_TABLE
102: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 99: , a1 out nocopy JTF_NUMBER_TABLE

95: end if;
96: end if;
97: end rosetta_table_copy_in_p1;
98: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_relation_pvt.mr_relation_tbl, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_NUMBER_TABLE
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_NUMBER_TABLE
102: , a4 out nocopy JTF_VARCHAR2_TABLE_100
103: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 101: , a3 out nocopy JTF_NUMBER_TABLE

97: end rosetta_table_copy_in_p1;
98: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_relation_pvt.mr_relation_tbl, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_NUMBER_TABLE
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_NUMBER_TABLE
102: , a4 out nocopy JTF_VARCHAR2_TABLE_100
103: , a5 out nocopy JTF_VARCHAR2_TABLE_100
104: , a6 out nocopy JTF_NUMBER_TABLE
105: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 104: , a6 out nocopy JTF_NUMBER_TABLE

100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_NUMBER_TABLE
102: , a4 out nocopy JTF_VARCHAR2_TABLE_100
103: , a5 out nocopy JTF_VARCHAR2_TABLE_100
104: , a6 out nocopy JTF_NUMBER_TABLE
105: , a7 out nocopy JTF_VARCHAR2_TABLE_100
106: , a8 out nocopy JTF_NUMBER_TABLE
107: , a9 out nocopy JTF_VARCHAR2_TABLE_100
108: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 106: , a8 out nocopy JTF_NUMBER_TABLE

102: , a4 out nocopy JTF_VARCHAR2_TABLE_100
103: , a5 out nocopy JTF_VARCHAR2_TABLE_100
104: , a6 out nocopy JTF_NUMBER_TABLE
105: , a7 out nocopy JTF_VARCHAR2_TABLE_100
106: , a8 out nocopy JTF_NUMBER_TABLE
107: , a9 out nocopy JTF_VARCHAR2_TABLE_100
108: , a10 out nocopy JTF_VARCHAR2_TABLE_100
109: , a11 out nocopy JTF_VARCHAR2_TABLE_100
110: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 127: , a29 out nocopy JTF_NUMBER_TABLE

123: , a25 out nocopy JTF_VARCHAR2_TABLE_200
124: , a26 out nocopy JTF_VARCHAR2_TABLE_200
125: , a27 out nocopy JTF_VARCHAR2_TABLE_200
126: , a28 out nocopy JTF_DATE_TABLE
127: , a29 out nocopy JTF_NUMBER_TABLE
128: , a30 out nocopy JTF_DATE_TABLE
129: , a31 out nocopy JTF_NUMBER_TABLE
130: , a32 out nocopy JTF_NUMBER_TABLE
131: , a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 129: , a31 out nocopy JTF_NUMBER_TABLE

125: , a27 out nocopy JTF_VARCHAR2_TABLE_200
126: , a28 out nocopy JTF_DATE_TABLE
127: , a29 out nocopy JTF_NUMBER_TABLE
128: , a30 out nocopy JTF_DATE_TABLE
129: , a31 out nocopy JTF_NUMBER_TABLE
130: , a32 out nocopy JTF_NUMBER_TABLE
131: , a33 out nocopy JTF_VARCHAR2_TABLE_100
132: ) as
133: ddindx binary_integer; indx binary_integer;

Line 130: , a32 out nocopy JTF_NUMBER_TABLE

126: , a28 out nocopy JTF_DATE_TABLE
127: , a29 out nocopy JTF_NUMBER_TABLE
128: , a30 out nocopy JTF_DATE_TABLE
129: , a31 out nocopy JTF_NUMBER_TABLE
130: , a32 out nocopy JTF_NUMBER_TABLE
131: , a33 out nocopy JTF_VARCHAR2_TABLE_100
132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin

Line 136: a0 := JTF_NUMBER_TABLE();

132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();

Line 137: a1 := JTF_NUMBER_TABLE();

133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_VARCHAR2_TABLE_100();

Line 139: a3 := JTF_NUMBER_TABLE();

135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_NUMBER_TABLE();
138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_VARCHAR2_TABLE_100();
142: a6 := JTF_NUMBER_TABLE();
143: a7 := JTF_VARCHAR2_TABLE_100();

Line 142: a6 := JTF_NUMBER_TABLE();

138: a2 := JTF_VARCHAR2_TABLE_100();
139: a3 := JTF_NUMBER_TABLE();
140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_VARCHAR2_TABLE_100();
142: a6 := JTF_NUMBER_TABLE();
143: a7 := JTF_VARCHAR2_TABLE_100();
144: a8 := JTF_NUMBER_TABLE();
145: a9 := JTF_VARCHAR2_TABLE_100();
146: a10 := JTF_VARCHAR2_TABLE_100();

Line 144: a8 := JTF_NUMBER_TABLE();

140: a4 := JTF_VARCHAR2_TABLE_100();
141: a5 := JTF_VARCHAR2_TABLE_100();
142: a6 := JTF_NUMBER_TABLE();
143: a7 := JTF_VARCHAR2_TABLE_100();
144: a8 := JTF_NUMBER_TABLE();
145: a9 := JTF_VARCHAR2_TABLE_100();
146: a10 := JTF_VARCHAR2_TABLE_100();
147: a11 := JTF_VARCHAR2_TABLE_100();
148: a12 := JTF_VARCHAR2_TABLE_100();

Line 165: a29 := JTF_NUMBER_TABLE();

161: a25 := JTF_VARCHAR2_TABLE_200();
162: a26 := JTF_VARCHAR2_TABLE_200();
163: a27 := JTF_VARCHAR2_TABLE_200();
164: a28 := JTF_DATE_TABLE();
165: a29 := JTF_NUMBER_TABLE();
166: a30 := JTF_DATE_TABLE();
167: a31 := JTF_NUMBER_TABLE();
168: a32 := JTF_NUMBER_TABLE();
169: a33 := JTF_VARCHAR2_TABLE_100();

Line 167: a31 := JTF_NUMBER_TABLE();

163: a27 := JTF_VARCHAR2_TABLE_200();
164: a28 := JTF_DATE_TABLE();
165: a29 := JTF_NUMBER_TABLE();
166: a30 := JTF_DATE_TABLE();
167: a31 := JTF_NUMBER_TABLE();
168: a32 := JTF_NUMBER_TABLE();
169: a33 := JTF_VARCHAR2_TABLE_100();
170: else
171: a0 := JTF_NUMBER_TABLE();

Line 168: a32 := JTF_NUMBER_TABLE();

164: a28 := JTF_DATE_TABLE();
165: a29 := JTF_NUMBER_TABLE();
166: a30 := JTF_DATE_TABLE();
167: a31 := JTF_NUMBER_TABLE();
168: a32 := JTF_NUMBER_TABLE();
169: a33 := JTF_VARCHAR2_TABLE_100();
170: else
171: a0 := JTF_NUMBER_TABLE();
172: a1 := JTF_NUMBER_TABLE();

Line 171: a0 := JTF_NUMBER_TABLE();

167: a31 := JTF_NUMBER_TABLE();
168: a32 := JTF_NUMBER_TABLE();
169: a33 := JTF_VARCHAR2_TABLE_100();
170: else
171: a0 := JTF_NUMBER_TABLE();
172: a1 := JTF_NUMBER_TABLE();
173: a2 := JTF_VARCHAR2_TABLE_100();
174: a3 := JTF_NUMBER_TABLE();
175: a4 := JTF_VARCHAR2_TABLE_100();

Line 172: a1 := JTF_NUMBER_TABLE();

168: a32 := JTF_NUMBER_TABLE();
169: a33 := JTF_VARCHAR2_TABLE_100();
170: else
171: a0 := JTF_NUMBER_TABLE();
172: a1 := JTF_NUMBER_TABLE();
173: a2 := JTF_VARCHAR2_TABLE_100();
174: a3 := JTF_NUMBER_TABLE();
175: a4 := JTF_VARCHAR2_TABLE_100();
176: a5 := JTF_VARCHAR2_TABLE_100();

Line 174: a3 := JTF_NUMBER_TABLE();

170: else
171: a0 := JTF_NUMBER_TABLE();
172: a1 := JTF_NUMBER_TABLE();
173: a2 := JTF_VARCHAR2_TABLE_100();
174: a3 := JTF_NUMBER_TABLE();
175: a4 := JTF_VARCHAR2_TABLE_100();
176: a5 := JTF_VARCHAR2_TABLE_100();
177: a6 := JTF_NUMBER_TABLE();
178: a7 := JTF_VARCHAR2_TABLE_100();

Line 177: a6 := JTF_NUMBER_TABLE();

173: a2 := JTF_VARCHAR2_TABLE_100();
174: a3 := JTF_NUMBER_TABLE();
175: a4 := JTF_VARCHAR2_TABLE_100();
176: a5 := JTF_VARCHAR2_TABLE_100();
177: a6 := JTF_NUMBER_TABLE();
178: a7 := JTF_VARCHAR2_TABLE_100();
179: a8 := JTF_NUMBER_TABLE();
180: a9 := JTF_VARCHAR2_TABLE_100();
181: a10 := JTF_VARCHAR2_TABLE_100();

Line 179: a8 := JTF_NUMBER_TABLE();

175: a4 := JTF_VARCHAR2_TABLE_100();
176: a5 := JTF_VARCHAR2_TABLE_100();
177: a6 := JTF_NUMBER_TABLE();
178: a7 := JTF_VARCHAR2_TABLE_100();
179: a8 := JTF_NUMBER_TABLE();
180: a9 := JTF_VARCHAR2_TABLE_100();
181: a10 := JTF_VARCHAR2_TABLE_100();
182: a11 := JTF_VARCHAR2_TABLE_100();
183: a12 := JTF_VARCHAR2_TABLE_100();

Line 200: a29 := JTF_NUMBER_TABLE();

196: a25 := JTF_VARCHAR2_TABLE_200();
197: a26 := JTF_VARCHAR2_TABLE_200();
198: a27 := JTF_VARCHAR2_TABLE_200();
199: a28 := JTF_DATE_TABLE();
200: a29 := JTF_NUMBER_TABLE();
201: a30 := JTF_DATE_TABLE();
202: a31 := JTF_NUMBER_TABLE();
203: a32 := JTF_NUMBER_TABLE();
204: a33 := JTF_VARCHAR2_TABLE_100();

Line 202: a31 := JTF_NUMBER_TABLE();

198: a27 := JTF_VARCHAR2_TABLE_200();
199: a28 := JTF_DATE_TABLE();
200: a29 := JTF_NUMBER_TABLE();
201: a30 := JTF_DATE_TABLE();
202: a31 := JTF_NUMBER_TABLE();
203: a32 := JTF_NUMBER_TABLE();
204: a33 := JTF_VARCHAR2_TABLE_100();
205: if t.count > 0 then
206: a0.extend(t.count);

Line 203: a32 := JTF_NUMBER_TABLE();

199: a28 := JTF_DATE_TABLE();
200: a29 := JTF_NUMBER_TABLE();
201: a30 := JTF_DATE_TABLE();
202: a31 := JTF_NUMBER_TABLE();
203: a32 := JTF_NUMBER_TABLE();
204: a33 := JTF_VARCHAR2_TABLE_100();
205: if t.count > 0 then
206: a0.extend(t.count);
207: a1.extend(t.count);

Line 296: , p9_a0 in out nocopy JTF_NUMBER_TABLE

292: , p_module_type VARCHAR2
293: , x_return_status out nocopy VARCHAR2
294: , x_msg_count out nocopy NUMBER
295: , x_msg_data out nocopy VARCHAR2
296: , p9_a0 in out nocopy JTF_NUMBER_TABLE
297: , p9_a1 in out nocopy JTF_NUMBER_TABLE
298: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p9_a3 in out nocopy JTF_NUMBER_TABLE
300: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100

Line 297: , p9_a1 in out nocopy JTF_NUMBER_TABLE

293: , x_return_status out nocopy VARCHAR2
294: , x_msg_count out nocopy NUMBER
295: , x_msg_data out nocopy VARCHAR2
296: , p9_a0 in out nocopy JTF_NUMBER_TABLE
297: , p9_a1 in out nocopy JTF_NUMBER_TABLE
298: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p9_a3 in out nocopy JTF_NUMBER_TABLE
300: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
301: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 299: , p9_a3 in out nocopy JTF_NUMBER_TABLE

295: , x_msg_data out nocopy VARCHAR2
296: , p9_a0 in out nocopy JTF_NUMBER_TABLE
297: , p9_a1 in out nocopy JTF_NUMBER_TABLE
298: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p9_a3 in out nocopy JTF_NUMBER_TABLE
300: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
301: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p9_a6 in out nocopy JTF_NUMBER_TABLE
303: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 302: , p9_a6 in out nocopy JTF_NUMBER_TABLE

298: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p9_a3 in out nocopy JTF_NUMBER_TABLE
300: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
301: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p9_a6 in out nocopy JTF_NUMBER_TABLE
303: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p9_a8 in out nocopy JTF_NUMBER_TABLE
305: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
306: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 304: , p9_a8 in out nocopy JTF_NUMBER_TABLE

300: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
301: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p9_a6 in out nocopy JTF_NUMBER_TABLE
303: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p9_a8 in out nocopy JTF_NUMBER_TABLE
305: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
306: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
307: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 325: , p9_a29 in out nocopy JTF_NUMBER_TABLE

321: , p9_a25 in out nocopy JTF_VARCHAR2_TABLE_200
322: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_200
323: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_200
324: , p9_a28 in out nocopy JTF_DATE_TABLE
325: , p9_a29 in out nocopy JTF_NUMBER_TABLE
326: , p9_a30 in out nocopy JTF_DATE_TABLE
327: , p9_a31 in out nocopy JTF_NUMBER_TABLE
328: , p9_a32 in out nocopy JTF_NUMBER_TABLE
329: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100

Line 327: , p9_a31 in out nocopy JTF_NUMBER_TABLE

323: , p9_a27 in out nocopy JTF_VARCHAR2_TABLE_200
324: , p9_a28 in out nocopy JTF_DATE_TABLE
325: , p9_a29 in out nocopy JTF_NUMBER_TABLE
326: , p9_a30 in out nocopy JTF_DATE_TABLE
327: , p9_a31 in out nocopy JTF_NUMBER_TABLE
328: , p9_a32 in out nocopy JTF_NUMBER_TABLE
329: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
330: )
331:

Line 328: , p9_a32 in out nocopy JTF_NUMBER_TABLE

324: , p9_a28 in out nocopy JTF_DATE_TABLE
325: , p9_a29 in out nocopy JTF_NUMBER_TABLE
326: , p9_a30 in out nocopy JTF_DATE_TABLE
327: , p9_a31 in out nocopy JTF_NUMBER_TABLE
328: , p9_a32 in out nocopy JTF_NUMBER_TABLE
329: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
330: )
331:
332: as