DBA Data[Home] [Help]

APPS.AHL_UA_COMMON_PVT dependencies on AHL_VWP_VISITS_PVT

Line 721: x_prec_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,

717: x_msg_count OUT NOCOPY NUMBER,
718: x_msg_data OUT NOCOPY VARCHAR2,
719: p_unit_config_id IN NUMBER,
720: p_start_date_time IN DATE,
721: x_prec_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
722: x_is_conflict OUT NOCOPY VARCHAR2
723: )
724: IS
725: -- 1. Declare local variables

Line 1093: x_succ_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,

1089: x_msg_count OUT NOCOPY NUMBER,
1090: x_msg_data OUT NOCOPY VARCHAR2,
1091: p_unit_config_id IN NUMBER,
1092: p_end_date_time IN DATE,
1093: x_succ_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
1094: x_is_conflict OUT NOCOPY VARCHAR2
1095: )
1096: IS
1097: -- 1. Declare local variables

Line 1459: x_prec_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,

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

Line 1474: l_prec_visit AHL_VWP_VISITS_PVT.Visit_Rec_Type;

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

Line 1744: x_succ_visit OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,

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

Line 1759: l_succ_visit AHL_VWP_VISITS_PVT.Visit_Rec_Type;

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