DBA Data[Home] [Help]

APPS.AHL_RM_ASO_RESOURCE_PVT_W dependencies on JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_rm_aso_resource_pvt.bom_resource_tbl_type, 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_rm_aso_resource_pvt.bom_resource_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE

Line 17: , a1 JTF_NUMBER_TABLE

13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p2(t out nocopy ahl_rm_aso_resource_pvt.bom_resource_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_DATE_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE

Line 19: , a3 JTF_NUMBER_TABLE

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

Line 21: , a5 JTF_NUMBER_TABLE

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

Line 22: , a6 JTF_NUMBER_TABLE

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

Line 23: , a7 JTF_NUMBER_TABLE

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

Line 24: , a8 JTF_NUMBER_TABLE

20: , a4 JTF_DATE_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_VARCHAR2_TABLE_100
26: , a10 JTF_VARCHAR2_TABLE_300
27: , a11 JTF_VARCHAR2_TABLE_300
28: , a12 JTF_DATE_TABLE

Line 29: , a13 JTF_NUMBER_TABLE

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

Line 97: procedure rosetta_table_copy_out_p2(t ahl_rm_aso_resource_pvt.bom_resource_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

93: end loop;
94: end if;
95: end if;
96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t ahl_rm_aso_resource_pvt.bom_resource_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_DATE_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_DATE_TABLE

Line 98: , a1 out nocopy JTF_NUMBER_TABLE

94: end if;
95: end if;
96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t ahl_rm_aso_resource_pvt.bom_resource_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_DATE_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_DATE_TABLE
102: , a5 out nocopy JTF_NUMBER_TABLE

Line 100: , a3 out nocopy JTF_NUMBER_TABLE

96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t ahl_rm_aso_resource_pvt.bom_resource_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_DATE_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_DATE_TABLE
102: , a5 out nocopy JTF_NUMBER_TABLE
103: , a6 out nocopy JTF_NUMBER_TABLE
104: , a7 out nocopy JTF_NUMBER_TABLE

Line 102: , a5 out nocopy JTF_NUMBER_TABLE

98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_DATE_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_DATE_TABLE
102: , a5 out nocopy JTF_NUMBER_TABLE
103: , a6 out nocopy JTF_NUMBER_TABLE
104: , a7 out nocopy JTF_NUMBER_TABLE
105: , a8 out nocopy JTF_NUMBER_TABLE
106: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 103: , a6 out nocopy JTF_NUMBER_TABLE

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

Line 104: , a7 out nocopy JTF_NUMBER_TABLE

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

Line 105: , a8 out nocopy JTF_NUMBER_TABLE

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

Line 110: , a13 out nocopy JTF_NUMBER_TABLE

106: , a9 out nocopy JTF_VARCHAR2_TABLE_100
107: , a10 out nocopy JTF_VARCHAR2_TABLE_300
108: , a11 out nocopy JTF_VARCHAR2_TABLE_300
109: , a12 out nocopy JTF_DATE_TABLE
110: , a13 out nocopy JTF_NUMBER_TABLE
111: , a14 out nocopy JTF_VARCHAR2_TABLE_300
112: , a15 out nocopy JTF_VARCHAR2_TABLE_100
113: , a16 out nocopy JTF_VARCHAR2_TABLE_200
114: , a17 out nocopy JTF_VARCHAR2_TABLE_200

Line 133: a0 := JTF_NUMBER_TABLE();

129: ) as
130: ddindx binary_integer; indx binary_integer;
131: begin
132: if t is null or t.count = 0 then
133: a0 := JTF_NUMBER_TABLE();
134: a1 := JTF_NUMBER_TABLE();
135: a2 := JTF_DATE_TABLE();
136: a3 := JTF_NUMBER_TABLE();
137: a4 := JTF_DATE_TABLE();

Line 134: a1 := JTF_NUMBER_TABLE();

130: ddindx binary_integer; indx binary_integer;
131: begin
132: if t is null or t.count = 0 then
133: a0 := JTF_NUMBER_TABLE();
134: a1 := JTF_NUMBER_TABLE();
135: a2 := JTF_DATE_TABLE();
136: a3 := JTF_NUMBER_TABLE();
137: a4 := JTF_DATE_TABLE();
138: a5 := JTF_NUMBER_TABLE();

Line 136: a3 := JTF_NUMBER_TABLE();

132: if t is null or t.count = 0 then
133: a0 := JTF_NUMBER_TABLE();
134: a1 := JTF_NUMBER_TABLE();
135: a2 := JTF_DATE_TABLE();
136: a3 := JTF_NUMBER_TABLE();
137: a4 := JTF_DATE_TABLE();
138: a5 := JTF_NUMBER_TABLE();
139: a6 := JTF_NUMBER_TABLE();
140: a7 := JTF_NUMBER_TABLE();

Line 138: a5 := JTF_NUMBER_TABLE();

134: a1 := JTF_NUMBER_TABLE();
135: a2 := JTF_DATE_TABLE();
136: a3 := JTF_NUMBER_TABLE();
137: a4 := JTF_DATE_TABLE();
138: a5 := JTF_NUMBER_TABLE();
139: a6 := JTF_NUMBER_TABLE();
140: a7 := JTF_NUMBER_TABLE();
141: a8 := JTF_NUMBER_TABLE();
142: a9 := JTF_VARCHAR2_TABLE_100();

Line 139: a6 := JTF_NUMBER_TABLE();

135: a2 := JTF_DATE_TABLE();
136: a3 := JTF_NUMBER_TABLE();
137: a4 := JTF_DATE_TABLE();
138: a5 := JTF_NUMBER_TABLE();
139: a6 := JTF_NUMBER_TABLE();
140: a7 := JTF_NUMBER_TABLE();
141: a8 := JTF_NUMBER_TABLE();
142: a9 := JTF_VARCHAR2_TABLE_100();
143: a10 := JTF_VARCHAR2_TABLE_300();

Line 140: a7 := JTF_NUMBER_TABLE();

136: a3 := JTF_NUMBER_TABLE();
137: a4 := JTF_DATE_TABLE();
138: a5 := JTF_NUMBER_TABLE();
139: a6 := JTF_NUMBER_TABLE();
140: a7 := JTF_NUMBER_TABLE();
141: a8 := JTF_NUMBER_TABLE();
142: a9 := JTF_VARCHAR2_TABLE_100();
143: a10 := JTF_VARCHAR2_TABLE_300();
144: a11 := JTF_VARCHAR2_TABLE_300();

Line 141: a8 := JTF_NUMBER_TABLE();

137: a4 := JTF_DATE_TABLE();
138: a5 := JTF_NUMBER_TABLE();
139: a6 := JTF_NUMBER_TABLE();
140: a7 := JTF_NUMBER_TABLE();
141: a8 := JTF_NUMBER_TABLE();
142: a9 := JTF_VARCHAR2_TABLE_100();
143: a10 := JTF_VARCHAR2_TABLE_300();
144: a11 := JTF_VARCHAR2_TABLE_300();
145: a12 := JTF_DATE_TABLE();

Line 146: a13 := JTF_NUMBER_TABLE();

142: a9 := JTF_VARCHAR2_TABLE_100();
143: a10 := JTF_VARCHAR2_TABLE_300();
144: a11 := JTF_VARCHAR2_TABLE_300();
145: a12 := JTF_DATE_TABLE();
146: a13 := JTF_NUMBER_TABLE();
147: a14 := JTF_VARCHAR2_TABLE_300();
148: a15 := JTF_VARCHAR2_TABLE_100();
149: a16 := JTF_VARCHAR2_TABLE_200();
150: a17 := JTF_VARCHAR2_TABLE_200();

Line 166: a0 := JTF_NUMBER_TABLE();

162: a29 := JTF_VARCHAR2_TABLE_200();
163: a30 := JTF_VARCHAR2_TABLE_200();
164: a31 := JTF_VARCHAR2_TABLE_100();
165: else
166: a0 := JTF_NUMBER_TABLE();
167: a1 := JTF_NUMBER_TABLE();
168: a2 := JTF_DATE_TABLE();
169: a3 := JTF_NUMBER_TABLE();
170: a4 := JTF_DATE_TABLE();

Line 167: a1 := JTF_NUMBER_TABLE();

163: a30 := JTF_VARCHAR2_TABLE_200();
164: a31 := JTF_VARCHAR2_TABLE_100();
165: else
166: a0 := JTF_NUMBER_TABLE();
167: a1 := JTF_NUMBER_TABLE();
168: a2 := JTF_DATE_TABLE();
169: a3 := JTF_NUMBER_TABLE();
170: a4 := JTF_DATE_TABLE();
171: a5 := JTF_NUMBER_TABLE();

Line 169: a3 := JTF_NUMBER_TABLE();

165: else
166: a0 := JTF_NUMBER_TABLE();
167: a1 := JTF_NUMBER_TABLE();
168: a2 := JTF_DATE_TABLE();
169: a3 := JTF_NUMBER_TABLE();
170: a4 := JTF_DATE_TABLE();
171: a5 := JTF_NUMBER_TABLE();
172: a6 := JTF_NUMBER_TABLE();
173: a7 := JTF_NUMBER_TABLE();

Line 171: a5 := JTF_NUMBER_TABLE();

167: a1 := JTF_NUMBER_TABLE();
168: a2 := JTF_DATE_TABLE();
169: a3 := JTF_NUMBER_TABLE();
170: a4 := JTF_DATE_TABLE();
171: a5 := JTF_NUMBER_TABLE();
172: a6 := JTF_NUMBER_TABLE();
173: a7 := JTF_NUMBER_TABLE();
174: a8 := JTF_NUMBER_TABLE();
175: a9 := JTF_VARCHAR2_TABLE_100();

Line 172: a6 := JTF_NUMBER_TABLE();

168: a2 := JTF_DATE_TABLE();
169: a3 := JTF_NUMBER_TABLE();
170: a4 := JTF_DATE_TABLE();
171: a5 := JTF_NUMBER_TABLE();
172: a6 := JTF_NUMBER_TABLE();
173: a7 := JTF_NUMBER_TABLE();
174: a8 := JTF_NUMBER_TABLE();
175: a9 := JTF_VARCHAR2_TABLE_100();
176: a10 := JTF_VARCHAR2_TABLE_300();

Line 173: a7 := JTF_NUMBER_TABLE();

169: a3 := JTF_NUMBER_TABLE();
170: a4 := JTF_DATE_TABLE();
171: a5 := JTF_NUMBER_TABLE();
172: a6 := JTF_NUMBER_TABLE();
173: a7 := JTF_NUMBER_TABLE();
174: a8 := JTF_NUMBER_TABLE();
175: a9 := JTF_VARCHAR2_TABLE_100();
176: a10 := JTF_VARCHAR2_TABLE_300();
177: a11 := JTF_VARCHAR2_TABLE_300();

Line 174: a8 := JTF_NUMBER_TABLE();

170: a4 := JTF_DATE_TABLE();
171: a5 := JTF_NUMBER_TABLE();
172: a6 := JTF_NUMBER_TABLE();
173: a7 := JTF_NUMBER_TABLE();
174: a8 := JTF_NUMBER_TABLE();
175: a9 := JTF_VARCHAR2_TABLE_100();
176: a10 := JTF_VARCHAR2_TABLE_300();
177: a11 := JTF_VARCHAR2_TABLE_300();
178: a12 := JTF_DATE_TABLE();

Line 179: a13 := JTF_NUMBER_TABLE();

175: a9 := JTF_VARCHAR2_TABLE_100();
176: a10 := JTF_VARCHAR2_TABLE_300();
177: a11 := JTF_VARCHAR2_TABLE_300();
178: a12 := JTF_DATE_TABLE();
179: a13 := JTF_NUMBER_TABLE();
180: a14 := JTF_VARCHAR2_TABLE_300();
181: a15 := JTF_VARCHAR2_TABLE_100();
182: a16 := JTF_VARCHAR2_TABLE_200();
183: a17 := JTF_VARCHAR2_TABLE_200();

Line 313: , p10_a0 in out nocopy JTF_NUMBER_TABLE

309: , p9_a24 in out nocopy VARCHAR2
310: , p9_a25 in out nocopy VARCHAR2
311: , p9_a26 in out nocopy VARCHAR2
312: , p9_a27 in out nocopy VARCHAR2
313: , p10_a0 in out nocopy JTF_NUMBER_TABLE
314: , p10_a1 in out nocopy JTF_NUMBER_TABLE
315: , p10_a2 in out nocopy JTF_DATE_TABLE
316: , p10_a3 in out nocopy JTF_NUMBER_TABLE
317: , p10_a4 in out nocopy JTF_DATE_TABLE

Line 314: , p10_a1 in out nocopy JTF_NUMBER_TABLE

310: , p9_a25 in out nocopy VARCHAR2
311: , p9_a26 in out nocopy VARCHAR2
312: , p9_a27 in out nocopy VARCHAR2
313: , p10_a0 in out nocopy JTF_NUMBER_TABLE
314: , p10_a1 in out nocopy JTF_NUMBER_TABLE
315: , p10_a2 in out nocopy JTF_DATE_TABLE
316: , p10_a3 in out nocopy JTF_NUMBER_TABLE
317: , p10_a4 in out nocopy JTF_DATE_TABLE
318: , p10_a5 in out nocopy JTF_NUMBER_TABLE

Line 316: , p10_a3 in out nocopy JTF_NUMBER_TABLE

312: , p9_a27 in out nocopy VARCHAR2
313: , p10_a0 in out nocopy JTF_NUMBER_TABLE
314: , p10_a1 in out nocopy JTF_NUMBER_TABLE
315: , p10_a2 in out nocopy JTF_DATE_TABLE
316: , p10_a3 in out nocopy JTF_NUMBER_TABLE
317: , p10_a4 in out nocopy JTF_DATE_TABLE
318: , p10_a5 in out nocopy JTF_NUMBER_TABLE
319: , p10_a6 in out nocopy JTF_NUMBER_TABLE
320: , p10_a7 in out nocopy JTF_NUMBER_TABLE

Line 318: , p10_a5 in out nocopy JTF_NUMBER_TABLE

314: , p10_a1 in out nocopy JTF_NUMBER_TABLE
315: , p10_a2 in out nocopy JTF_DATE_TABLE
316: , p10_a3 in out nocopy JTF_NUMBER_TABLE
317: , p10_a4 in out nocopy JTF_DATE_TABLE
318: , p10_a5 in out nocopy JTF_NUMBER_TABLE
319: , p10_a6 in out nocopy JTF_NUMBER_TABLE
320: , p10_a7 in out nocopy JTF_NUMBER_TABLE
321: , p10_a8 in out nocopy JTF_NUMBER_TABLE
322: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100

Line 319: , p10_a6 in out nocopy JTF_NUMBER_TABLE

315: , p10_a2 in out nocopy JTF_DATE_TABLE
316: , p10_a3 in out nocopy JTF_NUMBER_TABLE
317: , p10_a4 in out nocopy JTF_DATE_TABLE
318: , p10_a5 in out nocopy JTF_NUMBER_TABLE
319: , p10_a6 in out nocopy JTF_NUMBER_TABLE
320: , p10_a7 in out nocopy JTF_NUMBER_TABLE
321: , p10_a8 in out nocopy JTF_NUMBER_TABLE
322: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_300

Line 320: , p10_a7 in out nocopy JTF_NUMBER_TABLE

316: , p10_a3 in out nocopy JTF_NUMBER_TABLE
317: , p10_a4 in out nocopy JTF_DATE_TABLE
318: , p10_a5 in out nocopy JTF_NUMBER_TABLE
319: , p10_a6 in out nocopy JTF_NUMBER_TABLE
320: , p10_a7 in out nocopy JTF_NUMBER_TABLE
321: , p10_a8 in out nocopy JTF_NUMBER_TABLE
322: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_300
324: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_300

Line 321: , p10_a8 in out nocopy JTF_NUMBER_TABLE

317: , p10_a4 in out nocopy JTF_DATE_TABLE
318: , p10_a5 in out nocopy JTF_NUMBER_TABLE
319: , p10_a6 in out nocopy JTF_NUMBER_TABLE
320: , p10_a7 in out nocopy JTF_NUMBER_TABLE
321: , p10_a8 in out nocopy JTF_NUMBER_TABLE
322: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_300
324: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_300
325: , p10_a12 in out nocopy JTF_DATE_TABLE

Line 326: , p10_a13 in out nocopy JTF_NUMBER_TABLE

322: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_300
324: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_300
325: , p10_a12 in out nocopy JTF_DATE_TABLE
326: , p10_a13 in out nocopy JTF_NUMBER_TABLE
327: , p10_a14 in out nocopy JTF_VARCHAR2_TABLE_300
328: , p10_a15 in out nocopy JTF_VARCHAR2_TABLE_100
329: , p10_a16 in out nocopy JTF_VARCHAR2_TABLE_200
330: , p10_a17 in out nocopy JTF_VARCHAR2_TABLE_200