DBA Data[Home] [Help]

APPS.AHL_UA_FLIGHT_SCHEDULES_PVT_W dependencies on JTF_DATE_TABLE

Line 6: , a3 JTF_DATE_TABLE

2: /* $Header: AHLWUFSB.pls 120.1.12020000.2 2012/12/14 07:11:17 shnatu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_ua_flight_schedules_pvt.flight_schedules_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE

Line 7: , a4 JTF_DATE_TABLE

3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_ua_flight_schedules_pvt.flight_schedules_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100

Line 12: , a9 JTF_DATE_TABLE

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE

Line 13: , a10 JTF_DATE_TABLE

9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100

Line 125: , a3 out nocopy JTF_DATE_TABLE

121: end rosetta_table_copy_in_p1;
122: procedure rosetta_table_copy_out_p1(t ahl_ua_flight_schedules_pvt.flight_schedules_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_VARCHAR2_TABLE_100
124: , a2 out nocopy JTF_VARCHAR2_TABLE_100
125: , a3 out nocopy JTF_DATE_TABLE
126: , a4 out nocopy JTF_DATE_TABLE
127: , a5 out nocopy JTF_NUMBER_TABLE
128: , a6 out nocopy JTF_VARCHAR2_TABLE_100
129: , a7 out nocopy JTF_NUMBER_TABLE

Line 126: , a4 out nocopy JTF_DATE_TABLE

122: procedure rosetta_table_copy_out_p1(t ahl_ua_flight_schedules_pvt.flight_schedules_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123: , a1 out nocopy JTF_VARCHAR2_TABLE_100
124: , a2 out nocopy JTF_VARCHAR2_TABLE_100
125: , a3 out nocopy JTF_DATE_TABLE
126: , a4 out nocopy JTF_DATE_TABLE
127: , a5 out nocopy JTF_NUMBER_TABLE
128: , a6 out nocopy JTF_VARCHAR2_TABLE_100
129: , a7 out nocopy JTF_NUMBER_TABLE
130: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 131: , a9 out nocopy JTF_DATE_TABLE

127: , a5 out nocopy JTF_NUMBER_TABLE
128: , a6 out nocopy JTF_VARCHAR2_TABLE_100
129: , a7 out nocopy JTF_NUMBER_TABLE
130: , a8 out nocopy JTF_VARCHAR2_TABLE_100
131: , a9 out nocopy JTF_DATE_TABLE
132: , a10 out nocopy JTF_DATE_TABLE
133: , a11 out nocopy JTF_NUMBER_TABLE
134: , a12 out nocopy JTF_VARCHAR2_TABLE_100
135: , a13 out nocopy JTF_NUMBER_TABLE

Line 132: , a10 out nocopy JTF_DATE_TABLE

128: , a6 out nocopy JTF_VARCHAR2_TABLE_100
129: , a7 out nocopy JTF_NUMBER_TABLE
130: , a8 out nocopy JTF_VARCHAR2_TABLE_100
131: , a9 out nocopy JTF_DATE_TABLE
132: , a10 out nocopy JTF_DATE_TABLE
133: , a11 out nocopy JTF_NUMBER_TABLE
134: , a12 out nocopy JTF_VARCHAR2_TABLE_100
135: , a13 out nocopy JTF_NUMBER_TABLE
136: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 180: a3 := JTF_DATE_TABLE();

176: if t is null or t.count = 0 then
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_VARCHAR2_TABLE_100();
179: a2 := JTF_VARCHAR2_TABLE_100();
180: a3 := JTF_DATE_TABLE();
181: a4 := JTF_DATE_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_VARCHAR2_TABLE_100();
184: a7 := JTF_NUMBER_TABLE();

Line 181: a4 := JTF_DATE_TABLE();

177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_VARCHAR2_TABLE_100();
179: a2 := JTF_VARCHAR2_TABLE_100();
180: a3 := JTF_DATE_TABLE();
181: a4 := JTF_DATE_TABLE();
182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_VARCHAR2_TABLE_100();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_VARCHAR2_TABLE_100();

Line 186: a9 := JTF_DATE_TABLE();

182: a5 := JTF_NUMBER_TABLE();
183: a6 := JTF_VARCHAR2_TABLE_100();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_VARCHAR2_TABLE_100();
186: a9 := JTF_DATE_TABLE();
187: a10 := JTF_DATE_TABLE();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_VARCHAR2_TABLE_100();
190: a13 := JTF_NUMBER_TABLE();

Line 187: a10 := JTF_DATE_TABLE();

183: a6 := JTF_VARCHAR2_TABLE_100();
184: a7 := JTF_NUMBER_TABLE();
185: a8 := JTF_VARCHAR2_TABLE_100();
186: a9 := JTF_DATE_TABLE();
187: a10 := JTF_DATE_TABLE();
188: a11 := JTF_NUMBER_TABLE();
189: a12 := JTF_VARCHAR2_TABLE_100();
190: a13 := JTF_NUMBER_TABLE();
191: a14 := JTF_VARCHAR2_TABLE_100();

Line 232: a3 := JTF_DATE_TABLE();

228: else
229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_VARCHAR2_TABLE_100();
231: a2 := JTF_VARCHAR2_TABLE_100();
232: a3 := JTF_DATE_TABLE();
233: a4 := JTF_DATE_TABLE();
234: a5 := JTF_NUMBER_TABLE();
235: a6 := JTF_VARCHAR2_TABLE_100();
236: a7 := JTF_NUMBER_TABLE();

Line 233: a4 := JTF_DATE_TABLE();

229: a0 := JTF_NUMBER_TABLE();
230: a1 := JTF_VARCHAR2_TABLE_100();
231: a2 := JTF_VARCHAR2_TABLE_100();
232: a3 := JTF_DATE_TABLE();
233: a4 := JTF_DATE_TABLE();
234: a5 := JTF_NUMBER_TABLE();
235: a6 := JTF_VARCHAR2_TABLE_100();
236: a7 := JTF_NUMBER_TABLE();
237: a8 := JTF_VARCHAR2_TABLE_100();

Line 238: a9 := JTF_DATE_TABLE();

234: a5 := JTF_NUMBER_TABLE();
235: a6 := JTF_VARCHAR2_TABLE_100();
236: a7 := JTF_NUMBER_TABLE();
237: a8 := JTF_VARCHAR2_TABLE_100();
238: a9 := JTF_DATE_TABLE();
239: a10 := JTF_DATE_TABLE();
240: a11 := JTF_NUMBER_TABLE();
241: a12 := JTF_VARCHAR2_TABLE_100();
242: a13 := JTF_NUMBER_TABLE();

Line 239: a10 := JTF_DATE_TABLE();

235: a6 := JTF_VARCHAR2_TABLE_100();
236: a7 := JTF_NUMBER_TABLE();
237: a8 := JTF_VARCHAR2_TABLE_100();
238: a9 := JTF_DATE_TABLE();
239: a10 := JTF_DATE_TABLE();
240: a11 := JTF_NUMBER_TABLE();
241: a12 := JTF_VARCHAR2_TABLE_100();
242: a13 := JTF_NUMBER_TABLE();
243: a14 := JTF_VARCHAR2_TABLE_100();

Line 408: , p9_a3 in out nocopy JTF_DATE_TABLE

404: , x_msg_data out nocopy VARCHAR2
405: , p9_a0 in out nocopy JTF_NUMBER_TABLE
406: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
407: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
408: , p9_a3 in out nocopy JTF_DATE_TABLE
409: , p9_a4 in out nocopy JTF_DATE_TABLE
410: , p9_a5 in out nocopy JTF_NUMBER_TABLE
411: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
412: , p9_a7 in out nocopy JTF_NUMBER_TABLE

Line 409: , p9_a4 in out nocopy JTF_DATE_TABLE

405: , p9_a0 in out nocopy JTF_NUMBER_TABLE
406: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
407: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
408: , p9_a3 in out nocopy JTF_DATE_TABLE
409: , p9_a4 in out nocopy JTF_DATE_TABLE
410: , p9_a5 in out nocopy JTF_NUMBER_TABLE
411: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
412: , p9_a7 in out nocopy JTF_NUMBER_TABLE
413: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 414: , p9_a9 in out nocopy JTF_DATE_TABLE

410: , p9_a5 in out nocopy JTF_NUMBER_TABLE
411: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
412: , p9_a7 in out nocopy JTF_NUMBER_TABLE
413: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
414: , p9_a9 in out nocopy JTF_DATE_TABLE
415: , p9_a10 in out nocopy JTF_DATE_TABLE
416: , p9_a11 in out nocopy JTF_NUMBER_TABLE
417: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
418: , p9_a13 in out nocopy JTF_NUMBER_TABLE

Line 415: , p9_a10 in out nocopy JTF_DATE_TABLE

411: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
412: , p9_a7 in out nocopy JTF_NUMBER_TABLE
413: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
414: , p9_a9 in out nocopy JTF_DATE_TABLE
415: , p9_a10 in out nocopy JTF_DATE_TABLE
416: , p9_a11 in out nocopy JTF_NUMBER_TABLE
417: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
418: , p9_a13 in out nocopy JTF_NUMBER_TABLE
419: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100