DBA Data[Home] [Help]

APPS.AHL_UA_FLIGHT_SCHEDULES_PVT_W dependencies on AHL_UA_FLIGHT_SCHEDULES_PVT

Line 1: package body ahl_ua_flight_schedules_pvt_w as

1: package body ahl_ua_flight_schedules_pvt_w as
2: /* $Header: AHLWUFSB.pls 120.1 2006/05/02 04:36 amsriniv noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_ua_flight_schedules_pvt.flight_schedules_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_p1(t out nocopy ahl_ua_flight_schedules_pvt.flight_schedules_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_DATE_TABLE
20: , a4 JTF_DATE_TABLE

Line 123: procedure rosetta_table_copy_out_p1(t ahl_ua_flight_schedules_pvt.flight_schedules_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

119: end loop;
120: end if;
121: end if;
122: end rosetta_table_copy_in_p1;
123: procedure rosetta_table_copy_out_p1(t ahl_ua_flight_schedules_pvt.flight_schedules_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
124: , a1 out nocopy JTF_VARCHAR2_TABLE_100
125: , a2 out nocopy JTF_VARCHAR2_TABLE_100
126: , a3 out nocopy JTF_DATE_TABLE
127: , a4 out nocopy JTF_DATE_TABLE

Line 424: ddp_x_flight_schedules_tbl ahl_ua_flight_schedules_pvt.flight_schedules_tbl_type;

420: , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_100
421: )
422:
423: as
424: ddp_x_flight_schedules_tbl ahl_ua_flight_schedules_pvt.flight_schedules_tbl_type;
425: ddindx binary_integer; indx binary_integer;
426: begin
427:
428: -- copy data to the local IN or IN-OUT args, if any

Line 438: ahl_ua_flight_schedules_pvt_w.rosetta_table_copy_in_p1(ddp_x_flight_schedules_tbl, p9_a0

434:
435:
436:
437:
438: ahl_ua_flight_schedules_pvt_w.rosetta_table_copy_in_p1(ddp_x_flight_schedules_tbl, p9_a0
439: , p9_a1
440: , p9_a2
441: , p9_a3
442: , p9_a4

Line 486: ahl_ua_flight_schedules_pvt.process_flight_schedules(p_api_version,

482: , p9_a44
483: );
484:
485: -- here's the delegated call to the old PL/SQL routine
486: ahl_ua_flight_schedules_pvt.process_flight_schedules(p_api_version,
487: p_init_msg_list,
488: p_commit,
489: p_validation_level,
490: p_default,

Line 507: ahl_ua_flight_schedules_pvt_w.rosetta_table_copy_out_p1(ddp_x_flight_schedules_tbl, p9_a0

503:
504:
505:
506:
507: ahl_ua_flight_schedules_pvt_w.rosetta_table_copy_out_p1(ddp_x_flight_schedules_tbl, p9_a0
508: , p9_a1
509: , p9_a2
510: , p9_a3
511: , p9_a4

Line 555: end ahl_ua_flight_schedules_pvt_w;

551: , p9_a44
552: );
553: end;
554:
555: end ahl_ua_flight_schedules_pvt_w;