APPS.AHL_RM_MATERIAL_AS_PVT dependencies on AHL_ROUTES_B

Line 2286: UPDATE ahl_routes_b

2282: OPEN get_route_status (l_dummy_number);
2283: FETCH get_route_status INTO l_obj_status;
2284: IF (get_route_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
2285: THEN
2286: UPDATE ahl_routes_b
2287: SET revision_status_code = 'DRAFT'
2288: WHERE route_id = l_dummy_number;
2289: END IF;
2290: CLOSE get_route_status;

Line 2311: UPDATE ahl_routes_b

2307: OPEN get_route_status (p_object_id);
2308: FETCH get_route_status INTO l_obj_status;
2309: IF (get_route_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
2310: THEN
2311: UPDATE ahl_routes_b
2312: SET revision_status_code = 'DRAFT'
2313: WHERE route_id = p_object_id;
2314: END IF;
2315: CLOSE get_route_status;

Line 2827: UPDATE ahl_routes_b

2823: OPEN get_route_status (p_object_id);
2824: FETCH get_route_status INTO l_obj_status;
2825: IF (get_route_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
2826: THEN
2827: UPDATE ahl_routes_b
2828: SET revision_status_code = 'DRAFT'
2829: WHERE route_id = p_object_id;
2830: END IF;
2831: CLOSE get_route_status;