DBA Data[Home] [Help]

APPS.AHL_FMP_MR_ACTION_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 16: , a3 JTF_VARCHAR2_TABLE_100

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

Line 17: , a4 JTF_VARCHAR2_TABLE_100

13: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_mr_action_pvt.mr_action_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_VARCHAR2_TABLE_100
20: , a7 JTF_VARCHAR2_TABLE_2000
21: , a8 JTF_VARCHAR2_TABLE_100

Line 19: , a6 JTF_VARCHAR2_TABLE_100

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

Line 21: , a8 JTF_VARCHAR2_TABLE_100

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

Line 42: , a29 JTF_VARCHAR2_TABLE_100

38: , a25 JTF_NUMBER_TABLE
39: , a26 JTF_DATE_TABLE
40: , a27 JTF_NUMBER_TABLE
41: , a28 JTF_NUMBER_TABLE
42: , a29 JTF_VARCHAR2_TABLE_100
43: ) as
44: ddindx binary_integer; indx binary_integer;
45: begin
46: if a0 is not null and a0.count > 0 then

Line 93: , a3 out nocopy JTF_VARCHAR2_TABLE_100

89: end rosetta_table_copy_in_p1;
90: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_action_pvt.mr_action_tbl, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_NUMBER_TABLE
93: , a3 out nocopy JTF_VARCHAR2_TABLE_100
94: , a4 out nocopy JTF_VARCHAR2_TABLE_100
95: , a5 out nocopy JTF_NUMBER_TABLE
96: , a6 out nocopy JTF_VARCHAR2_TABLE_100
97: , a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 94: , a4 out nocopy JTF_VARCHAR2_TABLE_100

90: procedure rosetta_table_copy_out_p1(t ahl_fmp_mr_action_pvt.mr_action_tbl, a0 out nocopy JTF_NUMBER_TABLE
91: , a1 out nocopy JTF_NUMBER_TABLE
92: , a2 out nocopy JTF_NUMBER_TABLE
93: , a3 out nocopy JTF_VARCHAR2_TABLE_100
94: , a4 out nocopy JTF_VARCHAR2_TABLE_100
95: , a5 out nocopy JTF_NUMBER_TABLE
96: , a6 out nocopy JTF_VARCHAR2_TABLE_100
97: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
98: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 96: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 98: , a8 out nocopy JTF_VARCHAR2_TABLE_100

94: , a4 out nocopy JTF_VARCHAR2_TABLE_100
95: , a5 out nocopy JTF_NUMBER_TABLE
96: , a6 out nocopy JTF_VARCHAR2_TABLE_100
97: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
98: , a8 out nocopy JTF_VARCHAR2_TABLE_100
99: , a9 out nocopy JTF_VARCHAR2_TABLE_200
100: , a10 out nocopy JTF_VARCHAR2_TABLE_200
101: , a11 out nocopy JTF_VARCHAR2_TABLE_200
102: , a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 119: , a29 out nocopy JTF_VARCHAR2_TABLE_100

115: , a25 out nocopy JTF_NUMBER_TABLE
116: , a26 out nocopy JTF_DATE_TABLE
117: , a27 out nocopy JTF_NUMBER_TABLE
118: , a28 out nocopy JTF_NUMBER_TABLE
119: , a29 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_VARCHAR2_TABLE_100();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_VARCHAR2_TABLE_2000();

Line 128: a4 := JTF_VARCHAR2_TABLE_100();

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

Line 130: a6 := JTF_VARCHAR2_TABLE_100();

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

Line 132: a8 := JTF_VARCHAR2_TABLE_100();

128: a4 := JTF_VARCHAR2_TABLE_100();
129: a5 := JTF_NUMBER_TABLE();
130: a6 := JTF_VARCHAR2_TABLE_100();
131: a7 := JTF_VARCHAR2_TABLE_2000();
132: a8 := JTF_VARCHAR2_TABLE_100();
133: a9 := JTF_VARCHAR2_TABLE_200();
134: a10 := JTF_VARCHAR2_TABLE_200();
135: a11 := JTF_VARCHAR2_TABLE_200();
136: a12 := JTF_VARCHAR2_TABLE_200();

Line 153: a29 := JTF_VARCHAR2_TABLE_100();

149: a25 := JTF_NUMBER_TABLE();
150: a26 := JTF_DATE_TABLE();
151: a27 := JTF_NUMBER_TABLE();
152: a28 := JTF_NUMBER_TABLE();
153: a29 := JTF_VARCHAR2_TABLE_100();
154: else
155: a0 := JTF_NUMBER_TABLE();
156: a1 := JTF_NUMBER_TABLE();
157: a2 := JTF_NUMBER_TABLE();

Line 158: a3 := JTF_VARCHAR2_TABLE_100();

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

Line 159: a4 := JTF_VARCHAR2_TABLE_100();

155: a0 := JTF_NUMBER_TABLE();
156: a1 := JTF_NUMBER_TABLE();
157: a2 := JTF_NUMBER_TABLE();
158: a3 := JTF_VARCHAR2_TABLE_100();
159: a4 := JTF_VARCHAR2_TABLE_100();
160: a5 := JTF_NUMBER_TABLE();
161: a6 := JTF_VARCHAR2_TABLE_100();
162: a7 := JTF_VARCHAR2_TABLE_2000();
163: a8 := JTF_VARCHAR2_TABLE_100();

Line 161: a6 := JTF_VARCHAR2_TABLE_100();

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

Line 163: a8 := JTF_VARCHAR2_TABLE_100();

159: a4 := JTF_VARCHAR2_TABLE_100();
160: a5 := JTF_NUMBER_TABLE();
161: a6 := JTF_VARCHAR2_TABLE_100();
162: a7 := JTF_VARCHAR2_TABLE_2000();
163: a8 := JTF_VARCHAR2_TABLE_100();
164: a9 := JTF_VARCHAR2_TABLE_200();
165: a10 := JTF_VARCHAR2_TABLE_200();
166: a11 := JTF_VARCHAR2_TABLE_200();
167: a12 := JTF_VARCHAR2_TABLE_200();

Line 184: a29 := JTF_VARCHAR2_TABLE_100();

180: a25 := JTF_NUMBER_TABLE();
181: a26 := JTF_DATE_TABLE();
182: a27 := JTF_NUMBER_TABLE();
183: a28 := JTF_NUMBER_TABLE();
184: a29 := JTF_VARCHAR2_TABLE_100();
185: if t.count > 0 then
186: a0.extend(t.count);
187: a1.extend(t.count);
188: a2.extend(t.count);

Line 271: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100

267: , x_msg_data out nocopy VARCHAR2
268: , p9_a0 in out nocopy JTF_NUMBER_TABLE
269: , p9_a1 in out nocopy JTF_NUMBER_TABLE
270: , p9_a2 in out nocopy JTF_NUMBER_TABLE
271: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
272: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
273: , p9_a5 in out nocopy JTF_NUMBER_TABLE
274: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
275: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 272: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100

268: , p9_a0 in out nocopy JTF_NUMBER_TABLE
269: , p9_a1 in out nocopy JTF_NUMBER_TABLE
270: , p9_a2 in out nocopy JTF_NUMBER_TABLE
271: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
272: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
273: , p9_a5 in out nocopy JTF_NUMBER_TABLE
274: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
275: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
276: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 274: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100

270: , p9_a2 in out nocopy JTF_NUMBER_TABLE
271: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
272: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
273: , p9_a5 in out nocopy JTF_NUMBER_TABLE
274: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
275: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
276: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
277: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_200
278: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_200

Line 276: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100

272: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
273: , p9_a5 in out nocopy JTF_NUMBER_TABLE
274: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
275: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
276: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
277: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_200
278: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_200
279: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_200
280: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200

Line 297: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100

293: , p9_a25 in out nocopy JTF_NUMBER_TABLE
294: , p9_a26 in out nocopy JTF_DATE_TABLE
295: , p9_a27 in out nocopy JTF_NUMBER_TABLE
296: , p9_a28 in out nocopy JTF_NUMBER_TABLE
297: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
298: )
299:
300: as
301: ddp_x_mr_action_tbl ahl_fmp_mr_action_pvt.mr_action_tbl;