DBA Data[Home] [Help]

APPS.AHL_UA_COMMON_PVT dependencies on AHL_VWP_VISITS_PVT

Line 712: x_prec_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,

708: x_msg_count OUT NOCOPY NUMBER,
709: x_msg_data OUT NOCOPY VARCHAR2,
710: p_unit_config_id IN NUMBER,
711: p_start_date_time IN DATE,
712: x_prec_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
713: x_is_conflict OUT NOCOPY VARCHAR2
714: )
715: IS
716: -- 1. Declare local variables

Line 974: x_succ_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,

970: x_msg_count OUT NOCOPY NUMBER,
971: x_msg_data OUT NOCOPY VARCHAR2,
972: p_unit_config_id IN NUMBER,
973: p_end_date_time IN DATE,
974: x_succ_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
975: x_is_conflict OUT NOCOPY VARCHAR2
976: )
977: IS
978: -- 1. Declare local variables

Line 1234: x_prec_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,

1230: x_msg_data OUT NOCOPY VARCHAR2,
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: )

Line 1249: l_prec_visit AHL_VWP_VISITS_PVT.Visit_Rec_Type;

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);
1253: BEGIN

Line 1519: x_succ_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,

1515: x_msg_data OUT NOCOPY VARCHAR2,
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: )

Line 1534: l_succ_visit AHL_VWP_VISITS_PVT.Visit_Rec_Type;

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);
1538: