APPS.AHL_RM_MATERIAL_AS_PVT dependencies on AHL_ROUTES_B

Line 2399: UPDATE ahl_routes_b

2395: OPEN get_route_status (l_dummy_number);
2396: FETCH get_route_status INTO l_obj_status;
2397: IF (get_route_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
2398: THEN
2399: UPDATE ahl_routes_b
2400: SET revision_status_code = 'DRAFT'
2401: WHERE route_id = l_dummy_number;
2402: END IF;
2403: CLOSE get_route_status;

Line 2427: UPDATE ahl_routes_b

2423: OPEN get_route_status (p_object_id);
2424: FETCH get_route_status INTO l_obj_status;
2425: IF (get_route_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
2426: THEN
2427: UPDATE ahl_routes_b
2428: SET revision_status_code = 'DRAFT'
2429: WHERE route_id = p_object_id;
2430: END IF;
2431: CLOSE get_route_status;

Line 2984: UPDATE ahl_routes_b

2980: OPEN get_route_status (p_object_id);
2981: FETCH get_route_status INTO l_obj_status;
2982: IF (get_route_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
2983: THEN
2984: UPDATE ahl_routes_b
2985: SET revision_status_code = 'DRAFT'
2986: WHERE route_id = p_object_id;
2987: END IF;
2988: CLOSE get_route_status;