APPS.AHL_RM_RT_OPER_RESOURCE_PVT dependencies on AHL_ROUTES_B

Line 1475: UPDATE ahl_routes_b

1471: OPEN get_route_status (p_object_id);
1472: FETCH get_route_status INTO l_obj_status;
1473: IF (get_route_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
1474: THEN
1475: UPDATE ahl_routes_b
1476: SET revision_status_code = 'DRAFT'
1477: WHERE route_id = p_object_id;
1478: END IF;
1479: CLOSE get_route_status;

Line 2384: UPDATE ahl_routes_b

2380: OPEN get_route_status (l_object_id);
2381: FETCH get_route_status INTO l_obj_status;
2382: IF (get_route_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
2383: THEN
2384: UPDATE ahl_routes_b
2385: SET revision_status_code = 'DRAFT'
2386: WHERE route_id = l_object_id;
2387: END IF;
2388: CLOSE get_route_status;