DBA Data[Home] [Help]

APPS.AHL_UA_COMMON_PVT dependencies on AHL_UA_FLIGHT_SCHEDULES_PVT

Line 390: x_prec_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,

386: x_msg_data OUT NOCOPY VARCHAR2,
387: p_unit_config_id IN NUMBER,
388: p_start_date_time IN DATE,
389: p_use_actuals IN VARCHAR2,
390: x_prec_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
391: x_is_conflict OUT NOCOPY VARCHAR2
392: )
393: IS
394: -- 1. Declare local variables

Line 1235: x_prec_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,

1231: p_unit_config_id IN NUMBER,
1232: p_start_date_time IN DATE,
1233: p_use_actuals IN VARCHAR2,
1234: x_prec_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
1235: x_prec_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
1236: x_is_conflict OUT NOCOPY VARCHAR2,
1237: x_is_org_in_user_ou OUT NOCOPY VARCHAR2
1238: )
1239: IS

Line 1248: l_prec_flight_schedule AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;

1244: l_msg_count NUMBER;
1245: l_msg_data VARCHAR2(2000);
1246: L_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
1247:
1248: l_prec_flight_schedule AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;
1249: l_prec_visit AHL_VWP_VISITS_PVT.Visit_Rec_Type;
1250: l_prec_is_visit VARCHAR2(1);
1251: l_is_flight_conflict VARCHAR2(1);
1252: l_is_visit_conflict VARCHAR2(1);

Line 1520: x_succ_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,

1516: p_unit_config_id IN NUMBER,
1517: p_end_date_time IN DATE,
1518: p_use_actuals IN VARCHAR2,
1519: x_succ_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
1520: x_succ_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
1521: x_is_conflict OUT NOCOPY VARCHAR2,
1522: x_is_org_in_user_ou OUT NOCOPY VARCHAR2
1523: )
1524: IS

Line 1533: l_succ_flight_schedule AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;

1529: l_msg_count NUMBER;
1530: l_msg_data VARCHAR2(2000);
1531: L_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
1532:
1533: l_succ_flight_schedule AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;
1534: l_succ_visit AHL_VWP_VISITS_PVT.Visit_Rec_Type;
1535: l_succ_is_visit VARCHAR2(1);
1536: l_is_flight_conflict VARCHAR2(1);
1537: l_is_visit_conflict VARCHAR2(1);

Line 1782: x_succ_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,

1778: x_msg_data OUT NOCOPY VARCHAR2,
1779: p_unit_config_id IN NUMBER,
1780: p_end_date_time IN DATE,
1781: p_use_actuals IN VARCHAR2,
1782: x_succ_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
1783: x_is_conflict OUT NOCOPY VARCHAR2
1784: )
1785: IS
1786: -- 1. Declare local variables