97:
98: CURSOR CHK_ROUTE_NUM(c_route_num VARCHAR2)
99: IS
100: SELECT count(route_no)
101: FROM ahl_routes_b
102: WHERE sysdate BETWEEN nvl(start_date_active, sysdate) AND nvl(end_date_active, sysdate)
103: AND route_no = c_route_num;
104:
105: CURSOR CHK_ROUTE_TYPE(c_route_type VARCHAR2)
112:
113: CURSOR CHK_SYSTEM(c_system VARCHAR2)
114: IS
115: SELECT count(CONCATENATED_SEGMENTS)
116: FROM AHL_ROUTES_B_KFV
117: WHERE CONCATENATED_SEGMENTS = c_system;
118:
119: CURSOR CHK_PROCESS(c_process VARCHAR2)
120: IS