24: p_mr_route_id in number
25: )
26: IS
27: SELECT route_number, stage
28: FROM ahl_mr_routes_v
29: WHERE mr_route_id = p_mr_route_id;
30:
31: BEGIN
32:
38:
39: -- Get the minimum bound for route stage, based on routes executed before
40: SELECT nvl(max(mrr.stage), 1)
41: INTO l_min_stage
42: FROM ahl_mr_routes_v mrr,
43: ahl_mr_route_sequences mrs
44: WHERE mrr.mr_route_id = mrs.mr_route_id and
45: mrs.related_mr_route_id = p_mr_route_id;
46:
46:
47: -- Get the maximum bound for route stage, based on routes executed after
48: SELECT nvl(min(mrr.stage), l_max_stage_num)
49: INTO l_max_stage
50: FROM ahl_mr_routes_v mrr,
51: ahl_mr_route_sequences mrs
52: WHERE mrr.mr_route_id = mrs.related_mr_route_id and
53: mrs.mr_route_id = p_mr_route_id;
54:
496: And MR_HEADER_ID=C_MR_HEADER_ID;
497: CURSOR get_route_num_routeid(C_MR_ROUTE_ID NUMBER)
498: IS
499: Select ROUTE_NUMBER,ROUTE_ID
500: From AHL_MR_ROUTES_V
501: Where MR_ROUTE_ID=C_MR_ROUTE_ID;
502:
503: L_ROUTE_NUMBER_REC get_route_num_routeid%ROWTYPE;
504: