APPS.AHL_UA_FLIGHT_SCHEDULES_PUB dependencies on AHL_OSP_UTIL_PKG

Line 33: l_flight_schedule_csr AHL_OSP_UTIL_PKG.ahl_search_csr;

29: l_api_version CONSTANT NUMBER := 1.0;
30: l_return_status VARCHAR2(1);
31: l_search_Query VARCHAR2(5000);
32: i NUMBER;
33: l_flight_schedule_csr AHL_OSP_UTIL_PKG.ahl_search_csr;
34: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
35: l_bind_index NUMBER;
36: l_super_user VARCHAR2(1);
37: l_unit_schedule_id NUMBER;

Line 34: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

30: l_return_status VARCHAR2(1);
31: l_search_Query VARCHAR2(5000);
32: i NUMBER;
33: l_flight_schedule_csr AHL_OSP_UTIL_PKG.ahl_search_csr;
34: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
35: l_bind_index NUMBER;
36: l_super_user VARCHAR2(1);
37: l_unit_schedule_id NUMBER;
38: l_flight_schedule_rec AHL_UA_FLIGHT_SCHEDULES_PVT.FLIGHT_SCHEDULE_REC_TYPE;

Line 323: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_flight_schedule_csr, l_bind_value_tbl, l_search_Query);

319: -- add order by. this doesnt have to be done when unit_schedule_id is passed.
320: l_search_Query := l_search_Query || ' ORDER BY UNIT_CONFIG_NAME DESC, EST_DEPARTURE_TIME DESC, EST_ARRIVAL_TIME DESC';
321: END IF;
322:
323: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_flight_schedule_csr, l_bind_value_tbl, l_search_Query);
324:
325: i := 0;
326: l_super_user := AHL_UA_FLIGHT_SCHEDULES_PVT.is_super_user;
327: