DBA Data[Home] [Help]

APPS.AHL_UA_COMMON_PVT dependencies on AHL_UA_FLIGHT_SCHEDULES_PVT

Line 389: x_prec_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,

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

Line 1460: x_prec_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,

1456: p_unit_config_id IN NUMBER,
1457: p_start_date_time IN DATE,
1458: p_use_actuals IN VARCHAR2,
1459: x_prec_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
1460: x_prec_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
1461: x_is_conflict OUT NOCOPY VARCHAR2,
1462: x_is_org_in_user_ou OUT NOCOPY VARCHAR2
1463: )
1464: IS

Line 1473: l_prec_flight_schedule AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;

1469: l_msg_count NUMBER;
1470: l_msg_data VARCHAR2(2000);
1471: L_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
1472:
1473: l_prec_flight_schedule AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;
1474: l_prec_visit AHL_VWP_VISITS_PVT.Visit_Rec_Type;
1475: l_prec_is_visit VARCHAR2(1);
1476: l_is_flight_conflict VARCHAR2(1);
1477: l_is_visit_conflict VARCHAR2(1);

Line 1745: x_succ_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,

1741: p_unit_config_id IN NUMBER,
1742: p_end_date_time IN DATE,
1743: p_use_actuals IN VARCHAR2,
1744: x_succ_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
1745: x_succ_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
1746: x_is_conflict OUT NOCOPY VARCHAR2,
1747: x_is_org_in_user_ou OUT NOCOPY VARCHAR2
1748: )
1749: IS

Line 1758: l_succ_flight_schedule AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;

1754: l_msg_count NUMBER;
1755: l_msg_data VARCHAR2(2000);
1756: L_DEBUG_MODULE CONSTANT VARCHAR2(100) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
1757:
1758: l_succ_flight_schedule AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type;
1759: l_succ_visit AHL_VWP_VISITS_PVT.Visit_Rec_Type;
1760: l_succ_is_visit VARCHAR2(1);
1761: l_is_flight_conflict VARCHAR2(1);
1762: l_is_visit_conflict VARCHAR2(1);

Line 2007: x_succ_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,

2003: x_msg_data OUT NOCOPY VARCHAR2,
2004: p_unit_config_id IN NUMBER,
2005: p_end_date_time IN DATE,
2006: p_use_actuals IN VARCHAR2,
2007: x_succ_flight_schedule OUT NOCOPY AHL_UA_FLIGHT_SCHEDULES_PVT.Flight_Schedule_Rec_Type,
2008: x_is_conflict OUT NOCOPY VARCHAR2
2009: )
2010: IS
2011: -- 1. Declare local variables