DBA Data[Home] [Help]

APPS.AHL_UA_FLIGHT_SCHEDULES_PUB_W dependencies on AHL_UA_FLIGHT_SCHEDULES_PUB

Line 1: package body ahl_ua_flight_schedules_pub_w as

1: package body ahl_ua_flight_schedules_pub_w as
2: /* $Header: AHLUFSWB.pls 120.0.12020000.2 2012/12/10 16:49:12 prakkum ship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ua_flight_schedules_pub.flight_visit_sch_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ua_flight_schedules_pub.flight_visit_sch_tbl_type, a0 JTF_NUMBER_TABLE

1: package body ahl_ua_flight_schedules_pub_w as
2: /* $Header: AHLUFSWB.pls 120.0.12020000.2 2012/12/10 16:49:12 prakkum ship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ua_flight_schedules_pub.flight_visit_sch_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

Line 130: procedure rosetta_table_copy_out_p4(t ahl_ua_flight_schedules_pub.flight_visit_sch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

126: end loop;
127: end if;
128: end if;
129: end rosetta_table_copy_in_p4;
130: procedure rosetta_table_copy_out_p4(t ahl_ua_flight_schedules_pub.flight_visit_sch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
131: , a1 out nocopy JTF_VARCHAR2_TABLE_100
132: , a2 out nocopy JTF_VARCHAR2_TABLE_100
133: , a3 out nocopy JTF_DATE_TABLE
134: , a4 out nocopy JTF_DATE_TABLE

Line 499: ddp_flight_search_rec ahl_ua_flight_schedules_pub.flight_search_rec_type;

495: , p10_a50 out nocopy JTF_VARCHAR2_TABLE_100
496: )
497:
498: as
499: ddp_flight_search_rec ahl_ua_flight_schedules_pub.flight_search_rec_type;
500: ddx_flight_schedules_tbl ahl_ua_flight_schedules_pvt.flight_schedules_tbl_type;
501: ddindx binary_integer; indx binary_integer;
502: begin
503:

Line 529: ahl_ua_flight_schedules_pub.get_flight_schedule_details(p_api_version,

525: ddp_flight_search_rec.date_apply_to_flag := p9_a11;
526:
527:
528: -- here's the delegated call to the old PL/SQL routine
529: ahl_ua_flight_schedules_pub.get_flight_schedule_details(p_api_version,
530: p_init_msg_list,
531: p_commit,
532: p_validation_level,
533: p_default,

Line 737: ahl_ua_flight_schedules_pub.process_flight_schedules(p_api_version,

733: , p9_a50
734: );
735:
736: -- here's the delegated call to the old PL/SQL routine
737: ahl_ua_flight_schedules_pub.process_flight_schedules(p_api_version,
738: p_init_msg_list,
739: p_commit,
740: p_validation_level,
741: p_default,

Line 879: ddp_x_flight_visit_sch_tbl ahl_ua_flight_schedules_pub.flight_visit_sch_tbl_type;

875: , p9_a54 in out nocopy JTF_VARCHAR2_TABLE_100
876: )
877:
878: as
879: ddp_x_flight_visit_sch_tbl ahl_ua_flight_schedules_pub.flight_visit_sch_tbl_type;
880: ddindx binary_integer; indx binary_integer;
881: begin
882:
883: -- copy data to the local IN or IN-OUT args, if any

Line 893: ahl_ua_flight_schedules_pub_w.rosetta_table_copy_in_p4(ddp_x_flight_visit_sch_tbl, p9_a0

889:
890:
891:
892:
893: ahl_ua_flight_schedules_pub_w.rosetta_table_copy_in_p4(ddp_x_flight_visit_sch_tbl, p9_a0
894: , p9_a1
895: , p9_a2
896: , p9_a3
897: , p9_a4

Line 951: ahl_ua_flight_schedules_pub.process_flightvisit_sch(p_api_version,

947: , p9_a54
948: );
949:
950: -- here's the delegated call to the old PL/SQL routine
951: ahl_ua_flight_schedules_pub.process_flightvisit_sch(p_api_version,
952: p_init_msg_list,
953: p_commit,
954: p_validation_level,
955: p_default,

Line 972: ahl_ua_flight_schedules_pub_w.rosetta_table_copy_out_p4(ddp_x_flight_visit_sch_tbl, p9_a0

968:
969:
970:
971:
972: ahl_ua_flight_schedules_pub_w.rosetta_table_copy_out_p4(ddp_x_flight_visit_sch_tbl, p9_a0
973: , p9_a1
974: , p9_a2
975: , p9_a3
976: , p9_a4

Line 1030: end ahl_ua_flight_schedules_pub_w;

1026: , p9_a54
1027: );
1028: end;
1029:
1030: end ahl_ua_flight_schedules_pub_w;