APPS.AHL_RM_RT_OPER_PANEL_PVT dependencies on AHL_OPERATIONS_B

Line 586: from ahl_operations_b

582:
583: cursor get_oper_status (p_operation_id in number)
584: is
585: select revision_status_code
586: from ahl_operations_b
587: where operation_id = p_operation_id;
588:
589: l_api_version CONSTANT NUMBER := 1.0;
590: l_return_status VARCHAR2(1);

Line 791: UPDATE ahl_operations_b

787: OPEN get_oper_status (p_object_id);
788: FETCH get_oper_status INTO l_obj_status;
789: IF (get_oper_status%FOUND AND l_obj_status = 'APPROVAL_REJECTED')
790: THEN
791: UPDATE ahl_operations_b
792: SET revision_status_code = 'DRAFT'
793: WHERE operation_id = p_object_id;
794: END IF;
795: CLOSE get_oper_status;