APPS.AHL_RM_RT_OPER_RESOURCE_PVT dependencies on AHL_ROUTES_B

Line 1433: UPDATE ahl_routes_b

1429: OPEN get_route_status (p_object_id);
1430: FETCH get_route_status INTO l_obj_status;
1431: IF (get_route_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
1432: THEN
1433: UPDATE ahl_routes_b
1434: SET revision_status_code = 'DRAFT'
1435: WHERE route_id = p_object_id;
1436: END IF;
1437: CLOSE get_route_status;

Line 2342: UPDATE ahl_routes_b

2338: OPEN get_route_status (l_object_id);
2339: FETCH get_route_status INTO l_obj_status;
2340: IF (get_route_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
2341: THEN
2342: UPDATE ahl_routes_b
2343: SET revision_status_code = 'DRAFT'
2344: WHERE route_id = l_object_id;
2345: END IF;
2346: CLOSE get_route_status;