DBA Data[Home] [Help]

APPS.AHL_UA_UNIT_SCHEDULES_PVT dependencies on AHL_UA_FLIGHT_SCHEDULES_PVT

Line 40: p_unit_flight_schedule_rec IN AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,

36: -- Determine whether to add record in appropriate table
37: ---------------------------------------------------------------------------------
38: PROCEDURE populate_unit_schedule_rec
39: (
40: p_unit_flight_schedule_rec IN AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
41: p_prev_event_type IN VARCHAR2,
42: p_window_event IN BOOLEAN,
43: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
44: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,

Line 770: l_flight_schedule_rec AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;

766:
767: -- Variable to hold all the events in the time slot
768: l_event_schedule_tbl AHL_UA_COMMON_PVT.Event_schedule_Tbl_type;
769: -- to store the flight record
770: l_flight_schedule_rec AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;
771: -- to store fetched visit record
772: l_visit_rec AHL_VWP_VISITS_PVT.Visit_Rec_Type;
773: -- to store previous and current record information
774: l_prev_event_type VARCHAR2(12);

Line 849: l_flight_schedules_tbl AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE;

845:
846:
847: -- To search a flight record and hold search results
848: l_flight_search_rec AHL_UA_FLIGHT_SCHEDULES_PUB.FLIGHT_SEARCH_REC_TYPE;
849: l_flight_schedules_tbl AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULES_TBL_TYPE;
850:
851: -- early exit flag for module type 'US' processing
852: l_early_exit_flag BOOLEAN;
853:

Line 1417: p_unit_flight_schedule_rec IN AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,

1413: -- Determines Maintenance Opportunity and Conflcits for the current flight record
1414: -- Prepare it with transient variable calculations
1415: -------------------------------------------------------------------------------------------
1416: PROCEDURE populate_unit_schedule_rec(
1417: p_unit_flight_schedule_rec IN AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
1418: p_prev_event_type IN VARCHAR2,
1419: p_window_event IN BOOLEAN,
1420: p_prev_unit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Unit_Schedule_rec_type,
1421: p_prev_visit_schedule_rec IN AHL_UA_UNIT_SCHEDULES_PVT.Visit_Schedule_rec_type,

Line 2031: x_prec_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,

2027: p_unit_config_id IN NUMBER,
2028: p_start_date_time IN DATE,
2029: p_end_date_time IN DATE,
2030: x_prec_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
2031: x_prec_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
2032: x_is_prec_conflict OUT NOCOPY VARCHAR2,
2033: x_is_prec_org_in_ou OUT NOCOPY VARCHAR2,
2034: x_succ_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
2035: x_succ_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,

Line 2035: x_succ_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,

2031: x_prec_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
2032: x_is_prec_conflict OUT NOCOPY VARCHAR2,
2033: x_is_prec_org_in_ou OUT NOCOPY VARCHAR2,
2034: x_succ_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
2035: x_succ_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
2036: x_is_succ_conflict OUT NOCOPY VARCHAR2,
2037: x_is_succ_org_in_ou OUT NOCOPY VARCHAR2
2038: )
2039: IS